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
'Oracle > ORA-Error' 카테고리의 다른 글
ORA-39213:Metadata processing is not available (0) | 2016.04.25 |
---|---|
Export failed when trying using SYS user. * (ORA-28009: connection as SYS should be as SYSDBA or SYSOPER) (0) | 2016.04.25 |
INS-06006 INS-06003 (0) | 2016.04.19 |
CRS-4124: Oracle High Availability Services startup failed (0) | 2016.04.15 |
ORA-24324,ORA-01041 (0) | 2015.09.14 |