在vmvare上装了Oracle 10g,升级刷新数据字典时,又碰到了坏块。可以确保的是刷新之前数据库没有坏块。
[quote]SQL> execute dbms_registry_sys.gather_stats(null);
BEGIN dbms_registry_sys.gather_stats(null); END;
*
第 1 行出现错误:
ORA-01578: ORACLE 数据块损坏 (文件号 1, 块号 57583)
ORA-01110: 数据文件 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
ORA-06512: 在 "SYS.DBMS_STATS", line 13591
ORA-06512: 在 "SYS.DBMS_STATS", line 13904
ORA-06512: 在 "SYS.DBMS_STATS", line 16240
ORA-06512: 在 "SYS.DBMS_STATS", line 16282
ORA-06512: 在 "SYS.DBMS_REGISTRY_SYS", line 953
ORA-06512: 在 line 1[/quote]
结果导致N多组件没有成功,已经不止一次在vmware中碰到坏块了。
[quote]Oracle Database 10.2 Upgrade Status Utility 05-06-2010 17:53:15
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:11:31
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:00:00
Oracle XDK VALID 10.2.0.4.0 00:00:00
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:00
Oracle Text INVALID 10.2.0.4.0 00:00:37
Oracle XML Database VALID 10.2.0.4.0 00:00:00
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:49
Oracle Data Mining INVALID 10.2.0.4.0 00:00:00
OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:00
OLAP Catalog INVALID 10.2.0.4.0 00:00:00
Oracle OLAP API VALID 10.2.0.4.0 00:00:00
Oracle interMedia VALID 10.2.0.4.0 00:00:00
Spatial VALID 10.2.0.4.0 00:00:00
Oracle Ultra Search VALID 10.2.0.4.0 00:00:00
.
Total Upgrade Time: 00:13:58[/quote]
PS:如果一定要选择vmware作为虚拟机,根据经验,[color=red]务必预先分配好虚拟磁盘,禁止虚拟磁盘自动扩展![/color]
另附一案例
在备份库recover logfile时
[quote]SQL> recover standby database;
ORA-00279: change 9745363839799 generated at 05/16/2010 21:55:02 needed for
thread 1
ORA-00289: suggestion : /Tbackup/king/archlog/arc_1_12654.dbf
ORA-00280: change 9745363839799 for thread 1 is in sequence #12654
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 5108 change 9745363839800 time 05/16/2010
21:55:02
ORA-00334: archived log: '/Tbackup/king/archlog/arc_1_12654.dbf'
ORA-01112: media recovery not started[/quote]
利用bbed查看logfile
[quote]BBED> dump block 5108
File: /Tbackup/king/archlog/arc_1_12654.dbf (0)
Block: 5108 Offsets: 0 to 511 Dba:0x00000000
------------------------------------------------------------------------
6e310000 f4130000 b6e8dd2a 000026b0 312d3130 3a30303a 34393a31 35055641
4c494401 4e014e01 4e2c000d 06505542 4c494314 4d52565f 4f4c4150 325f4157
56494557 434f4c53 ff04c304 0a0bff07 53594e4f 4e594d07 786d0b0a 01320f07
786d0b0a 01320f13 32303039 2d31312d 31303a30 303a3439 3a313405 56414c49
44014e01 4e014e2c 000d0650 55424c49 43114d52 565f4f4c 4150325f 41575649
455753ff 04c3040a 0aff0753 594e4f4e 594d0778 6d0b0a01 320f0778 6d0b0a01
320f1332 3030392d 31312d31 303a3030 3a34393a 31340556 414c4944 014e014e
014e2c00 0d065055 424c4943 174d5256 5f4f4c41 50325f41 575f4154 54524942
55544553 ff04c304 0a40ff07 53594e4f 4e594d07 786d0b0a 01321007 786d0b0a
01321013 32303039 2d31312d 31303a30 303a3439 3a313505 56414c49 44014e01
4e014e2c 000d0650 55424c49 43124d52 565f4f4c 4150325f 41575f43 55424553
ff04c304 0a41ff07 53594e4f 4e594d07 786d0b0a [color=red]01121007 [/color]786d0b0a 01321013
32303039 2d31312d 31303a30 303a3439 3a313505 56414c49 44014e01 4e014e2c
000d0650 55424c49 43194d52 565f4f4c 4150325f 41575f43 5542455f 4147475f
4c564cff 04c3040a 47ff0753 594e4f4e 594d0778 6d0b0a01 32100778 6d0b0a01
32101332 3030392d 31312d31 303a3030 3a34393a 31350556 414c4944 014e014e [/quote]
<32 bytes per line>
查看正确的logfile
BBED> dump block 5108
[quote] File: /oradata/archlog/arc_1_12654.dbf (0)
Block: 5108 Offsets: 0 to 511 Dba:0x00000000
------------------------------------------------------------------------
6e310000 f4130000 b6e8dd2a 000026b0 312d3130 3a30303a 34393a31 35055641
4c494401 4e014e01 4e2c000d 06505542 4c494314 4d52565f 4f4c4150 325f4157
56494557 434f4c53 ff04c304 0a0bff07 53594e4f 4e594d07 786d0b0a 01320f07
786d0b0a 01320f13 32303039 2d31312d 31303a30 303a3439 3a313405 56414c49
44014e01 4e014e2c 000d0650 55424c49 43114d52 565f4f4c 4150325f 41575649
455753ff 04c3040a 0aff0753 594e4f4e 594d0778 6d0b0a01 320f0778 6d0b0a01
320f1332 3030392d 31312d31 303a3030 3a34393a 31340556 414c4944 014e014e
014e2c00 0d065055 424c4943 174d5256 5f4f4c41 50325f41 575f4154 54524942
55544553 ff04c304 0a40ff07 53594e4f 4e594d07 786d0b0a 01321007 786d0b0a
01321013 32303039 2d31312d 31303a30 303a3439 3a313505 56414c49 44014e01
4e014e2c 000d0650 55424c49 43124d52 565f4f4c 4150325f 41575f43 55424553
ff04c304 0a41ff07 53594e4f 4e594d07 786d0b0a [color=red]01321007 [/color]786d0b0a 01321013
32303039 2d31312d 31303a30 303a3439 3a313505 56414c49 44014e01 4e014e2c
000d0650 55424c49 43194d52 565f4f4c 4150325f 41575f43 5542455f 4147475f
4c564cff 04c3040a 47ff0753 594e4f4e 594d0778 6d0b0a01 32100778 6d0b0a01
32101332 3030392d 31312d31 303a3030 3a34393a 31350556 414c4944 014e014e [/quote]
<32 bytes per line>
可以看到红色部分发生了变化,又是一虚拟机的bug!
[quote]SQL> execute dbms_registry_sys.gather_stats(null);
BEGIN dbms_registry_sys.gather_stats(null); END;
*
第 1 行出现错误:
ORA-01578: ORACLE 数据块损坏 (文件号 1, 块号 57583)
ORA-01110: 数据文件 1: 'C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF'
ORA-06512: 在 "SYS.DBMS_STATS", line 13591
ORA-06512: 在 "SYS.DBMS_STATS", line 13904
ORA-06512: 在 "SYS.DBMS_STATS", line 16240
ORA-06512: 在 "SYS.DBMS_STATS", line 16282
ORA-06512: 在 "SYS.DBMS_REGISTRY_SYS", line 953
ORA-06512: 在 line 1[/quote]
结果导致N多组件没有成功,已经不止一次在vmware中碰到坏块了。
[quote]Oracle Database 10.2 Upgrade Status Utility 05-06-2010 17:53:15
.
Component Status Version HH:MM:SS
Oracle Database Server INVALID 10.2.0.4.0 00:11:31
JServer JAVA Virtual Machine VALID 10.2.0.4.0 00:00:00
Oracle XDK VALID 10.2.0.4.0 00:00:00
Oracle Database Java Packages VALID 10.2.0.4.0 00:00:00
Oracle Text INVALID 10.2.0.4.0 00:00:37
Oracle XML Database VALID 10.2.0.4.0 00:00:00
Oracle Workspace Manager VALID 10.2.0.4.3 00:00:49
Oracle Data Mining INVALID 10.2.0.4.0 00:00:00
OLAP Analytic Workspace VALID 10.2.0.4.0 00:00:00
OLAP Catalog INVALID 10.2.0.4.0 00:00:00
Oracle OLAP API VALID 10.2.0.4.0 00:00:00
Oracle interMedia VALID 10.2.0.4.0 00:00:00
Spatial VALID 10.2.0.4.0 00:00:00
Oracle Ultra Search VALID 10.2.0.4.0 00:00:00
.
Total Upgrade Time: 00:13:58[/quote]
PS:如果一定要选择vmware作为虚拟机,根据经验,[color=red]务必预先分配好虚拟磁盘,禁止虚拟磁盘自动扩展![/color]
另附一案例
在备份库recover logfile时
[quote]SQL> recover standby database;
ORA-00279: change 9745363839799 generated at 05/16/2010 21:55:02 needed for
thread 1
ORA-00289: suggestion : /Tbackup/king/archlog/arc_1_12654.dbf
ORA-00280: change 9745363839799 for thread 1 is in sequence #12654
Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
ORA-00283: recovery session canceled due to errors
ORA-00368: checksum error in redo log block
ORA-00353: log corruption near block 5108 change 9745363839800 time 05/16/2010
21:55:02
ORA-00334: archived log: '/Tbackup/king/archlog/arc_1_12654.dbf'
ORA-01112: media recovery not started[/quote]
利用bbed查看logfile
[quote]BBED> dump block 5108
File: /Tbackup/king/archlog/arc_1_12654.dbf (0)
Block: 5108 Offsets: 0 to 511 Dba:0x00000000
------------------------------------------------------------------------
6e310000 f4130000 b6e8dd2a 000026b0 312d3130 3a30303a 34393a31 35055641
4c494401 4e014e01 4e2c000d 06505542 4c494314 4d52565f 4f4c4150 325f4157
56494557 434f4c53 ff04c304 0a0bff07 53594e4f 4e594d07 786d0b0a 01320f07
786d0b0a 01320f13 32303039 2d31312d 31303a30 303a3439 3a313405 56414c49
44014e01 4e014e2c 000d0650 55424c49 43114d52 565f4f4c 4150325f 41575649
455753ff 04c3040a 0aff0753 594e4f4e 594d0778 6d0b0a01 320f0778 6d0b0a01
320f1332 3030392d 31312d31 303a3030 3a34393a 31340556 414c4944 014e014e
014e2c00 0d065055 424c4943 174d5256 5f4f4c41 50325f41 575f4154 54524942
55544553 ff04c304 0a40ff07 53594e4f 4e594d07 786d0b0a 01321007 786d0b0a
01321013 32303039 2d31312d 31303a30 303a3439 3a313505 56414c49 44014e01
4e014e2c 000d0650 55424c49 43124d52 565f4f4c 4150325f 41575f43 55424553
ff04c304 0a41ff07 53594e4f 4e594d07 786d0b0a [color=red]01121007 [/color]786d0b0a 01321013
32303039 2d31312d 31303a30 303a3439 3a313505 56414c49 44014e01 4e014e2c
000d0650 55424c49 43194d52 565f4f4c 4150325f 41575f43 5542455f 4147475f
4c564cff 04c3040a 47ff0753 594e4f4e 594d0778 6d0b0a01 32100778 6d0b0a01
32101332 3030392d 31312d31 303a3030 3a34393a 31350556 414c4944 014e014e [/quote]
<32 bytes per line>
查看正确的logfile
BBED> dump block 5108
[quote] File: /oradata/archlog/arc_1_12654.dbf (0)
Block: 5108 Offsets: 0 to 511 Dba:0x00000000
------------------------------------------------------------------------
6e310000 f4130000 b6e8dd2a 000026b0 312d3130 3a30303a 34393a31 35055641
4c494401 4e014e01 4e2c000d 06505542 4c494314 4d52565f 4f4c4150 325f4157
56494557 434f4c53 ff04c304 0a0bff07 53594e4f 4e594d07 786d0b0a 01320f07
786d0b0a 01320f13 32303039 2d31312d 31303a30 303a3439 3a313405 56414c49
44014e01 4e014e2c 000d0650 55424c49 43114d52 565f4f4c 4150325f 41575649
455753ff 04c3040a 0aff0753 594e4f4e 594d0778 6d0b0a01 320f0778 6d0b0a01
320f1332 3030392d 31312d31 303a3030 3a34393a 31340556 414c4944 014e014e
014e2c00 0d065055 424c4943 174d5256 5f4f4c41 50325f41 575f4154 54524942
55544553 ff04c304 0a40ff07 53594e4f 4e594d07 786d0b0a 01321007 786d0b0a
01321013 32303039 2d31312d 31303a30 303a3439 3a313505 56414c49 44014e01
4e014e2c 000d0650 55424c49 43124d52 565f4f4c 4150325f 41575f43 55424553
ff04c304 0a41ff07 53594e4f 4e594d07 786d0b0a [color=red]01321007 [/color]786d0b0a 01321013
32303039 2d31312d 31303a30 303a3439 3a313505 56414c49 44014e01 4e014e2c
000d0650 55424c49 43194d52 565f4f4c 4150325f 41575f43 5542455f 4147475f
4c564cff 04c3040a 47ff0753 594e4f4e 594d0778 6d0b0a01 32100778 6d0b0a01
32101332 3030392d 31312d31 303a3030 3a34393a 31350556 414c4944 014e014e [/quote]
<32 bytes per line>
可以看到红色部分发生了变化,又是一虚拟机的bug!