91.
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 & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| You would use the switch datafile command (for example, switch datafile 1 to copy) to instantly switch to the image copy. Issue the restore command and then start up the database. |
92.
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 & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| You would run the RMAN command recover corruption list to recover the corrupted blocks using block media recovery. |
93.
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;
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 & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The commands will run without error until you attempt to open the database. At that time, the alter database open resetlogs command will fail. This will be because datafile 4 and the rest of the database will be inconsistent with each other and Oracle does not allow this. If you are going to restore and recover an Oracle database using point-in-time recovery, you must do so with the entire database. |
94.
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 & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| For this recovery, you would use the RMAN sql command to issue an alter database datafile offline command. You would then use the RMAN restore and recover commands to recover the lost datafile. Finally, you would use the RMAN sql command to issue the alter database datafile online command. |
95.
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.
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.
- A.a, b, c, d, e, f, g
- B.b, c, d, g, f, e, a
- C.g, f, a, b, c, e, d
- D.c, a, d, b, f, e, g
- E.g, f, a, b, e, c, d
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| To restore the database, in this case they needed to connect to the recovery catalog with RMAN. They then started the DSL instance with the startup nomount command and restored the control file with the restore controlfile command. After restoring the control file, they mounted the database with the alter database mount command and then restored the database with the restore database command. After restoring the database, they recovered it with the recover database command and then opened it with the alter database open resetlogs command. |
|
|
||||||||||||||||||||||||||||
