ORA-01152解決

與刃爭鋒發表於2013-12-30
RMAN> alter database open resetlogs; 
ORA-01152: file 1 was not restored from a sufficiently old backup 
ORA-01110: data file 1: '/home/oracle/app/oradata/westos/system01.dbf'


解決:
SQL> startup force;
ORACLE instance started.
SQL> alter system set "_allow_resetlogs_corruption"=true scope=spfile;
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 2282018 generated at 07/14/2012 15:48:31 needed for thread 1
ORA-00289: suggestion :

Specify log: {=suggested | filename | AUTO | CANCEL}
auto
SQL> alter database open resetlogs;

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/25025926/viewspace-1065661/,如需轉載,請註明出處,否則將追究法律責任。

相關文章