Skip to main content
Question

Oracle RAC backups to tape from rman command line

  • 2 July 2024
  • 1 reply
  • 36 views

Hi

Normally we use the Commvault Comcell to initiate and schedule our backups.  We are trying to run this from the rman command line on the server but when using the script below, it writes the backups to local disk not tape.  

 

The reason we want to run from the command line is to enable detailed tracing as Oracle Support have requested this for a backup issue we currently have.

run {
allocate channel ch1 type 'sbt_tape' connect sys/passt@CNTEST PARMS="SBT_LIBRARY=/home/commvault/Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName=Instance001)";
allocate channel ch2 type 'sbt_tape' connect sys/pass##T3st@CNTEST PARMS="SBT_LIBRARY=/home/commvault/Base/libobk.so,BLKSIZE=1048576,ENV=(CvClientName=Instance001)";
--send "--cv-host <Backup host hostname> --cv-clientname <Pseudo client name>";
send "BACKUP -jm 32813 -a 2:7814 -cl 3017 -ins 840 -at 80 -j 6054893 -jt 6054893:4:1:0:0:15469 -bal 0 -t 1 -ms 1 -data -useCvNwSrv -mhn server1-bup.iperm.ie*server1*8400*8402";
setlimit channel ch1 maxopenfiles 4;
setlimit channel ch2 maxopenfiles 4;
backup incremental level = 0
filesperset = 4
format='6054893_%d_%U'
database include current controlfile spfile;
}

 

I found this parameter but we only want to enable tracing for the LEVEL 0 full backup.  At what level do we have to set nORATRACELEVEL

https://documentation.commvault.com/additionalsetting/details?name=%22nORATRACELEVEL%22&id=529

 

Would appreciate any help or advice 

 

Thanks

Gavin

1 reply

Userlevel 6
Badge +15

Hello @GavinH 

 

Thanks for the question and all the details. If there are no outlined settings in the script we should just honor the storage policy that is associated to the subclient.  

 

If you do want to set a specific storage target this should help you build the script to achieve that: 

https://documentation.commvault.com/2023e/expert/oracle_agent_media_parameters.html

 

Kind regards

Albert Williams

Reply