Oracle DG--Build physical Standby (one main library for multi-repository)
System environment:
Oracle:oracle 10.2.0.1.0
650) this.width=650; "src=" Http://s3.51cto.com/wyfs02/M00/54/10/wKioL1R25dqSqrvxAADnIlkOMXs321.jpg "title=" Dg1.png "alt=" Wkiol1r25dqsqrvxaadnilkomxs321.jpg "/>
, the main library is bjdb (Db_unique_name), and the repository is SHDB and gzdb.
Case Analysis:
One main library, two standby libraries
Main Library initialization parameters (Pfile):
[email protected] 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 '
The following parameters are used for D G 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 '
Standby initialization parameter Pfile (SHDB):
[email protected] 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 '
*.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 '
Standby initialization parameter Pfile (GZDB):
[email protected] 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
*.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 '
---above to build a main library 2 physical standby initialization parameters, the creation process is omitted, you can refer to:http://tiany.blog.51cto.com/513694/1583444 Oracle DG--Construction of physical Standby
This article is from the "Tianya blog," Please make sure to keep this source http://tiany.blog.51cto.com/513694/1583399
Oracle DG--Build physical Standby (one main library for multi-repository)