############################################################################################
SYS@PROD>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,applied from v$archived_log;
SEQUENCE# FIRST_TIM NEXT_TIME APP ---------- --------- --------- --- ... 17 25-MAR-14 25-MAR-14 YES 17 25-MAR-14 25-MAR-14 YES 18 25-MAR-14 25-MAR-14 YES 18 25-MAR-14 25-MAR-14 NO 19 25-MAR-14 25-MAR-14 YES 19 25-MAR-14 25-MAR-14 NO 20 25-MAR-14 25-MAR-14 YES 20 25-MAR-14 25-MAR-14 NO 21 25-MAR-14 25-MAR-14 YES 22 25-MAR-14 25-MAR-14 YES
27 rows selected.
SYS@PROD>
SYS@PRODSTD>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME,applied from v$archived_log;
SEQUENCE# FIRST_TIM NEXT_TIME APP ---------- --------- --------- --- ..... 17 25-MAR-14 25-MAR-14 YES 18 25-MAR-14 25-MAR-14 YES 19 25-MAR-14 25-MAR-14 YES 20 25-MAR-14 25-MAR-14 YES 21 25-MAR-14 25-MAR-14 NO 21 25-MAR-14 25-MAR-14 YES 22 25-MAR-14 25-MAR-14 NO 22 25-MAR-14 25-MAR-14 YES
14 rows selected.
############################################################################################
在PRODSTD 数据库中创建一个表，验证是否能在PROD数据库中查到。这里的验证可能有点问题。
SYS@PRODSTD>create table switch_tb as select * from dba_objects;
Table created.
SYS@PRODSTD>ALTER SYSTEM SWITCH LOGFILE;
System altered.
Tue Mar 25 13:05:50 2014 Primary database is in MAXIMUM PERFORMANCE mode RFS[2]: Successfully opened standby log 6: '/u01/app/oracle/oradata/PROD/Disk1/standby06.log' Tue Mar 25 13:05:54 2014 Media Recovery Log /u01/app/oracle/oradata/PROD/Disk2/arch/1_23_842523531.arc Media Recovery Waiting for thread 1 sequence 24 (in transit)
tail -f alert_PRODSTD.log
Tue Mar 25 13:05:49 2014 Thread 1 advanced to log sequence 24 Current log# 4 seq# 24 mem# 0: /u01/app/oracle/oradata/PRODSTD/Disk1/redo04.log Current log# 4 seq# 24 mem# 1: /u01/app/oracle/oradata/PRODSTD/Disk2/redo04_1.log Tue Mar 25 13:05:50 2014 LNS: Standby redo logfile selected for thread 1 sequence 24 for destination LOG_ARCHIVE_DEST_2
SYS@PROD>select count(*) from switch_tb; select count(*) from switch_tb * ERROR at line 1: ORA-01219: database not open: queries allowed on fixed tables/views only
SYS@PROD>startup force ORACLE instance started.
Total System Global Area 524288000 bytes Fixed Size 1220360 bytes Variable Size 176161016 bytes Database Buffers 343932928 bytes Redo Buffers 2973696 bytes Database mounted. Database opened. SYS@PROD>select count(*) from switch_tb;
COUNT(*) ---------- 9400
SYS@PROD>
############################################################################################
第一次切换，主库PROD与备库PRODSTD切换。
PRODSTD主库切换成备库 SYS@ PRODSTD>select database_role,switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PRIMARY TO STANDBY
SYS@ PROD>select database_role,switchover_status from v$database;
DATABASE_ROLE SWITCHOVER_STATUS ---------------- -------------------- PHYSICAL STANDBY SESSIONS ACTIVE
SYS@PRODSTD> ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY; Database altered. SYS@PRODSTD> SHUTDOWN IMMEDIATE; ORA-01507: database not mounted ORACLE insta