oracle dataguard protection level

物理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>

 

 

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值