主库配置文件和状态:
*.log_archive_dest_2='SERVICE=tnsccdbdg OPTIONAL LGWR SYNC AFFIRM
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=tnsccdbdg'
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#,BLOCK#,BLOCKS,PID FROM V$MANAGED_STANDBY;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS PID
--------- ------------ ---------- ---------- ---------- ---------- ----------
ARCH CLOSING 1 655 1 94 1819
ARCH CLOSING 1 654 1 412 1821
ARCH CONNECTED 0 0 0 0 1823
ARCH CLOSING 1 656 1 591 1825
SQL> select OPEN_MODE,SWITCHOVER_STATUS,DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL FROM v$database;
OPEN_MODE SWITCHOVER_STATUS DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
-------------------- -------------------- ---------------- -------------------- --------------------
READ WRITE FAILED DESTINATION PRIMARY MAXIMUM AVAILABILITY RESYNCHRONIZATION
alert:
LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (16086)
LGWR: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
Error 16086 for archive log file 1 to 'tnsccdbdg'
LGWR: Failed to archive log 1 thread 1 sequence 658 (16086)
Thread 1 advanced to log sequence 658 (LGWR switch)
Current log# 1 seq# 658 mem# 0: /u02/oradata/ccdb/redo01.log
Thu Aug 06 09:14:21 2015
Archived Log entry 1303 added for thread 1 sequence 657 ID 0xd175dd6e dest 1:
物理standby配置文件和状态
*.log_archive_dest_2='SERVICE=tnsccdb OPTIONAL LGWR SYNC AFFIRM
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=tnsccdb'
SQL> SELECT PROCESS, STATUS, THREAD#, SEQUENCE#,BLOCK#,BLOCKS,PID FROM V$MANAGED_STANDBY;
PROCESS STATUS THREAD# SEQUENCE# BLOCK# BLOCKS PID
--------- ------------ ---------- ---------- ---------- ---------- ----------
ARCH CONNECTED 0 0 0 0 5863
ARCH CONNECTED 0 0 0 0 5865
ARCH CONNECTED 0 0 0 0 5867
ARCH CONNECTED 0 0 0 0 5869
RFS IDLE 0 0 0 0 6015
RFS IDLE 0 0 0 0 5925
RFS IDLE 0 0 0 0 6017
MRP0 WAIT_FOR_LOG 1 656 0 0 5937
SQL> select OPEN_MODE,SWITCHOVER_STATUS,DATABASE_ROLE,PROTECTION_MODE,PROTECTION_LEVEL FROM v$database;
OPEN_MODE SWITCHOVER_STATUS DATABASE_ROLE PROTECTION_MODE PROTECTION_LEVEL
-------------------- -------------------- ---------------- -------------------- --------------------
READ WRITE FAILED DESTINATION PRIMARY MAXIMUM AVAILABILITY RESYNCHRONIZATION
alert:
Thu Aug 06 09:14:10 2015
Primary database is in MAXIMUM AVAILABILITY mode
Standby controlfile consistent with primary
Standby controlfile consistent with primary
RFS[9]: Assigned to RFS process 6038
RFS[9]: No standby redo logfiles created for thread 1
RFS[9]: No standby redo logfiles selected (reason:7)
Thu Aug 06 09:14:11 2015
RFS[10]: Assigned to RFS process 6036
RFS[10]: Opened log for thread 1 sequence 656 dbid -780783250 branch 886364910
Archived Log entry 304 added for thread 1 sequence 656 rlc 886364910 ID 0xd175dd6e dest 2:
Thu Aug 06 09:14:12 2015
Media Recovery Log /u02/arch/1_656_886364910.dbf
Media Recovery Waiting for thread 1 sequence 657
求大神现身呀 不是主库手动切换日之后,备库的standy redo log 就会自动 online吗