Shulou(Shulou.com)06/01 Report--

Oracle DG-- build Physical Standby (a master library corresponds to a multi-standby library)

System environment:

Operating system: RedHat EL6

Oracle: Oracle 10.2.0.1.0

As shown in the figure, the main library is bjdb (db_unique_name), and the standby libraries are shdb and gzdb.

Case study:

One main library and two standby libraries

Main library initialization parameters (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' '/ u01According to oracleback oradataAccordholders. DbAadataAccordbacks fileholders destinationholders, u01apaclerecoverychangareasides. Dbappingrecoveryaccounting fileplates destinationsizeplates 2147483648 .instanceblade nameplates processors bjacks .jobstones queueprocessors processors 10 processes. Openbacks cursorsbooks 300 goals .pgait targets 94371840 processes. Processes150 purposes.remotecards logincharacters passwordfileframes EXUUSIVEpictures. Gaze targets targets 285212672. Undobread managementbooks AUTOBUTIONS .undotablespaceUNTUBUT1strings. Usernames destinatetargets targets 94371840 processes. Processes 150 purposes. remoteurs login passwordfileframes EXUUSIVEpictures. Gaze targets targets 285212672. Undobread management.UUtoids. UndotablespaceUNCOBUTUBUTUB1BUBUBING.

The following parameters are used for DG configuration:

* .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'

Slave library initialization parameter 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' '/ u01appAcleUnioradataActureoradataDuring shemales; u01applicoraclepplicoradataUniverywords; u01applemoradataplicationoradataplains shedding .instanceencoding nameplates including shedding .jobbacks queueprocessors processesprocessing 10percent .opencodes cursors300; opencards cursors300; openings cursors300; opening cursors150; remotewords loginwords; passwordfileholders exeUSIVEpur.sgaits targettargets 285212672; undobread managementwords AUTOUTO .undobread tablespacespaces UNDOTBS1cards. Usernames dumpdestinationdestinationsU0directions.appacleadminenplacements

The following parameters are used for DG configuration:

* .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'

Slave library initialization parameter 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' '/ u01ApplicationoracleUniverse oradataAccordityoradata.u01appAclePlus oradataUniverySequenceU01ApplicationoracleChinoradatapadatapGATAU01appSimplication.opencards cursorswords 300and.pgaordinatetarget words 94371840 words .processeswords 150 minutes .remotepieces logininpasswordfilewords words called EXCLUSIVpromotion.sgajecttargets 285212672and.undobread managementcharacters AUTOTERS .undobread tablespacewords UNDOTBS1cards. Usernames dumpends destinationcards u01apporacleandadminmingzudumprocessors .euobqueprocesses10

The following parameters are used for DG configuration:

* .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'

-the above are the initialization parameters for building a main library with two Physical Standby. The creation process is omitted. For more information, please see: http://tiany.blog.51cto.com/513694/1583444 "Oracle DG-- Building Physical Standby"

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.