冷备份恢复的问题?

[复制链接]
查看11 | 回复3 | 2006-4-17 13:46:34 | 显示全部楼层 |阅读模式
冷备份恢复到另一台机器上,把后来产生的归档日志APPLY到新机器上时出现问题?
两台相同的机器:xp+ORACLE 8.1.7
机器A数据库(自动归档模式)停机后。把数据文件,日志文件,控制文件复制到机器B上。
在机器A上执行了一些dml语句,用alter system switch logfile产生了两个归档日志文件orclt001s00003.arc,orclt001s00004.arc,将归档日志文件copy到机器B上,执行以下命令:
svrmgrl>recover database using backup controlfile until cancel;
ORA-00279: change 74788 generated at 04/26/2004 14:11:36 needed for thread1
ORA-00289: suggestion : c:\oracle\oradata\orcl\archive\orclt001s00003.arc
ORA-00280: change 74788 for thread 1 is in sequence #3
Specify log : {=suggested | filename | AUTO | CANCEL }
AUTO
ORA-00283: recoverysession canceled due to errors
ORA-00600: internal error code, arguments:[3020], [8439810], [1], [34], [202], [16], [ ], [ ]
恢复没有成功,以前是没有问题的,帮忙解决一下上述的错误。
回复

使用道具 举报

千问 | 2006-4-17 13:46:34 | 显示全部楼层

回复

使用道具 举报

千问 | 2006-4-17 13:46:34 | 显示全部楼层
关注
回复

使用道具 举报

千问 | 2006-4-17 13:46:34 | 显示全部楼层
metalink上的解释如下:
Errors
ORA 600 "internal error code, arguments: [%s],[%s],[%s], [%s], [%s],
[KCRRLCK.1]
Symptoms
Failover fails with [ORA-600 [kcrrlck.1]
Alert.log
======
Alter database recover managed standby database finish skip standby logfile
Thu Feb 5 16:54:25 2004
Database not recovered through End-Of-REDO
Attempt to do a Terminal Incomplete Recovery
Media Recovery Start: Managed Standby Recovery
Starting datafile 1 recovery in thread 1 sequence 31
Datafile 1: '/dev/vx/rdsk/aotsdrdg/AOTSDRSYSTEM1'
Starting datafile 2 recovery in thread 1 sequence 31
Datafile 2: '/dev/vx/rdsk/aotsdrdg/AOTSDRUNDO1'
Starting datafile 3 recovery in thread 1 sequence 31
.......
.......
Media Recovery Log
Media Recovery Waiting for thread 1 seq# 31
Terminal Incomplete Recovery: UNTIL CHANGE 70021
Terminal Incomplete Recovery: End-Of-Redo log allocation
Terminal Incomplete Recovery: log 101 reserved for thread 1 seq# 31
Thu Feb 5 16:54:40 2004
Errors in file /opt/oracle/AOTSDR/admin/udump/aotsdr_ora_16260.trc:
ORA-00600: internal error code, arguments: [kcrrlck.1], [0], [0], [0], [], [], [], []
Recovery interrupted.
Media Recovery failed with error 600
Cause
This error would generally be returned when you are testing Failover. This is because the RFS process on the standby has locks on the standby redo logs.
Fix
You need to either shutdown the Primary or bounce the standby to release the RFS lock on the standby redo log.
References
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行