export ORACLE_SID=aaa
rman target /catalog rman/rman@rman
recover database until time '2007-06-14 19:00:00'
报错:
ORA-01861: literal does not match format string
运行
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
recover database until time '2007-06-14 19:00:00'
仍然报错:
ORA-01861: literal does not match format string
什么原因?环境变量我设置!
aix +oracle10g
最初由 tiegang_zhang 发布
[B]export ORACLE_SID=aaa
rman target /catalog rman/rman@rman
recover database until time '2007-0614 19:00:00'
报错:
ORA-01861: literal does not match format string
运行
export NLS_DATE_FORMAT='yyyy-mm-dd hh24:mi:ss'
recover database until time '2007-0614 19:00:00'
仍然报错:
ORA-01861: literal does not match format string
什么原因?环境变量我设置!
aix +oracle10g [/B]
recover database until time '2007-0614 19:00:00'
'2007-0614 19:00:00' 错误
在RMAN环境中应用下面的语句进行设置:
RMAN> set until time "to_date('','YYYY-MM-DD HH24:MI:SS')";
然后再进行数据的转储和恢复工作,如:
RMAN> restore database;
RMAN> recover database;
RMAN> sql 'alter database open resetlogs';