OCM_Session8_2_Step-by-StepInstructionsforCreatingaPhysicalStandbyDatabase - 数据库编程

RESS=(PROTOCOL=ipc)(KEY=EXTPROC0))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Service "PROD" has 1 instance(s). Instance "PROD", status UNKNOWN, has 1 handler(s) for this service... Service "PRODSTD" has 1 instance(s). Instance "PRODSTD", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully [oracle@ocm2 admin]$
Step 5 Create a server parameter file for the standby database.
[oracle@ocm2 ~]$ export ORACLE_SID=PRODSTD [oracle@ocm2 ~]$ sqlplus "/as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 25 11:06:14 2014
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to an idle instance.
SYS@PRODSTD> create spfile from pfile;
File created.

2.6.Start the Physical Standby Database 启动备库
Step 1 Start the physical standby database.
SYS@PRODSTD>startup mount ORACLE instance started.
Total System Global Area 524288000 bytes Fixed Size 1220360 bytes Variable Size 188743928 bytes Database Buffers 331350016 bytes Redo Buffers 2973696 bytes Database mounted. SYS@PRODSTD> 备库 SYS@PRODSTD>select database_role,switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PHYSICAL STANDBY RECOVERY NEEDED 主库 SYS@PROD>select database_role,switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PRIMARY SESSIONS ACTIVE
Step 2 Start Redo Apply.

备库只有在mount状态的时候可以应用日志，read only状态不能应用日志应用日志调用2个MRP进程启动LEO3库日志应用并后台运行 alter database recover managed standby database disconnect from session parallel 2;
备库 SYS@PRODSTD>alter database recover managed standby database disconnect from session parallel 2;
Database altered.
SYS@PRODSTD>select database_role,switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PHYSICAL STANDBY SESSIONS ACTIVE
主库 SYS@PROD>select database_role,switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PRIMARY SESSIONS ACTIVE
Step 3 Test archival operations to the physical standby database.
SYS@PROD>alter system switch logfile;
System altered.

tail -f alert_PROD.log
LNS1 started with pid=59, OS id=9381 Tue Mar 25 11:23:53 2014 Thread 1 advanced to log sequence 13 Current log# 5 seq# 13 mem# 0: /u01/app/oracle/oradata/PROD/Disk1/redo05.log Current log# 5 seq# 13 mem# 1: /u01/app/oracle/oradata/PROD/Disk2/redo05_1.log Tue Mar 25 11:23:54 2014 ****************************************************************** LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2 ****************************************************************** LNS: Standby redo logfile selected for thread 1 sequence 13 for destination LOG_ARCHIVE_DEST_2 Tue Mar 25 11:23:55 2014 ARC4: Standby redo logfile selected for thread 1 sequence 12 for destination LOG_ARCHIVE_DEST_2
tail -f alert_PRODSTD.log
Tue Mar 25 11:23:54 2014 Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[2]: Assigned to RFS process 4259 RFS[2]: Identified database type as 'physical standby' Tue Mar 25 11:23:54 2014 Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[3]: Assigned to RFS process 4257 RFS[3]: Identified database type as 'physical standby' Primary database is in MAXIMUM P

OCM_Session8_2_Step-by-StepInstructionsforCreatingaPhysicalStandbyDatabase(七)