oralce DG方案 从库alter database open打不开,卡住

新手上路,请多包涵

问题描述

从库同步完数据做好后
从库:

1. 从库操作
SQL>SHUTDOWN IMMEDIATE
SQL>STARTUP MOUNT;
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;
2.主库上操作
SQL>ALTER SYSTEM SWITCH LOGFILE;

3.备库操作
SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SQL>ALTER DATABASE OPEN;

卡在ALTER DATABASE OPEN,无法开启数据库
alter-ee.log报错日志如下:

Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Fri Oct 25 08:14:09 2019
RFS[30]: Selected log 11 for thread 1 sequence 992347 dbid 1402893608 branch 954839898
Archived Log entry 1094 added for thread 1 sequence 992346 ID 0x585eb54d dest 1:
Fri Oct 25 08:14:19 2019
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Fri Oct 25 08:14:51 2019
Errors in file /home/oracle/oracle11g/diag/rdbms/orcldg/EE/trace/EE_m000_6345.trc:
ORA-01155: the database is being opened, closed, mounted or dismounted
Fri Oct 25 08:15:19 2019
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Fri Oct 25 08:15:49 2019
Using STANDBY_ARCHIVE_DEST parameter default value as USE_DB_RECOVERY_FILE_DEST
Fri Oct 25 08:15:49 2019
RFS[30]: Selected log 12 for thread 1 sequence 992348 dbid 1402893608 branch 954839898
Archived Log entry 1095 added for thread 1 sequence 992347 ID 0x585eb54d dest 1:
Fri Oct 25 08:16:19 2019

打不开数据库

阅读 2.9k
撰写回答
你尚未登录,登录后可以
  • 和开发者交流问题的细节
  • 关注并接收问题和回答的更新提醒
  • 参与内容的编辑和改进,让解决方法与时俱进