Examine the following command that is used to duplicate a database on the same host:
RMAN> RUN
{
ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK;
DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; }
Which two statements describe the effect after the database is duplicated successfully? (Choose two)
A.
The data files of the read-only tablespaces in the target database are not duplicated
B.
The read-only tablespaces in the target database are still defined in new the database
C.
The read-only tablespaces in the target database are changed to online after duplication
D.
The data files of the read-only tablespaces in the target database get duplicated
E.
The read-only tablespaces in the target database are not defined in the new database
I think the right answer is A,E. In Oracle´s documentation is said: •Skip read-only tablespaces with the SKIP READONLY clause (read-only tablespaces are included by default). You can also exclude any tablespace with the SKIP TABLESPACE clause so long as it is not the SYSTEM or SYSAUX tablespace and does not contain rollback or undo data. If you omit tablespaces, then you can add them later.
A,E is Correct Answer.
A, E
Yes E is correct because …
see …
http://oracle.su/docs/11g/backup.112/e10642/rcmdupdb.htm#BGBFFBFC
just below you can see the text
“A duplicate database can include the same contents as the source database or only a subset of the tablespaces in the source database. For example, you can use the TABLESPACE option to duplicate only specified tablespaces, or the SKIP READONLY option to exclude read-only tablespaces from the duplicate database.”
B is correct
“Note: A record for the skipped read-only tablespace still appears in DBA_TABLESPACES. By using this feature, you can activate the read-only tablespace later. For example, you can store the read-only tablespace data on a writable DVD, then mount the DVD later and view the data.”
http://oracle.su/docs/11g/backup.112/e10643/rcmsynta020.htm#RCMRF126