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@xxxxxxxxx>
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@xxxxxxxxxxxxx> 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