If you cannot recover data by yourself, ask Parnassusdata, the professional ORACLE database recovery team for help.

The goal of this article is to assist DBAs who encounter the following errors at Database open.

ORA-1194 "file %s needs more recovery to be consistent"

ORA-1547 "warning: RECOVER succeeded but OPEN RESETLOGS would get error below"

ORA-1110 "data file %s: '%s'"

Scope

This article is meant for database administrators and backup and recovery specialists tasked with the restore and recovery of a database

Details

Assuming All Datafiles was either successfully restored, and/or recovery was done with existing database datafiles.

Then open the database failed with errors like:

ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below

ORA-01194: file 1 needs more recovery to be consistent

ORA-01110: data file 1: '/u01/app/oracle/oradata/V1123/system01.dbf'

Scenario 1: Current Controlfile is available

This shows the Information whats needed for recovery, usually you will not see the errors as above at open database, but nevertheless giving this

example.

1) Ensure Instance is Mounted and ALL Datafiles ONLINE

If the CURRENT CONTROLFILE is used then you can run recover database, and it will

apply all archivelogs, and the online 'current' redolog if available, and finally you can open database

Example: