SQL> recover database using backup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-01190: controlfile or data file 8 is from before the last RESETLOGS
ORA-01110: data file 8: '/home2/table/wk/erp.dbf'
1.如果是当前的联机日志,如果你没有备份的话,只有加隐含参数打开
2.如果是非当前联机日志,那么只要
select group#,sequence#,archived,status from v$log;
然后clear
alter database clear unarchived logfile group 1;
如果没有把握的话,找个有经验的来作