For help, don't know how to make the

SQL> The alter database open resetlogs;
The alter database open resetlogs
*
Line 1 error:
ORA - 01194: file 1 need more back to consistency
ORA - 01110: data file 1: 'D: \ APP \ ORADATA \ ZB \ SYSTEM01 DBF'

CodePudding user response:

There are archived log? Continue to recover?

CodePudding user response:

There is no archive log, done, set parameters _allow_resetlogs_corruption=TRUE

CodePudding user response:

Normally, the machine recovery do perfect, there will be a plus archivelog options, should recover,

PS: set allow_resetlogs_corruption=true, and after the open, to remove the this parameter,

CodePudding user response:

If not, use this script to check database, generate HTML files I http://www.xifenfei.com/oracle_recovery_check