Re: Need help on RMAN Backup failure

From: ramukam <ramukam1983_at_gmail.com>
Date: Fri, 11 Oct 2019 08:03:55 -0500
Message-ID: <CAF3+JmKfRbQCPdy6gcSV=1NnYkxJCXMVZZuXQbrWXCQd_yFMjg_at_mail.gmail.com>



Thank you all for your tips.
Finally I was able to track down that one of our DBAs needed to change it from 'SBT_TAPE' to 'DISK' for data migration effort and he forgot to notify me.

After I changed it back to 'SBT_TAPE' the backup is working again.

Ashoke

On Tue, Oct 1, 2019 at 5:12 PM Leng <lkaing_at_gmail.com> wrote:

> The problem is with the disk channel - see the below - ora_disk_3 is
> trying to write to the root file system:
>
> 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"
>
>
> Your previous log shows all backups are going to SBT, not disk. So either
> your default Rman device type has changed from sbt to disk, or you are
> running a script that is using disk channels.
>
> Cheers,
> Leng
>
> On 29 Sep 2019, at 2:34 am, Mladen Gogala <gogala.mladen_at_gmail.com> wrote:
>
> Fair point. Yes, the MML logs should be checked out.
> On 9/28/19 11:07 AM, Harel Safra wrote:
>
> The backup is done to ORA_SBT_TAPE_3. I think the /arch at the beginning
> is the format of the media manager save set name, not the root file system
> on the server.
>
> You might want to check the MML logs for further details.
>
> Harel Safra
> --
>
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Oct 11 2019 - 15:03:55 CEST

Original text of this message