linux下oracle11G DG搭建(三):围绕备库搭建操作
环境
名称 |
主库 |
备库 |
主机名 |
bjsrv |
shsrv |
软件版本 |
RedHat Enterprise5.5、Oracle 11g 11.2.0.1 |
RedHat Enterprise5.5、Oracle 11g 11.2.0.1 |
三、围绕备库操作:
1、备库-修改初始化参数文件
$cd$ORACLE_HOME/dbs
$df -h
$vi initshdb.ora
修改简要说明:
*.audit_file_dest='/u01/app/oracle/admin/sh/adump'
//审计文件存放的路径
*.audit_trail='db'
*.compatible='11.2.0.0.0'
*.control_files='/u01/app/oracle/oradata/sh/sh_control01.ctl'
*.db_block_size=8192
*.db_name='TestDB12'
*.db_recovery_file_dest='/u01/app/oracle/fast_recovery_area'
*.db_recovery_file_dest_size=4322230272
*.diagnostic_dest='/u01/app/oracle'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=TestDB12XDB)'//用于共享,删除
*.log_archive_format='arch_%t_%s_%r.log'
*.memory_target=642006528
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.undo_tablespace='UNDOTBS1'
DB_UNIQUE_NAME=shdb
LOG_ARCHIVE_CONFIG='DG_CONFIG=(bjdb,shdb)'
LOG_ARCHIVE_DEST_1=
'LOCATION=/dsk4/arch_sh
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=shdb'
LOG_ARCHIVE_DEST_2=
'SERVICE=bjdbASYNC //应该是对方
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=bjdb'
LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_MAX_PROCESSES=3
FAL_SERVER=