188
Examine the following scenario:
The target database instance is running. The most recent backup available for the target database was
taken two days ago. Log files switches have occurred in last two days. The target database is duplicated
on the same host, using the Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN
{
ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO auxdb;
}
Which statement is true about the duplicate database in this scenario?
A. It contains data till the last backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target
Section: (none)
Explanation
Explanation/Reference:
Explanation:
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126
For backup-based duplication of databases in ARCHIVELOG mode, RMAN recovers by default up to the
last archived redo log generated at the time the command was executed, or until a time specified with a
SET UNTIL clause.
http://download.oracle.com/docs/cd/B10500_01/server.920/a96566/rcmdupdb.htm#441820
During duplication, RMAN must perform incomplete recovery because the online redo logs in the target are
not backed up and cannot be applied to the duplicate database. The farthest that RMAN can go in
recovery of the duplicate database is the most recent redo log archived by the target database.
Examine the following scenario:
The target database instance is running. The most recent backup available for the target database was
taken two days ago. Log files switches have occurred in last two days. The target database is duplicated
on the same host, using the Recovery Manager (RMAN) duplicate command as follows:
RMAN> RUN
{
ALLOCATE AUXILIARY CHANNEL aux 1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO auxdb;
}
Which statement is true about the duplicate database in this scenario?
A. It contains data till the last backup
B. It contains all data from target database until the current time
C. It contains all data from only the committed transactions in the target database
D. It contains all data except that which is used by the transactions in the current online redo file of target
database
Section: (none)
Explanation
Explanation/Reference:
Explanation:
http://download.oracle.com/docs/cd/E11882_01/backup.112/e10643/rcmsynta020.htm#RCMRF126
For backup-based duplication of databases in ARCHIVELOG mode, RMAN recovers by default up to the
last archived redo log generated at the time the command was executed, or until a time specified with a
SET UNTIL clause.
http://download.oracle.com/docs/cd/B10500_01/server.920/a96566/rcmdupdb.htm#441820
During duplication, RMAN must perform incomplete recovery because the online redo logs in the target are
not backed up and cannot be applied to the duplicate database. The farthest that RMAN can go in
recovery of the duplicate database is the most recent redo log archived by the target database.