Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database(二)
ame=+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.__pg