10g备份恢复后的奇怪问题

[复制链接]
查看11 | 回复2 | 2015-5-19 13:15:06 | 显示全部楼层 |阅读模式
恢复后不停的自己在做:alter database recover logfile
贴出相关日志如下:
ALTER SYSTEM SET db_recovery_file_dest_size='3G' SCOPE=BOTH;
Tue Nov 20 10:19:00 2012
Full restore complete of datafile 4 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\USERS01.DBF.Elapsed time: 0:00:00
checkpoint is 38448762
Full restore complete of datafile 2 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\UNDOTBS01.DBF.Elapsed time: 0:00:02
checkpoint is 38448762
Full restore complete of datafile 5 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\EXAMPLE01.DBF.Elapsed time: 0:00:02
checkpoint is 38448762
Full restore complete of datafile 3 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSAUX01.DBF.Elapsed time: 0:00:06
checkpoint is 38448762
Full restore complete of datafile 1 D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\SYSTEM01.DBF.Elapsed time: 0:00:06
checkpoint is 38448762
Tue Nov 20 10:19:16 2012
Full restore complete of datafile 6 F:\ORACLE\DATA\JWEBPLUS\WEBPLUS.DBF.Elapsed time: 0:00:16
checkpoint is 38448762
Tue Nov 20 10:19:20 2012
alter database recover datafile list clear
Tue Nov 20 10:19:20 2012
Completed: alter database recover datafile list clear
Tue Nov 20 10:19:20 2012
alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
Completed: alter database recover datafile list
1 , 2 , 3 , 4 , 5 , 6
Tue Nov 20 10:19:20 2012
alter database recover if needed
start
Media Recovery Start
parallel recovery started with 15 processes
Media Recovery start incarnation depth : 1, target inc# : 4, irscn : 52584156
ORA-279 signalled during: alter database recover if needed
start
...
Tue Nov 20 10:19:26 2012
alter database recover logfile 'F:\ORACLE\ARCHLOG\ARC00650_0770663353.001'
Tue Nov 20 10:19:26 2012
Media Recovery Log F:\ORACLE\ARCHLOG\ARC00650_0770663353.001
ORA-279 signalled during: alter database recover logfile 'F:\ORACLE\ARCHLOG\ARC00650_0770663353.001'...
Tue Nov 20 10:19:26 2012
alter database recover logfile 'F:\ORACLE\ARCHLOG\ARC00651_0770663353.001'
Tue Nov 20 10:19:26 2012
Media Recovery Log F:\ORACLE\ARCHLOG\ARC00651_0770663353.001
ORA-279 signalled during: alter database recover logfile 'F:\ORACLE\ARCHLOG\ARC00651_0770663353.001'...
Tue Nov 20 10:19:26 2012
alter database recover logfile 'F:\ORACLE\ARCHLOG\ARC00652_0770663353.001'
Tue Nov 20 10:19:26 2012
Media Recovery Log F:\ORACLE\ARCHLOG\ARC00652_0770663353.001
ORA-279 signalled during: alter database recover logfile 'F:\ORACLE\ARCHLOG\ARC00652_0770663353.001'...
下面省略
一直在做alter database recover logfile
请教原因,谢谢

回复

使用道具 举报

千问 | 2015-5-19 13:15:06 | 显示全部楼层
从你备份的时间,到恢复的时候,又产生了很多的归档吧?恢复到了备份时间点,然后往后推,从归档中继续恢复,直到异常前的状态
回复

使用道具 举报

千问 | 2015-5-19 13:15:06 | 显示全部楼层
你恢复的语句呢
回复

使用道具 举报

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

本版积分规则

主题

0

回帖

4882万

积分

论坛元老

Rank: 8Rank: 8

积分
48824836
热门排行