Linux下DG备库问题

remen

原帖由 jasoname 于 2010-1-22 09:45 发表
Linux下DG备库问题


[oracle@node2 ~]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Fri Jan 22 09:37:40 2010

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area  167772160 bytes
Fixed Size                  1218316 bytes
Variable Size              62916852 bytes
Database Buffers          100663296 bytes
Redo Buffers                2973696 bytes
Database mounted.
ORA-16004: backup database requires recovery
ORA-01194: file 1 needs more recovery to be consistent
ORA-01110: data file 1: '/u01/oradata/dgdemo/system01.dbf'
这是什么原因怎么解决啊

至于这个问题则估计是因为丛库的redo应用关掉后部分归档没应用到备库导致的
你可以这样查查看

select sequence#, applied from v$archived_log; 如果发现No的字样，开始redo apply即可

alter database recover managed standby database disconnect from session;