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\’

1. oracle data guard pengertian

2. demo oracle data guard physical standby database

3. oracle data guard test pengiriman logfile

4. oracle data guard standby server untuk reporting

5. oracle data guard active data guard 11g

6. oracle data guard switchover failover

7. oracle data guard test switchover failover

8. oracle data guard lampiran initora

One Response to “Oracle Data Guard : LAMPIRAN init.ora (8)”

  1. Jack Nickolson May 4, 2010 at 8:48 pm #

    Good blog for configuration of init.ora of primary database and standby database.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: