RMAN restore from a location different from original backup location
BaffySep 5 2011 — edited Sep 5 2011All,
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.