Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database(九)
bf
/u01/app/oracle/oradata/zwc/redo_2_2.log
/u01/app/oracle/oradata/zwc/redo_2_1.log
/u01/app/oracle/oradata/zwc/redo_1_2.log
/u01/app/oracle/oradata/zwc/redo_1_1.log
/u01/app/oracle/oradata/zwc/redo_3_2.log
/u01/app/oracle/oradata/zwc/redo_3_1.log
/u01/app/oracle/oradata/zwc/redo_4_2.log
/u01/app/oracle/oradata/zwc/redo_4_1.log
/u01/app/oracle/oradata/zwc/control01.ctl
/u01/app/oracle/oradata/zwc/control02.ctl
17 rows selected.
SQL>
SQL> col member for a50
SQL> select group#,member from v$logfile order by 1
2
SQL> /
GROUP# MEMBER
---------- --------------------------------------------------
1 /u01/app/oracle/oradata/zwc/redo_1_1.log
1 /u01/app/oracle/oradata/zwc/redo_1_2.log
2 /u01/app/oracle/oradata/zwc/redo_2_1.log
2 /u01/app/oracle/oradata/zwc/redo_2_2.log
3 /u01/app/oracle/oradata/zwc/redo_3_2.log
3 /u01/app/oracle/oradata/zwc/redo_3_1.log
4 /u01/app/oracle/oradata/zwc/redo_4_2.log
4 /u01/app/oracle/oradata/zwc/redo_4_1.log
8 rows selected.
SQL>
[oracle@rmanrec ~]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 20 05:37:19 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (DBID=582474828, not open)
RMAN> recover database;
Starting recover at 20-SEP-2013 05:38:05
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=18 device type=DISK
starting media recovery
channel ORA_DISK_1: starting archived log restore to default destination
channel ORA_DISK_1: restoring archived log
archived log thread=1 sequence=10
channel ORA_DISK_1: restoring archived log
archived log thread=2 sequence=6
channel ORA_DISK_1: reading from backup piece /u01/app/oracle/bak/20130920_3_1_ARC
channel ORA_DISK_1: piece handle=/u01/app/oracle/bak/20130920_3_1_ARC tag=TAG20130920T125000
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_10_826495119.dbf thread=1 sequence=10
archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch2_6_826495119.dbf thread=2 sequence=6
unable to find archived log
archived log thread=2 sequence=7
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 09/20/2013 05:38:08
RMAN-06054: media recovery requesting unknown archived log for thread 2 with sequence 7 and starting SCN of 1055464
RMAN>
alter database open resetlogs;
database opened
RMAN>
alert_zwc.log
Fri Sep 20 05:38:06 2013
alter database recover datafile list clear
Completed: alter database recover datafile list clear
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
alter database recover if needed
start until cancel using backup controlfile
Media Recovery Start
Serial Media Recovery started
ORA-279 signalled during: alter database recover if needed
s