Thursday 6 January 2022

RMAN Backup fails with archivelog not found error ORA-19625: error identifying file

 RMAN  Backup fails with archivelog not found error ORA-19625: error identifying file


Connect to RMAN promp

$ rman target / 

$ crosscheck archivelog all;

$ delete obsolete

Got following error : 

RMAN-03002: failure of delete command at 01/06/2022 18:09:45

RMAN-06091: no channel allocated for maintenance (of an appropriate type)


Solution:

Allocate channel for maintenance type for each device type

$ rman target /

RMAN>  allocate channel for maintenance device  TYPE 'SBT_TAPE' PARMS 'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';

using target database control file instead of recovery catalog
allocated channel: ORA_MAINT_SBT_TAPE_1
channel ORA_MAINT_SBT_TAPE_1: SID=756 instance=prd1 device type=SBT_TAPE
channel ORA_MAINT_SBT_TAPE_1: Veritas NetBackup for Oracle - Release 8.3.0.1 (2020081919)

RMAN> allocate channel for maintenance device type disk;

allocated channel: ORA_MAINT_DISK_2
channel ORA_MAINT_DISK_2: SID=883 instance=prd1 device type=DISK

RMAN> delete obsolete;



XX_XXXXXXX is not a valid responsibility for the current user. Please contact your System Administrator.

  XX_XXXXXXX is not a valid responsibility for the current user. Please contact your System Administrator. Issue : When user logs into EBS, ...