AskDBA.net Pam Eroticnastyteen Zh Words Index Erotic Nasty Teen

©作者：eygle.com

Start Standby Database

startup nomount
alter database mount standby database;
alter database recover managed standby database disconnect;

Disable/Enable archive log destinations

alter system set log_archive_dest_state_2 = 'defer';
alter system set log_archive_dest_state_2 = 'enable';

To remove a delay from a standby

alter database recover managed standby database cancel;

alter database recover managed standby database nodelay disconnect;

Stop and Start of Logical standby apply

alter database stop logical standby apply;
alter database start logical standby apply;

Physical Standby switchover:
In Primary Database：

ALTER DATABASE COMMIT TO SWITCHOVER TO PHYSICAL STANDBY;
SHUTDOWN IMMEDIATE;
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;

In standby Database:

ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
SHUTDOWN IMMEDIATE;
STARTUP;

In Primary Database:

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

If the primary Database is down,we can use fllowing step to active standby database:

Alter DATABASE RECOVER MANAGED STANDBY DATABASE FINISH;
Alter DATABASE COMMIT TO SWITCHOVER TO PRIMARY;
SHUTDOWN IMMEDIATE;
STARTUP;

Register missing archive log file
Find archive log gap by query:

SELECT THREAD#, LOW_SEQUENCE#, HIGH_SEQUENCE# FROM V$ARCHIVE_GAP;

ALTER DATABASE REGISTER PHYSICAL LOGFILE 'filespec1';

相关文章|Related Articles

• Logical Standby ORA-01425错误处理一则
  
• 数据字典视图之：DBA_LOGSTDBY_LOG结构
  
• Oracle10g DataGuard中ORA-16026错误解决
  
• Duplicate standby 与 RMAN-05501 错误
  
• duplicate standby 与 RMAN-05507 错误
  

评论数量(0)|Add Comments

本文网址：archives/2009/03/oracle_dataguard_manual.html