Oracle OCP 1Z0-053 Q128(Rman Image Copy Switch)
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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP 1Z0-053 Q693(RMAN Image Copy)Oracle
- Oracle OCP IZ0-053 Q594(RMAN Image Copy)Oracle
- Oracle OCP 1Z0 053 Q79(RMAN Recover Image Copy)Oracle
- Oracle OCP 1Z0-053(Rman Compression Algorithm)OracleGo
- Oracle OCP 1Z0-053 Q698(RMAN Recovery)Oracle
- Oracle OCP 1Z0-053 Q160(RMAN Duplex)Oracle
- Oracle OCP 1Z0-053 Q486(Rman Validate)Oracle
- Oracle OCP 1Z0-053 Q360(RMAN Disaster Recovery)OracleAST
- Oracle OCP 1Z0-053 Q630(RMAN Backup Encryption)Oracle
- Oracle OCP 1Z0-053 Q6(RMAN Import Catalog)OracleImport
- Oracle OCP 1Z0-053 Q566(Rman Recovery System Tablespace)Oracle
- Oracle OCP 1Z0-053 Q706(Rman Retention Policy)Oracle
- Oracle OCP 1Z0-053 Q671(Rman Encryption&Wallet)Oracle
- Oracle OCP 1Z0-053 Q326(Rman Recover Command)Oracle
- Oracle OCP 1Z0-053 Q510(RMAN REPORT NEED BACKUP)Oracle
- Oracle OCP 1Z0-053 Q307(Rman execute global scripts)Oracle
- Oracle OCP 1Z0-053 Q337(Rman Catalog Start with)Oracle
- Oracle OCP 1Z0-053 Q100(Rman Duplicate Skip Readonly)Oracle
- Oracle 使用RMAN COPY 移動 Datafile 位置Oracle
- RMAN備份型別 - 備份集(backupset)和映象副本(Image copy)型別
- Oracle OCP(60):RMAN 備份Oracle
- Oracle OCP 1Z0-053 (ASM)OracleASM
- Oracle OCP 1Z0-053 Q577(Rman Recover lost control files)Oracle
- RMAN備份型別 - 備份集(backupset)和映象副本(Image copy) [final]型別
- Oracle OCP 1Z0-053 (System Partitioning)Oracle
- Oracle OCP 1Z0-053 Q445Oracle
- rman set newname switch 用法
- Oracle 11G OCP 1Z0-053 600Oracle
- Oracle 11G OCP 1Z0-053 581Oracle
- Oracle 11G OCP 1Z0-053 582Oracle
- Oracle 11G OCP 1Z0-053 583Oracle
- Oracle 11G OCP 1Z0-053 584Oracle
- Oracle 11G OCP 1Z0-053 585Oracle
- Oracle 11G OCP 1Z0-053 586Oracle
- Oracle 11G OCP 1Z0-053 587Oracle
- Oracle 11G OCP 1Z0-053 588Oracle
- Oracle 11G OCP 1Z0-053 589Oracle
- Oracle 11G OCP 1Z0-053 590Oracle