Skip to Main Content

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, swathi.

Asked: July 21, 2016 - 2:57 pm UTC

Last updated: August 08, 2016 - 3:07 am UTC

Version: 11g

Viewed 10K+ times! This question is

You Asked

Hi..
3 days before I took Level 0 and Level 1 backup from my database( name:sample) by using RMAN .Yesterday my target database was crashed.So I created another new database(sample1). Now I want to use those backup files and restore that all data in sample1 which is in sample db.
Now I can't connect to the target database(sample) it's gone.By using those backup files only i want to restore data.I have that backup files witch are taking by using RMAN.So what is the procedure to restore data in new database without connect to the target database by using RMAN backup files?

and Connor said...

Every database has a unique identifier (the "DBID") which rman uses. So (by default) it is setup to restore/recover back into the same database from which it was backed up.

But this doesn't mean that is the *only* supported means. You just need to let RMAN know that you're doing something this is not the default.

So the basic premise is typically:

- connect to your *new* database
- tell RMAN that it is the *old* database using the "SET DBID" command.

There's plenty of blog posts out there with some step by step instructions. Here's a couple for you:

http://www.dbasupport.com/forums/showthread.php?60006-Restore-RMAN-full-backup-to-different-server-with-other-name

http://www.rdc.co.za/blog/index.php/restore-db-with-a-different-db-name-using-rman/

https://www.pythian.com/blog/oracle-rman-restore-to-the-same-machine-as-the-original-database/


Rating

  (2 ratings)

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

Comments

Ignore pre-existing sample1 and restore sample

Hemant K Chitale, August 10, 2016 - 7:13 am UTC

Since sample and sample1 are two different databases (different DB_NAMEs and different DBIDs), you'd have to ignore the pre-existing sample1 (or drop it). Startup nomount, restore controlfile and then restore database. With an online backup, you also need to recover database.
You can, after the recovery is complete to the point in time you want, open and rename the database from sample to sample1 if you choose.

swathi, August 11, 2016 - 11:39 am UTC


More to Explore

Backup/Recovery

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