`
itspace
  • 浏览: 959451 次
  • 性别: Icon_minigender_1
  • 来自: 杭州
社区版块
存档分类
最新评论

ORACLE 10g 跨平台dataguard搭建错误记录

阅读更多
windows到linux跨平台dataguard只有在在ORACLE 11g支持,今天闲来无事,想在ORACLE 10g实现一下,可以看到linux在应用windows的redolog时,发生了内部错误,说明redolog windows和linux在物理上还是有区别的,以下权作记录:
引用
SQL> recover database using backup controlfile;
ORA-00279: change 801654 generated at 07/14/2009 13:26:22 needed for thread 1
ORA-00289: suggestion : /oradata/archlog/orcl/ARC0000000024_0689897146.0001
ORA-00280: change 801654 for thread 1 is in sequence #24


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/tmp/REDO02.LOG
ORA-00308: cannot open archived log '/tmp/REDO02.LOG'
ORA-27046: file size is not a multiple of logical block size
Additional information: 1


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/tmp/REDO02.LOG
ORA-00283: recovery session canceled due to errors
ORA-10562: Error occurred while applying redo to data block (file# 3, block#
31760)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 3: '/oradata/orcl/sysaux01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 51625
ORA-00600: internal error code, arguments: [ktbair2_0], [12], [64], [], [], [],
[], []


ORA-01112: media recovery not started



或者

引用
SQL> recover database using backup controlfile;
ORA-00279: change 1326232 generated at 07/15/2009 13:17:41 needed for thread 1
ORA-00289: suggestion : /oradata/archlog/orcl/ARC0000000061_0689897146.0001
ORA-00280: change 1326232 for thread 1 is in sequence #61


Specify log: {<RET>=suggested | filename | AUTO | CANCEL}
/tmp/ARC00061_0689897146.001
ORA-00283: recovery session canceled due to errors
ORA-10562: Error occurred while applying redo to data block (file# 1, block# 9)
ORA-10564: tablespace SYSTEM
ORA-01110: data file 1: '/oradata/orcl/system01.dbf'
ORA-10560: block type 'KTU UNDO HEADER W/UNLIMITED EXTENTS'
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4187], [47], [47], [], [], [], [],
[]


ORA-01112: media recovery not started


SQL>
分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics