Re: Need help on RMAN Backup failure

On 9/28/19 8:50 AM, ramukam wrote:

> Greetings All,
> The RMAN backup is failing with the following error messages. Not sure
> if this is an issue with the backup media or it is a database issue.
> Any help would be appreciated.
> Oracle DB version: 11.2.0.3
> OS version: Solaris 10
> Back Media: NetBackup
> Netbacklup version: NetBackup-Solaris10 7.7
>
> *Errors experiencing during backup:*
> channel ORA_SBT_TAPE_3: starting archive log backupset
> "arch_backup_thdmas_tape.log" 559044 lines, 25045576 characters
> RMAN-03009: failure of backup command on ORA_DISK_2 channel at
> 09/28/2019 05:27:26
> ORA-19504: failed to create file
> "/arch_THDMAS_1219123_1020144446_hjucsapu"
> ORA-27041: unable to open file
> SVR4 Error: 2: No such file or directory
> Additional information: 9
> channel ORA_DISK_2 disabled, job failed on it will be run on another
> channel
> RMAN-03009: failure of backup command on ORA_DISK_3 channel at
> 09/28/2019 05:27:26
> ORA-19504: failed to create file
> "/arch_THDMAS_1219124_1020144446_hkucsapu"
> ORA-27041: unable to open file
> SVR4 Error: 2: No such file or directory
> Additional information: 9
> channel ORA_DISK_3 disabled, job failed on it will be run on another
> channel
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03009: failure of backup command on ORA_DISK_4 channel at
> 09/28/2019 05:27:26
> ORA-19504: failed to create file
> "/arch_THDMAS_1219125_1020144446_hlucsapu"
> ORA-27041: unable to open file
> SVR4 Error: 2: No such file or directory
> Additional information: 9
>
> Thanks,
> Ashoke Mandal

Hi Ashoke,

The path is /arch_THDMAS_1219123_1020144446_hjucsapu which is directly under the machine root, "/", typically not available to users for writing.  The root cause is probably something like this:

mgogala_at_umajor:~$ touch /arch_THDMAS_1219123_1020144446_hjucsapu touch: cannot touch '/arch_THDMAS_1219123_1020144446_hjucsapu': Permission denied
mgogala_at_umajor:~$

This is of course my machine. In other words, your format string needs revisiting.

Regards

-- 
Mladen Gogala
Database Consultant
Tel: (347) 321-1217


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