DataGuard常见维护命令

• Oracle DataGuard 常用维护命令参考手册

• Oracle DataGuard Standby database ID mismatch错误
• Oracle Dataguard备库失败与主库响应测试
• DataGuard ORA-01111文件创建失败问题解决
• DataGuard的STANDBY_ARCHIVE_DEST参数
• HDS Truecopy实现原理及项目的选择
• 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;

• register using:

• ALTER DATABASE REGISTER PHYSICAL LOGFILE 'filespec1';