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!

How to restore rman backup from tape to other remote server

683218Apr 25 2010 — edited May 9 2010
Hi,

I want to make database clone using rman backup on other server so because of this i need to restore rman backup from tape to target host How can i do it?

Find below rman script that is using for rman backup.

There are two files:

1:.
rman target=$DB_USERID/$DB_PASSWD@EBS catalog=rman/rman@rman cmdfile $SCRIPTS_HOME/Online_EBS.txt log $LOG_FILE

2:
run
{
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';

allocate channel t1 type 'sbt_tape' parms
'ENV=(TDPO_OPTFILE=/usr/tivoli/tsm/client/oracle/bin64/tdpo.opt)';

backup
incremental level 0
tag daily_level_0_backup
filesperset 5
format 'df_%d_%U_%t'
(database);
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
backup
filesperset 20
format 'al_%d_%U_%t'
(archivelog all
delete input);

backup
format 'cf_%d_%U_%t'
current controlfile
tag='post_dailylevel0_backup_cfile';

release channel t1;

}

Thanks
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 6 2010
Added on Apr 25 2010
5 comments
3,575 views