Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> RMAN point in time recovery error ORA-01830

RMAN point in time recovery error ORA-01830

From: Greg C. <gdclark_at_southwind.net>
Date: 25 Sep 1998 12:58:45 GMT
Message-ID: <01bde884$936a5b70$360baa0a@ictltgclark>


Can someone please help me with this. I contacted Oracle about this 2 days ago and they dont have a clue. my nls_date_format = DD-Mon-yyyy hh24:mi:ss.
You can reach me by email - gdclark_at_southwind.net

Here is the rman script and its error messages.

8> run {
9> allocate channel d1 type disk;

10> set until time '23-sep-1998 13:03:00';
11> restore database;
12> recover database;
13> sql "alter database open resetlogs";
14> release channel d1;
15> }
16>
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: d1
RMAN-08500: channel d1: sid=10 devtype=DISK
RMAN-03022: compiling command: set
RMAN-03026: error recovery releasing channel resources
RMAN-08031: released channel: d1
RMAN-00569: ================error message stack follows================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: set
RMAN-06003: ORACLE error from target database: ORA-01830: date format
picture ends before converting entire input string Received on Fri Sep 25 1998 - 07:58:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US