OraFAQ Forum: Server Administration » Recover database with lost of some datafiles and some archivelogs

Home » RDBMS Server » Server Administration » Recover database with lost of some datafiles and some archivelogs

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

Recover database with lost of some datafiles and some archivelogs [message #487283]

Fri, 24 December 2010 10:12

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

Report message to a moderator

Re: Recover database with lost of some datafiles and some archivelogs [message #487285 is a reply to message #487283]

Fri, 24 December 2010 10:21

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

you must restore all datafiles, do NOT restore the controlfile.

Report message to a moderator

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

Michel Cadot
Messages: 68648
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

Re: Recover database with lost of some datafiles and some archivelogs [message #487294 is a reply to message #487288]

Fri, 24 December 2010 11:36

sonumalhi
Messages: 62
Registered: April 2008

Member

Thanks guys for quick response.
I think full restore and recover until last log will be easier.

Thanks for support again.

Report message to a moderator

Re: Recover database with lost of some datafiles and some archivelogs [message #487297 is a reply to message #487294]

Fri, 24 December 2010 12:00

sonumalhi
Messages: 62
Registered: April 2008

Member

Guys luckily we got our archivelogs diskgroup mounted ,
Can we now just now restore just our missing datafiles now instead of restoring all datafiles and then recover then to current SCN ?

Report message to a moderator

Re: Recover database with lost of some datafiles and some archivelogs [message #487298 is a reply to message #487297]

Fri, 24 December 2010 12:03

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You should consider doing a full cold backup before starting any recovery/restoration.
If so, then you will be able to get back to current state should problems arise in the future.

Report message to a moderator

Re: Recover database with lost of some datafiles and some archivelogs [message #487299 is a reply to message #487297]

Fri, 24 December 2010 12:06

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

Yes - and be certain NOT to restore controlfile or online logs, trhey must be current.
Complete recovery! That should give you a happy christmas.
My shift is over. Cheers!

Report message to a moderator