Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database
Oracle RACOracle RMANOracle
Source 2-Nodes Oracle 11.2.0.4.0 RAC
Target Single Instance Oracle 11.2.0.4.0
Source
[oracle@vzwc1 oracle]$ mkdir /u01/app/oracle/bak
[oracle@vzwc1 oracle]$ rman target /
Recovery Manager: Release 11.2.0.4.0 - Production on Fri Sep 20 12:45:57 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: ZWC (DBID=582474828)
RMAN> run
2> {
3> CONFIGURE CONTROLFILE AUTOBACKUP ON;
4> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/bak/%F_CNT';
5> BACKUP FORMAT '/u01/app/oracle/bak/%T_%s_%p_DAT' DATABASE
6> PLUS ARCHIVELOG FORMAT '/u01/app/oracle/bak/%T_%s_%p_ARC' DELETE ALL INPUT;
7> }
using target database control file instead of recovery catalog
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/app/oracle/bak/%F_CNT';
new RMAN configuration parameters are successfully stored
Starting backup at 20-SEP-2013 12:47:54
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=75 instance=zwc1 device type=DISK
channel ORA_DISK_1: starting archived log backup set
channel ORA_DISK_1: specifying archived log(s) in backup set
input archived log thread=1 sequence=6 RECID=2 STAMP=826495840
input archived log thread=2 sequence=1 RECID=1 STAMP=826495593
input archived log thread=2 sequence=2 RECID=3 STAMP=826495840
input archived log thread=2 sequence=3 RECID=5 STAMP=826495942
input archived log thread=1 sequence=7 RECID=4 STAMP=826495882
input archived log thread=1 sequence=8 RECID=7 STAMP=826630270
input archived log thread=2 sequence=4 RECID=6 STAMP=826495944
input archived log thread=1 sequence=9 RECID=8 STAMP=826634876
input archived log thread=2 sequence=5 RECID=9 STAMP=826634878
channel ORA_DISK_1: starting piece 1 at 20-SEP-2013 12:48:05
channel ORA_DISK_1: finished piece 1 at 20-SEP-2013 12:48:06
piece handle=/u01/app/oracle/bak/20130920_1_1_ARC tag=TAG20130920T124804 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
channel ORA_DISK_1: deleting archived log(s)
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_1_seq_6.263.826495841 RECID=2 STAMP=826495840
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_2_seq_1.261.826495591 RECID=1 STAMP=826495593
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_2_seq_2.262.826495839 RECID=3 STAMP=826495840
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_2_seq_3.265.826495943 RECID=5 STAMP=826495942
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_1_seq_7.264.826495883 RECID=4 STAMP=826495882
archived log file name=+FRADG/zwc/archivelog/2013_09_20/thread_1_seq_8.267.826630269 RECID=7 STAMP=826630270
archived log file name=+FRADG/zwc/archivelog/2013_09_18/thread_2_seq_4.266.826495943 RECID=6 STAMP=826495944
archived log file name=+FRADG/zwc/archivelog/2013_09_20/thread_1_seq_9.268.826634877 RECID=8 STAMP=826634876
archived log file n