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
I think that the answer is A
Although it says “It contains data till the last backup” which I think contains a typo so I will take it to say “It contains data up to the point in time of the last backup”
Please note that the version of oracle examened in the exam IZO-053 is 11.2.0.1 as stated here
https://education.oracle.com/pls/web_prod-plq-dad/db_pages.getpage?page_id=5001&get_params=p_exam_id:1Z0-053&p_org_id=&lang=
Therefore please refer to the 11.2.0.1 documentation found in
http://oracle.su/docs/11g/nav/portal_booklist.htm
I recommend reading …
http://oracle.su/docs/11g/backup.112/e10642/rcmdupdb.htm#i1008564
the section titled “Backup-Based Duplication With a Target Connection: Example”
it says …
The FROM ACTIVE DATABASE clause is not specified. By not specifying this clause, you instruct RMAN to perform backup-based duplication.
D is correct
The URL http://oracle.su/docs/11g/backup.112/e10642/rcmdupdb.htm#i1008564 has the following text.
How RMAN Duplicates a Database
RMAN must perform database point-in-time recovery, even when no explicit point in time is provided for duplication. Point-in-time recover is required because the online redo log files in the source database are not backed up and cannot be applied to the duplicate database. ====> The farthest point of recovery of the duplicate database is the most recent redo log file archived by the source database. <=====