Requirements for OBI source databases

The section covers the OBI source database 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 ].

     Example:

     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 ].

     Example:

     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)";