Oracle OCP 1Z0-053 Q128(Rman Image Copy Switch)

abstractcyj發表於2016-03-23
328.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

參考:https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta049.htm


Example 2-147 Switching to Image Copies to Avoid Restoring from Backup

Assume that a disk fails, rendering all datafiles in the users tablespace inaccessible. Image copies of all datafiles in this tablespace exist in the flash recovery area. After starting RMAN and connecting to the database as TARGET, you can run SWITCH to point to the control file to the new datafiles and then run RECOVER as follows:

SQL "ALTER TABLESPACE users OFFLINE IMMEDIATE";
SWITCH TABLESPACE users TO COPY;
RECOVER TABLESPACE users;
SQL "ALTER TABLESPACE users ONLINE";

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2062252/,如需轉載,請註明出處,否則將追究法律責任。

相關文章