Skip to content

Source Requirements

Database instance
  1. Note down DBID of source database

select dbid from v$database
2. Note down db_name of source database

show parameter db_name
3. Backup Info

  • 3a. Note down name of controlfile backuppiece name [ if using disk backups ]
  • 3b. Note down tape backup parameters used to backup database [ if using Tape backups ]
  • 3c. Note down tape backup parameters used to backup database [ if using ZDLRA ] 
e.g. ALLOCATE CHANNEL C1 DEVICE TYPE 'SBT_TAPE' FORMAT '%d_%U' PARMS
"SBT_LIBRARY=/u01/app/oracle/product/12.1.0.2/dbhome_1/lib/libra.so,
ENV=(RA_WALLET='location=file:/u01/app/oracle/wallet credential_alias=ZFREP00_CATALOG')";
  • 3d. Note down tape backup parameters used to backup database [ if using DDBOOST ]
e.g. ALLOCATE CHANNEL C1 DEVICE TYPE 'SBT_TAPE' FORMAT '%d_%U' PARMS
"SBT_LIBRARY=/u01/app/oracle/product/18.0.0.0/dbhome_1/lib/libddobk.so,
ENV=(STORAGE_UNIT=StorageUnit1,BACKUP_HOST=10.0.0.10,
ORACLE_HOME=/u01/app/oracle/product/18.0.0.0/dbhome_1)";