Copy  RMAN backup files including archive log backup files to the target server

Copy the SNAPSHOT CONTROL FILE or backed up control file from source server to target server.

If you do not remember the snapshot control file location, connect to source rman and query “snapshot controlfile name” and it will give as below: 

Source Server: 

RMAN> connect target /;
connected to target database: HRDMO (DBID=209403493034)

RMAN> show SNAPSHOT CONTROLFILE NAME;
using target database control file instead of recovery catalog
RMAN configuration parameters are:
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/10g/dbs/snapcf_HRDMO.f'; # default

Copy the snapshot controlfile to your target server or the backup of control file.

NOTE: You need to have same directories created for the restoration of files and the RMAN backup files, including archive log backup and they should be in the same structure as it is in source server. If you don’t have exactly same file system just create soft links to cheat. 

Target Server:

Export ORACLE_SID=HRDMO
RMAN

RMAN>startup nomount;
RMAN> set DBID=209403493034;
executing command: SET DBID
RMAN> restore controlfile from '/opt/oracle/standby/dbs/snapcf_crmprod.f'; # The location where you have it in target srvr.

Starting restore at 06-FEB-08 using channel ORA_DISK_1
channel ORA_DISK_1: copied controlfile copy
replicating controlfile
input filename=/db1/oradata/HRDMO/control01.ctl
output filename=/db2/oradata/HRDMO/control02.ctl
output filename=/db3/oradata/HRDMO/control03.ctl

Finished restore at 06-FEB-08

RMAN>alter database mount;
RMAN> run
2> {
3> sql 'alter session set NLS_DATE_FORMAT="YYYY-MM-DD HH24:MI:SS"';
4> set until time '2008-01-31 01:00:00';
5> restore database;
6> recover database;
7> } 

RMAN>alter database open resetlogs; 

You have the copy of instance in the target server. 

Try it out and if you have any issues, comment here we can fix it.

Comments (12)

	11. 06-19-2010 09:52
	i am following your above steps to redirect restore the oracle DB  i am getting with the ora-01103 database name aba in control file is not abb  can you help me..? Guest

srinivas

	12. 06-23-2010 05:07
	You should make sure that the control file that you are using is from the backup of same DB.    If you are trying to clone the DB ABB to ABA, then it will not work. First restore with the same name and change the SID.     You can not clone in the same server/box. You need to restore it in different box and rename the DB. Registered

RD

Write Comment

Thankyou for your comments. Feel free to comment if there are any mistake in the postings also. If you have a Blog or website, feel free to provide the link. We will take a peak. Just ensure to *Refresh* your browser for a new security code to be displayed prior to clicking on the 'Send' button. Keep in mind that the above process only applies if you simply entered the wrong security code.
Name:
Homepage
BBCode:
Comment:
Code:*
	I wish to be contacted by email regarding additional comments

Copy Right: AKOComments v.1.4.6