Datafile added and RMAN restore fails

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
k3vsmithAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) 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.
0
Steve WalesSenior Database AdministratorCommented:
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.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
k3vsmithAuthor 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!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.