OCM_Session8_3_RoleTransitionsInvolvingPhysicalStandbyDatabases - 数据库编程

在上一章节已经测试过物理备库是否在应用归档日志，在这一章节中再次验证主库创建的表空间是否应用到备库。
1 .首先创建一个表空间。
SYS@PROD>create tablespace swtich_tbs datafile '/u01/app/oracle/oradata/PROD/Disk1/swtich_tbs01.dbf' size 10m;
Tablespace created.

##################################################################################################
tail -f alert_PROD.log
ue Mar 25 12:25:44 2014 create tablespace swtich_tbs datafile '/u01/app/oracle/oradata/PROD/Disk1/swtich_tbs01.dbf' size 10m Tue Mar 25 12:25:47 2014 Completed: create tablespace swtich_tbs datafile '/u01/app/oracle/oradata/PROD/Disk1/swtich_tbs01.dbf' size 10m
##################################################################################################

2.手动归档，让日志同步。
SYS@PROD> alter system archive log current;
System altered.
##################################################################################################
tail -f alert_PROD.log

LNS1 started with pid=54, OS id=9623 Tue Mar 25 12:26:37 2014 Thread 1 advanced to log sequence 18 Current log# 5 seq# 18 mem# 0: /u01/app/oracle/oradata/PROD/Disk1/redo05.log Current log# 5 seq# 18 mem# 1: /u01/app/oracle/oradata/PROD/Disk2/redo05_1.log Tue Mar 25 12:26:38 2014 LNS: Standby redo logfile selected for thread 1 sequence 18 for destination LOG_ARCHIVE_DEST_2 Tue Mar 25 12:27:08 2014 ARC8: Standby redo logfile selected for thread 1 sequence 17 for destination LOG_ARCHIVE_DEST_2

tail -f alert_PRODSTD.log
Tue Mar 25 12:26:30 2014 RFS[4]: Possible network disconnect with primary database Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[5]: Assigned to RFS process 4505 RFS[5]: Identified database type as 'physical standby' Primary database is in MAXIMUM PERFORMANCE mode Primary database is in MAXIMUM PERFORMANCE mode RFS[5]: Successfully opened standby log 7: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby07.log' Tue Mar 25 12:26:42 2014 Fetching gap sequence in thread 1, gap sequence 17-17 Tue Mar 25 12:27:08 2014 Redo Shipping Client Connected as PUBLIC -- Connected User is Valid RFS[6]: Assigned to RFS process 4508 RFS[6]: Identified database type as 'physical standby' RFS[6]: Successfully opened standby log 6: '/u01/app/oracle/oradata/PRODSTD/Disk1/standby06.log' Tue Mar 25 12:27:13 2014 Media Recovery Log /u01/app/oracle/oradata/PRODSTD/Disk2/arch/1_17_842523531.arc Successfully added datafile 5 to media recovery Datafile #5: '/u01/app/oracle/oradata/PRODSTD/Disk1/PRODSTD/datafile/o1_mf_swtich_t_9m21f1f0_.dbf' Media Recovery Waiting for thread 1 sequence 18 (in transit)
##################################################################################################
3.分别在主库备库中都能查到刚在主库新建的表空间。 SYS@ PROD>select * from v$tablespace;
TS# NAME INC BIG FLA ENC ---------- ------------------------------ --- --- --- --- 0 SYSTEM YES NO YES 1 UNDOTBS1 YES NO YES 2 SYSAUX YES NO YES 3 TEMPTS1 NO NO YES 12 SWTICH_TBS YES NO YES 7 EXAMPLE YES YES YES 10 USERS YES NO YES
7 rows selected.

SYS@ PRODSTD>select * from v$tablespace;
TS# NAME INC BIG FLA ENC ---------- ------------------------------ --- --- --- --- 0 SYSTEM YES NO YES 1 UNDOTBS1 YES NO YES 2 SYSAUX YES NO YES 3 TEMPTS1 NO NO YES 12 SWTICH_TBS YES NO YES 7 EXAMPLE YES YES YES 10 USERS YES NO YES
7 rows selected.

第一次切换，主库PROD与备库PRODSTD切换。 参考官方文档：7 Role Transitions-->7.2 Role Transitions Involving Physical Standby Databases http://docs.oracle.co

OCM_Session8_3_RoleTransitionsInvolvingPhysicalStandbyDatabases(一)