OCM_Session8_2_Step-by-StepInstructionsforCreatingaPhysicalStandbyDatabase - 数据库编程

le@ocm2 oradata]$ rm -rf PRODSTD/Disk1/control01.ctl [oracle@ocm2 oradata]$ rm -rf PRODSTD/Disk2/control02.ctl [oracle@ocm2 oradata]$ rm -rf PRODSTD/Disk3/control03.ctl
③Standby control file created in Section2.2
[oracle@ocm1 dbs]$ scp /home/oracle/control01.ctl ocm2.localdomain:/u01/app/oracle/oradata/PRODSTD/Disk1 oracle@ocm2.localdomain's password: control01.ctl 100% 6672KB 3.3MB/s 00:02 [oracle@ocm1 dbs]$

④Initialization parameter file created in Section2.3，已经拷贝
2.5 Set Up the Environment to Support the Standby Database
Step 1 Create a Windows-based service.-linux操作下面不用操作这一步 Step 2 Create a password file. 2.4.1已经创建 Step 3 Configure listeners for the primary and standby databases. Step 4 Create Oracle Net service names.

ocm1 [oracle@ocm1 dbs]$ cd /u01/app/oracle/product/10.2.0/db_1/network/admin/ [oracle@ocm1 admin]$ ll total 20 -rw-r--r-- 1 oracle oinstall 712 Mar 18 12:30 listener.ora drwxr-x--- 2 oracle oinstall 4096 Mar 16 19:17 samples -rw-r----- 1 oracle oinstall 172 Dec 26 2003 shrept.lst -rw-r--r-- 1 oracle oinstall 41 Mar 18 13:38 sqlnet.ora -rw-r--r-- 1 oracle oinstall 589 Mar 18 18:47 tnsnames.ora

[oracle@ocm1 admin]$ cat listener.ora LISTENER= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)) (ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))) SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (GLOBAL_DBNAME=PROD) (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1) (SID_NAME=PROD)) (SID_DESC= (GLOBAL_DBNAME=PRODSTD) (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1)----添加 (SID_NAME=PRODSTD)) (SID_DESC= (SID_NAME=plsextproc) (ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1) (PROGRAM=extproc)))
LSNR2= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1526)) (ADDRESS=(PROTOCOL=ipc)(KEY=extproc1)))) [oracle@ocm1 admin]$ cat tnsnames.ora prod= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521)) (CONNECT_DATA= (SERVICE_NAME=PROD) (SERVER=dedicated)))
PRODSTD= (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST=ocm2.localdomain)(PORT=1521))-添加 (CONNECT_DATA= (SERVICE_NAME=PRODSTD) (SERVER=dedicated))) [oracle@ocm1 admin]$
[oracle@ocm1 admin]$ lsnrctl start
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 25-MAR-2014 10:48:36
Copyright (c) 1991, 2005, Oracle. All rights reserved.
Starting /u01/app/oracle/product/10.2.0/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 10.2.0.1.0 - Production System parameter file is /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Log messages written to /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=extproc)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ocm1.localdomain)(PORT=1521))) STATUS of the LISTENER ------------------------ Alias LISTENER Version TNSLSNR for Linux: Version 10.2.0.1.0 - Production Start Date 25-MAR-2014 10:48:38 Uptime 0 days 0 hr. 0 min. 0 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/listener.ora Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listener.log Listeni

OCM_Session8_2_Step-by-StepInstructionsforCreatingaPhysicalStandbyDatabase(五)