Shulou(Shulou.com)06/01 Report--

"manually delete a backup or archive on the operating system, and rman is not immediately aware of this change, so crosscheck is required to update the status of the backup."

Manual rm archive log

Check and file

RMAN > crosscheck archivelog all

Released channel: ORA_DISK_1

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=18 device type=DISK

Validation failed for archived log

Archived log file name=/home/oracle/1_62_947085344.dbf RECID=5 STAMP=950278766

Validation failed for archived log

Archived log file name=/home/oracle/1_63_947085344.dbf RECID=6 STAMP=950279852

Validation failed for archived log

Archived log file name=/home/oracle/1_64_947085344.dbf RECID=7 STAMP=950455276

Validation failed for archived log

...

Archived log file name=/home/oracle/1_1_950712737.dbf RECID=72 STAMP=950712738

Validation succeeded for archived log

Archived log file name=/home/oracle/1_2_950712737.dbf RECID=73 STAMP=950713931

Crosschecked 60 objects

Delete effectiveness Archive

RMAN > delete expired archivelog all

Released channel: ORA_DISK_1

Allocated channel: ORA_DISK_1

Channel ORA_DISK_1: SID=18 device type=DISK

List of Archived Log Copies for database with db_unique_name TEST

=

Key Thrd Seq S Low Time

-

5 1 62 X 2017-07-23 22:09:22

Name: / home/oracle/1_62_947085344.dbf

6 1 63 X 2017-07-25 14:19:26

Name: / home/oracle/1_63_947085344.dbf

7 1 64 X 2017-07-25 14:37:32

Name: / home/oracle/1_64_947085344.dbf

. . .

71 1 119 X 2017-07-30 14:24:59

Name: / home/oracle/1_119_947085344.dbf

72 1 1 X 2017-07-30 14:52:17

Name: / home/oracle/1_1_950712737.dbf

73 1 2 X 2017-07-30 14:52:18

Name: / home/oracle/1_2_950712737.dbf

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

Deleted archived log

Archived log file name=/home/oracle/1_62_947085344.dbf RECID=5 STAMP=950278766

Deleted archived log

Archived log file name=/home/oracle/1_63_947085344.dbf RECID=6 STAMP=950279852

Deleted archived log

...

STAMP=950711099

Deleted archived log

Archived log file name=/home/oracle/1_119_947085344.dbf RECID=71 STAMP=950712737

Deleted archived log

Archived log file name=/home/oracle/1_1_950712737.dbf RECID=72 STAMP=950712738

Deleted archived log

Archived log file name=/home/oracle/1_2_950712737.dbf RECID=73 STAMP=950713931

Deleted 60 EXPIRED objects

RMAN > list archivelog all

Specification does not match any archived log in the repository

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.