首页 > 代码库 > Oracle DG之--构建Physical Standby(一主库对应多备库)
Oracle DG之--构建Physical Standby(一主库对应多备库)
Oracle DG之--构建Physical Standby(一主库对应多备库)
系统环境:
操作系统: RedHat EL6
Oracle: Oracle 10.2.0.1.0
如图所示,主库为bjdb(db_unique_name),备库为shdb和gzdb。
案例分析:
一个主库,两个备库
主库初始化参数(pfile):
[oracle@bjsrv dbs]$ cat initbj.ora
*.audit_file_dest=‘/u01/app/oracle/admin/prod/adump‘ *.background_dump_dest=‘/u01/app/oracle/admin/prod/bdump‘ *.compatible=‘10.2.0.1.0‘ *.control_files=‘/u01/app/oracle/oradata/prod/control01.ctl‘,‘/disk1/oradata/bj/control02.ctl‘,‘/disk2/oradata/bj/control03.ctl‘ *.core_dump_dest=‘/u01/app/oracle/admin/prod/cdump‘ *.db_block_size=8192 *.db_domain=‘‘ *.db_file_multiblock_read_count=16 *.DB_FILE_NAME_CONVERT=‘/u01/app/oracle/oradata/sh‘,‘/u01/app/oracle/oradata/prod‘,‘/u01/app/oracle/oradata/gz‘,‘/u01/app/oracle/oradata/prod‘ *.db_recovery_file_dest=‘/u01/app/oracle/flash_recovery_area‘ *.db_recovery_file_dest_size=2147483648 *.instance_name=‘bj‘ *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile=‘EXCLUSIVE‘ *.sga_target=285212672 *.undo_management=‘AUTO‘ *.undo_tablespace=‘UNDOTBS1‘ *.user_dump_dest=‘/u01/app/oracle/admin/prod/udump‘
以下参数用于DG配置:
*.db_name=‘prod‘ *.DB_UNIQUE_NAME=‘bjdb‘ *.FAL_CLIENT=‘bjdb‘ *.FAL_SERVER=‘shdb‘,‘gzdb‘ *.LOG_ARCHIVE_CONFIG=‘DG_CONFIG=(bjdb,shdb,gzdb)‘ *.LOG_ARCHIVE_DEST_1=‘LOCATION=/disk3/arch_bj VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=bjdb‘ *.LOG_ARCHIVE_DEST_2=‘SERVICE=shdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=shdb‘ *.LOG_ARCHIVE_DEST_3=‘SERVICE=gzdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=gzdb‘ *.LOG_ARCHIVE_DEST_STATE_1=‘ENABLE‘ *.LOG_ARCHIVE_DEST_STATE_2=‘ENABLE‘ *.LOG_ARCHIVE_DEST_STATE_3=‘ENABLE‘ *.log_archive_format=‘arch_%t_%s_%r.log‘ *.LOG_ARCHIVE_MAX_PROCESSES=3 *.LOG_FILE_NAME_CONVERT=‘/disk1/oradata/sh‘,‘/disk1/oradata/bj‘,‘/disk2/oradata/sh‘,‘/disk2/oradata/bj‘,‘/disk1/oradata/gz‘,‘/disk1/oradata/bj‘,‘/disk2/oradata/gz‘,‘/disk2/oradata/bj‘ *.STANDBY_FILE_MANAGEMENT=‘AUTO‘
备库初始化参数pfile(shdb):
[oracle@shsrv dbs]$ cat initsh.ora *.audit_file_dest=‘/u01/app/oracle/admin/sh/adump‘ *.background_dump_dest=‘/u01/app/oracle/admin/sh/bdump‘ *.compatible=‘10.2.0.1.0‘ *.control_files=‘/u01/app/oracle/oradata/sh/std_control.ctl‘ *.core_dump_dest=‘/u01/app/oracle/admin/sh/cdump‘ *.db_block_size=8192 *.db_domain=‘‘ *.db_file_multiblock_read_count=16 *.DB_FILE_NAME_CONVERT=‘/u01/app/oracle/oradata/prod‘,‘/u01/app/oracle/oradata/sh‘,‘/u01/app/oracle/gz‘,‘/u01/app/oracle/oradata/sh‘ *.instance_name=‘sh‘ *.job_queue_processes=10 *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile=‘EXCLUSIVE‘ *.sga_target=285212672 *.undo_management=‘AUTO‘ *.undo_tablespace=‘UNDOTBS1‘ *.user_dump_dest=‘/u01/app/oracle/admin/sh/udump‘
以下参数用于DG配置:
*.db_name=‘prod‘ *.DB_UNIQUE_NAME=‘shdb‘ *.FAL_CLIENT=‘shdb‘ *.FAL_SERVER=‘bjdb‘,‘gzdb‘ *.LOG_ARCHIVE_CONFIG=‘DG_CONFIG=(bjdb,shdb,gzdb)‘ *.LOG_ARCHIVE_DEST_1=‘LOCATION=/disk3/arch_sh VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=shdb‘ *.LOG_ARCHIVE_DEST_2=‘SERVICE=bjdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bjdb‘ *.LOG_ARCHIVE_DEST_3=‘SERVICE=gzdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=gzdb‘ *.LOG_ARCHIVE_DEST_STATE_1=‘ENABLE‘ *.LOG_ARCHIVE_DEST_STATE_2=‘ENABLE‘ *.LOG_ARCHIVE_DEST_STATE_3=‘ENABLE‘ *.log_archive_format=‘arch_%t_%s_%r.log‘ *.LOG_ARCHIVE_MAX_PROCESSES=3 *.LOG_FILE_NAME_CONVERT=‘/disk1/oradata/bj‘,‘/disk1/oradata/sh‘,‘/disk2/oradata/bj‘,‘/disk2/oradata/sh‘,‘/disk1/oradata/gz‘,‘/disk1/oradata/sh‘,‘/disk2/oradata/gz‘,‘/disk2/oradata/sh‘ *.STANDBY_FILE_MANAGEMENT=‘AUTO‘
备库初始化参数pfile(gzdb):
[oracle@gzsrv dbs]$ cat initgz.ora
*.audit_file_dest=‘/u01/app/oracle/admin/gz/adump‘ *.background_dump_dest=‘/u01/app/oracle/admin/gz/bdump‘ *.compatible=‘10.2.0.1.0‘ *.control_files=‘/u01/app/oracle/oradata/gz/gzstd_control.ctl‘ *.core_dump_dest=‘/u01/app/oracle/admin/gz/cdump‘ *.db_block_size=8192 *.db_domain=‘‘ *.db_file_multiblock_read_count=16 *.DB_FILE_NAME_CONVERT=‘/u01/app/oracle/oradata/prod‘,‘/u01/app/oracle/oradata/gz‘,‘/u01/app/oracle/oradata/sh‘,‘/u01/app/oracle/oradata/gz‘ *.open_cursors=300 *.pga_aggregate_target=94371840 *.processes=150 *.remote_login_passwordfile=‘EXCLUSIVE‘ *.sga_target=285212672 *.undo_management=‘AUTO‘ *.undo_tablespace=‘UNDOTBS1‘ *.user_dump_dest=‘/u01/app/oracle/admin/gz/udump‘ *.job_queue_processes=10
以下参数用于DG配置:
*.db_name=‘prod‘ *.DB_UNIQUE_NAME=‘gzdb‘ *.FAL_CLIENT=‘gzdb‘ *.FAL_SERVER=‘bjdb‘,‘shdb‘ *.instance_name=‘gz‘ *.LOG_ARCHIVE_CONFIG=‘DG_CONFIG=(bjdb,shdb,gzdb)‘ *.LOG_ARCHIVE_DEST_1=‘LOCATION=/disk3/arch_gz VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=gzdb‘ *.LOG_ARCHIVE_DEST_2=‘SERVICE=bjdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=bjdb‘ *.LOG_ARCHIVE_DEST_3=‘SERVICE=shdb LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=shdb‘ *.LOG_ARCHIVE_DEST_STATE_1=‘ENABLE‘ *.LOG_ARCHIVE_DEST_STATE_2=‘ENABLE‘ *.LOG_ARCHIVE_DEST_STATE_3=‘ENABLE‘ *.log_archive_format=‘arch_%t_%s_%r.log‘ *.LOG_ARCHIVE_MAX_PROCESSES=3 *.LOG_FILE_NAME_CONVERT=‘/disk1/oradata/bj‘,‘/disk1/oradata/gz‘,‘/disk2/oradata/bj‘,‘/disk2/oradata/gz‘,‘/disk1/oradata/sh‘,‘/disk1/oradata/gz‘,‘/disk2/oradata/sh‘,‘/disk2/oradata/gz‘ *.STANDBY_FILE_MANAGEMENT=‘AUTO‘
---以上为构建一个主库2个Physical Standby的初始化参数,创建过程省略,可以参考:http://tiany.blog.51cto.com/513694/1583444《 Oracle DG之--构建Physical Standby》
本文出自 “天涯客的blog” 博客,请务必保留此出处http://tiany.blog.51cto.com/513694/1583399
Oracle DG之--构建Physical Standby(一主库对应多备库)
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。