oracle dataguard PROTECTION_MODE

来源：互联网发布：黑色休闲裤知乎编辑：程序博客网时间：2024/05/16 02:50

物理dataguard：

默认的 protection mode 是： MAXIMUM PERFORMANCE (最大性能模式)

SQL> select dest_name,status,type,database_mode,recovery_mode,protection_mode,destination from v$archive_dest_status;

DEST_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS TYPE DATABASE_MODE RECOVERY_MODE PROTECTION_MODE
--------- -------------- --------------- ----------------------- --------------------
DESTINATION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LOG_ARCHIVE_DEST_1
VALID PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE
/u01/oradata/log

LOG_ARCHIVE_DEST_2
VALID PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE
10gpri

DEST_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS TYPE DATABASE_MODE RECOVERY_MODE PROTECTION_MODE
--------- -------------- --------------- ----------------------- --------------------
DESTINATION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

LOG_ARCHIVE_DEST_3
INACTIVE PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

LOG_ARCHIVE_DEST_4
INACTIVE PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

DEST_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS TYPE DATABASE_MODE RECOVERY_MODE PROTECTION_MODE
--------- -------------- --------------- ----------------------- --------------------
DESTINATION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

LOG_ARCHIVE_DEST_5
INACTIVE PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

LOG_ARCHIVE_DEST_6

DEST_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS TYPE DATABASE_MODE RECOVERY_MODE PROTECTION_MODE
--------- -------------- --------------- ----------------------- --------------------
DESTINATION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
INACTIVE PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

LOG_ARCHIVE_DEST_7
INACTIVE PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

DEST_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS TYPE DATABASE_MODE RECOVERY_MODE PROTECTION_MODE
--------- -------------- --------------- ----------------------- --------------------
DESTINATION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
LOG_ARCHIVE_DEST_8
INACTIVE PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

LOG_ARCHIVE_DEST_9
INACTIVE PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

DEST_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS TYPE DATABASE_MODE RECOVERY_MODE PROTECTION_MODE
--------- -------------- --------------- ----------------------- --------------------
DESTINATION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

LOG_ARCHIVE_DEST_10
INACTIVE PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

STANDBY_ARCHIVE_DEST
VALID PHYSICAL MOUNTED-STANDBY MANAGED MAXIMUM PERFORMANCE

DEST_NAME
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS TYPE DATABASE_MODE RECOVERY_MODE PROTECTION_MODE
--------- -------------- --------------- ----------------------- --------------------
DESTINATION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/oradata/log

11 rows selected.

SQL>

注：这里PHYSICAL Dataguard的个数应该是系统能够配置的最多dataguard数量10个。