一主一物一邏備庫

經過一定時間的學習與測試，現已完成一主帶一邏一物庫。

順序為：主----&gt邏----&gt物

配置為：

主：

SERVICE_NAMES=SNOWDB
DB_UNIQUE_NAME='uqn_node1'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(uqn_node2,uqn_node1)'
LOG_ARCHIVE_DEST_2=
'SERVICE=fastrise02 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=uqn_node2'
LOG_ARCHIVE_DEST_3=
'SERVICE=fastrise03 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=uqn_node2'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_DEST_STATE_3=ENABLE
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=fastrise03
FAL_SERVER=fastrise02
FAL_CLIENT=fastrsie01
STANDBY_FILE_MANAGEMENT=AUTO

邏：

*.LOG_ARCHIVE_CONFIG='DG_CONFIG=(uqn_node1,uqn_node2)'
*.log_archive_dest_1='LOCATION=/u01/oradata/arch2/'
*.LOG_ARCHIVE_DEST_2='SERVICE=fastrise01 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=uqn_node1'
*.LOG_ARCHIVE_DEST_STATE_1='ENABLE'
*.LOG_ARCHIVE_DEST_STATE_2='ENABLE'
*.log_archive_format='%t_%s_%r.arc'
*.LOG_ARCHIVE_MAX_PROCESSES=30
*.open_cursors=300
*.pga_aggregate_target=16777216
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.SERVICE_NAMES='SNOWDB'
*.sga_target=167772160
*.standby_archive_dest='/u01/oradata/arch1'
*.STANDBY_FILE_MANAGEMENT='AUTO'
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/u01/admin/snowdb/udump'

物：

SERVICE_NAMES=SNOWDB
DB_UNIQUE_NAME='uqn_node2'
LOG_ARCHIVE_CONFIG='DG_CONFIG=(uqn_node1,uqn_node2)'
LOG_ARCHIVE_DEST_2=
'SERVICE=fastrise01 ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=uqn_node1'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_MAX_PROCESSES=30
FAL_SERVER=fastrise01
FAL_CLIENT=fastrsie03
STANDBY_FILE_MANAGEMENT=AUTO

[@more@]