舒悦 刘志平:ORA-01547 ORA-01194 ORA-01110

RMAN> run { set until time "to_date('20081125 19:50:44','yyyymmdd HH24:MI:SS')";recover database;}

executing command: SET until clause

Starting recover at 25-NOV-08
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=1082 devtype=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: sid=1085 devtype=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: sid=1086 devtype=DISK

starting media recovery

Oracle Error:
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01194: file 3 needs more recovery to be consistent
ORA-01110: data file 3: '+DATA/oradata/fdcd/sysaux.dbf'

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 11/25/2008 19:53:15
RMAN-06053: unable to perform media recovery because of missing log
RMAN-06025: no backup of log thread 1 seq 1861 lowscn 2061909090 found to restore

这个问题还没有解决,0级备份后，backup archivelog all;但是没有备份当前日志，也就是未执行

alter system log archive current ;

在这种情况下，recover 不能使数据库保持一致，如何解决呢？

-----------------------------------------------------------------

2008-11-25日解决这个问题

alter system set "_allow_resetlogs_corruption"=true scope=spfile;

recover database using backup controlfile until cancel;

SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> startup force;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup force;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> startup;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@dg_fdct rman]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 25 20:01:43 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 7516192768 bytes
Fixed Size                  2084432 bytes
Variable Size             872415664 bytes
Database Buffers         6627000320 bytes
Redo Buffers               14692352 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

SQL> startup force;
ORA-24324: service handle not initialized
ORA-01041: internal error. hostdef extension doesn't exist
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@dg_fdct rman]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Nov 25 20:02:18 2008

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

Connected to an idle instance.

SQL> startup force;
ORACLE instance started.

Total System Global Area 7516192768 bytes
Fixed Size                  2084432 bytes
Variable Size             872415664 bytes
Database Buffers         6627000320 bytes
Redo Buffers               14692352 bytes
Database mounted.
Database opened.

具体说来 "_allow_resetlogs_corruption参数的作用很大,在很多系统中都是靠参数来改变的

oracel 更加依赖参数