RMAN時間錯誤? RMAN-11001: Oracle Error: ORA-01861: literal does not match format string
RMAN基于時間的恢復,提示
RMAN-11001: Oracle Error: ORA-01861: literal does not match format string錯誤?
什么原因啊?
恢復命令如下:
run
{
set until time "to_date('2003-10-17:15:39:39','yyyy-mm-dd:hh24:mi:ss')";
shutdown immediate;
startup mount;
sql 'alter session set NLS_LANGUAGE=AMERICAN';
sql 'alter session set nls_date_format ="YYYY-MM-DD:HH24:MI:SS"';
allocate channel d1 type disk;
restore database;
recover database;
alter database open resetlogs;
}
錯誤提示:
RMAN-03022: 編譯命令: recover(3)
RMAN-03023: 執行命令: recover(3)
RMAN-08054: 啟動媒體復原
RMAN-08059: 媒體復原失敗
RMAN-03026: 復原釋放通道資源發生錯誤
RMAN-08031: 已釋放通道: d1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: recover
RMAN-03006: non-retryable error occurred during execution of command: recover(3)
RMAN-07004: unhandled exception during command execution on channel default
RMAN-20000: abnormal termination of job step
RMAN-11003: failure during parse/execution of SQL statement: alter database reco
ver if needed
start until time '10月 17 2003 15:39:39'
RMAN-11001: Oracle Error: ORA-01861: literal does not match format string