# 44450
skysea
|
|
To: 盖老师
继44449报警信息
[B]Tue Aug 18 15:33:05 2009
Hex dump of (file 3, block 13133) in trace file /u01/app/oracle/admin/dbrac/bdump/dbrac2_j000_23025.trc
Corrupt block relative dba: 0x00c0334d (file 3, block 13133)
Bad header found during buffer read
Data in bad block:
type: 2 format: 2 rdba: 0x0080184d
last change scn: 0x0000.00016696 seq: 0x5d flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x6696025d
check value in block header: 0xed71
computed block checksum: 0x0
Reread of rdba: 0x00c0334d (file 3, block 13133) found same corrupted data
Tue Aug 18 15:33:11 2009
Hex dump of (file 3, block 13081) in trace file /u01/app/oracle/admin/dbrac/udump/dbrac2_ora_21784.trc[/B]
From: skysea 2009.08.22 06:04
|
|
|
|
# 44449
skysea
|
|
To: 盖老师
问题"44437续问
"/u01/app/oracle/admin/dbrac/bdump/alert_dbrac2.log"似乎有错误。
部分日志如下
Tue Aug 18 15:31:34 2009
Starting ORACLE instance (normal)
...........
Completed: ALTER DATABASE OPEN
[B]Hex dump of (file 3, block 13148) in trace file /u01/app/oracle/admin/dbrac/udump/dbrac2_ora_21784.trc
Corrupt block relative dba: 0x00c0335c (file 3, block 13148)
Bad header found during buffer read
Data in bad block:
type: 2 format: 2 rdba: 0x0080185c
last change scn: 0x0000.00016930 seq: 0x1 flg: 0x04
spare1: 0x0 spare2: 0x0 spare3: 0x0
consistency value in tail: 0x69300201
check value in block header: 0x9361
computed block checksum: 0x0
Reread of rdba: 0x00c0335c (file 3, block 13148) found same corrupted data
Tue Aug 18 15:32:21 2009
Corrupt Block Found
TSN = 2, TSNAME = SYSAUX
RFN = 3, BLK = 13148, RDBA = 12596060
OBJN = 10943, OBJD = 10943, OBJECT = MGMT_METRICS_IDX_01, SUBOBJECT =
SEGMENT OWNER = SYSMAN, SEGMENT TYPE = Index Segment
From: skysea 2009.08.22 06:01
|
|
|
|
# 44437
skysea
|
|
To: 盖老师
oracle 10g在两台IBMx346部署rac,最后dbca时,在最后一步“Completing Database Creation”报错,内容如下
ORA-00600: internal error code, arguments: [6002], [0], [0], [2], [0], [], [], []
ORA-06512:"SYS.UTL_RECOMP" at line 608
ORA-06512:"SYS.UTL_RECOMP" at line 605
ORA-06512:at line 1
点击报错窗口“OK”后,似乎数据创建成功。而且数据库和实例在两台IBMx346都正常运行,且一切资源都正常。
盖老师:ORA-00600: internal error code, arguments: [6002], [0], [0], [2], [0], [], [], []是什么错误,严重吗?
望指教。谢谢
From: skysea 2009.08.16 20:12
|
|
|
|
To: skysea
似乎是最后编译阶段出错了,你可以看看有没有INVALID的对象,如果没有就不怕了。
From: eygle 2009.08.18 22:05
|
|
|
|
# 44432
anncy
来自: bj
|
|
To: eygle
盖老师:
您好!
咨询您个问题,可否将10g从HP-UX同步到AIX上或LINUX上?
当然我知道物理方式(RMAN/BACKUP)不行的,EXP/IMP是应该可以的
当然还需要对HP-UX端的每日增量同步到另一端,这个可以用脚本实现吧。。。
我记得好象10g有个TOOLS能执行类似功能,但没尝试过,不知道您做过吗?
给指导下!多谢!!!
From: anncy 2009.08.08 10:40
|
|
|
|
To: anncy
exp/imp来同步非常不现实,高级复制、MV等技术还可以考虑。
From: eygle 2009.08.09 19:10
|
|
|
|
# 44431
Paul
|
|
To: eygle
Eygle,你好!
我在按照你的《循序渐进ORACLE》第一章使用模板创建数据库的时候碰到了一个问题,具体情况是这样的:
1. 使用dbca命令成功创建了名为peng的模板
2. 执行peng.bat创建数据库,很快出现了错误并中断安装。
查询了trace.log和bdump目录下的alert_peng.log,发现错误信息如下:
ORA-09314: sltln: error translating logical name
OSD-04026: Invalid parameter passed.
google一番后说是创建控制文件失败,我查了一下init.ora文件,发现createDB.sql最后确实没有生成control_files参数项。(我是使用OMF来管理文件的)
请问如何解决这个问题?THX
From: Paul 2009.08.05 02:17
|
|
|
|
To: Paul
你可以尝试一个脚本一个脚本的手工执行,看看问题出在什么地方。
control_files 应该是后加入进去的,因为OMF管理,控制文件的名字生成后才能得知。
From: eygle 2009.08.09 19:07
|
|
|
|
|