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