RMAN restore backupset from SBT Tape
Oracle: 10.2.0.4
I need to RMAN clone a production db (lpar A) to another server (lpar b). The production db is 1.7 TB and we dont have disk space to copy a full rman backup to disk. So we backup the production db on lpar A to a SBT tape device with the following run block:
run
{
sql 'ALTER SESSION SET NLS_DATE_FORMAT="DD-MON-YY HH24:MI"';
allocate channel ch01 type sbt format='%d_data_set%s_piece%p_%T_%U' PARMS 'ENV=(TDPO_OPTFILE=/$LPAR/$OPTFILE)';
allocate channel ch02 type sbt format='%d_data_set%s_piece%p_%T_%U' PARMS 'ENV=(TDPO_OPTFILE=/$LPAR/$OPTFILE)';
configure retention policy to recovery window of 23 days;
configure archivelog deletion policy to none;
crosscheck archivelog all;
backup database plus archivelog delete input;
delete force noprompt obsolete;
release channel ch01;
release channel ch02;
}
After the backup completes I invoke the catalog and see these two backupset pieces that contain the full backup:
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
112673 Full 714.48G SBT_TAPE 09:01:16 08-MAY-11
BP Key: 112680 Status: AVAILABLE Compressed: NO Tag: TAG20110507T221229
Handle: PRD002L_data_set655_piece1_20110507_kfmbovae_1_1 Media:
------- ---- -- ---------- ----------- ------------ ---------------
112674 Full 720.16G SBT_TAPE 09:20:45 08-MAY-11
BP Key: 112681 Status: AVAILABLE Compressed: NO Tag: TAG20110507T221229
Handle: PRD002L_data_set656_piece1_20110507_kgmbovae_1_1 Media:
PROBLEM: How can i use rman on a different server (lpar b) connecting to the catalog that the full backup was taken from lpar A and copy the backupset's to lpar b.
Any help would be appreciated !!