dataguard standby資料庫的關閉和啟動

gugu99發表於2007-12-24
dataguard standby資料庫的關閉和啟動

各位:standby資料庫的關閉和啟動命令如下,重啟後資料庫能繼續複製嗎?還有dataguard primary 資料庫和standby資料庫的啟動引數如sort_area_size 大小不一致,有沒有問題?



Starting Up a Physical Standby Database



Start the database:

SQL> STARTUP NOMOUNT;



Mount the standby database:

SQL> ALTER DATABASE MOUNT STANDBY DATABASE;



Start the managed recovery operation:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;



Shutting Down a Physical Standby Database

SQL> SELECT PROCESS, STATUS FROM V$MANAGED_STANDBY;

Cancel managed recovery operations.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

Shut down the standby database.

SQL> SHUTDOWN IMMEDIATE;
[@more@]

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10748419/viewspace-995674/,如需轉載,請註明出處,否則將追究法律責任。

相關文章