Sample Scripts for Oracle Third-Party Command Line Operations

You can use these scripts as examples for backup and restore operations when Oracle disk caching of log files is enabled.

Backup Scripts

Backup of Only the Archive Log

run
{
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=262144,ENV=(CvInstanceName=Instance001)";
allocate channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=262144,
ENV=(CvInstanceName=Instance001)";
backup archivelog all delete input;
}

Backup of the Data and Logs

run
{
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvInstanceName=Instance001)";
allocate channel ch2 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvInstanceName=Instance001)";
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
backup incremental level = 0
filesperset =8
format='%s_%t_%d_%U'
database
include current controlfile;
}
#******LOGS BACKUP SCRIPT******#
run
{
allocate channel ch1 type 'sbt_tape
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvInstanceName=Instance001)";
allocate channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvInstanceName=Instance001)";
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
format='%s_%t_%d_%U'
(archivelog all delete input);
}

Restore Scripts

Restore and Recover the Database

run
{
allocate channel ch1 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=262144, ENV=(CvInstanceName=Instance001)";
allocate channel ch2 type 'sbt_tape' PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=262144, ENV=(CvInstanceName=Instance001)";
restore database;
recover database;
}

Cross Machine Restore

CvSrcClientName – Source client name
CvSrcOraSID – Source SID

The following script must be run from the destination client, connecting to RMAN on the destination database. The destination database must be in NOMOUNT mode.

run
{
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvSrcClientName=boson, CvSrcOraSID=db12,CvInstanceName=Instance001)";
allocate channel ch2 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvSrcClientName=boson,CvSrcOraSID=db12,CvInstanceName=Instance001)";
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
restore controlfile from 'c-1912158803-20210310-45';
sql 'alter database mount';
}
run
{
set newname for database to '/data/oradata/db12/%U';
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvSrcClientName=boson,CvSrcOraSID=db12,CvInstanceName=Instance001)";
allocate channel ch2 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvSrcClientName=boson,CvSrcOraSID=db12,CvInstanceName=Instance001)";
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
restore database  until time = "TO_DATE('03/10/2021 11:30:11','MM/DD/YYYY HH24:MI:SS')" ;
switch datafile all;
}
run
{
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvSrcClientName=boson,CvSrcOraSID=db12,CvInstanceName=Instance001)";
allocate channel ch2 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvSrcClientName=boson,CvSrcOraSID=db12,CvInstanceName=Instance001)";
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
recover database until time = "TO_DATE('03/10/2021 11:30:11','MM/DD/YYYY HH24:MI:SS')"
delete archivelog;
alter database open resetlogs;
}

Restore a Database When Using Disk Caching for Frequent Log Backups

If you are using disk caching for frequent log backups, use a script similar to the following to restore a database.

Use the following parameters:

CvSrcClientName - source client name:
- Stand-alone Oracle - use the physical client name
- Oracle RAC - use the pseudoclient name
CvSrcOraSID – source instance name. Use the instance name configured in the Commvault software.

run
{
allocate channel ch1 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvSrcClientName=boson,CvSrcOraSID=db12,CvInstanceName=Instance001)";
allocate channel ch2 type 'sbt_tape'
PARMS="SBT_LIBRARY=/opt/commvault/Base/libobk.so, BLKSIZE=1048576, ENV=(CvSrcClientName=boson,CvSrcOraSID=db12,CvInstanceName=Instance001)";
setlimit channel ch1 maxopenfiles 8;
setlimit channel ch2 maxopenfiles 8;
restore archivelog all;
}