Re: Comvault Oracle RMAN Shell Script

 Leng
It is running fine if I ran as cron or manually but when Comvault configure on their end to call this shell script using comvault client, it is failing. Below is output running manually and is not giving any error with Controlfile. It look like COmvault need to update the details in its catalog about backup and so giving issue as it is not connected with it and cannot rely on DB control file for the same or something linked. connected to target database: TESTRPDB(DBID=1029808982) RMAN> run {2> allocate channel ch1 type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/commvault/Base/libobk.so,BLKSIZE=1048576'; 3> sql "alter system archive log current";4> backup5> ( archivelog  all) ;6> backup  current controlfile  ;7> }8> exit;using target database control file instead of recovery catalogallocated channel: ch1channel ch1: SID=191 instance=TESTRPDB device type=SBT_TAPEchannel ch1: CommVault Systems for Oracle: Version 11.0.0(BUILD80) sql statement: alter system archive log current Starting backup at 19-DEC-19current log archivedchannel ch1: starting archived log backup setchannel ch1: specifying archived log(s) in backup set........channel ch1: starting piece 1 at 19-DEC-19channel ch1: finished piece 1 at 19-DEC-19piece handle=efujnpbm_1_1 tag=TAG20191219T105902 comment=API Version 2.0,MMS Version 11.0.0.80channel ch1: backup set complete, elapsed time: 00:00:35Finished backup at 19-DEC-19 Starting backup at 19-DEC-19channel ch1: starting full datafile backup setchannel ch1: specifying datafile(s) in backup setincluding current control file in backup setchannel ch1: starting piece 1 at 19-DEC-19channel ch1: finished piece 1 at 19-DEC-19piece handle=egujnpcq_1_1 tag=TAG20191219T105938 comment=API Version 2.0,MMS Version 11.0.0.80channel ch1: backup set complete, elapsed time: 00:00:01Finished backup at 19-DEC-19 Starting Control File and SPFILE Autobackup at 19-DEC-19piece handle=c-1030388028-20191219-06 comment=API Version 2.0,MMS Version 11.0.0.80Finished Control File and SPFILE Autobackup at 19-DEC-19released channel: ch1 Recovery Manager complete.

    On Friday, December 20, 2019, 01:36:50 AM EST, Leng <lkaing_at_gmail.com> wrote:  

 To eliminate the allocate channel, you can configure it at the Rman level.  However, the problem looks to be with your I/o request to the controlfile. Is there a problem with your controlfile or asm? Cheers,Leng

On 20 Dec 2019, at 12:50 pm, Sanjay Mishra (Redacted sender smishra_97 for DMARC) <dmarc-noreply_at_freelists.org> wrote:

I had the requirement to run some dynamically generated Archivelog backup script with Commvault tape Library and so need to call shell script on DB Server using Comvault Client. I had the required script which can generate the required RMAN command and can be executed but when the same is called with Comvault, it is giving error

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup command at 12/19/2019 11:41:22

ORA-00204: error in reading (block 1, # blocks 1) of control file

ORA-00202: control file: '+ARCH/TESTRPDB/control01.ctl'

ORA-15081: failed to submit an I/O operation to a disk

Issue look like is with Channel Allocation and Env/Params setting and Comvault Admin is working offshore and not able to share any details. Here is the final RMAN script called connect target /run {allocate channel ch1 type 'sbt_tape' PARMS 'SBT_LIBRARY=/opt/commvault/Base/libobk.so,BLKSIZE=1048576'; sql "alter system archive log current";backup( archivelog  all) ;backup  current controlfile  ;}

TIASanjay   

--
http://www.freelists.org/webpage/oracle-l