How to handle RMAN-06059 errors when RMAN backs up archived logs

Source: Internet
Author: User

RMAN> Backup format 'd: \ backup \ % d _ % S. Bak 'tablespace users plus archivelog;

Start backup from March 10 to April 10
The current log is archived.
Use channel ora_disk_1
The archived log c: \ demo \ archive \ logs 667054810.log is not found or the directory exceeds the synchronization limit.
Attempting to use the replacement file for archiving log thread 1, sequence 1
RMAN-00571: ========================================================== ==============================
RMAN-00569: ==================== error message stack follows ==========================
RMAN-00571: ========================================================== ==============================
RMAN-03002: backup plus archivelog command (on 13:06:33) failed
RMAN-06059: failed to find the expected archive log, loss of archive log will affect recoverability
An error occurred while identifying the file D: \ demo \ archive \ Login Failed 667054810.log
ORA-27041: Unable to open file
0sd-04002: Unable to open the file
0/S-error: (OS 2) the system cannot find the specified file.

 

Some archived logs are deleted, so an error is reported when you execute the preceding statement. solution:

RMAN> change archivelog all crosscheck;

Released channel: ora_disk_1
Allocated channel: ora_disk_1
Channel ora_disk_1: SID = 146 devtype = Disk
The archived log is verified successfully.
Archive log file name = c: \ demo \ archive \ 1_1_667054810.log Record ID = 320 timestamp = 667054873
The archived log is verified successfully.
Archive log file name = D: \ demo \ archive \ 1_1_667054810.log Record ID = 321 timestamp = 667054873
The archived log is verified successfully.
Archive log file name = c: \ demo \ archive \ 2_1_667054810.log Record ID = 322 timestamp = 667054874
The archived log is verified successfully.
Archive log file name = D: \ demo \ archive \ 2_1_667054810.log Record ID = 323 timestamp = 667054874
The archived log is verified successfully.
Archive log file name = c: \ demo \ archive \ 3_417667054810.log Record ID = 324 timestamp = 667054879
The archived log is verified successfully.
Archive log file name = D: \ demo \ archive \ 3_1_667054810.log Record ID = 325 timestamp = 667054879
The archived log is verified successfully.
Archive log file name = c: \ demo \ archive \ 4_1_667054810.log Record ID = 326 timestamp = 667054879
The archived log is verified successfully.
Archive log file name = D: \ demo \ archive \ 4_1_667054810.log Record ID = 327 timestamp = 667054879
The archived log is verified successfully.
Archive log file name = c: \ demo \ archive \ 5_1_667054810.log Record ID = 328 timestamp = 667054888
The archived log is verified successfully.
Archive log file name = D: \ demo \ archive \ 5_1_667054810.log Record ID = 329 timestamp = 667054888
The archived log is verified successfully.
Archive log file name = c: \ demo \ archive \ 6_417667054810.log Record ID = 330 timestamp = 667054939
The archived log is verified successfully.
Archive log file name = D: \ demo \ archive \ 6_1_667054810.log Record ID = 331 timestamp = 667054939
The archived log is verified successfully.
Archive log file name = c: \ demo \ archive \ 7_1_667054810.log Record ID = 332 timestamp = 667054983
The archived log is verified successfully.
Archive log file name = D: \ demo \ archive \ 7_1_667054810.log Record ID = 333 timestamp = 667054983
An error occurred while verifying the archived logs.
Archive log file name = c: \ demo \ archive \ 8_1_667054810.log Record ID = 334 timestamp = 667055192
An error occurred while verifying the archived logs.
Archive log file name = D: \ demo \ archive \ 8_1_667054810.log Record ID = 335 timestamp = 667055192
An error occurred while verifying the archived logs.
Archive log file name = c: \ demo \ archive \ 9_2017667054810.log Record ID = 336 timestamp = 667055247
An error occurred while verifying the archived logs.
Archive log file name = D: \ demo \ archive \ 9_2017667054810.log Record ID = 337 timestamp = 667055247
An error occurred while verifying the archived logs.
Archive log file name = c: \ demo \ archive \ 10_1_667054810.log Record ID = 338 timestamp = 667055251

An error occurred while verifying the archived logs.
Archive log file name = D: \ demo \ archive \ 10_1_667054810.log Record ID = 339 timestamp = 667055251

An error occurred while verifying the archived logs.
Archive log file name = c: \ demo \ archive \ 11_2017667054810.log Record ID = 340 timestamp = 667055251

An error occurred while verifying the archived logs.
Archive log file name = D: \ demo \ archive \ 11_1_667054810.log Record ID = 341 timestamp = 667055251

An error occurred while verifying the archived logs.
Archive log file name = c: \ demo \ archive \ 12_1_667054810.log Record ID = 342 timestamp = 667055256

An error occurred while verifying the archived logs.
Archive log file name = D: \ demo \ archive \ 12_1_667054810.log Record ID = 343 timestamp = 667055256

24 objects that have been cross-checked

 

Back up again.

 

RMAN> Backup format 'd: \ backup \ % d _ % S. Bak 'tablespace users plus archivelog;

Start backup from March 10 to April 10
The current log is archived.
Use channel ora_disk_1
Channel ora_disk_1: archiving log backup set is being started
Channel ora_disk_1: archiving logs in the specified backup set
Input archiving log thread = 1 sequence = 8 Record ID = 334 timestamp = 667055192
Input archiving log thread = 1 sequence = 9 Record ID = 336 timestamp = 667055247
Input archiving log thread = 1 sequence = 10 Record ID = 338 timestamp = 667055251
Input archiving log thread = 1 sequence = 11 Record ID = 340 timestamp = 667055251
Input archiving log thread = 1 sequence = 12 Record ID = 342 timestamp = 667055256
Input archiving log thread = 1 sequence = 13 Record ID = 344 timestamp = 667055301
Channel ora_disk_1: Starting segment 1 from March 10 to April 10
Channel ora_disk_1: Completed segment 1 in March 10-08
Segment handle = D: \ backup \ demo_56.bak flag = tag20081002t130821 annotation = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 02
Backup completed from March 10 to April 10

Start backup from March 10 to April 10
Use channel ora_disk_1
Channel ora_disk_1: Start all data file backup Sets
Channel ora_disk_1: Specifies the data file in the backup set.
Enter the data file fno = 00004 name = D: \ demo \ users01.dbf
Channel ora_disk_1: Starting segment 1 from March 10 to April 10
Channel ora_disk_1: Completed segment 1 in March 10-08
Segment handle = D: \ backup \ demo_57.bak mark = tag20081002t130824 comment = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 25
Backup completed from March 10 to April 10

Start backup from March 10 to April 10
The current log is archived.
Use channel ora_disk_1
Channel ora_disk_1: archiving log backup set is being started
Channel ora_disk_1: archiving logs in the specified backup set
Input archiving log thread = 1 sequence = 14 Record ID = 347 timestamp = 667055330
Channel ora_disk_1: Starting segment 1 from March 10 to April 10
Channel ora_disk_1: Completed segment 1 in March 10-08
Segment handle = D: \ backup \ demo_58.bak mark = tag20081002t130850 comment = none
Channel ora_disk_1: Backup set completed. elapsed time: 00: 00: 02
Backup completed from March 10 to April 10

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.