Skip Headers
Oracle® Database Backup and Recovery Advanced User's Guide
10g Release 2 (10.2)

Part Number B14191-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

Making User-Managed Backups of Archived Redo Logs

To save disk space in your primary archiving location, you may want to back up archived logs to tape or to an alternative disk location. If you archive to multiple locations, then only back up one copy of each log sequence number.

To back up archived redo logs:

  1. To determine which archived redo log files that the database has generated, query V$ARCHIVED_LOG. For example, run the following query:

    SELECT THREAD#,SEQUENCE#,NAME 
    FROM V$ARCHIVED_LOG;
    
    
  2. Back up one copy of each log sequence number by using an operating system utility. This example backs up all logs in the primary archiving location to a disk devoted to log backups:

    % cp $ORACLE_HOME/oracle/trgt/arch/* /disk2/backup/arch
    

    See Also:

    Oracle Database Reference for more information about the data dictionary views