Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
Oracle数据库数据恢复、性能优化»论坛 › Oracle › Oracle数据库管理 › oracle双节点RAC-rman-错误-03009
发新帖
lingzhiluoye

0

积分

0

好友

8

主题

[物理/逻辑坏块] oracle双节点RAC-rman-错误-03009

1#
发表于 2015-3-4 18:11:23 | 查看: 3958| 回复: 3
  1. SQL> select * from v$$version;

  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

  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     

  22. NAME                                 TYPE        VALUE
  23. ------------------------------------ ----------- ------------------------------
  24. db_recovery_file_dest                string      +ARCH
  25. db_recovery_file_dest_size           big integer 1500G

  27. RMAN> show all;

  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';

  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

复制代码
2#
发表于 2015-3-4 18:11:50
  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

  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

  89. RMAN> RMAN>
复制代码

回复 只看该作者 道具 举报

3#
发表于 2015-3-4 18:12:59
找不到日志？为何呢 ？

回复 只看该作者 道具 举报

4#
发表于 2015-3-6 12:29:52
你到对应的磁盘组目录下去找找看，那些文件到底在没在

回复 只看该作者 道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-5-17 20:15 , Processed in 0.047890 second(s), 20 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569