Skip to Main Content
Oracle in a Nutshell
book

Oracle in a Nutshell

by Rick Greenwald, David C. Kreines
December 2002
Intermediate to advanced content levelIntermediate to advanced
928 pages
85h 29m
English
O'Reilly Media, Inc.
Content preview from Oracle in a Nutshell

Backing up datafiles

You can make a user-managed consistent backup of your complete Oracle database after you have shut down the database with the NORMAL, IMMEDIATE, or TRANSACTIONAL keyword. Once the database is shut down, you use the appropriate operating system command to back up or copy the datafiles.

You can also back up individual tablespaces and datafiles. If a tablespace is offline, you can use the appropriate operating system command to back up the datafiles. If the tablespace is online, you must first put the tablespace into BACKUP mode by issuing the following command in SQL*Plus:

ALTER TABLESPACE tablespace_name BEGIN BACKUP;

Once the backup is complete, you issue either of the following commands:

ALTER TABLESPACE tablespace_name END BACKUP;
ALTER DATABASE END BACKUP;

to return to normal operation. Because there is extra overhead involved in writing the extra information to the log files while in BACKUP mode, you should always end the mode as soon as your backup completes successfully.

Tip

You may need to use the ALTER DATABASE END BACKUP command if your database is still in BACKUP mode when it fails. Oracle will not reopen a tablespace in BACKUP mode, so you will need to mount the database, run this command, and then open the database.

You may find that it makes more sense to back up your tablespaces serially, rather than in a single job. By backing up your tablespaces one at a time, you avoid having to put all the tablespaces in BACKUP mode for the duration of the complete ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Oracle Internals

Oracle Internals

Donald K. Burleson
Oracle PL/SQL

Oracle PL/SQL

Lewis Cunningham
Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Oracle Essentials: Oracle9i, Oracle8i and Oracle8, Second Edition

Rick Greenwald, Robert Stackowiak, Jonathan Stern

Publisher Resources

ISBN: 0596003366Errata Page