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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8520577/viewspace-2057691/