Implementation of data guard
edited Feb 21, 2010 7:30AM in High Availability Data Guard, Sharding and Global Data Services (MOSC) 3 commentsAnswered
Hi, I'am implementing dataguard in my company and have this question:
1) Exists a value optimal for the parameter LOG_ARCHIVE_MAX_PROCESSES?. There any way to obtain or calculate?.
2) I have these command, which allows the switchover, are correct ?
primary
alter database commit to switchover to standby with session shutdown;
shutdown immediate;
startup nomount;
alter database mount standby database;
alter system set log_archive_dest_state_2=defer;
alter database recover managed standby database disconnect;
standby
alter database commit to switchover to primary with session shutdown;
alter system set log_archive_dest_state_2=enable;
shutdown immediate;
startup;
3) I created, 3 standby logfile in the primary database, and in the database standby i created 1 standby logfile, question? Is necessary what in the database standby exists 3 standby logfile ?
1) Exists a value optimal for the parameter LOG_ARCHIVE_MAX_PROCESSES?. There any way to obtain or calculate?.
2) I have these command, which allows the switchover, are correct ?
primary
alter database commit to switchover to standby with session shutdown;
shutdown immediate;
startup nomount;
alter database mount standby database;
alter system set log_archive_dest_state_2=defer;
alter database recover managed standby database disconnect;
standby
alter database commit to switchover to primary with session shutdown;
alter system set log_archive_dest_state_2=enable;
shutdown immediate;
startup;
3) I created, 3 standby logfile in the primary database, and in the database standby i created 1 standby logfile, question? Is necessary what in the database standby exists 3 standby logfile ?
0