init
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
This blog is created for the oracle DBA community who search a lot for valuable data on the internet.This is compilation of posts from various forums and groups.Oracle Database community is growing by the day and the necessity of such a blog will be felt very soon.
clicksor ad
Monday, January 16, 2006
Standby server on RAC environment
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment