Database Reference
In-Depth Information
ExErcisE 1.4 (continued)
11. Having switched log files, you need to wait for ARCH to complete copying the last log
file to the archive-log directory. You can check for this completion by looking at the
V$ARCHIVED_LOG view:
SQL> Select sequence#, archived, status from v$archived_log
2 Where sequence# between 14 and 15;
SEQUENCE# ARC S
---------- --- -
14 YES A
15 YES A
Here you see that the logs with sequence numbers 14 and 15 (already identified as
critical to restoring this backup) have been archived successfully. The ARCHIVED col-
umn indicates this with the use of the YES value.
12. Now back up all archived redo logs, ensuring that all logs with numbers between
sequence x and sequence y are backed up. You will simply copy all archived redo logs
from the directory identified in step 3 ( c:\oracle\arch\orcl ) to your backup directory:
SQL> Host copy c:\oracle\arch\orcl\*.* c:\backup\orcl\backup2
c:\oracle\arch\orcl\ORCL_658485967_1_10.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_11.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_12.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_13.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_14.ARC Log sequence 14
c:\oracle\arch\orcl\ORCL_658485967_1_15.ARC Log sequence 15
c:\oracle\arch\orcl\ORCL_658485967_1_2.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_3.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_4.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_5.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_6.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_7.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_8.ARC
c:\oracle\arch\orcl\ORCL_658485967_1_9.ARC
14 file(s) copied.
You can tell that the logs with sequence numbers 14 and 15 were backed up since
you know that the log sequence number is part of the filename (it's the number right
before the extension). We also marked them for you in the output just because we
are nice guys. After copying the archived redo logs to the backup location, you can
delete the source location if you want to save space. Once the backup of the archived
redo logs is complete, your database backup is done.
 
Search WWH ::




Custom Search