RMAN – error：RMAN-07519: Reason: Error while cataloging. See alert.log. and ORA-27046: file size is not a multiple of logical block size
今天在DG环境下使用主库的RMAN跳过备库GAP的时候，在备库恢复主库端生成的RMAN备份集的时候遇到了如题所示的报错。
具体如下：
RMAN：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 |
AIX-ME:oraorcl 2> rman target / Recovery Manager: Release 11.2.0.2.0 - Production on Mon Jan 22 10:59:51 2018 Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved. connected to target database: orcl (DBID=183258872, not open) RMAN> RMAN> shutdown; using target database control file instead of recovery catalog database dismounted Oracle instance shut down RMAN> RMAN> startup nomount; connected to target database (not started) Oracle instance started Total System Global Area 51309510656 bytes Fixed Size 2231608 bytes Variable Size 30467424968 bytes Database Buffers 20803747840 bytes Redo Buffers 36106240 bytes RMAN> RMAN> restore standby controlfile from '/oracle_backup/primary_rman_datafile/ForStandby_controlfile.bak'; Starting restore at 22-JAN-18 allocated channel: ORA_DISK_1 channel ORA_DISK_1: SID=227 device type=DISK channel ORA_DISK_1: restoring control file channel ORA_DISK_1: restore complete, elapsed time: 00:00:08 output file name=/oracle/orcl/origlogA/cntrl/controlstandby1.ctl Finished restore at 22-JAN-18 RMAN> RMAN> startup mount; database is already started database mounted released channel: ORA_DISK_1 For record type BACKUP PIECE RECIDS from 2419845 to 2508096 are re-used before resync For record type BACKUP SET RECIDS from 2419845 to 2508096 are re-used before resync For record type DELETED OBJECT RECIDS from 251985 to 260049 are re-used before resync RMAN> RMAN> RMAN> catalog start with '/oracle_backup/primary_rman_datafile'; searching for all files that match the pattorcl /oracle_backup/primary_rman_datafile List of Files Unknown to the Database ===================================== File Name: /oracle_backup/primary_rman_datafile/ForStandby_86sou91p_1_1 File Name: /oracle_backup/primary_rman_datafile/ForStandby_controlfile.bak File Name: /oracle_backup/primary_rman_datafile/ForStandby_easot9an_1_1 File Name: /oracle_backup/primary_rman_datafile/ForStandby_ebsot9ao_1_1 File Name: /oracle_backup/primary_rman_datafile/ForStandby_ecsot9aq_1_1 File Name: /oracle_backup/primary_rman_datafile/ForStandby_edsot9as_1_1 File Name: /oracle_backup/primary_rman_datafile/ForStandby_eesot9au_1_1 File Name: /oracle_backup/primary_rman_datafile/ForStandby_rnsottd8_1_1 File Name: /oracle_backup/primary_rman_datafile/ForStandby_ttsotuif_1_1 File Name: /oracle_backup/primary_rman_datafile/me Do you really want to catalog the above files (enter YES or NO)? yes cataloging files... cataloging done List of Cataloged Files ======================= File Name: /oracle_backup/primary_rman_datafile/ForStandby_86sou91p_1_1 File Name: /oracle_backup/primary_rman_datafile/ForStandby_controlfile.bak List of Files Which Where Not Cataloged ======================================= File Name: /oracle_backup/primary_rman_datafile/ForStandby_easot9an_1_1 RMAN-07519: Reason: Error while cataloging. See alert.log. File Name: /oracle_backup/primary_rman_datafile/ForStandby_ebsot9ao_1_1 RMAN-07519: Reason: Error while cataloging. See alert.log. File Name: /oracle_backup/primary_rman_datafile/ForStandby_ecsot9aq_1_1 RMAN-07519: Reason: Error while cataloging. See alert.log. File Name: /oracle_backup/primary_rman_datafile/ForStandby_edsot9as_1_1 RMAN-07519: Reason: Error while cataloging. See alert.log. File Name: /oracle_backup/primary_rman_datafile/ForStandby_eesot9au_1_1 RMAN-07519: Reason: Error while cataloging. See alert.log. File Name: /oracle_backup/primary_rman_datafile/ForStandby_rnsottd8_1_1 RMAN-07519: Reason: Error while cataloging. See alert.log. File Name: /oracle_backup/primary_rman_datafile/ForStandby_ttsotuif_1_1 RMAN-07519: Reason: Error while cataloging. See alert.log. File Name: /oracle_backup/primary_rman_datafile/me RMAN-07517: Reason: The file header is corrupted RMAN> |
发生该错误的时候，Oracle的ALERT日志的问题如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 |
Mon Jan 22 11:12:16 2018 Errors in file /oracle/orcl/myoracle_trace/diag/rdbms/standby1/orcl/trace/orcl_ora_3474240.trc: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /oracle_backup/primary_rman_datafile/ForStandby_easot9an_1_1 ORA-19505: failed to identify file "/oracle_backup/primary_rman_datafile/ForStandby_easot9an_1_1" ORA-27046: file size is not a multiple of logical block size Additional information: 1 Additional information: 1073741312 Additional information: 8192 Errors in file /oracle/orcl/myoracle_trace/diag/rdbms/standby1/orcl/trace/orcl_ora_3474240.trc: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /oracle_backup/primary_rman_datafile/ForStandby_ebsot9ao_1_1 ORA-19505: failed to identify file "/oracle_backup/primary_rman_datafile/ForStandby_ebsot9ao_1_1" ORA-27046: file size is not a multiple of logical block size Additional information: 1 Additional information: 1073741312 Additional information: 8192 Errors in file /oracle/orcl/myoracle_trace/diag/rdbms/standby1/orcl/trace/orcl_ora_3474240.trc: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /oracle_backup/primary_rman_datafile/ForStandby_ecsot9aq_1_1 ORA-19505: failed to identify file "/oracle_backup/primary_rman_datafile/ForStandby_ecsot9aq_1_1" ORA-27046: file size is not a multiple of logical block size Additional information: 1 Additional information: 1073741312 Additional information: 8192 Errors in file /oracle/orcl/myoracle_trace/diag/rdbms/standby1/orcl/trace/orcl_ora_3474240.trc: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /oracle_backup/primary_rman_datafile/ForStandby_edsot9as_1_1 ORA-19505: failed to identify file "/oracle_backup/primary_rman_datafile/ForStandby_edsot9as_1_1" ORA-27046: file size is not a multiple of logical block size Additional information: 1 Additional information: 1073741312 Additional information: 8192 Errors in file /oracle/orcl/myoracle_trace/diag/rdbms/standby1/orcl/trace/orcl_ora_3474240.trc: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /oracle_backup/primary_rman_datafile/ForStandby_eesot9au_1_1 ORA-19505: failed to identify file "/oracle_backup/primary_rman_datafile/ForStandby_eesot9au_1_1" ORA-27046: file size is not a multiple of logical block size Additional information: 1 Additional information: 1073741312 Additional information: 8192 Errors in file /oracle/orcl/myoracle_trace/diag/rdbms/standby1/orcl/trace/orcl_ora_3474240.trc: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /oracle_backup/primary_rman_datafile/ForStandby_rnsottd8_1_1 ORA-19505: failed to identify file "/oracle_backup/primary_rman_datafile/ForStandby_rnsottd8_1_1" ORA-27046: file size is not a multiple of logical block size Additional information: 1 Additional information: 1073741312 Additional information: 8192 Errors in file /oracle/orcl/myoracle_trace/diag/rdbms/standby1/orcl/trace/orcl_ora_3474240.trc: ORA-19624: operation failed, retry possible ORA-19870: error while restoring backup piece /oracle_backup/primary_rman_datafile/ForStandby_ttsotuif_1_1 ORA-19505: failed to identify file "/oracle_backup/primary_rman_datafile/ForStandby_ttsotuif_1_1" ORA-27046: file size is not a multiple of logical block size Additional information: 1 Additional information: 1073741312 Additional information: 8192 |
在MOS上，发生该问题的原因很多，主要有以下两点：
1. 参数文件spfile：
RMAN backup fails with RMAN-03009 ORA-27046 (文档 ID 428524.1)
2. 密码文件：
ORA-27046: file size is not a multiple of logical block size and file information is not listed (文档 ID 1615335.1)
但是在我的环境里，问题原因是因为：备份集文件数据不完整。
主库端：
备库端：
————————————————————————
Done。
微信扫一扫，打赏作者吧～
控制文件：
FILE SIZE IS NOT A MULTIPLE OF LOGICAL BLOCK SIZE ORA-00202 ORA-27046 OSD-04012 [ID 356867.1]