溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊(cè)×
其他方式登錄
點(diǎn)擊 登錄注冊(cè) 即表示同意《億速云用戶服務(wù)條款》

Oracle DG之--構(gòu)建Physical Standby（一主庫對(duì)應(yīng)多備庫）

發(fā)布時(shí)間：2020-05-29 08:24:30 來源：網(wǎng)絡(luò) 閱讀：5005 作者：客居天涯 欄目：關(guān)系型數(shù)據(jù)庫

Oracle DG之--構(gòu)建Physical Standby（一主庫對(duì)應(yīng)多備庫）


系統(tǒng)環(huán)境：

操作系統(tǒng)： RedHat EL6

Oracle:    Oracle 10.2.0.1.0

Oracle DG之--構(gòu)建Physical Standby（一主庫對(duì)應(yīng)多備庫）

      如圖所示，主庫為bjdb（db_unique_name)，備庫為shdb和gzdb。


案例分析： 

一個(gè)主庫，兩個(gè)備庫

主庫初始化參數(shù)（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'

以下參數(shù)用于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'


備庫初始化參數(shù)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'

以下參數(shù)用于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'

備庫初始化參數(shù)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

以下參數(shù)用于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'

---以上為構(gòu)建一個(gè)主庫2個(gè)Physical Standby的初始化參數(shù)，創(chuàng)建過程省略，可以參考：http://tiany.blog.51cto.com/513694/1583444《 Oracle DG之--構(gòu)建Physical Standby》

向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點(diǎn)不代表本網(wǎng)站立場，如果涉及侵權(quán)請(qǐng)聯(lián)系站長郵箱：is@yisu.com進(jìn)行舉報(bào)，并提供相關(guān)證據(jù)，一經(jīng)查實(shí)，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手