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