Re: Need help on RMAN Backup failure

From: <niall.litchfield_at_gmail.com>
Date: Sat, 28 Sep 2019 14:26:26 +0100
Message-ID: <CABe10sbs5mxf05=DxxbOr2PuVAOms=WTsQZnjhzPUShDQ1G-oA_at_mail.gmail.com>



What does the log from the last successful backup have as the backup piece location?

On Sat, Sep 28, 2019 at 2:17 PM ramukam <ramukam1983_at_gmail.com> wrote:

> Mladen, Thanks for your response. The backup has been running for last 8
> years with the same
> configuration for last 8 years and don't remember seeing this earlier. We
> are not storing the backup files on the same server as the database. The
> backup files are created on backup servers, which are maintained by our
> backup team. Do you think there could be an issue with the backup server?
>
> Ashoke
>
> On Sat, Sep 28, 2019 at 8:05 AM Mladen Gogala <gogala.mladen_at_gmail.com>
> wrote:
>
>> 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
>>
>>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Sat Sep 28 2019 - 15:26:26 CEST

Original text of this message