my database is not opening

[nawaz]

hi all

i dont have any backup how i can open my database


thanks in advance

nawaz

-------------here is story----------

SVRMGR> startup mount
ORACLE instance started.
Total System Global Area 84121628 bytes
Fixed Size 75804 bytes
Variable Size 57024512 bytes
Database Buffers 26943488 bytes
Redo Buffers 77824 bytes
Database mounted.
SVRMGR> alter database open
2> ;
alter database open
*
ORA-01122: database file 8 failed verification check
ORA-01110: data file 8: 'D:\DATA\MAINMTR01.DBF'
ORA-01207: file is more recent than controlfile - old controlfile

[yxez]

you can try...
sql> startup mount
sql> recover database

[Thomasps]

Did you restore your controlfile?

[davey23uk]

you can try...
sql> startup mount
sql> recover database

that wont help

[pareshjavkar]

Hi,

svrmgrl> startup mount;
svrmgrl> alter database backup controlfile to trace;

----Check udump location---- for latest Trace which has the script of your current controlfile.

Remove the entry 'D:\DATA\MAINMTR01.DBF'.

svrmgrl> shutdown immediate
svrmgrl> startup nomount
svrmgrl> (Backup your old controlfile before your fire this)
svrmgrl> alter database open;

Your will lose all the data in 'D:\DATA\MAINMTR01.DBF'.


Else apply archives, if you have ARCHIVELOG mode On.