各位前辈好,小弟碰到一个这样的问题,急急急,就是数据库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掉该进程。
请各位前辈赐教!!