oracle执行成功以后需要comit,oracle恢复完成后报错

各位前辈好,小弟碰到一个这样的问题,急急急,就是数据库recover完毕,在alert日志已经提示完成,如下:

hncrm1app4:/oracle/app/admin/pild/bdump$>tail -f alert_pild.log

ORA-279 signalled during: alter database recover logfile '/usr/test/arc_1_5562_4598065.dbf '...

Tue Mar 11 13:39:47 2014

alter database recover logfile '/usr/test/arc_1_5563_4598067.dbf '

Tue Mar 11 13:39:47 2014

Media Recovery Log /usr/test/arc_1_5564_4598076.dbf

Tue Mar 11 13:50:04 2014

Incomplete Recovery applied until change 13897674432

Tue Mar 11 13:50:04 2014

Media Recovery Complete (pild )

Completed: alter database recover logfile '/usr/test/arc_1_5565_4598098.dbf'

我写的脚本如下:

hncrm1app4:/arch$>more test.sh

rman target /    log /usr/test.log  << EOF

run {

set archivelog destination to '/usr/test/';

recover database until time "to_date('2014-03-06 19','YYYY-MM-DD HH24')" ;

}

EOF

其中在/usr/test.log日志里也提示:

media recovery complete, elapsed time: 45:46:24

Finished recover at 11-MAR-14

但是奇怪的是他并没有终止,

而是一直在/usr/test.log继续写入:

media recovery complete, elapsed time: 45:46:24

Finished recover at 11-MAR-14

RMAN>

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01006: error signalled during parse

RMAN-00565: unable to read input file

LFI-01506: fflush() failed(OSD return value = 5).

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01006: error signalled during parse

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01006: error signalled during parse

就一直频繁的写入以下同样的错误:

RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-00558: error encountered while parsing input commands

RMAN-01006: error signalled during parse

使用ps -ef | grep rman

也能看到该rman target的进程,至直你手动kill掉该进程,

请问各位前辈这是什么原因??

而且不管我是restore database还是restore archive log,在完成restore以后释放通道然后也不停的写入上面那种错误,直至手动kill掉该进程。

请各位前辈赐教!!

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值