Home » RDBMS Server » Backup & Recovery » recover database with out redo and controlfiles
recover database with out redo and controlfiles [message #303127] Thu, 28 February 2008 01:19 Go to next message
Vivek.k.thakur
Messages: 30
Registered: December 2007
Location: DELHI, INDIA
Member

Hi experts.
Situation is this , My production server's Hotbackup(user managed) completed at 7:30PM, and My database looses its redologs and controlfiles at 8:22PM , almost after 52 minutes, My database was running in archive log mode. Now I want to know can I recover data between these 52 minutes? I can apply hotbackup, it is the simplest way, But I am loosing the data of 52 minutes, My redo log size is 100M. one archive has been created of 80M. while I start recovery ,oracle server asked for file, I gave,then it gave the error of block corruption. Is there any possibility to recover. Please suggest me.


Thanks
vivek
Re: recover database with out redo and controlfiles [message #303214 is a reply to message #303127] Thu, 28 February 2008 07:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Yes, you can recover your database upto recent archived log file.

1. restore complete host backup which you taken last recent.
2. apply all archivelog file upto last created.

Re: recover database with out redo and controlfiles [message #303241 is a reply to message #303127] Thu, 28 February 2008 09:04 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
You will have to do Point-in-time Recovery (PITR) and will loose any data that was still in the redo logs.

[Updated on: Thu, 28 February 2008 09:05]

Report message to a moderator

Previous Topic: database failing to start up / database recovery without a backup (merged)
Next Topic: Oracle data block corrupation
Goto Forum:
  


Current Time: Mon May 13 20:41:01 CDT 2024