Oracle 11.2.0.4.0 RAC Using RMAN Recovery to Single Instance Database(四)
a_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.thread=2
#zwc1.thread=1
#zwc1.undo_tablespace='UNDOTBS1'
#zwc2.undo_tablespace='UNDOTBS2'
*.undo_tablespace='UNDOTBS1'
[oracle@vzwc1 bak]$ tar -czvf fullbak.tar.gz *
20130920_1_1_ARC
20130920_2_1_DAT
20130920_3_1_ARC
c-582474828-20130920-00_CNT
[oracle@vzwc1 bak]$ ll
total 1437936
-rw-r----- 1 oracle asmadmin 15411200 Sep 20 12:48 20130920_1_1_ARC
-rw-r----- 1 oracle asmadmin 1153646592 Sep 20 12:49 20130920_2_1_DAT
-rw-r----- 1 oracle asmadmin 12288 Sep 20 12:50 20130920_3_1_ARC
-rw-r----- 1 oracle asmadmin 18579456 Sep 20 12:50 c-582474828-20130920-00_CNT
-rw-r--r-- 1 oracle oinstall 283332444 Sep 20 13:00 fullbak.tar.gz
[oracle@vzwc1 bak]$ scp fullbak.tar.gz oracle@192.168.1.11:/u01/app/oracle/bak
The authenticity of host '192.168.1.11 (192.168.1.11)' can't be established.
RSA key fingerprint is 2b:c6:19:09:45:4b:ee:ba:c2:6f:48:da:04:72:de:27.
Are you sure you want to continue connecting (yes/no) yes
Warning: Permanently added '192.168.1.11' (RSA) to the list of known hosts.
oracle@192.168.1.11's password:
fullbak.tar.gz 100% 270MB 18.0MB/s 00:15
[oracle@vzwc1 bak]$ scp $ORACLE_HOME/dbs/initzwc.ora oracle@192.168.1.11:/u01/app/oracle/product/11.2.0/dbhome_1/dbs
oracle@192.168.1.11's password:
initzwc.ora 100% 1359 1.3KB/s 00:00
[oracle@vzwc1 bak]$
Target
[oracle@rmanrec ~]$ mkdir /u01/app/oracle/arch
[oracle@rmanrec ~]$ mkdir -p /u01/app/oracle/admin/zwc/adump
[oracle@rmanrec ~]$ mkdir -p /u01/app/oracle/oradata/zwc
[oracle@rmanrec ~]$ orapwd file=$ORACLE_HOME/dbs/orapwzwc entries=5 force=y password=oracle
[oracle@rmanrec ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Fri Sep 20 05:10:18 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
create spfile from pfile;
File created.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 384180224 bytes
Fixed Size 2253424 bytes
Variable Size 327159184 bytes
Database Buffers 50331648 bytes
Redo Buffers 4435968 bytes
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With t