oracle_datagrard 之Create筆記2

wmlm發表於2007-04-11
前面已經把建庫的過程給講過了,這裡對備庫關閉的情況做一個補充[@more@]

當我把備庫的主機關掉後,發生了以下情況:
alert.log檔案中出現
Errors in file d:oracleadmingswebbdumpgsweb_arc0_2976.trc:
ORA-12535: TNS:operation timed out
...
Wed Apr 11 16:00:33 2007
Errors in file d:oracleadmingswebbdumpgsweb_arc0_2976.trc:
ORA-16058: standby database instance is not mounted
當我把備庫啟來以後
Wed Apr 11 16:06:33 2007
ARC1: Begin FAL archive (thread 1 sequence 124 destination gsweb2)
Wed Apr 11 16:06:33 2007
ARC0: Begin FAL archive (thread 1 sequence 125 destination gsweb2)
Wed Apr 11 16:06:33 2007
Creating archive destination LOG_ARCHIVE_DEST_2: 'gsweb2'
Wed Apr 11 16:06:33 2007
Creating archive destination LOG_ARCHIVE_DEST_2: 'gsweb2'
Wed Apr 11 16:06:34 2007
ARC1: Complete FAL archive (thread 1 sequence 124 destination gsweb2)
ARC1: Begin FAL archive (thread 1 sequence 126 destination gsweb2)
Creating archive destination LOG_ARCHIVE_DEST_2: 'gsweb2'

啟備庫的過程
conn / as sysdba
SQL> startup nomount
SQL> ALTER DATABASE MOUNT STANDBY DATABASE;
SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION
請各位多指教!

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

相關文章