Home » RDBMS Server » Backup & Recovery » How to Recover Data From redo files in oracle 8.1.5 (merged)
How to Recover Data From redo files in oracle 8.1.5 (merged) [message #402800] Tue, 12 May 2009 09:52 Go to next message
qanita786
Messages: 213
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
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
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/
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 Go to previous messageGo to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
The alertSid log not found any where
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
Dear Michel The Problem is i have no backup please help me for recovery any way
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64140
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No way, your database is lost.

Regards
Michel
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 Go to previous messageGo to next message
qanita786
Messages: 213
Registered: May 2007
Location: PAKISTAN
Senior Member
I am trying to find alertsid
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 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member

What happened preceeding this failure?
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 Go to previous messageGo to next message
qanita786
Messages: 213
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
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 Go to previous message
BlackSwan
Messages: 25046
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
Previous Topic: Full backup + archive logs = redundant?
Next Topic: RMAN incarnation issus (merged)
Goto Forum:
  


Current Time: Fri Dec 09 08:04:15 CST 2016

Total time taken to generate the page: 0.06472 seconds