Skip to Main Content
  • Questions

  • RMAN restoration check - what do I need to create ?

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, oracle.

Asked: November 19, 2015 - 4:51 am UTC

Last updated: November 20, 2015 - 5:23 am UTC

Version: 11.2.0.3.0

Viewed 1000+ times

You Asked

Dear Tom,

I have rman full backup with archivelog all (backup database plus archivelog) of primary production database now i want to check the backup existince For that i have created new instance on different server for restoration; Now I have some doubt
My primary database with 6 users and 6 tablespaces and many other objects So, before to restore i need to create all users and tablespace to match with primary then restore (catalog start with, set new name for datafile 1...) or need not to create any users, tablespaces and all. Just catalog and set new name and restore the db thats it.



Thanks

and Connor said...

You just need to restore/recover using RMAN.

All of the definitions etc are included in the backup files (for the SYSTEM tablespace). That's where all those definitions live. Once you restore the datafiles/controlfiles, it will all be back.

Hope this helps.

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

oracle, November 19, 2015 - 8:26 am UTC

Thanks for reply.

I want to restore production rman backup to newly created instance with different server for that Need not to create any user tablespaces and all ?

Only scp that backup files from production to new restoration server and start with catalog and restore it

Will create all productinon users tablespaces and all ?

Thanks


Connor McDonald
November 19, 2015 - 12:13 pm UTC

That is correct yes. As long as you can start an empty *instance* (ie, a parameter file and the directories where the datafiles will be restored to are present), RMAN should take care of the rest (with set newname etc).

You can also use the backup within a DUPLICATE command.

Hope this helps.

A reader, November 19, 2015 - 5:37 pm UTC

Means need not to create any user tablespaces and all but at the time of restoration I gives an error tablespaces not there then II create same tablespaces users then try to restore the backup with set new name...

Thats why I need to ask before rman backup restore user tablespaces need to create or need I m not using duplicate commad I have rman backup pieces to restore.

Thanks
Chris Saxon
November 20, 2015 - 2:23 am UTC

Sorry, I have no idea what those sentences are trying to convey.

oracle, November 20, 2015 - 4:12 am UTC


I have a new rman full backup with archivelog backup pieces to restore on different server on that activity what i do
-->I create a new instance
-->Create same tablespace and users then
-->restore the control file then
-->mount and catalog the new pieces and restore and recovery to give set until sequence no. then It happen Thats why i am asking that was wrong way for this to create a tablespace and users before to restore the rman backup on different instance.

Thanks

Connor McDonald
November 20, 2015 - 5:23 am UTC

There's a section of the documentation that might be useful here:

"Restoring a Database on a New Host"

http://docs.oracle.com/cd/E11882_01/backup.112/e10642/rcmadvre.htm#BRADV908

more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Backup/Recovery

Check out the complete guide to all of the Backup & Recovery techniques in the Oracle Database.