问题描述
从库同步完数据做好后
从库:
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
打不开数据库