Home » RDBMS Server » Backup & Recovery » Restore RMAN backup of database to a new database (merged) (Oracle 10g Release 10.2.0.1.0)
Restore RMAN backup of database to a new database (merged) [message #490480] Tue, 25 January 2011 05:01 Go to next message
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

Re: Restore RMAN backup of database to a new database [message #490484 is a reply to message #490480] Tue, 25 January 2011 05:09 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
This is a scenario that is in the documentation.
I posted the link many times and not so far than yesterday.
Please search it.

Regards
Michel
Re: Restore RMAN backup of database to a new database [message #490506 is a reply to message #490484] Tue, 25 January 2011 05:53 Go to previous message
dkdms2124
Messages: 369
Registered: April 2010
Location: INDIA
Senior Member

I really respect your suggestion SIR but I need to make this thing happen very soon I have not given much time to do all this.

I'll really appreciate if you can tell the forum post in which you provided the solution or if you can provide the neccesary steps here that will be really helpful.


Thanks
Deepak
Previous Topic: Database not Open
Next Topic: BLOCK RECOVERY
Goto Forum:
  


Current Time: Thu Nov 21 21:58:10 CST 2024