oracle01194,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;

startup force;

recover database using backup controlfile until cancel;

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 更加依赖参数