Restore RMAN backup of database to a new database (merged) [message #490480] |
Tue, 25 January 2011 05:01 |
|
dkdms2124
Messages: 369 Registered: April 2010 Location: INDIA
|
Senior Member |
|
|
Hi All,
I have oracle 10g installed on my system and name of the database is "ORCL" for which I have schedule the incremental backup everyday. Mentioned below are the steps followed
*************PARAMETERS TO BE CHANGED******************
configure channel 1 device type disk
format '\\192.16.17.140\dbbackups\192.16.17.152\oracle_rman_backup_incremental\std_%U';
configure channel 2 device type disk
format '\\192.16.17.140\dbbackups\192.16.17.152\oracle_rman_backup_incremental\std_%U';
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK
TO '\\192.16.17.140\dbbackups\192.16.17.152\oracle_rman_backup_incremental\cntrl_%U';
CONFIGURE RETENTION POLICY TO REDUNDANCY 7;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
*******************************************************
*******COMMAND FOR THE CONNECTING TO RMAN**************
rman LOG = \\192.16.17.140\dbbackups\192.16.17.152\oracle_rman_backup_incremental\
rmanlog_%date:~4,2%-%date:~7,2%-%date:~10%.txt APPEND
CONNECT TARGET SYS/ORACLE@ORCL
*******************************************************
********INCREMENTAL BACKUP COMMAND*********************
RUN
{
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_backup' DATABASE;
BACKUP ARCHIVELOG ALL DELETE INPUT;
}
********************************************************************
Now I want to restore this backup to some other system with new database. Please tell me how to do this recovery to some other database on new system.
Thanks in advance.
Regards
Deepak.
[Updated on: Tue, 25 January 2011 06:08] by Moderator Report message to a moderator
|
|
|
|
|