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

Determining the files to back up

Because your Oracle database is always changing, your first step in performing a user-managed backup is to determine the files you will need to back up. You can identify these files by running queries against the various V$ views, as shown in Table 15-2.

Table 15-2. V$ views used in user-managed backup

Type of file

V$ view

SQL

Datafile

V$DATAFILE

SELECT NAME FROM V$DATAFILE;

Online redo log files

V$LOGFILE

SELECT MEMBER FROM V$LOGFILE;

Archived redo log files

V$ARCHIVED_LOG

SELECT THREAD#, SEQUENCE#, 
       NAME FROM V$ARCHIVED_LOG;

Control files

V$CONTROLFILE

SELECT NAME FROM V$CONTROLFILE;

Make sure to save a list of the datafiles and archived log files with the control file. The structure of your database may change between the time you make your backup and the time you have to use it, in which case the current control file for that database might not match up with the files you backed up.

When performing a user-managed backup, you need to back up four types of files:

  • Datafiles

  • Log files

  • Control files

  • Miscellaneous files

Because you need all of these types of files for recovery operations, make sure that your user-managed backup routines include backups of all four file types.

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