Re: Need help on RMAN Backup failure

  • From: Mladen Gogala <gogala.mladen@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sat, 28 Sep 2019 09:04:41 -0400

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@umajor:~$ touch /arch_THDMAS_1219123_1020144446_hjucsapu
touch: cannot touch '/arch_THDMAS_1219123_1020144446_hjucsapu': Permission denied
mgogala@umajor:~$

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

Regards




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

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 09-2019