Recover database with lost of some datafiles and some archivelogs [message #487283] |
Fri, 24 December 2010 10:12 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sonumalhi
Messages: 62 Registered: April 2008
|
Member |
|
|
Hi
We have lost some datafiles and some archivelogs. We have backup of whole database taken on Dec 20 and archivelogs until Dec 23.
So we dont have 1 day worth of archivelogs which can lead to incomplete recovery.
Now question is do we need to restore all datafiles or only lost datafiles for incomplete recovery since we dont have all archivelogs ?
lost datafiles belong to different tablespaces.
Datafiles which are still intact are with current SCN and we restore lost datafiles only and recover unitl our last available archivelog it will have different SCN.
Will we be able to open database or we need to resotre whole database for this scenario ?
Thanks in Advance.
Mehtab
|
|
|
|
Re: Recover database with lost of some datafiles and some archivelogs [message #487288 is a reply to message #487283] |
Fri, 24 December 2010 10:29 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
You can restore and recover ONLY to the last archived logs you have.
You can also restore the database in another place, recover it to the last possible SCN, export all what is in your lost tablespaces. Then, in your failed one, you offline and drop the lost tablespaces, open reset logs the database, recreate the drop tablespaces and import what you saved from the other database.
This is the best you can have.
Regards
Michel
[Updated on: Fri, 24 December 2010 10:30] Report message to a moderator
|
|
|
|
|
|
|
|
|