OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle Error

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

Oracle Error [message #183970]

Mon, 24 July 2006 10:46

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

Report message to a moderator

Re: Oracle Error [message #183990 is a reply to message #183970]

Mon, 24 July 2006 13:36

Frank Naude
Messages: 4580
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.

Report message to a moderator

Re: Oracle Error [message #183991 is a reply to message #183990]

Mon, 24 July 2006 13:57

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

BTW, did you hug your backup today?

Report message to a moderator

Re: Oracle Error [message #184013 is a reply to message #183991]

Mon, 24 July 2006 21:55

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

Report message to a moderator

Re: Oracle Error [message #184021 is a reply to message #184013]

Mon, 24 July 2006 22:39

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: Oracle Error [message #184053 is a reply to message #184013]

Tue, 25 July 2006 02:27

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.

Report message to a moderator

Re: Oracle Error [message #184263 is a reply to message #184053]

Tue, 25 July 2006 22:58

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

Report message to a moderator

Re: Oracle Error [message #184276 is a reply to message #184263]

Wed, 26 July 2006 00:31

Frank Naude
Messages: 4580
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

Report message to a moderator

Previous Topic:	ORA-12500: TNS:listener failed to start a dedicated server process
Next Topic:	fragmentation in LMT ?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:34:26 CDT 2024