2.Step-by-Step Instructions for Creating a Physical Standby Database
准备工作： 创建转储目录
[oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/adump [oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/bdump [oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/cdump [oracle@ocm2 dbs]$ mkdir -p /u01/app/oracle/admin/PRODSTD/udump
Table 3-2 Creating a Physical Standby Database
| Reference | Task | Database |
|---|---|---|
| Section 3.2.1 |
Create a Backup Copy of the Primary Database Datafiles |
Primary |
| Section 3.2.2 |
Create a Control File for the Standby Database |
Primary |
| Section 3.2.3 |
Prepare an Initialization Parameter File for the Standby Database |
Primary |
| Section 3.2.4 |
Copy Files from the Primary System to the Standby System |
Primary |
| Section 3.2.5 |
Set Up the Environment to Support the Standby Database |
Standby |
| Section 3.2.6 |
Start the Physical Standby Database |
Standby |
| Section 3.2.7 |
Verify the Physical Standby Database Is Performing Properly |
Standby |
2.1.Create a Backup Copy of the Primary Database Datafiles 冷备份主库
SYS@PROD>! [oracle@ocm1 ~]$ cd /u01/app/oracle/oradata/ [oracle@ocm1 oradata]$ ll total 4 drwxr-xr-x 7 oracle oinstall 4096 Mar 19 13:16 PROD [oracle@ocm1 oradata]$ tar -czvf PROD.tar.gz PROD 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@ocm1 oradata]$ exit exit
2.2.Create a Control File for the Standby Database 成备库的控制文件
SYS@PROD>startup mount ORACLE instance started.
Total System Global Area 524288000 bytes Fixed Size 1220360 bytes Variable Size 171966712 bytes Database Buffers 348127232 bytes Redo Buffers 2973696 bytes Database mounted. SYS@PROD> SYS@PROD> ALTER DATABASE CREATE STANDBY CONTROLFILE AS '/home/oracle/control01.ctl';
Database altered.
SYS@PROD> ALTER DATABASE OPEN;
Database altered.
2.3.Prepare an Initialization Parameter File for the Standby Database
准备备库的参数文件 initPRODSTD.ora
①在主库中将主库的pfile文件传输到备库中 [oracle@ocm1 ~]$ cd /u01/app/oracle/product/10.2.0/db_1/dbs [oracle@ocm1 dbs]$ ll total 6744 -rw-rw---- 1 oracle oinstall 1544 Mar 25 09:59 hc_PROD.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 1827 Mar 25 09:39 initPROD.ora -rw-rw---- 1 oracle oinstall 24 Mar 18 10:18 lkPROD -rw-r----- 1 oracle oinstall 5120 Mar 18 09:54 orapwPROD -rw-r--r-- 1 oracle oinstall 318 Mar 17 20:37 pfile.ora -rw-r----- 1 oracle oinst