Posts

Showing posts from October 15, 2013

Oracle 8i:Disaster recovery solution -Standby Database for Oracle version 8.1.7.0.0

Image
Oracle 8i:Standby Database for Disaster recovery solution. Here is the simple steps for creating standby database in oracle 8i. This is testing purpose,So do the all steps from creating primary to real time sync of standby database. 1.Create/Configure Primary Database. a)Create primary database pfile. db_name = "primary" instance_name = primary service_names = primary control_files = ("/oracle/primary/stdby1.ctl","/oracle/primary/stdby2.ctl") control_file_record_keep_time=30 open_cursors = 100 max_enabled_roles = 30 db_block_buffers = 40000 db_block_lru_latches=4 cursor_space_for_time=true session_cached_cursors=40 shared_pool_size = 71680000 shared_pool_reserved_size=9216000 large_pool_size = 10485760 java_pool_size = 10485760 log_checkpoint_interval = 1048576 processes = 300 log_buffer = 163840 l og_archive_start = true log_archive_dest_1 = "location=/oracle/primary/arc/"