RMAN> recover database until time ‘2017-09-20 15:00:00’;http://www.cndba.cn/asker/article/2532http://www.cndba.cn/asker/article/2532

Starting recover at 20-SEP-17
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of recover command at 20/14/2017 22:49:54
ORA-01861: literal does not match format stringhttp://www.cndba.cn/asker/article/2532http://www.cndba.cn/asker/article/2532http://www.cndba.cn/asker/article/2532

这个错误是由于时间日期格式设置的问题。

[oracle@localhost ~]$ export NLS_DATE_FORMAT=’yyyy-mm-dd hh24:mi:ss’http://www.cndba.cn/asker/article/2532http://www.cndba.cn/asker/article/2532

RMAN> recover database until time ‘2017-09-20 15:00:00’http://www.cndba.cn/asker/article/2532

没有报错。

版权声明：本文为博主原创文章，未经博主允许不得转载。

ora-01861 NLS_DATE_FORMAT