RMAN> RECOVER COPY OF DATAFILE '/u01/app/oracle/oradata/orcl/users01.dbf';
Which statement regarding the above command is correct?
A. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the image copy.
B. The '/u01/app/oracle/oradata/orcl/users01.dbf' data file is recovered from the last incremental backup.
C. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are updated with all changes
up to incremental backup SCN.
D. Image copies of the '/u01/app/oracle/oradata/orcl/users01.dbf' data file are recovered using the above
command if data file recovery fails.
Answer: C
http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmbckba.htm#BRADV89531
Incrementally Updating Backups
By incrementally updating backups, you can avoid the overhead of making full image copy backups of datafiles, while also minimizing time required for media recovery of your database. For example, if you run a daily backup script, then you never have more than 1 day of redo to apply for media recovery.
To incrementally update data file backups:
-
Create a full image copy backup of a data file with a specified tag.
-
At regular intervals (such as daily), make a level 1 differential incremental backup of the data file and use the same tag as the base data file copy.
-
Apply the incremental backup to the most recent backup with the same tag.
This technique rolls forward the backup to the time when the level 1 incremental backup was made. RMAN can restore this incrementally updated backupand apply changes from the redo log. The result is the same as restoring a data file backup taken at the SCN of the most recently applied incremental level 1 backup.
Note:
If you runRECOVER COPY
daily
without specifying an
UNTIL TIME
, then a continuously updated image copy cannot satisfy a
recovery window of more than a day. The incrementally updated backup feature is an optimization for fast media recovery.
Incrementally Updating Backups: Basic Example
To create incremental backups for use in an incrementally updated backups strategy, use the BACKUP ...
FOR
RECOVER
OF
COPY
WITH
TAG
form of the BACKUP
command. The command is best understood in a sample script that implements the strategy.
The script in Example 9-9, run regularly, is all that is required to implement a strategy based on incrementally updated backups.
Example 9-9 Basic Incremental Update Script
RUN { RECOVER COPY OF DATABASE WITH TAG 'incr_update'; BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' DATABASE; }