OraFAQ Forum: Backup & Recovery » How to Recover Data From redo files in oracle 8.1.5 (merged)

Home » RDBMS Server » Backup & Recovery » How to Recover Data From redo files in oracle 8.1.5 (merged)

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

How to Recover Data From redo files in oracle 8.1.5 (merged) [message #402800]

Tue, 12 May 2009 09:52

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Dear How to recover database when this error occured ORA-01033 Oracle Initialization or shut down in progress

kind regards
Faheem

Report message to a moderator

Re: How to recover database when this error occured in oracle 8.1.5 [message #402801 is a reply to message #402800]

Tue, 12 May 2009 09:56

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Perhaps you cant't/don't.

There should be a trace file named in alertSID.log file which might hold valuable clues.

What happened preceeding this failure?

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: How to recover database when this error occured in oracle 8.1.5 [message #402803 is a reply to message #402801]

Tue, 12 May 2009 10:07

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

The alertSid log not found any where

Report message to a moderator

Re: How to recover database when this error occured in oracle 8.1.5 [message #402805 is a reply to message #402803]

Tue, 12 May 2009 10:11

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But it is somewhere.
Post what you did to find it.

Regards
Michel

[Updated on: Tue, 12 May 2009 10:12]

Report message to a moderator

Re: How to recover database when this error occured in oracle 8.1.5 [message #402806 is a reply to message #402805]

Tue, 12 May 2009 10:17

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

Dear Michel The Problem is i have no backup please help me for recovery any way

Report message to a moderator

Re: How to recover database when this error occured in oracle 8.1.5 [message #402807 is a reply to message #402806]

Tue, 12 May 2009 10:20

Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No way, your database is lost.

Regards
Michel

Report message to a moderator

Re: How to recover database when this error occured in oracle 8.1.5 [message #402809 is a reply to message #402800]

Tue, 12 May 2009 10:22

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

I am trying to find alertsid

Report message to a moderator

Re: How to recover database when this error occured in oracle 8.1.5 [message #402810 is a reply to message #402800]

Tue, 12 May 2009 10:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

What happened preceeding this failure?

Report message to a moderator

How to Recover Data From redo files in oracle 8.1.5 [message #402813 is a reply to message #402800]

Tue, 12 May 2009 10:51

qanita786
Messages: 229
Registered: May 2007
Location: PAKISTAN

Senior Member

How to Recover Data From redo files in oracle 8.1.5 when database occure following error Oracle Initialization or Shut down in progress

kind regards
Faheem

Report message to a moderator

Re: How to Recover Data From redo files in oracle 8.1.5 [message #402816 is a reply to message #402813]

Tue, 12 May 2009 11:00

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

http://www.orafaq.com/forum/m/402810/136107/#msg_402810

do NOT cross/multi-post

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

sqlplus
connect internal
shutdown abort
startup
exit

do above then CUT & PASTE results of whole sesion

Report message to a moderator

Previous Topic:	Full backup + archive logs = redundant?
Next Topic:	RMAN incarnation issus (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 08:39:10 CST 2024