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-01110: data file 1

RamMay 30 2010 — edited May 30 2010

when try to open database display error messg...

SQL> startup pfile='e:\newdb\hutch.ora'
ORACLE instance started.

Total System Global Area 289406976 bytes
Fixed Size 1290184 bytes
Variable Size 130023480 bytes
Database Buffers 150994944 bytes
Redo Buffers 7098368 bytes
Database mounted.
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open

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: 'E:\NEWDB\HUTCH\SYSTEM01.DBF'

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2010

Added on May 30 2010

#general-database-discussions

25 comments

25,589 views