|
Re: [Networker] Timestamps for recovered Oracle files?
2006-10-20 15:10:11
Ah you must be running 10G. I
tried the same and got an error also.
RMAN> run
2> {
3> set until time 'Oct 16 2006 21:00:00';
4> }
executing command: SET until clause
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of set command at 10/20/2006 14:16:01
ORA-01858: a non-numeric character was found where a numeric was expected
But not in 9i
connected to target database: QCOE1 (DBID=1536254558)
connected to recovery catalog database
RMAN> run {
2> set until time "Oct 16 2006 21:00:00";
3> }
executing command: SET until clause
But using the following syntax I got it to work in 10G as well.
You might try this.
RMAN> RMAN> run {
2> set until time "to_date('10/16/2006 09:00 PM','mm/dd/yyyy hh:mi
am')";
3> }
executing command: SET until clause
|
|
|
