Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-01195: online backup of file 1 needs more recovery to be consistent

happy10319Mar 20 2008 — edited Mar 20 2008

Hi,
in 8i, I have following problem :
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01195: online backup of file 1 needs more recovery to be consistent
ORA-01110: data file 1: 'S:\ORADATA\mydb\SYSTEM_01.DBF'

What do you suggest me ?
Thank you.

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 17 2008

Added on Mar 20 2008

#general-database-discussions

15 comments

22,435 views