Home » RDBMS Server » Server Administration » Oracle Error
icon10.gif  Oracle Error [message #183970] Mon, 24 July 2006 10:46 Go to next message
bravobritto
Messages: 6
Registered: July 2006
Location: Somewhere in India
Junior Member

Hi

I have some problem in SUN SERVER at billing section in which I'm not able to access the oracle database.
Pl. help me solving the following oracle error.

ORA-01033; Oracle Initialization or Shutdown in Progress.
ORA-01157; Cannot identify / lock data file 2 - see DBWR trace file
ORA-01110; data file 2; '/data_undo/poi/undotbs1.dbf'

I guess this problem must have been aroused because of abrupt power trip.

Regards
Britto Embarassed
Re: Oracle Error [message #183990 is a reply to message #183970] Mon, 24 July 2006 13:36 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Your database cannot start as file /data_undo/poi/undotbs1.dbf is not available on the operating system. Check if you can see it. If you need to, restore it from backup.
Re: Oracle Error [message #183991 is a reply to message #183990] Mon, 24 July 2006 13:57 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
BTW, did you hug your backup today?
icon6.gif  Re: Oracle Error [message #184013 is a reply to message #183991] Mon, 24 July 2006 21:55 Go to previous messageGo to next message
bravobritto
Messages: 6
Registered: July 2006
Location: Somewhere in India
Junior Member

I'm new to Oracle so guide me how to proceed ? How to find whether backup has been taken ?
Regards
Britto Mad
Re: Oracle Error [message #184021 is a reply to message #184013] Mon, 24 July 2006 22:39 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I guess it is you who should know whether you perform database backup or not.
Re: Oracle Error [message #184053 is a reply to message #184013] Tue, 25 July 2006 02:27 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Littlefoot's right - if you're the DBA for this database, then it's your job to know that the backups have been taken.

If you don't have a backup, then I think you're in trouble.

The good news is that it looks like you've "only" lost your UNDO tablespace, so you may get away without losing any data.

If I were you, I'd get in touch with Metalink and raise a SR for this one - database recovery isn't something you want to do by yourself if your new to Oracle.
icon12.gif  Re: Oracle Error [message #184263 is a reply to message #184053] Tue, 25 July 2006 22:58 Go to previous messageGo to next message
bravobritto
Messages: 6
Registered: July 2006
Location: Somewhere in India
Junior Member

Database backup exists and my friend advised me to check it before restoring. So I'm planning to install Oracle in Sun Blade 150, which is Sun workstation. What is this metalink and how can I get help from them ?

Regards
Britto Laughing
Re: Oracle Error [message #184276 is a reply to message #184263] Wed, 26 July 2006 00:31 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Quote:

What is this metalink and how can I get help from them?


See http://www.orafaq.com/wiki/Engaging_Oracle_Support
Previous Topic: ORA-12500: TNS:listener failed to start a dedicated server process
Next Topic: fragmentation in LMT ?
Goto Forum:
  


Current Time: Sat Dec 03 18:08:52 CST 2016

Total time taken to generate the page: 0.11097 seconds