Search This Blog

Wednesday, 24 June 2020

RMAN LEVEL0 BACKUP FAILED ORA-19504 ,ORA-27040

Log File Error


channel ORA_DISK_5: backup set complete, elapsed time: 01:41:25
channel ORA_DISK_2: finished piece 1 at 24-JUN-20
piece handle=/u01/TEST/TEST_LVL0_20200624_o2v3j678_s54018_p11 tag=TAG20200624T111720 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 01:30:02
Finished backup at 24-JUN-20

Starting Control File and SPFILE Autobackup at 24-JUN-20
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of Control File and SPFILE Autobackup command on ORA_DISK_1 channel at 06/24/2020 22:58:13
ORA-19504: failed to create file "/u01/TEST/autobackup/c-3117373769-20200624-00"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 1

Recovery Manager complete.

Cause:


There was no directory /autobackup/ ,So control file backup got failed.

Resolution:

1) Create directory under /u01/TEST/autobackup/

2) RMAN TARGET /

RMAN>backup archivelog all;

Output of last lines:


piece handle=/TEST/TEST/00v3jfin_1_1 tag=TAG20200624T235145 comment=                                                                                        NONE
channel ORA_DISK_2: backup set complete, elapsed time: 00:00:05
channel ORA_DISK_4: finished piece 1 at 25-JUN-20
piece handle=/TEST/TEST/01v3jfip_1_1 tag=TAG20200624T235145 comment=                                                                                        NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:03
Finished backup at 25-JUN-20

Starting Control File and SPFILE Autobackup at 25-JUN-20
piece handle=/TEST/TEST/autobackup/c-3117373769-20200625-00 comment=                                                                                        NONE
Finished Control File and SPFILE Autobackup at 25-JUN-20


Query To Check Backup Status:


set linesize 500 pagesize 2000
col Hours format 9999.99
col STATUS format a10
select SESSION_KEY, INPUT_TYPE, STATUS,
to_char(START_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_Bkup_start_time,
to_char(END_TIME,'mm-dd-yyyy hh24:mi:ss') as RMAN_Bkup_end_time,
elapsed_seconds/3600 Hours from V$RMAN_BACKUP_JOB_DETAILS
order by session_key;

No comments:

Post a Comment