OraFAQ Forum: Backup & Recovery » Loss of all redo logs

Home » RDBMS Server » Backup & Recovery » Loss of all redo logs (Linux)

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

Loss of all redo logs [message #459422]

Fri, 04 June 2010 23:02

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

Report message to a moderator

Re: Loss of all redo logs [message #459444 is a reply to message #459422]

Sat, 05 June 2010 08:47

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.

Report message to a moderator

Re: Loss of all redo logs [message #459531 is a reply to message #459422]

Sun, 06 June 2010 14:00

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;

Report message to a moderator

Re: Loss of all redo logs [message #459534 is a reply to message #459531]

Sun, 06 June 2010 14:07

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Nov 21 20:25:29 CST 2024