Datafile added and RMAN restore fails

k3vsmith
k3vsmith used Ask the Experts™
on
Hello,
I want to know if there is a command I can run in rman after adding a datafile that will make rman aware of the datafile incase I have to restore. Currently we are waiting to add datafiles till either before our full or incremental backup kicks off or adding a datafile and manually kicking off a backup.
Is there another option to make rman aware of datafile without doing a full or incremental backup?

Thanks
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Distinguished Expert 2018

Commented:
RMAN should be aware of the new data file the next time it runs.

That said: I suppose you could set RMAN up in such a way that it wouldn't but you would probably have to go out of your way to do so.

In the title, you mentioned an error on restore.  If you are getting an error we will need more information.  Preferably the RMAN script that performs the backup, how often it runs and the restore process along with error.
Senior Database Administrator
Commented:
Is the error coming out of a restore or a duplicate ?  
 
If it's a duplicate then there is a bug in 11.2.0.3 and earlier:
BUG:12799744 - DUPLICATE TO POINT IN TIME AFTER DATAFILE WAS ADDED FAIL.

(I've seen this behavior myself in 11.2.0.3).

This has been fixed in 11.2.0.4:
Rman-06023 encountered during duplicate to point in time after datafile was added (Doc ID 782317.1)

This support note also gives the work around on how to get past this issue.

Author

Commented:
Thanks both. Steve it was a restore. When I do a backup first and then a restore it works fine after addding a datafile. I guess thats the route Ill take. We are on 11.2.0.3 planning to upgrade to 12c later this year once our version of EBS certifies it. Thanks!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial