OraFAQ Forum: Backup & Recovery » Unable to open database

Home » RDBMS Server » Backup & Recovery » Unable to open database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Unable to open database [message #147744]

Sun, 20 November 2005 14:53

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

Hi!

Oracle version: 8.0.5 Operation system
When I try to open the database this errors appears:

SVRMGR> startup open O09818DB
ORACLE instance started.
Total System Global Area 39987760 bytes
Fixed Size 59952 bytes
Variable Size 22478848 bytes
Database Buffers 16777216 bytes
Redo Buffers 671744 bytes
Database mounted.
ORA-01122: database file 1 failed verification check
ORA-01110: data file 1: '$DISK810:[ORACLE8.DB_O09818DB]ORA_SYSTEM.DBS
SVRMGR>

My alert file show me this:

20-NOV-2005 21:41:43.07:
alter database O09818DB mount

20-NOV-2005 21:42:22.24:
Successful mount of redo thread 1, with mount id 419370798.

20-NOV-2005 21:42:22.24:
Database mounted in Exclusive Mode.
Completed: alter database O09818DB mount

20-NOV-2005 21:42:22.26:
alter database open
ORA-1122 signalled during: alter database open ..

I have no backup.

Can anyone help?

Zoltan

Report message to a moderator

Re: Unable to open database [message #147791 is a reply to message #147744]

Mon, 21 November 2005 01:34

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

I am afraid that you can't as you said that you dont have any backup.

And the error suggests that there is some problem with the SYSTEM tablespace.

Report message to a moderator

Re: Unable to open database [message #147892 is a reply to message #147744]

Mon, 21 November 2005 09:53

zoltanp
Messages: 58
Registered: March 2005
Location: Hungary

Member

I mounted database, I query V$DATAFILE view and I gave the following error messages:

select * from v$datafile;
ORA-00235: controlfile fixed table inconsistent due to
concurrent update

I haven't got any backup!

What can I do?
SOMEBODY HELP ME?

Zoltan

Report message to a moderator