본문 바로가기

Oracle/ORA-Error

ORA-19625, RMAN-06059

RMAN> backup as compressed backupset database spfile plus archivelog;


Starting backup at 25-APR-16
current log archived
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 04/25/2016 17:40:55
RMAN-06059: expected archived log not found, loss of archived log compromises recoverability
ORA-19625: error identifying file /app/oracle/archive/16909762353.arc
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3


Solution.


Step1.

RMAN> crosscheck archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=46 device type=DISK
validation failed for archived log
archived log file name=/app/oracle/archive/16909762353.arc RECID=1 STAMP=909765034
validation failed for archived log
archived log file name=/app/oracle/archive/17909762353.arc RECID=2 STAMP=909765040
validation failed for archived log
archived log file name=/app/oracle/archive/18909762353.arc RECID=3 STAMP=909765043
validation failed for archived log
archived log file name=/app/oracle/archive/1_909762353_9.arc RECID=4 STAMP=909765210
validation failed for archived log
archived log file name=/app/oracle/archive/1_909762353_10.arc RECID=5 STAMP=909765211
validation failed for archived log
archived log file name=/app/oracle/archive/1_909762353_11.arc RECID=6 STAMP=909765215
validation failed for archived log
archived log file name=/app/oracle/archive/1_909762353_12.arc RECID=7 STAMP=909765215
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_13.arc RECID=8 STAMP=909765244
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_14.arc RECID=9 STAMP=909765245
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_15.arc RECID=10 STAMP=909765248
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_16.arc RECID=11 STAMP=909765248
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_17.arc RECID=12 STAMP=909765248
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_18.arc RECID=13 STAMP=910086073
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_19.arc RECID=14 STAMP=910091092
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_20.arc RECID=15 STAMP=910107834
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_21.arc RECID=16 STAMP=910114134
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_22.arc RECID=17 STAMP=910114215
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_23.arc RECID=18 STAMP=910114588
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_24.arc RECID=19 STAMP=910114696
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_25.arc RECID=20 STAMP=910114698
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_26.arc RECID=21 STAMP=910114701
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_27.arc RECID=22 STAMP=910114701
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_28.arc RECID=23 STAMP=910114701
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_29.arc RECID=24 STAMP=910114706
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_30.arc RECID=25 STAMP=910114706
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_31.arc RECID=26 STAMP=910114706
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_32.arc RECID=27 STAMP=910114709
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_33.arc RECID=28 STAMP=910114709
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_34.arc RECID=29 STAMP=910114709
validation succeeded for archived log
archived log file name=/app/oracle/archive/1_909762353_35.arc RECID=30 STAMP=910114855
Crosschecked 30 objects


Step2.

RMAN> delete expired archivelog all;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=46 device type=DISK
List of Archived Log Copies for database with db_unique_name ORCL
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - ---------
1       1    6       X 21-APR-16
        Name: /app/oracle/archive/16909762353.arc

2       1    7       X 21-APR-16
        Name: /app/oracle/archive/17909762353.arc

3       1    8       X 21-APR-16
        Name: /app/oracle/archive/18909762353.arc

4       1    9       X 21-APR-16
        Name: /app/oracle/archive/1_909762353_9.arc

5       1    10      X 21-APR-16
        Name: /app/oracle/archive/1_909762353_10.arc

6       1    11      X 21-APR-16
        Name: /app/oracle/archive/1_909762353_11.arc

7       1    12      X 21-APR-16
        Name: /app/oracle/archive/1_909762353_12.arc


Do you really want to delete the above objects (enter YES or NO)? yes
deleted archived log
archived log file name=/app/oracle/archive/16909762353.arc RECID=1 STAMP=909765034
deleted archived log
archived log file name=/app/oracle/archive/17909762353.arc RECID=2 STAMP=909765040
deleted archived log
archived log file name=/app/oracle/archive/18909762353.arc RECID=3 STAMP=909765043
deleted archived log
archived log file name=/app/oracle/archive/1_909762353_9.arc RECID=4 STAMP=909765210
deleted archived log
archived log file name=/app/oracle/archive/1_909762353_10.arc RECID=5 STAMP=909765211
deleted archived log
archived log file name=/app/oracle/archive/1_909762353_11.arc RECID=6 STAMP=909765215
deleted archived log
archived log file name=/app/oracle/archive/1_909762353_12.arc RECID=7 STAMP=909765215
Deleted 7 EXPIRED objects