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博客

ORA-01152解决

最新文章