After the archived logs are manually deleted, the Rman backup detects that the logs are missing and cannot be further executed.
Therefore, you need to manually execute the crosscheck process, and then the Rman backup can be restored to normal.
1. Crosscheck log
$ Rman target/
Recovery Manager: Release 9.2.0.4.0-64bit Production
Copyright (c) 1995,200 2, Oracle Corporation. All rights reserved.
Connected to target database: AVATAR2 (DBID = 2480694409)
RMAN> crosscheck archivelog all;
Using target database controlfile instead of recovery catalog
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid = 25 devtype = DISK
Validation failed for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/4152714.dbf recid = 2702 stamp = 545107659
Validation failed for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/4152715.dbf recid = 2703 stamp = 545108268
...........
Validation failed for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/logs 2985.dbf recid = 2973 stamp = 545399327
Validation succeeded for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/logs 2986.dbf recid = 2974 stamp = 545400820
Validation succeeded for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/logs 2987.dbf recid = 2975 stamp = 545401757
Validation succeeded for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/logs 2988.dbf recid = 2976 stamp = 545402716
Validation succeeded for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/logs 2989.dbf recid = 2977 stamp = 545403661
Validation succeeded for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/4152990.dbf recid = 2978 stamp = 545404946
Validation succeeded for archived log
Archive log filename =/opt/oracle/oradata/avatar2/archive/logs 2991.dbf recid = 2979 stamp = 545406220
Crosschecked 278 objects
RMAN> |
2. Run the delete expired archivelog all command to delete all expired archived logs:
RMAN> delete expired archivelog all;
Released channel: ORA_DISK_1
Allocated channel: ORA_DISK_1
Channel ORA_DISK_1: sid = 12 devtype = DISK
List of Archived Log Copies
Key Thrd Seq S Low Time Name
--------------------------------
376 1 2714X23-NOV-04 =/opt/oracle/oradata/avatar2/archive/4152714.dbf
..... |
