Oracle OCP IZ0-053 Q64(Rman controlfile)

abstractcyj發表於2016-03-15
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> 

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

相關文章