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

转载

小叔叔书 2021-08-09 22:42:03 博主文章分类：Oracle

文章标签 linux oracle sql 内部错误跨平台 文章分类 Oracle 数据库

本文引自：http://www.coin163.com/it/5020203149940361146/Linux-Windows-SQLthreadOracle

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>