oracle dataguard PROTECTION_MODE

最新推荐文章于 2022-10-10 12:44:53 发布

aicon

最新推荐文章于 2022-10-10 12:44:53 发布

阅读量830

点赞数

分类专栏： Oracle EBS Oracle 文章标签： oracle archive database performance sql

本文链接：https://blog.csdn.net/aicon/article/details/5410204

版权

Oracle 同时被 2 个专栏收录

523 篇文章 0 订阅

订阅专栏

Oracle EBS

416 篇文章 0 订阅

订阅专栏

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