Home » RDBMS Server » Backup & Recovery » Loss of all redo logs (Linux)
Loss of all redo logs [message #459422] Fri, 04 June 2010 23:02 Go to next message
amkdba
Messages: 1
Registered: June 2010
Junior Member
I have loss all of my redologs group,when i try to recover using

recover database using backup controlfile until cancel

then it prompts me to select


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
auto
ORA-00308: cannot open archived log
'/u99/************/Arc_1_10_720660101.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3


ORA-00308: cannot open archived log
'/u99/*********/Arc_1_10_720660101.arc'
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3

and when i select the secound option ie cancel


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
cancel
Media recovery cancelled

and open the database using resetlogs option it gives me the below error

alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/u14/oradata/amazon/system01.dbf'


now how can i recover it....


Thanks
Re: Loss of all redo logs [message #459444 is a reply to message #459422] Sat, 05 June 2010 08:47 Go to previous messageGo to next message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Your recovery options will depend on the state of the redo logs at the time of failure. I assume you lost all your redo logs while the database was open, in which case you'll have to perform PITR from a previous backup.

Check Recovering After the Loss of Online Redo Log Files: Scenarios for details.
Re: Loss of all redo logs [message #459531 is a reply to message #459422] Sun, 06 June 2010 14:00 Go to previous messageGo to next message
mahfoozali0786
Messages: 1
Registered: June 2010
Location: new delhi
Junior Member
Dear

if you have taken multiplexing of redo logs then copy the to destination and open with resetlogs if you have not then first drop group and re-create;
Re: Loss of all redo logs [message #459534 is a reply to message #459531] Sun, 06 June 2010 14:07 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
mahfoozali0786 wrote on Sun, 06 June 2010 15:00

if you have taken multiplexing of redo logs then copy the to destination and open with resetlogs if you have not then first drop group and re-create;

Read the post closely:

amkdba wrote on Sat, 05 June 2010 00:02
I have loss all of my redologs group

Previous Topic: recover table without backup
Next Topic: whole backup
Goto Forum:
  


Current Time: Thu Apr 24 22:40:59 CDT 2014

Total time taken to generate the page: 0.09620 seconds