Home » RDBMS Server » Backup & Recovery » New DBA trying recovery scenarios
New DBA trying recovery scenarios [message #228804] Wed, 04 April 2007 04:52 Go to next message
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
Re: New DBA trying recovery scenarios [message #228806 is a reply to message #228804] Wed, 04 April 2007 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

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

Regards
Michel
Re: New DBA trying recovery scenarios [message #228810 is a reply to message #228804] Wed, 04 April 2007 05:18 Go to previous messageGo to next message
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
Re: New DBA trying recovery scenarios [message #228841 is a reply to message #228810] Wed, 04 April 2007 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64102
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not a copy/paste of your screen
Re: New DBA trying recovery scenarios [message #228861 is a reply to message #228810] Wed, 04 April 2007 07:46 Go to previous message
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
Previous Topic: Outlook Express Backup how to
Next Topic: manage my old archive logs
Goto Forum:
  


Current Time: Fri Dec 02 16:35:27 CST 2016

Total time taken to generate the page: 0.55198 seconds