RMAN - Restoring database from backup in another location

[ErrolDC2]

Hi. I'm just doing some DR testing and I'm trying to restore the database from a backup piece in an alternate location. Much like you would restore a control file or the spile from an alternate location. Rman does not seem to allow that. How do I tell it that my autobackup is not in the same place anymore?

Thanks!

 

[LKBrwnDBA]

Just a matter of http://en.wikipedia.org/wiki/RTFM&e=9797]reading[/url] the manual.



----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[ErrolDC2]

Hi and thx for your reply.

Perhaps I was not clear. On the production system, rman backups are dumped to E:\somepath.
On the system I am using for recovery, there is no E:\somepath. As a matter of "E:" does not exist. I have searched the manual and it is not clear to me on how I can instruct rman to realize that the backup files are no longer in the same location. Your reference to the documentation seems to point me to restoring datafiles to an alternate location. There is a section that talks about the use of the catalog command, but the reference manual says this:

You cannot use CATALOG to perform the following operations:

Catalog any datafile copies that were created in Oracle7 unless they were made after the final consistent shutdown in Oracle7 and before running the migration utility, or were made of a tablespace that was offline normal or read-only at the time of the migration. In other words, no Oracle7 redo must need to be applied to the backups to roll them forward. 
Recatalog backup pieces or backup sets. If you run CHANGE ... UNCATALOG against an RMAN backup, then it is permanently unusable by RMAN. 
[b]Rename a backup piece or move a backup piece from one place to another.[/b]

So catalog cannot be used to do what I am trying to do.
For some reason, this seems much more difficult than it should be. Where am I going wrong?

 

[LKBrwnDBA]

Check chapter 10 of the Oracle9i Recovery Manager User's Guide Restoring Files to a New Location.

----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

 

[LKBrwnDBA]

PS: CATALOG/UNCATALOG/CHANGE commands are NOT USED to recover database to another location.


----------------------------------------------------------------------------
The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb