Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database

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 name=+FRADG/zwc/archivelog/2013_09_20/thread_2_seq_5.269.826634877 RECID=9 STAMP=826634878  
Finished backup at 20-SEP-2013 12:48:09  
  
Starting backup at 20-SEP-2013 12:48:10  
using channel ORA_DISK_1  
channel ORA_DISK_1: starting full datafile backup set  
channel ORA_DISK_1: specifying datafile(s) in backup set  
input datafile file number=00001 name=+DATADG/zwc/datafile/system.256.826495029  
input datafile file number=00002 name=+DATADG/zwc/datafile/sysaux.257.826495029  
input datafile file number=00005 name=+DATADG/zwc/datafile/example.264.826495145  
input datafile file number=00003 name=+DATADG/zwc/datafile/undotbs1.258.826495029  
input datafile file number=00006 name=+DATADG/zwc/datafile/undotbs2.265.826495425  
input datafile file number=00004 name=+DATADG/zwc/datafile/users.259.826495029  
channel ORA_DISK_1: starting piece 1 at 20-SEP-2013 12:48:10  
channel ORA_DISK_1: finished piece 1 at 20-SEP-2013 12:49:56  
piece handle=/u01/app/oracle/bak/20130920_2_1_DAT tag=TAG20130920T124810 comment=NONE  
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:46  
Finished backup at 20-SEP-2013 12:49:56  
  
Starting backup at 20-SEP-2013 12:49:56  
current log archived  
using channel ORA_DISK_1  
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=10 RECID=11 STAMP=826635000  
input archived log thread=2 sequence=6 RECID=10 STAMP=826634997  
channel ORA_DISK_1: starting piece 1 at 20-SEP-2013 12:50:00  
channel ORA_DISK_1: finished piece 1 at 20-SEP-2013 12:50:01  
piece handle=/u01/app/oracle/bak/20130920_3_1_ARC tag=TAG20130920T125000 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_20/thread_1_seq_10.268.826634999 RECID=11 STAMP=826635000  
archived log file name=+FRADG/zwc/archivelog/2013_09_20/thread_2_seq_6.269.826634997 RECID=10 STAMP=826634997  
Finished backup at 20-SEP-2013 12:50:02  
  
Starting Control File and SPFILE Autobackup at 20-SEP-2013 12:50:03  
piece handle=/u01/app/oracle/bak/c-582474828-20130920-00_CNT comment=NONE  
Finished Control File and SPFILE Autobackup at 20-SEP-2013 12:50:10  
  
RMAN> exit  
  
  
Recovery Manager complete.  

[oracle@vzwc1 dbs]$ sqlplus / as sysdba  
  
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 12:53:17 2013  
  
Copyright (c) 1982, 2013, Oracle.  All rights reserved.  
  
  
Connected to:  
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production  
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,  
Data Mining and Real Application Testing options  
  
SQL> show parameter spfile  
  
NAME                                 TYPE        VALUE  
------------------------------------ ----------- ------------------------------  
spfile                               string      +DATADG/zwc/spfilezwc.ora  
SQL> create pfile='initzwc.ora' from spfile;  
  
File created.  

[oracle@vzwc1 dbs]$ cat initzwc.ora   
#zwc2.__db_cache_size=553648128  
#zwc1.__db_cache_size=536870912  
#zwc1.__java_pool_size=16777216  
#zwc2.__java_pool_size=16777216  
#zwc1.__large_pool_size=33554432  
#zwc2.__large_pool_size=33554432  
#zwc2.__pga_aggregate_target=285212672  
#zwc1.__pga_aggregate_target=318767104  
#zwc2.__sga_target=989855744  
#zwc1.__sga_target=956301312  
#zwc1.__shared_io_pool_size=0  
#zwc2.__shared_io_pool_size=0  
#zwc1.__shared_pool_size=352321536  
#zwc2.__shared_pool_size=369098752  
#zwc1.__streams_pool_size=0  
#zwc2.__streams_pool_size=0  
*.audit_file_dest='/u01/app/oracle/admin/zwc/adump'  
*.audit_trail='db'  
#*.cluster_database=true  
*.compatible='11.2.0.4.0'  
*.control_files='/u01/app/oracle/oradata/zwc/control01.ctl','/u01/app/oracle/oradata/zwc/control02.ctl'  
*.db_block_size=8192  
#*.db_create_file_dest='+DATADG'  
*.db_domain=''  
*.db_name='zwc'  
#*.db_recovery_file_dest='+FRADG'  
#*.db_recovery_file_dest_size=10737418240  
*.diagnostic_dest='/u01/app/oracle'  
*.dispatchers='(PROTOCOL=TCP) (SERVICE=zwcXDB)'  
#zwc2.instance_number=2  
#zwc1.instance_number=1  
*.log_archive_format='%t_%s_%r.dbf'  
#*.memory_target=1262485504  
*.open_cursors=300  
*.processes=1200  
#*.remote_listener='vzwc-cluster-scan:1521'  
*.remote_login_passwordfile='exclusive'  
*.sessions=1325  
#zwc2.t