[oracle@ocm2 dbs]$ mkdir /home/oracle/flash [oracle@ocm2 dbs]$ mkdir /home/oracle/temp [oracle@ocm2 dbs]$ mkdir /home/oracle/scripts
2.4.Copy Files from the Primary System to the Standby System 从主库拷贝文件到备库
①password parameter file created in 1.2
[oracle@ocm2 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs [oracle@ocm1 dbs]$ scp orapwPROD ocm2.localdomain:/u01/app/oracle/product/10.2.0/db_1/dbs oracle@ocm2.localdomain's password: orapwPROD 100% 5120 5.0KB/s 00:01 [oracle@ocm1 dbs]$
在备库中修改密码文件名称 [oracle@ocm2 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs [oracle@ocm2 dbs]$ ll total 56 -rw-rw---- 1 oracle oinstall 1544 Mar 24 14:10 hc_EMREP.dat -rw-r----- 1 oracle oinstall 12920 May 3 2001 initdw.ora -rw-r----- 1 oracle oinstall 8385 Sep 11 1998 init.ora -rw-r--r-- 1 oracle oinstall 1960 Mar 25 10:13 initPRODSTD.ora -rw-rw---- 1 oracle oinstall 24 Mar 20 15:14 lkEMREP -rw-r----- 1 oracle oinstall 1536 Mar 20 16:16 orapwEMREP -rw-r----- 1 oracle oinstall 5120 Mar 25 10:17 orapwPROD -rw-r----- 1 oracle oinstall 2560 Mar 24 14:10 spfileEMREP.ora [oracle@ocm2 dbs]$ mv orapwPROD orapwPRODSTD
②Backup datafiles created in Section 2.1
[oracle@ocm1 dbs]$ scp /u01/app/oracle/oradata/PROD.tar.gz ocm2.localdomain:/u01/app/oracle/oradata/ oracle@ocm2.localdomain's password: PROD.tar.gz 100% 225MB 2.8MB/s 01:20 [oracle@ocm1 dbs]$
在备库中恢复
[oracle@ocm2 ~]$ cd /u01/app/oracle/oradata/ [oracle@ocm2 oradata]$ ll total 230872 drwxr-x--- 2 oracle oinstall 4096 Mar 20 15:16 EMREP -rw-r--r-- 1 oracle oinstall 236170241 Mar 25 10:21 PROD.tar.gz [oracle@ocm2 oradata]$ tar -xzvf PROD.tar.gz PROD/ PROD/Disk1/ PROD/Disk1/temp01.dbf PROD/Disk1/standby07.log PROD/Disk1/standby11.log PROD/Disk1/redo03.log PROD/Disk1/standby10.log PROD/Disk1/standby09.log PROD/Disk1/system01.dbf PROD/Disk1/redo01.log PROD/Disk1/standby08.log PROD/Disk1/standby06.log PROD/Disk1/control01.ctl PROD/Disk1/users01.dbf PROD/Disk1/sysaux01.dbf PROD/Disk1/example01.dbf PROD/Disk1/redo02.log PROD/Disk1/redo05.log PROD/Disk1/redo04.log PROD/Disk1/undotbs01.dbf PROD/Disk2/ PROD/Disk2/standby07_1.log PROD/Disk2/standby06_1.log PROD/Disk2/redo03_1.log PROD/Disk2/standby09_1.log PROD/Disk2/standby08_1.log PROD/Disk2/control02.ctl PROD/Disk2/redo05_1.log PROD/Disk2/redo02_1.log PROD/Disk2/redo01_1.log PROD/Disk2/redo04_1.log PROD/Disk2/standby10_1.log PROD/Disk2/standby11_1.log PROD/Disk2/arch/ PROD/Disk2/arch/arc_05p3jeqe_1_1.bak PROD/Disk3/ PROD/Disk3/control03.ctl PROD/Disk4/ PROD/Disk5/ PROD/Disk5/bak/ PROD/Disk5/bak/PROD_04p3jeq8_1_1.bak PROD/Disk5/bak/PROD_03p3jemu_1_1.bak [oracle@ocm2 oradata]$ [oracle@ocm2 oradata]$ ll total 230876 drwxr-x--- 2 oracle oinstall 4096 Mar 20 15:16 EMREP drwxr-xr-x 7 oracle oinstall 4096 Mar 19 13:16 PROD -rw-r--r-- 1 oracle oinstall 236170241 Mar 25 10:21 PROD.tar.gz [oracle@ocm2 oradata]$ mv PROD PRODSTD [oracle@ocm2 oradata]$ ll total 230876 drwxr-x--- 2 oracle oinstall 4096 Mar 20 15:16 EMREP drwxr-xr-x 7 oracle oinstall 4096 Mar 19 13:16 PRODSTD -rw-r--r-- 1 oracle oinstall 236170241 Mar 25 10:21 PROD.tar.gz [oracle@ocm2 oradata]$ rm -rf PROD.tar.gz [oracle@ocm2 oradata]$ ll total 8 drwxr-x--- 2 oracle oinstall 4096 Mar 20 15:16 EMREP drwxr-xr-x 7 oracle oinstall 4096 Mar 19 13:16 PRODSTD-路径和PROD的路径一致
删除PRODSTD中原主库控制文件 [oracle@ocm2 oradata]$ pwd /u01/app/oracle/oradata [orac