Re: RMAN point in time recovery error ORA-01830

Hi,
You will get thîs error from a unix script unless you export the nls_date_format first. Best is to put it into the same script you run the rman script from.

so in your shell script just
export NLS_DATE_FORMAT= 'DD-Mon-yyyy HH24:MI:SS'

regards
Kelvin

In article <01bde884$936a5b70$360baa0a_at_ictltgclark>,   "Greg C." <gdclark_at_southwind.net> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 01 1998 - 10:22:57 CDT