​

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>

原文


windows到linux跨平台dataguard只有在在ORACLE 11g支持,今天闲来无事,想在ORACLE 10g实现一下, 可以看到linux在应用windows的redolog时,发生了内部错误,说明redolog windows和linux在物理