OraFAQ Forum: Backup & Recovery » New DBA trying recovery scenarios

Home » RDBMS Server » Backup & Recovery » New DBA trying recovery scenarios

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

New DBA trying recovery scenarios [message #228804]

Wed, 04 April 2007 04:52

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Hi ,

I am new to DBA worls And tried the following recovery scenario in my test system.Could somebody please help in recovery

1.Db in archivelog mode
2.Full backup of database using RMAN: BACKUP DATABASE
3.Deleted all datafiles & redo files but kept control file
4. Restored the files: RESTORE DATABASE
4. While atempting recover using RECOVER DATABASE getting error that unable to find redo log file in location.HOw do i recover as the RMAN didnt backup the redo file

Please suggest the solution

Thanks
Ram

Report message to a moderator

Re: New DBA trying recovery scenarios [message #228806 is a reply to message #228804]

Wed, 04 April 2007 04:59

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

Senior Member
Account Moderator

Always:
1/ Post your Oracle version
2/ Copy and paste your script and execution as it is.

Regards
Michel

Report message to a moderator

Re: New DBA trying recovery scenarios [message #228810 is a reply to message #228804]

Wed, 04 April 2007 05:18

ram_ocp
Messages: 49
Registered: December 2005
Location: Karnataka

Member

Hi,

The version in oracle 10.2
Db mode: ARCHIVELOG

I executed the following :
sql>SHTDOWN IMMEDIATE;
rman> BACKUP DATABASE
Deleted datafiles+ redofiles
sql>ALTER DATABASE MOUNT;
rman>RESTORE DATABASE;
rman>RECOVER DTABASE;
Error: Unable to find the redo files in the specified path

Pls suggest

Ram

Report message to a moderator

Re: New DBA trying recovery scenarios [message #228841 is a reply to message #228810]

Wed, 04 April 2007 06:49

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

Senior Member
Account Moderator

This is not a copy/paste of your screen

Report message to a moderator

Re: New DBA trying recovery scenarios [message #228861 is a reply to message #228810]

Wed, 04 April 2007 07:46

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Hi,
When you restore you database through RMAN. then connect with SQL prompt and give below command.

sql>recover database until cancel;
cancel
sql>alter database open resetlogs;

Regards
Taj

Report message to a moderator

Previous Topic:	Outlook Express Backup how to
Next Topic:	manage my old archive logs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Nov 26 20:45:53 CST 2024