ITPub博客

首页 > 数据库 > Oracle > oracle_datagrard 之Create笔记2

oracle_datagrard 之Create笔记2

原创 Oracle 作者:wmlm 时间:2007-04-11 18:32:48 0 删除 编辑
前面已经把建库的过程给讲过了,这里对备库关闭的情况做一个补充[@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博客 ” ,链接:https://blog.itpub.net/271063/viewspace-909997/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-04-08

  • 博文量
    398
  • 访问量
    3716787