Home » RDBMS Server » Backup & Recovery » Restore datafile after RMAN backup taken (oracle 12c Windows 2012)
Restore datafile after RMAN backup taken [message #669620] Thu, 03 May 2018 08:17 Go to next message
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 68770
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 Go to previous messageGo to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon Sep 22 08:15:30 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.