Your database is up and running and one of your three control files is accidentally erased. You start RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? (Choose all that apply.)
A. The command restores only the missing control file. B. The command restores all the control files.
C. The command fails because the database is running. D. This is the correct way to address this problem. E. This is not the correct way to address this problem.
Answer: CE Section: (none)
QUESTION 425
Which of the following are valid until command options when attempting point-in-time recovery in
RMAN? (Choose all that apply.)
A. until time B. until change C. until sequence D. until SCN E. until commit
Answer: ACD Section: (none)
Explanation/Reference:
QUESTION 426
Which of the following does the recover command not do?
A. Restore archived redo logs. B. Apply archived redo logs. C. Restore incremental backups. D. Apply incremental backups.
E. Restore datafile images.
Answer: A Section: (none)
QUESTION 427
You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP. You want to\Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task? (Choose all that apply.)
A. SYSTEM B. SYSAUX C. UNDO D. USERS E. TEMP
F. This restore is not possible.
Answer: ABCD Section: (none)
Explanation/Reference: Answer: ABCDE
QUESTION 428
You have backed up your database using image copies. You have lost the SYSTEM tablespace and need to restart your database as quickly as possible. What is the correct solution?
A. Restore the SYSTEM tablespace from the last backup set and then recover the database.
B. Restore the SYSTEM tablespace image copy using the restore command and then restore the database. C. Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and open
the database.
D. The database is not recoverable in this situation with image copies.
E. Manually copy the datafile image copy to the correct location and then manually restore the database
from SQL*Plus.
Answer: C Section: (none)
Explanation/Reference:
QUESTION 429
If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of MEDIA_CORRUPT, what RMAN command would you run to correct the problem?
A. recover lost blocks; B. recover corrupt blocks;
C. recover media corrupt blocks from list; D. recover corrupt blocks from list; E. recover corruption list;
Answer: E Section: (none)
QUESTION 430
What will be the end result of this set of RMAN commands?
shutdown abort startup mount
restore datafile 4 until time ,,09/30/2008:15:00:00; recover datafile 4 until time ,,09/29/2008:15:00:00; alter database open resetlogs;
A. Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open. B. The restore command will fail. C. The recover command will fail.
D. The alter database open resetlogs command will fail.
E. All these commands will fail because they must be in the confines of a run block.
Answer: D Section: (none)
QUESTION 431
Which of the following represents the correct way to perform an online recovery of datafile 4, which is assigned to a tablespace called USERS?
A. shutdown restore datafile 4; recover datafile 4; alter database open;
B. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; alter database open; C. Sql alter database datafile 4 offline; restore datafile 4; Sql alter database datafile 4 online; D. Sql alter database datafile 4 offline; restore database datafile 4; recover database datafile 4;
Sql alter database datafile 4 online;
E. Sql alter database datafile 4 offline; restore datafile 4; recover datafile 4; Sql alter database
datafile 4 online;
Answer: E Section: (none)
QUESTION 432
David managed to accidentally delete the datafiles for database called DSL. He called Heber and Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover the database and in what order?
A. Restored the control file with the RMAN restore controlfile command. B. Mounted the DSL instance with the alter database mount command.
C. Restored the datafiles for the DSL database with the RMAN restore command. D. Opened the DSL database with the alter database open resetlogs command. E. Recovered the datafiles for the DSL database with the RMAN recover command. F. Started the DSL instance.
G. Connected to the recovery catalog with RMAN. H. a, b, c, d, e, f, g I. b, c, d, g, f, e, a J. g, f, a, b, c, e, d K. c, a, d, b, f, e, g L. g, f, a, b, e, c, d
Answer: C Section: (none)
Explanation/Reference:
QUESTION 433
Which command would you use to determine what database backups are currently available for restore?
A. list database backup; B. report database backup; C. list backup of database; D. list summary backup; E. report backup of database;
Answer: C Section: (none)
QUESTION 434
What command would you use to ensure that backup records in the control file are pointing to actual physical files on the backup media?
A. crosscheck B. list backup C. confirm D. resync
E. backup validate
Answer: A Section: (none)
QUESTION 435
You have backed up your database twice without connecting to the recovery catalog. What command do you issue to transfer the control-file metadata to the recovery catalog?
A. synch catalog B. resync catalog C. replicate catalog D. update catalog E. restore catalog
Answer: B Section: (none)
Explanation/Reference: