Powered By Blogger

Monday, July 5, 2010

Configure Active standby database 11g

run {
allocate channel ch1 type disk;

allocate channel ch2 type disk;

allocate channel ch3 type disk;

allocate channel ch4 type disk;

allocate auxiliary channel stndby type disk;


duplicate target database for standby from active database

spfile

parameter_value_convert 'orcl','orclstdby'

set db_unique_name='orclstdby'

set db_file_name_convert='/orcl/','/orclstdby/'

set log_file_name_convert='/orcl/','/orclstdby/'

set control_files='/u01/app/oracle/oradata/orclstdby.ctl'

set log_archive_max_processes='5'

set fal_client='orclstdby'

set fal_server='orcl'

set standby_file_management='AUTO'

set log_archive_config='dg_config=(orcl,orclstdby)'

set log_archive_dest_1='service=orcl ASYNC
valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=orcl' ;
}

alter database add standby logfile
('/u01/app/oracle/oradata/orcl/sredol01.log',
'/u01/app/oracle/oradata/orcl/sredol02.log',
'/u01/app/oracle/oradata/orcl/sredol03.log',
'/u01/app/oracle/oradata/orcl/sredol04.log')
size 52428800;



SELECT sequence#, first_time, next_time
FROM v$archived_log
ORDER BY sequence#;

select sequence#,archived,applied,deleted from v$archived_log where completion_time like '01-JUL-10'%;

No comments:

Post a Comment