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 have tried and I think answer is AE.
SOURCE DB:
SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces order by 1;
EXAMPLE ONLINE
QWE READ ONLY
RMANCATALOG ONLINE
SYSAUX ONLINE
SYSTEM ONLINE
TEMP3 ONLINE
UNDO ONLINE
USERS ONLINE
RMAN> DUPLICATE TARGET DATABASE TO test1 FROM ACTIVE DATABASE SKIP READONLY;
…
Dropping offline and skipped tablespaces
Executing: drop tablespace “QWE” including contents cascade constraints
Finished Duplicate Db at 22-DEC-15
DESTINATION DB:
SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces order by 1;
EXAMPLE ONLINE
RMANCATALOG ONLINE
SYSAUX ONLINE
SYSTEM ONLINE
TEMP3 ONLINE
UNDO ONLINE
USERS ONLINE
The correct answer is A and E
@dcdba, You are correct! Great example!
I suggest reading
http://oracle.su/docs/11g/backup.112/e10642/rcmdupdb.htm#CHDJJBCF
where it says …
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.
buuuuttt
read this!
“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.”
found in
http://oracle.su/docs/11g/backup.112/e10643/rcmsynta020.htm#RCMRF126
i thinks the correct anwers is A,B
@angel, your right! thanks for pointing that out.