Oracle冷备份丢失最新控制文件如何恢复

ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '/u01/app/oracle/oradata/orcl/system01.dbf'
ORA-01207: file is more recent than control file - old control file

SQL> RECOVER DATAFILE '/u01/app/oracle/oradata/orcl/system01.dbf'

--- 不要以controlfile中的scn作为恢复的终点
SQL> recover database using backup controlfile;

SQL> alter database open resetlogs;

SQL> select instance_Name,status from v$instance;

SQL> select * from emp;