clicksor ad

Monday, January 16, 2006

Standby server on RAC environment

init.ora for standby

background_dump_dest='/arch/dump/bdump'
#cluster_database_instances=2
#cluster_database=TRUE

compatible='9.2.0.5'
control_files='/oracle/admin/ctl/standbysun.ctl'
core_dump_dest='/arch/dump/cdump'
cursor_sharing='EXACT'
db_block_size=8192
db_cache_size=200000000
db_domain='world'
db_file_multiblock_read_count=8
db_name='sun'
fast_start_mttr_target=600
hash_join_enabled=TRUE
#sun11.instance_name='sun11'
#sun12.instance_name='sun12'
#sun12.instance_number=2
#sun11.instance_number=1

java_pool_size=31457280
job_queue_processes=2
large_pool_size=50000000
#sun11.log_archive_dest_1='/arch/log'
#sun12.log_archive_dest_1='/arch/log'

log_archive_dest_1='LOCATION=/arch/log'
log_archive_start=TRUE
log_buffer=1000000
max_dump_file_size='1000'
open_cursors=1000
optimizer_features_enable='9.2.0.1'
pga_aggregate_target=524288000
processes=500
query_rewrite_enabled='FALSE'
remote_dependencies_mode='SIGNATURE'
#remote_listener='LISTENERS_SUN'
#remote_login_passwordfile='exclusive'

resource_limit=TRUE
sga_max_size=3564084240
shared_pool_reserved_size=65000000
shared_pool_size=271859200
sort_area_size=524288
star_transformation_enabled='FALSE'
#sun12.thread=2
#sun11.thread=1

timed_statistics=TRUE
undo_management='AUTO'
undo_retention=10800
#sun11.undo_tablespace='UNDOTBS1'
#sun12.undo_tablespace='UNDOTBS2'

undo_tablespace='UNDOTBS2'
user_dump_dest='/arch/dump/udump'
#newly added for standby
standby_archive_dest=/arch/log
db_file_name_convert=('/dev/vx/rdsk/racdg','/bkp/oradata')
log_file_name_convert=('/dev/vx/rdsk/racdg','/bkp/oradata')



#-lines commented for standby database

No comments: