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>
分享到:
相关推荐
ORACLE 11G 搭建DATAGUARD步骤,搭建rac环境之后,还需搭建dg,让你的数据库做到更安全。
详细的Oracle10g RAC + DataGuard 实施步骤
Oracle10G dataguard实施的操作记录
linux下oracle 11g R2 dataguard
个人搭建dataguard的经验分享。。 最新,最全面!!!
ORACLE 11G 搭建DATAGUARD步骤
Oracle10g RAC环境下DataGuard备库搭建实例
Oracle 19c DataGuard搭建以及使用dg_broker管理,通过dg_broker管理DataGuard以及Far_SYNC实例,快速switchover。
详细步骤 如何配置 oracle10g dataguard
oracle10g dataguard oracle10g dataguard oracle10g dataguard
Oracle 11g R2 to DataGuard实施方案
Oracle 11gR2 dataguard搭建说明
Oracle 11gR2 dataguard搭建说明
linux操作系统下,Oracle 11g部署物理dataguard
ORACLE 10G DATAGUARD 配置物理STANDBY 手记
Oracle 11g R2 Dataguard 配置手册,手把手教你如何做配置
大牛教你配置Oracle 11g Active Dataguard
oracle 10g rac dataguard 参考