SQL> recover database until time '2013-03-26 05:00:00';
ORA-00283: recovery session canceled due to errors
ORA-19907: recovery time or SCN does not belong to recovered incarnation
这个错误又是这么回事?
recover database;完全恢复,自动会去读归档日志及当前的在线联机日志,恢复到当前时间
recover database until time 'yyyy-MM-dd HH:mm:ss';基于时间的不完全恢复。先拿备份集(restore)再做不完全恢复(recover until....)
SCOTT@>ho oerr ora 19907
ho oerr ora 19907
19907, 00000, "recovery time or SCN does not belong to recovered incarnation"
// *Cause: A point-in-time recovery to an SCN or timestamp prior to the last
// resetlogs was requested.
// *Action: Either change the specified recovery time/scn, or
//
change the recovery destination using RMAN's RESET DATABASE
//
command.
Extremeways 发表于 2013-3-26 20:53
SCOTT@>ho oerr ora 19907
ho oerr ora 19907
19907, 00000, "recovery time or SCN does not belong to...
先需要清楚exp 与RMAN的概念; 再做实验.