|
-
Oracle Version:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
I have gone through this url & hv created.
http://www.cs.umb.edu/cs634/ora9idoc.../create_ps.htm
and
http://www.orafaq.com/papers/create_...standby_db.pdf
Because the Database is Available in Remote place daily we will have to get Archive log files in Tape & have to restore.
####################
Init.ora please find my init.ora for standby db
####################
db_block_size=8192
db_cache_size=440401920
db_file_multiblock_read_count=16
Open_cursors=300
db_domain=""
db_name=fno
service_names = fno
background_dump_dest=E:\oracle\admin\fno\bdump
core_dump_dest=E:\oracle\admin\fno\cdump
timed_statistics=TRUE
user_dump_dest=E:\oracle\admin\fno\udump
control_files=("E:\oracle\oradata\fno\standby.ctl", "E:\oracle\oradata\fno\standby02.ctl", "E:\oracle\oradata\fno\standby03.ctl")
instance_name=fno
compatible=9.2.0.0.0
hash_join_enabled=TRUE
query_rewrite_enabled=TRUE
star_transformation_enabled=FALSE
query_rewrite_integrity= Enforced
#job_queue_interval = 60
job_queue_processes= 1
java_pool_size=20971520
large_pool_size=73400320
shared_pool_size=167772160
processes=150
fast_start_mttr_target=300
remote_login_passwordfile=EXCLUSIVE
pga_aggregate_target=329252864
sort_area_size=1048576
undo_management=AUTO
undo_retention=10800
undo_tablespace=UNDOTBS1
log_archive_start = false
log_archive_dest_1 = 'LOCATION=F:\Oracle\oradata\FNO\ARCH'
standby_archive_dest = F:\Oracle\oradata\FNO\ARCHS
log_archive_format = LOG_%t%s.ARC
#STANDBY_FILE_MANAGEMENT=auto
I am the new in this setup, Please help me if there is anything wrong.
Thanks & Regds.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|