Oracle Data Guard : LAMPIRAN init.ora (8)

28 Feb

############################################
#LAMPIRAN init_prmr11g.ora
############################################
## Primary Role Parameters ##
db_name=\’prmr11g\’
db_unique_name=\’prmr11g\’
LOG_ARCHIVE_CONFIG=\’DG_CONFIG=(prmr11g,stby11g)\’

LOG_ARCHIVE_DEST_1=
\’LOCATION=/u01/archive/prmr11g/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=prmr11g\’
LOG_ARCHIVE_DEST_2=
\’SERVICE=stby11g LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=stby11g\’

LOG_ARCHIVE_DEST_STATE_1=ENABLE
LOG_ARCHIVE_DEST_STATE_2=ENABLE
LOG_ARCHIVE_FORMAT=%t_%s_%r.arc
LOG_ARCHIVE_MAX_PROCESSES=30

## Standby Role Parameters ##
*.fal_server=stby11g
*.fal_client=prmr11g
*.standby_file_management=auto
*.db_file_name_convert=\’/u01/app/oracle/oradata/stby11g/\’,\’/u01/app/oracle/oradata/prmr11g/\’
*.log_file_name_convert=\’/u01/app/oracle/oradata/stby11g/\’,\’/u01/app/oracle/oradata/prmr11g/\’

prmr11g.__db_cache_size=50331648
prmr11g.__java_pool_size=12582912
prmr11g.__large_pool_size=4194304
prmr11g.__oracle_base=\’/u01/app/oracle\’#ORACLE_BASE set from environment
prmr11g.__pga_aggregate_target=209715200
prmr11g.__sga_target=213909504
prmr11g.__shared_io_pool_size=0
prmr11g.__shared_pool_size=142606336
prmr11g.__streams_pool_size=0
*.audit_file_dest=\’/u01/app/oracle/admin/prmr11g/adump\’
*.audit_trail=\’db\’
*.compatible=\’11.1.0.0.0\’
*.control_files=\’/u01/app/oracle/oradata/prmr11g/control01.ctl\’,\’/u01/app/oracle/oradata/prmr11g/control02.ctl\’,\’/u01/app/oracle/oradata/prmr11g/control03.ctl\’
*.db_block_size=8192
*.db_domain=\’\’
#*.db_name=\’prmr11g\’
*.db_recovery_file_dest=\’/u01/app/oracle/flash_recovery_area/prmr11g\’
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest=\’/u01/app/oracle\’
*.dispatchers=\’(PROTOCOL=TCP) (SERVICE=prmr11gXDB)\’
*.log_archive_dest_1=\’location=/u01/archive/prmr11g\’
*.memory_target=422576128
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile=\’EXCLUSIVE\’
*.undo_tablespace=\’UNDOTBS1\’

############################################
#LAMPIRAN init_stby11g.ora
############################################
*.db_name=\’prmr11g\’
*.db_unique_name=\’stby11g\’
*.LOG_ARCHIVE_CONFIG=\’DG_CONFIG=(prmr11g,stby11g)\’
*.LOG_ARCHIVE_DEST_1=\’LOCATION=/u01/archive/stby11g/
VALID_FOR=(ALL_LOGFILES,ALL_ROLES)
DB_UNIQUE_NAME=stby11g\’
*.LOG_ARCHIVE_DEST_2=\’SERVICE=prmr11g LGWR ASYNC
VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE)
DB_UNIQUE_NAME=prmr11g\’

*.LOG_ARCHIVE_DEST_STATE_1=\’ENABLE\’
*.LOG_ARCHIVE_DEST_STATE_2=\’ENABLE\’
*.LOG_ARCHIVE_FORMAT=\’%t_%s_%r.arc\’
*.LOG_ARCHIVE_MAX_PROCESSES=30

*.fal_server=\’prmr11g\’
*.fal_client=\’stby11g\’
*.standby_file_management=\’auto\’
*.db_file_name_convert=\’/u01/app/oracle/oradata/prmr11g/\’,\’/u01/app/oracle/oradata/stby11g/\’
*.log_file_name_convert=\’/u01/app/oracle/oradata/prmr11g/\’,\’/u01/app/oracle/oradata/stby11g/\’

stby11g.__db_cache_size=50331648
stby11g.__java_pool_size=12582912
stby11g.__large_pool_size=4194304
stby11g.__oracle_base=\’/u01/app/oracle\’#ORACLE_BASE set from environment
stby11g.__pga_aggregate_target=209715200
stby11g.__sga_target=213909504
stby11g.__shared_io_pool_size=0
stby11g.__shared_pool_size=142606336
stby11g.__streams_pool_size=0
*.audit_file_dest=\’/u01/app/oracle/admin/stby11g/adump\’
*.audit_trail=\’db\’
*.compatible=\’11.1.0.0.0\’
*.control_files=\’/u01/app/oracle/oradata/stby11g/control01.ctl\’,\’/u01/app/oracle/oradata/stby11g/control02.ctl\’,\’/u01/app/oracle/oradata/stby11g/control03.ctl\’
*.db_block_size=8192
*.db_domain=\’\’
*.db_recovery_file_dest=\’/u01/app/oracle/flash_recovery_area/stby11g\’
*.db_recovery_file_dest_size=2147483648
*.diagnostic_dest=\’/u01/app/oracle\’
*.dispatchers=\’(PROTOCOL=TCP) (SERVICE=stby11gXDB)\’
*.log_archive_dest_1=\’location=/u01/archive/stby11g\’
*.memory_target=422576128
*.open_cursors=300
*.processes=150
*.remote_login_passwordfile=\’EXCLUSIVE\’
*.undo_tablespace=\’UNDOTBS1\’