当我把备库的主机关掉后,发生了以下情况:
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/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/271063/viewspace-909997/