10g windows 到LINUX 报：ORA-10562

郑全

10g 10.2.0.5 windows 到LINUX 配置DG，
使用 alter database recover managed standby database disconnect,
报：ORA-10562

Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_p013_170561.trc:
ORA-10562: Error occurred while applying redo to data block (file# 3, block# 78014)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 3: '/data/orcl/sysaux01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED DATA BLOCK', data object# 354522
ORA-00600: internal error code, arguments: [4502], [0], [], [], [], [], [], []
Fri Jun 20 15:01:15 CST 2025
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_p012_170559.trc:
ORA-00339: archived log does not contain any redo
ORA-00334: archived log: '/data/orcl/RODO_2_2.LOG'
ORA-00600: internal error code, arguments: [6122], [0], [59337], [0], [], [], [], []
Fri Jun 20 15:01:15 CST 2025
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_p012_170559.trc:
ORA-10562: Error occurred while applying redo to data block (file# 3, block# 28590)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 3: '/data/orcl/sysaux01.dbf'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 354730
ORA-00600: internal error code, arguments: [6122], [0], [59337], [0], [], [], [], []
Recovery interrupted!
Recovered data files to a consistent state at change 17866220305330
Fri Jun 20 15:01:20 CST 2025
Errors in file /u01/app/oracle/admin/orcl/bdump/orcl_mrp0_170533.trc:
ORA-12801: Message 12801 not found; No message file for product=RDBMS, facility=ORA; arguments: [P007]
ORA-10562: Error occurred while applying redo to data block (file# 3, block# 61322)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 3: '/data/or
Fri Jun 20 15:01:20 CST 2025
MRP0: Background Media Recovery process shutdown (orcl)
Using STANDBY_ARCHIVE_DEST parameter default value as /data/arch_log
Redo Shipping Client Connected as PUBLIC
-- Connected User is Valid
RFS[1]: Assigned to RFS process 171391
RFS[1]: Identified database type as 'physical standby'
Fri Jun 20 15:05:02 CST 2025
RFS LogMiner: Client disabled from further notification
RFS[1]: Archived Log: '/data/arch_log/1_78338_1112013034.dbf'

登录/注册后可看大图

郑全

按官方的说法，WINDOWS到LINUX恢复，存在这个问题，但DG 不存在，我这里是DG，结果也不行

郑全

Duplicate from Windows to Linux ORA-600 [KTBRCL:CDLC NOT IN CR] (Doc ID 1508375.1)

Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Symptoms
Error during duplicate from Windows to Linux

starting media recovery

channel ORA_AUX_DISK_1: starting archived log restore to user-specified
destination
archived log destination=<+dgroup>
channel ORA_AUX_DISK_1: restoring archived log
archived log thread=1 sequence=362
channel ORA_AUX_DISK_1: reading from backup piece /<path>/<backup_piece_name_1_1>
channel ORA_AUX_DISK_1: piece handle=/<path>/<backup_piece_name_1_1> tag=TAG20120817T020356
channel ORA_AUX_DISK_1: restored backup piece 1
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:01
archived log file name=<+dgroup>/<dbname>/<file_type>/<date>/<thread_#_seq>_<seqno>.<file>.<incarnation> thread=<#> sequence=<seqno>
Oracle instance started

Total System Global Area    5344731136 bytes

Fixed Size                     2237776 bytes
Variable Size               1124076208 bytes
Database Buffers            4194304000 bytes
Redo Buffers                  24113152 bytes

contents of Memory Script:
{
   sql clone "alter system set  db_name =
''FSCMTP'' comment=
''Reset to original value by RMAN'' scope=spfile";
   sql clone "alter system reset  db_unique_name scope=spfile";
   shutdown clone immediate;
}
executing Memory Script

Errors in memory script
RMAN-03015: error occurred in stored script Memory Script
RMAN-06136: ORACLE error from auxiliary database: ORA-01507: database not mounted
ORA-06512: at "SYS.X$DBMS_RCVMAN", line 13466
ORA-06512: at line 1
RMAN-03015: error occurred in stored script Memory Script
RMAN-20000: abnormal termination of job step
RMAN-11003: failure during parse/execution of SQL statement: alter database recover logfile
'<+dgroup>/<dbname>/<file_type>/<date>/<thread_#_seq>_<seqno>.<file>.<incarnation>'
RMAN-11001: Oracle Error: ORA-10562: Error occurred while applying redo to data block (file# 2, block# 41789)
ORA-10564: tablespace SYSAUX
ORA-01110: data file 2: '<+dgroup>/<dbname>/<file_type>/<file_type_tag>.<file>.<incarnation>'
ORA-10561: block type 'TRANSACTION MANAGED INDEX BLOCK', data object# 272
ORA-00600: internal error code, arguments: [ktbrcl:CDLC not in CR], [166], [], [], [], [], [], [], [], [], [], []
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 08/17/2012 02:43:08
RMAN-05501: aborting duplication of target database

Changes


Cause
Cross platform duplicate from Linux <---> Windows when the database was NOT created in 11g

Solution
We face error ORA-600 [KTBRCL:CDLC NOT IN CR] while duplicating from Windows
to Linux when performing cross platform rman duplicate.

Cross-platform redo application, between Linux and Windows, is only supported when :


COMPATIBLE >= 11.0
Database has been created in 11g, so NOT upgraded from earlier versions

See also : Note 1079563.1 RMAN DUPLICATE/RESTORE/RECOVER Mixed Platform Support

References
BUG:14509878 - ORA-600 [KTBRCL:CDLC NOT IN CR] DUPLICATE FROM WINDOWS TO LINUX