RelationalDBDesign

SiteMap

Catalog Maintenance «Prev Next»

Recovery Catalog Maintenance - Quiz

Each question is worth one point. Select the best answer or answers for each question.

1.	Using the following RMAN startup command, which statements are true? `SET ORACLE_SID=PROD RMAN TARGET / CATALOG RMAN/RMAN@RCVCAT LOG rman_maintenance.log APPEND` Please select all the correct answers.
A.		The target database is local.
B.		The recovery catalog is accessed through the RCVCAT Oracle Net service name.
C.		The RMAN commands and output will appear only on your screen.
D.		The RMAN output will be appended to the specified RMAN log file.

2.	You have manually deleted the data file copy d:\backup\devorc1.dbf from your backup staging area. Which RMAN CHANGE command should you run so the RMAN repository no longer treats that copy as available? Please select the best answer.
A.		CHANGE DATAFILECOPY 'd:\backup\devorc1.dbf' UNCATALOG;
B.		CHANGE DATAFILECOPY 'd:\backup\devorc1.dbf' AVAILABLE;
C.		CHANGE DATAFILECOPY 'd:\backup\devorc1.dbf' DELETE;
D.		CHANGE DATAFILECOPY 'd:\backup\devorc1.dbf' VALIDATE;

3.	What is the purpose of the RESYNC CATALOG command in RMAN? Please select the best answer.
A.		To create a new recovery catalog schema
B.		To synchronize the recovery catalog with the target database control file
C.		To delete obsolete backups from the recovery catalog
D.		To validate all backups stored in the recovery catalog

4.	Which of the following are recommended practices for recovery catalog maintenance? Please select all the correct answers.
A.		Regularly run CROSSCHECK to identify expired or missing backups
B.		Periodically run DELETE OBSOLETE to remove backups that are no longer needed under the retention policy
C.		Back up the recovery catalog regularly (it is a database itself)
D.		Never use the same recovery catalog for multiple databases