Skip to Main Content
Forums

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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Database not opening up

baskar.l-2011272Mar 4 2008 — edited Mar 5 2008
Hi all,

Certain datafiles has been physically removed from the mountpoints.
So created a control file trace and removed those datafiles from control file and the control file has been recreated.
The database is no archive log mode.
When opening the database it throws error

SQL> startup nomount
ORACLE instance started.

Total System Global Area 598283852 bytes
Fixed Size 452172 bytes
Variable Size 419430400 bytes
Database Buffers 167772160 bytes
Redo Buffers 10629120 bytes
SQL> @control.sql

Control file created.

SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/steeld5_db/steeld5/system01.dbf'

Thanks,
baskar.l

Comments

Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Apr 2 2008
Added on Mar 4 2008
#general-database-discussions
24 comments
1,013 views