- 论坛徽章:
- 0
|
前段时间搭建的oracle 11G DG环境,测试主备库同步一切正常。
今天开发同事连不上oracle,让我重启一下数据库,执行shutdown immediate命令等了十几分钟一直等待,实在无奈,只能强行终止,再执行shutdown abort,数据库强制关闭。再启动报错,信息如下:
SQL> startup
ORACLE instance started.
Total System Global Area 1.3429E+10 bytes
Fixed Size 2217992 bytes
Variable Size 7180650488 bytes
Database Buffers 6241124352 bytes
Redo Buffers 4661248 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 5481
Session ID: 3018 Serial number: 3
网上解决方案:
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1.3429E+10 bytes
Fixed Size 2217992 bytes
Variable Size 7180650488 bytes
Database Buffers 6241124352 bytes
Redo Buffers 4661248 bytes
Database mounted.
SQL> recover database until time '2014-04-22'
Media recovery complete.
SQL> alter database open resetlogs;
Database altered.
SQL> select open_mode from v$database;
OPEN_MODE
--------------------
READ WRITE
备库查看应用进程也正常,归档日志也正常更新。
SQL> select thread#,sequence#,process,client_process,status,block#,blocks from v$managed_standby;
THREAD# SEQUENCE# PROCESS CLIENT_P STATUS BLOCK# BLOCKS
---------- ---------- --------- -------- ------------ ---------- ----------
0 0 ARCH ARCH CONNECTED 0 0
1 10 ARCH ARCH CLOSING 1 659
0 0 ARCH ARCH CONNECTED 0 0
1 8 ARCH ARCH CLOSING 2049 1185
0 0 RFS N/A IDLE 0 0
0 0 RFS UNKNOWN IDLE 0 0
0 0 RFS UNKNOWN IDLE 0 0
1 146 MRP0 N/A APPLYING_LOG 93444 102400
1 11 RFS LGWR IDLE 262 1
9 rows selected.
主库上插表,备库上数据死活就不同步,是因为我执行恢复操作导致的吗?求大神解释?
|
|