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