Shulou(Shulou.com)05/31 Report--

This article mainly shows you "what is the impact of manual rm deletion of archived logs in the database on backup and archived logs", which is easy to understand and well-organized, hoping to help you solve your doubts, the following let the editor lead you to study and learn "what is the impact of manual rm deletion of archived logs in the database on backup and archived logs".

After the archive log is deleted by manual rm, the deleted archive log will not be found in error when backing up the archive log. After crosscheck archivelog all and delete expired archivelog all, the backup archive log will no longer report an error.

After deleting the archive log using the delete command of rman, the backup archive log will not report an error

[oracle@oatest 2018 / 07 / 26] $ll

The total dosage is 12720

-rw-r-. 1 oracle dba 12994048 July 26 11:27 o1_mf_1_494_folhwg5h_.arc

-rw-r-. 1 oracle dba 1536 July 26 11:27 o1_mf_1_495_folhwhdx_.arc

-rw-r-. 1 oracle dba 2560 July 26 11:27 o1_mf_1_496_folhwkfj_.arc

-rw-r-. 1 oracle dba 1024 July 26 11:27 o1_mf_1_497_folhwlbh_.arc

-rw-r-. 1 oracle dba 1024 July 26 11:27 o1_mf_1_498_folhwq9c_.arc

-rw-r-. 1 oracle dba 1024 July 26 11:27 o1_mf_1_499_folhwr3b_.arc

-rw-r-. 1 oracle dba 1024 July 26 11:27 o1_mf_1_500_folhwx96_.arc

-rw-r-. 1 oracle dba 1024 July 26 11:27 o1_mf_1_501_folhwy86_.arc

[oracle@oatest 2018 / 07 / 26] $rm-f o1_mf_1_496_folhwkfj_.arc o1_mf_1_497_folhwlbh_.arc o1_mf_1_498_folhwq9c_.arc

RMAN > backup archivelog all format'/ home/oracle/archivelog%U' delete input

Starting backup at 26-JUL-18

Current log archived

Using target database control file instead of recovery catalog

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=224 device type=DISK

RMAN-00571: =

RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =

RMAN-00571: =

RMAN-03002: failure of backup command at 07/26/2018 11:31:23

RMAN-06059: expected archived log not found, loss of archived log compromises recoverability

ORA-19625: error identifying file / u01/app/oracle/fast_recovery_area/PROD7/archivelog/2018_07_26/o1_mf_1_496_folhwkfj_.arc

ORA-27037: unable to obtain file status

Linux-x86_64 Error: 2: No such file or directory

Additional information: 3

RMAN > crosscheck archivelog all

RMAN > delete expired archivelog all

...

Do you really want to delete the above objects (enter YES or NO)? Yes

Deleted archived log

Archived log file name=/u01/app/oracle/fast_recovery_area/PROD7/archivelog/2018_07_26/o1_mf_1_496_folhwkfj_.arc RECID=3 STAMP=982495633

Deleted archived log

Archived log file name=/u01/app/oracle/fast_recovery_area/PROD7/archivelog/2018_07_26/o1_mf_1_497_folhwlbh_.arc RECID=4 STAMP=982495634

Deleted archived log

Archived log file name=/u01/app/oracle/fast_recovery_area/PROD7/archivelog/2018_07_26/o1_mf_1_498_folhwq9c_.arc RECID=5 STAMP=982495639

Deleted 3 EXPIRED objects

RMAN > delete archivelog sequence 500

RMAN > backup archivelog all format'/ home/oracle/archivelog%U' delete input

Starting backup at 26-JUL-18

Current log archived

Using channel ORA_DISK_1

Channel ORA_DISK_1: starting archived log backup set

Channel ORA_DISK_1: specifying archived log (s) in backup set

Input archived log thread=1 sequence=494 RECID=1 STAMP=982495630

Input archived log thread=1 sequence=495 RECID=2 STAMP=982495631

Input archived log thread=1 sequence=499 RECID=6 STAMP=982495640

Input archived log thread=1 sequence=501 RECID=8 STAMP=982495646

Input archived log thread=1 sequence=502 RECID=9 STAMP=982495881

Input archived log thread=1 sequence=503 RECID=10 STAMP=982495953

Input archived log thread=1 sequence=504 RECID=11 STAMP=982513112

The archive logs of 496,497,498,500 sequence are not backed up.

The above is all the contents of the article "what is the impact of manual rm deletion of archive logs in the database on backup archive logs". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.