Home » RDBMS Server » Backup & Recovery » Unable to open database
Unable to open database [message #147744] Sun, 20 November 2005 14:53 Go to next message
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

Re: Unable to open database [message #147791 is a reply to message #147744] Mon, 21 November 2005 01:34 Go to previous messageGo to next message
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.

Re: Unable to open database [message #147892 is a reply to message #147744] Mon, 21 November 2005 09:53 Go to previous messageGo to next message
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


Re: Unable to open database [message #148356 is a reply to message #147744] Wed, 23 November 2005 15:22 Go to previous messageGo to next message
skempins
Messages: 16
Registered: June 2005
Location: Florida
Junior Member
No backup?!

Is this database your responsibility?

Is your resume up to date? http://www.resume-help.org/
Re: Unable to open database [message #148390 is a reply to message #148356] Wed, 23 November 2005 22:59 Go to previous messageGo to next message
tarundua
Messages: 1080
Registered: June 2005
Location: India
Senior Member
skempins wrote on Thu, 24 November 2005 02:52

Is your resume up to date?


By anyhow , does it relates to the problem Razz
Re: Unable to open database [message #148547 is a reply to message #148390] Thu, 24 November 2005 22:01 Go to previous message
chj733
Messages: 11
Registered: October 2005
Location: CHINA
Junior Member
no backups,I think you will not recover the database in normal way.
you can use the DUL tool to read the data
good luck!!!!

[Updated on: Thu, 24 November 2005 22:02]

Report message to a moderator

Previous Topic: How to multiplex backup on linux and window using rman and samba
Next Topic: Cold Backup
Goto Forum:
  


Current Time: Thu Dec 08 01:25:42 CST 2022