Host Configuration
AlterSystemSetDb_unique_name='Starboss'Scope=SPFile;AlterSystemSetLog_archive_config='dg_config= (starboss,starbossstby01,starbossstby02)';AlterSystemSetLog_archive_dest_1='location=/opt/app/oracle/archivelog/valid_for= (all_logfiles,all_roles) Db_unique_name=starboss';
alter system set log_archive_dest_2='service=starbossstby01 lgwr ASYNC VALID _for= (online_logfiles,primary_role) db_unique_name=starbossstby01'; alter system set log_archive_dest_3='service=starbossstby02 lgwr ASYNC Valid_for= (online_logfiles,primary_role) db_unique_name=starbossstby02';
AlterSystemSetLog_archive_dest_state_1='ENABLE';AlterSystemSetLog_archive_dest_state_2='ENABLE';AlterSystemSetLog_archive_dest_state_3='ENABLE';AlterSystemSetLog_archive_format='%t_%s_%r.arc'Scope=SPFile;AlterSystemSetRemote_login_passwordfile=EXCLUSIVE Scope=SPFile;AlterSystemSetLog_archive_max_processes= -;
Standby 01 Configuration
AlterSystemSetDb_unique_name='starbossstby01'Scope=SPFile;AlterSystemSetLog_archive_config='dg_config= (Starbossstby01,starboss)';AlterSystemSetLog_archive_dest_1='location=/opt/app/oracle/archivelog/valid_for= (all_logfiles,all_roles) db_unique_name=starbossstby01';AlterSystemSetLog_archive_dest_2='service=starboss lgwr ASYNC valid_for= (online_logfiles,primary_role) Db_unique_name=starboss';AlterSystemSetLog_archive_dest_state_1='ENABLE';AlterSystemSetLog_archive_dest_state_2='ENABLE';AlterSystemSetLog_archive_format='%t_%s_%r.arc'Scope=SPFile;AlterSystemSetRemote_login_passwordfile=EXCLUSIVE Scope=SPFile;AlterSystemSetFal_server='Starboss';AlterSystemSetFal_client='starbossstby01';AlterSystemSetStandby_file_management='AUTO';AlterSystemSetLog_file_name_convert='/stardb_log1/starboss','/stardb_log1/starboss'AlterSystemSetDb_file_name_convert='/opt/ora10/oradata/starboss/','/opt/ora10/oradata/starboss/'
Standby 02 Configuration
AlterSystemSetDb_unique_name='starbossstby02'Scope=SPFile;AlterSystemSetLog_archive_config='dg_config= (Starbossstby02,starboss)';AlterSystemSetLog_archive_dest_1='location=/opt/app/oracle/archivelog/valid_for= (all_logfiles,all_roles) db_unique_name=starbossstby02';AlterSystemSetLog_archive_dest_2='service=starboss lgwr ASYNC valid_for= (online_logfiles,primary_role) Db_unique_name=starboss';AlterSystemSetLog_archive_dest_state_1='ENABLE';AlterSystemSetLog_archive_dest_state_2='ENABLE';AlterSystemSetLog_archive_format='%t_%s_%r.arc'Scope=SPFile;AlterSystemSetRemote_login_passwordfile=EXCLUSIVE Scope=SPFile;AlterSystemSetFal_server='Starboss';AlterSystemSetFal_client='starbossstby02';AlterSystemSetStandby_file_management='AUTO';AlterSystemSetLog_file_name_convert='/stardb_log1/starboss','/stardb_log1/starboss'AlterSystemSetDb_file_name_convert='/opt/ora10/oradata/starboss/','/opt/ora10/oradata/starboss/'
Configuring multiple Dataguard Physical Spares in oracle11g