OraFAQ Forum: Backup & Recovery » Restore datafile after RMAN backup taken

Home » RDBMS Server » Backup & Recovery » Restore datafile after RMAN backup taken (oracle 12c Windows 2012)

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

Restore datafile after RMAN backup taken [message #669620]

Thu, 03 May 2018 08:17

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi All,

Having a small doubt.

If we have taken RMAN full DB backup at 11 AM, and added a new datafile at 11.30 AM.
And then taken only the LOG SEQUENCE backup.

If the DB crash at 12.30 PM and trying to restore the DB from backup.
Will it include the new datafile added.

Kindly guide us.

Regards
M.krish

Report message to a moderator

Re: Restore datafile after RMAN backup taken [message #669622 is a reply to message #669620]

Thu, 03 May 2018 09:33

gazzag
Messages: 1119
Registered: November 2010
Location: Bedwas, UK

Senior Member

Do you have CONTROLFILE AUTOBACKUP ON?

Report message to a moderator

Re: Restore datafile after RMAN backup taken [message #669625 is a reply to message #669620]

Thu, 03 May 2018 11:31

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

Senior Member
Account Moderator

Quote:

Will it include the new datafile added.

Yes, why don't you try it?

And, as gazzag suggested, better make a backup of your control file after adding a new file, it will ease the future operations.

Report message to a moderator

Re: Restore datafile after RMAN backup taken [message #669679 is a reply to message #669625]

Mon, 07 May 2018 07:54

Frank Naude
Messages: 4596
Registered: April 1998

Senior Member

"If a data file is damaged and no backup of the file is available, then you can still recover the data file if..."
https://docs.oracle.com/cd/E11882_01/backup.112/e10642/osadvsce.htm#BRADV224

Report message to a moderator

Re: Restore datafile after RMAN backup taken [message #669683 is a reply to message #669679]

Mon, 07 May 2018 09:09

muthukrish104
Messages: 82
Registered: November 2017

Member

Hi All,

Thanks for the guidance.

Regards.
M.Krish

Report message to a moderator

Previous Topic:	How To Determine The Start and End SCN of Restore and Recovery
Next Topic:	How to duplicate oracle database in multiple channels?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Sep 16 16:42:35 CDT 2026