Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

RMAN restore from a location different from original backup location

BaffySep 5 2011 — edited Sep 5 2011
All,

Apologies to bother you all on this simple matter but it's something I've never done before:

Background
=======

My sys admin is currently copying a full database backup from the RMAN default backup location to another disk location (say /u01/oracle/backup).
The backup was made using RMAN and I believe RMAN only knows of it's original backup location. Please see RMAN permanent setting below:

CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/banksys_arch0/backup/ora_cf%F';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO '%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DEVICE TYPE 'SBT_TAPE' PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE 'SBT_TAPE' TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK RATE 10 M FORMAT '/arch/oradata/BANKSYS/backup/%Y-%M-%D-ora_df_s%s_s%p';

Question
======
I need to restore and recover the database from this new backup location. Is it as simple as doing the following:

1. Change RMAN default location to the new location:

CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'u01/oracle/backup/ora_df%t_s%s_s%p'; (note I've changed this to the new location)

2. Restore and recover (I have a good understanding/experience of the part).

Thanks in advance.
This post has been answered by Balazs Papp on Sep 5 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 3 2011
Added on Sep 5 2011
8 comments
38,139 views