Oracle OCP IZ0-053 Q64(Rman controlfile)
604.You realize that the control file is damaged in your production database. After restoring the control file
from autobackup, what is the next step that you must do to proceed with the database recovery?
A. Mount the database
B. Open the database in NORMAL mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
Answer: A
驗證:
[oracle@db01 ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Mar 15 16:14:15 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 413372416 bytes
Fixed Size 2253784 bytes
Variable Size 310381608 bytes
Database Buffers 92274688 bytes
Redo Buffers 8462336 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 15-MAR-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=125 device type=DISK
recovery area destination: /u01/app/oracle/fast_recovery_area
database name (or database unique name) used for search: INST1
channel ORA_DISK_1: AUTOBACKUP /u01/app/oracle/fast_recovery_area/INST1/autobackup/2016_03_15/o1_mf_s_906563655_cghjw045_.bkp found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u01/app/oracle/fast_recovery_area/INST1/autobackup/2016_03_15/o1_mf_s_906563655_cghjw045_.bkp
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/u01/app/oracle/oradata/inst1/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/inst1/control02.ctl
Finished restore at 15-MAR-16
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/15/2016 16:14:49
ORA-01507: database not mounted
RMAN> startup
database is already started
database mounted
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 03/15/2016 16:15:05
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> startup resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "resetlogs": expecting one of: "dba, force, mount, newline, nomount, pfile, ;"
RMAN-01007: at line 1 column 9 file: standard input
RMAN> alter database mount;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/15/2016 16:15:26
ORA-01100: database already mounted
RMAN> alter database open resetlogs;
database opened
RMAN>
from autobackup, what is the next step that you must do to proceed with the database recovery?
A. Mount the database
B. Open the database in NORMAL mode
C. Open the database in RESTRICTED mode
D. Open the database with the RESETLOGS option
Answer: A
驗證:
[oracle@db01 ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Tue Mar 15 16:14:15 2016
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount
Oracle instance started
Total System Global Area 413372416 bytes
Fixed Size 2253784 bytes
Variable Size 310381608 bytes
Database Buffers 92274688 bytes
Redo Buffers 8462336 bytes
RMAN> restore controlfile from autobackup;
Starting restore at 15-MAR-16
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=125 device type=DISK
recovery area destination: /u01/app/oracle/fast_recovery_area
database name (or database unique name) used for search: INST1
channel ORA_DISK_1: AUTOBACKUP /u01/app/oracle/fast_recovery_area/INST1/autobackup/2016_03_15/o1_mf_s_906563655_cghjw045_.bkp found in the recovery area
AUTOBACKUP search with format "%F" not attempted because DBID was not set
channel ORA_DISK_1: restoring control file from AUTOBACKUP /u01/app/oracle/fast_recovery_area/INST1/autobackup/2016_03_15/o1_mf_s_906563655_cghjw045_.bkp
channel ORA_DISK_1: control file restore from AUTOBACKUP complete
output file name=/u01/app/oracle/oradata/inst1/control01.ctl
output file name=/u01/app/oracle/fast_recovery_area/inst1/control02.ctl
Finished restore at 15-MAR-16
RMAN> alter database open;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/15/2016 16:14:49
ORA-01507: database not mounted
RMAN> startup
database is already started
database mounted
released channel: ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 03/15/2016 16:15:05
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
RMAN> startup resetlogs;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "resetlogs": expecting one of: "dba, force, mount, newline, nomount, pfile, ;"
RMAN-01007: at line 1 column 9 file: standard input
RMAN> alter database mount;
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of alter db command at 03/15/2016 16:15:26
ORA-01100: database already mounted
RMAN> alter database open resetlogs;
database opened
RMAN>
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/8520577/viewspace-2057691/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle OCP IZ0-053 Q682(Rman Crosscheck)OracleROS
- Oracle OCP IZ0-053 Q88(Rman Channel)Oracle
- Oracle OCP IZ0-053 Q695(Rman catalog)Oracle
- Oracle OCP IZ0-053 Q594(RMAN Image Copy)Oracle
- Oracle OCP IZ0-053 Q193(rman recover)Oracle
- Oracle OCP IZ0-053 Q620(Rman Catalog)Oracle
- Oracle OCP IZ0-053 Q251(Rman Import Catalog)OracleImport
- Oracle OCP IZ0-053 Q319(Rman Retention)Oracle
- Oracle OCP IZ0-053 Q241(RMAN Recovery Catalog Keep)Oracle
- Oracle OCP IZ0-053 Q312(RMAN Catalog)Oracle
- Oracle OCP IZ0-053 Q311(Rman catalog stored scripts)Oracle
- Oracle OCP IZ0-053 Q543Oracle
- Oracle OCP IZ0-053 Q2Oracle
- Oracle OCP IZ0-053 Q282Oracle
- Oracle OCP IZ0-053 Q705Oracle
- Oracle OCP IZ0-053 Q476Oracle
- Oracle OCP IZ0-053 Q452Oracle
- Oracle OCP 1Z0 053 Q64(RESETLOGS&LOG_ARCHIVE_FORMAT)OracleHiveORM
- Oracle OCP IZ0-053 Q14(Hot Patch)Oracle
- Oracle OCP IZ0-053 Q432(Segment Shrink)Oracle
- Oracle OCP IZ0-053 Q651(Scheduler Job)Oracle
- Oracle OCP IZ0-053 Q694(Transportable Tablespace)Oracle
- Oracle IZ0-053 Q285(Rman Repair Failure)OracleAI
- Oracle IZ0-053 Q336(Rman Duration)Oracle
- Oracle OCP(60):RMAN 備份Oracle
- Oracle OCP IZ0-053(Recovery Missing Active Redo Log)Oracle
- Oracle OCP IZ0-053 Q448(Job Coordinator)Oracle
- Oracle OCP IZ0-053 Q257(workload capture)OracleAPT
- Oracle OCP IZ0-053 710(Recyclebin&Tablespace Quato)Oracle
- Oracle OCP IZ0-053 Q582(Recover Archivedlog)OracleHive
- Oracle OCP IZ0-053 Q425( transportable tablespace set)Oracle
- Oracle OCP IZ0-053 Q157(Data Encryption)Oracle
- Oracle OCP IZ0-053 Q530(ASM Shutdown Normal)OracleASMORM
- Oracle OCP IZ0-053 Q14(? ?NLS_LENGTH_SEMANTICS)Oracle
- Oracle OCP IZ0-053 Q166(Flashback Data Archive)OracleHive
- Oracle OCP IZ0-053 Q219(DB_SECUREFILE)Oracle
- Oracle OCP IZ0-053 Q692(Workload Capture and Replay)OracleAPT
- Oracle OCP IZ0-053 Q216(Job Chain Process)OracleAI