10g windows 到LINUX 报：ORA-10562 - 重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛

49318685508d7282d1.png (417.17 KB, 下载次数: 343)

2025-6-20 15:08 上传

作者: 郑全 时间: 2025-6-20 15:12
按官方的说法，WINDOWS到LINUX恢复，存在这个问题，但DG 不存在，我这里是DG，结果也不行

作者: 郑全 时间: 2025-6-22 13:37
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

欢迎光临重庆思庄Oracle、KingBase、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)