oracle dataguard protection level

04oznk62fl

　　物理dataguard：
　　
　　主库：
　　
　　SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE,
2 PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS
3 FROM V$DATABASE;
　　DATABASE_ROLE INSTANCE OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS
---------------- ------------------------------ ---------- -------------------- -------------------- --------------------
PRIMARY 10gpri READ WRITE MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE SESSIONS ACTIVE
　　SQL>
　　
　　
　　备库：
　　
　　SQL> SELECT DATABASE_ROLE, DB_UNIQUE_NAME INSTANCE, OPEN_MODE,
2 PROTECTION_MODE, PROTECTION_LEVEL, SWITCHOVER_STATUS
3 FROM V$DATABASE;
　　DATABASE_ROLE INSTANCE OPEN_MODE PROTECTION_MODE PROTECTION_LEVEL SWITCHOVER_STATUS
---------------- ------------------------------ ---------- -------------------- -------------------- --------------------
PHYSICAL STANDBY 10gstandby MOUNTED MAXIMUM PERFORMANCE MAXIMUM PERFORMANCE NOT ALLOWED
　　SQL>
　　
　　
　　
　　
　　主库：
　　
　　SQL> SELECT FS_FAILOVER_STATUS FSFO_STATUS,
2 FS_FAILOVER_CURRENT_TARGET TARGET_STANDBY,
3 FS_FAILOVER_THRESHOLD THRESHOLD,
4 FS_FAILOVER_OBSERVER_PRESENT OBS_PRES
5 FROM V$DATABASE;
　　FSFO_STATUS TARGET_STANDBY THRESHOLD OBS_PRE
--------------------- ------------------------------ ---------- -------
DISABLED 0
　　SQL>
　　
　　
　　
　　
　　从库：
　　
　　SQL> SELECT FS_FAILOVER_STATUS FSFO_STATUS,
2 FS_FAILOVER_CURRENT_TARGET TARGET_STANDBY,
3 FS_FAILOVER_THRESHOLD THRESHOLD,
4 FS_FAILOVER_OBSERVER_PRESENT OBS_PRES
5 FROM V$DATABASE;
　　FSFO_STATUS TARGET_STANDBY THRESHOLD OBS_PRE
--------------------- ------------------------------ ---------- -------
DISABLED 0
　　SQL>
　　
　　
　　
　　主库：
　　
　　
　　SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC2: Archival started
ARC1: Becoming the heartbeat ARCH
ARCH shutting down
ARC2: Archival stopped
ARC1: Standby redo logfile selected for thread 1 sequence 36 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 37 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 38 for destination LOG_ARCHIVE_DEST_2
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ARC1: Standby redo logfile selected for thread 1 sequence 39 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 40 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 41 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 42 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 43 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 44 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 45 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 46 for destination LOG_ARCHIVE_DEST_2
ARC1: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect (3113)
ARC1: Destination LOG_ARCHIVE_DEST_2 network reconnect abandoned
PING[ARC1]: Error 3113 when pinging standby 10gstandby.
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ARC1: Standby redo logfile selected for thread 1 sequence 49 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 50 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 51 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 52 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 53 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 54 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 55 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 56 for destination LOG_ARCHIVE_DEST_2
ARC1: Standby redo logfile selected for thread 1 sequence 57 for destination LOG_ARCHIVE_DEST_2
　　31 rows selected.
　　SQL>
　　
　　
　　
　　
　　
　　从库：
　　
　　
　　SQL> SELECT MESSAGE FROM V$DATAGUARD_STATUS;
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
ARC0: Archival started
ARC1: Archival started
ARC0: Becoming the 'no FAL' ARCH
ARC0: Becoming the 'no SRL' ARCH
ARC1: Becoming the heartbeat ARCH
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /u01/oradata/demo/redo01.log
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 47
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 14822
RFS[1]: Identified database type as 'physical standby'
Media Recovery Log /u01/oradata/log/1_47_714156559.dbf
Media Recovery Log /u01/oradata/log/1_48_714156559.dbf
Media Recovery Waiting for thread 1 sequence 49
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
Media Recovery Log /u01/oradata/log/1_49_714156559.dbf
Media Recovery Waiting for thread 1 sequence 50
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Media Recovery Log /u01/oradata/log/1_50_714156559.dbf
Media Recovery Waiting for thread 1 sequence 51
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
Media Recovery Log /u01/oradata/log/1_51_714156559.dbf
Media Recovery Waiting for thread 1 sequence 52
MRP0: Background Media Recovery cancelled with status 16037
MRP0: Background Media Recovery process shutdown
Managed Standby Recovery Canceled
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Clearing online redo logfile 1 /u01/oradata/demo/redo01.log
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 52
MRP0: Background Media Recovery cancelled with status 16037
MRP0: Background Media Recovery process shutdown
Managed Standby Recovery Canceled
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /u01/oradata/demo/redo01.log
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Clearing online redo logfile 1 complete
Media Recovery Log /u01/oradata/log/1_52_714156559.dbf
Media Recovery Waiting for thread 1 sequence 53
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
Media Recovery Log /u01/oradata/log/1_53_714156559.dbf
Media Recovery Waiting for thread 1 sequence 54
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
Media Recovery Log /u01/oradata/log/1_54_714156559.dbf
Media Recovery Waiting for thread 1 sequence 55
MRP0: Background Media Recovery cancelled with status 16037
MRP0: Background Media Recovery process shutdown
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Managed Standby Recovery Canceled
Attempt to start background Managed Standby Recovery process
MRP0: Background Managed Standby Recovery process started
Managed Standby Recovery not using Real Time Apply
Clearing online redo logfile 1 /u01/oradata/demo/redo01.log
Clearing online redo logfile 1 complete
Media Recovery Waiting for thread 1 sequence 55
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
Media Recovery Log /u01/oradata/log/1_55_714156559.dbf
Media Recovery Waiting for thread 1 sequence 56
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
　　MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Media Recovery Log /u01/oradata/log/1_56_714156559.dbf
Media Recovery Waiting for thread 1 sequence 57
RFS[1]: Successfully opened standby log 4: '/u01/oradata/demo/redo04.log'
Media Recovery Log /u01/oradata/log/1_57_714156559.dbf
Media Recovery Waiting for thread 1 sequence 58
　　71 rows selected.
　　SQL>