一键恢复ORA-01113 ORA-01110—Oracle Recovery Tools

一般由于归档日志丢失或者非归档库可能在数据库启动的时候出现类似如下错误

SQL> startup

ORACLE instance started.

Total System Global Area 2137886720 bytes

Fixed Size 2282960 bytes

Variable Size 587205168 bytes

Database Buffers 1543503872 bytes

Redo Buffers 4894720 bytes

Database mounted.

ORA-01113: file 1 needs media recovery

ORA-01110: data file 1: 'F:\ORADATA\XIFENFEI\SYSTEM01.DBF'

主要是由于数据文件不一致需要比较老的日志,但是日志不存在从而导致该问题

现在可以通过Oracle Recovery Tools工具一键解决

尝试open数据库

SQL> recover database;

Media recovery complete.

SQL> alter database open;

Database altered.