熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

OracleDataGuard常用維護命令參考手冊

2013-11-13 22:08:12  來源: Oracle 

  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_ = defer;
alter system set log_archive_dest_state_ = 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 downwe 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 filespec;


From:http://tw.wingwit.com/Article/program/Oracle/201311/18315.html
    推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.