oracle双节点RAC-rman-错误-03009

lingzhiluoye

1. SQL> select * from v$$version;
   
2. 
   
3. BANNER
   
4. --------------------------------------------------------------------------------
   
5. Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
   
6. PL/SQL Release 11.2.0.3.0 - Production
   
7. CORE    11.2.0.3.0      Production
   
8. TNS for Linux: Version 11.2.0.3.0 - Production
   
9. NLSRTL Version 11.2.0.3.0 - Production
   
10. 
    
11. SQL> archive log list
    
12. Database log mode              Archive Mode
    
13. Automatic archival             Enabled
    
14. Archive destination            USE_DB_RECOVERY_FILE_DEST
    
15. Oldest online log sequence     151687
    
16. Next log sequence to archive   151688
    
17. Current log sequence           151688
    
18. SQL>
    
19. SQL>
    
20. SQL> show parameter db_recovery_file_dest     
    
21. 
    
22. NAME                                 TYPE        VALUE
    
23. ------------------------------------ ----------- ------------------------------
    
24. db_recovery_file_dest                string      +ARCH
    
25. db_recovery_file_dest_size           big integer 1500G
    
26. 
    
27. RMAN> show all;
    
28. 
    
29. using target database control file instead of recovery catalog
    
30. RMAN configuration parameters for database with db_unique_name BIDB are:
    
31. CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
    
32. CONFIGURE BACKUP OPTIMIZATION ON;
    
33. CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
    
34. CONFIGURE CONTROLFILE AUTOBACKUP ON;
    
35. CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
    
36. CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET;
    
37. CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
38. CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
    
39. CONFIGURE MAXSETSIZE TO UNLIMITED; # default
    
40. CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
    
41. CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
    
42. CONFIGURE COMPRESSION ALGORITHM 'MEDIUM' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE;
    
43. CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
    
44. CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+ARCH/snapcf_bidb.f';
    
45. 
    
46. $$RMAN target / nocatalog msglog $$RMAN_LOG_FILE append <<EOF
    
47. configure channel device type 'SBT_TAPE' clear;
    
48. crosscheck archivelog all;
    
49. crosscheck backup;
    
50. delete noprompt expired archivelog all;
    
51. delete noprompt obsolete device type disk;
    
52. delete noprompt expired backup;
    
53. run
    
54. {
    
55.   allocate channel c1 device type disk;
    
56.   allocate channel c2 device type disk;
    
57.   allocate channel c3 device type disk;
    
58.   allocate channel c4 device type disk;
    
59.   backup format='$$OUTPUT_HOME/data_%T_%d_ID%I_%N' tag='backup_level"$$BACKUP_LEVEL"' incremental level=$$BACKUP_LEVEL skip inaccessible filesperset 1 database;
    
60.   backup archivelog all format='$$OUTPUT_HOME/arch_%T_%d_%U' tag='backup_archivelog' skip inaccessible filesperset 1 not backed up 1 times delete input;
    
61.   backup current controlfile format='$$OUTPUT_HOME/ctrl_%T_%d' tag='backup_control';
    
62.   backup spfile format='$$OUTPUT_HOME/spfl_%T_%d' tag='backup_spfile';
    
63.   release channel c1;
    
64.   release channel c2;
    
65.   release channel c3;
    
66.   release channel c4;
    
67. }
    
68. report obsolete;
    
69. delete noprompt obsolete device type disk;
    
70. crosscheck backup;
    
71. delete noprompt expired backup;
    
72. list backup summary;
    
73. EOF
    
74. 
    

复制代码

lingzhiluoye

1. Starting backup at 03-MAR-15
   
2. current log archived
   
3. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205 not found or out of sync with catalog
   
4. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205
   
5. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275 not found or out of sync with catalog
   
6. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275
   
7. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417 not found or out of sync with catalog
   
8. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417
   
9. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150775.1699.873251537 not found or out of sync with catalog
   
10. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150775.1699.873251537
    
11. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150776.12462.873251629 not found or out of sync with catalog
    
12. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150776.12462.873251629
    
13. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150777.1813.873251727 not found or out of sync with catalog
    
14. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150777.1813.873251727
    
15. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150778.1716.873251851 not found or out of sync with catalog
    
16. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150778.1716.873251851
    
17. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150779.12430.873252225 not found or out of sync with catalog
    
18. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150779.12430.873252225
    
19. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150780.1809.873252417 not found or out of sync with catalog
    
20. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150780.1809.873252417
    
21. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150781.1778.873252685 not found or out of sync with catalog
    
22. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150781.1778.873252685
    
23. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150782.472.873252779 not found or out of sync with catalog
    
24. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150782.472.873252779
    
25. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150783.1630.873252849 not found or out of sync with catalog
    
26. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205
    
27. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275 not found or out of sync with catalog
    
28. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275
    
29. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417 not found or out of sync with catalog
    
30. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417
    
31. channel c3: finished piece 1 at 03-MAR-15
    
32. piece handle=/u01/rman-backup/20150302.level0/data_20150303_BIDB_ID761205897_DEVFOCUSBAK_BIPLATFORM tag=BACKUP_LEVEL0 comment=NONE
    
33. channel c3: backup set complete, elapsed time: 00:00:19
    
34. channel c1: finished piece 1 at 03-MAR-15
    
35. piece handle=/u01/rman-backup/20150302.level0/data_20150303_BIDB_ID761205897_DEVFOCUSMOB_BIPLATFORM tag=BACKUP_LEVEL0 comment=NONE
    
36. channel c1: backup set complete, elapsed time: 00:00:07
    
37. Finished backup at 03-MAR-15
    
38. 
    
39. Starting backup at 03-MAR-15
    
40. current log archived
    
41. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205 not found or out of sync with catalog
    
42. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150772.346.873251205
    
43. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275 not found or out of sync with catalog
    
44. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150773.1723.873251275
    
45. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417 not found or out of sync with catalog
    
46. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150774.901.873251417
    
47. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150775.1699.873251537 not found or out of sync with catalog
    
48. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150775.1699.873251537
    
49. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150776.12462.873251629 not found or out of sync with catalog
    
50. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150776.12462.873251629
    
51. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150777.1813.873251727 not found or out of sync with catalog
    
52. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150777.1813.873251727
    
53. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150778.1716.873251851 not found or out of sync with catalog
    
54. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150778.1716.873251851
    
55. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150779.12430.873252225 not found or out of sync with catalog
    
56. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150779.12430.873252225
    
57. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150780.1809.873252417 not found or out of sync with catalog
    
58. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150780.1809.873252417
    
59. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150781.1778.873252685 not found or out of sync with catalog
    
60. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150781.1778.873252685
    
61. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150782.472.873252779 not found or out of sync with catalog
    
62. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150782.472.873252779
    
63. archived log +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150783.1630.873252849 not found or out of sync with catalog
    
64. skipping inaccessible file +ARCH/bidb/archivelog/2015_03_02/thread_2_seq_150783.1630.873252849
    
65. RMAN-06061: WARNING: skipping archived log compromises recoverability
    
66. channel c1: starting archived log backup set
    
67. RMAN-03009: failure of backup command on c1 channel at 03/03/2015 02:40:43
    
68. ORA-19588: archived log RECID 301863 STAMP 873251307 is no longer valid
    
69. channel c1 disabled, job failed on it will be run on another channel
    
70. channel c2: starting archived log backup set
    
71. RMAN-03009: failure of backup command on c2 channel at 03/03/2015 02:40:43
    
72. ORA-19588: archived log RECID 301864 STAMP 873251353 is no longer valid
    
73. channel c2 disabled, job failed on it will be run on another channel
    
74. channel c3: starting archived log backup set
    
75. RMAN-03009: failure of backup command on c3 channel at 03/03/2015 02:40:43
    
76. ORA-19588: archived log RECID 301867 STAMP 873251596 is no longer valid
    
77. channel c3 disabled, job failed on it will be run on another channel
    
78. channel c4: starting archived log backup set
    
79. released channel: c1
    
80. released channel: c2
    
81. released channel: c3
    
82. released channel: c4
    
83. RMAN-00571: ===========================================================
    
84. RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
    
85. RMAN-00571: ===========================================================
    
86. RMAN-03009: failure of backup command on c4 channel at 03/03/2015 02:40:43
    
87. ORA-19588: archived log RECID 301868 STAMP 873251636 is no longer valid
    
88. 
    
89. RMAN> RMAN>
    

复制代码

lingzhiluoye

找不到日志？为何呢 ？

liuwenqing

你到对应的磁盘组目录下去找找看，那些文件到底在没在