RMAN 8i and NLS_DATE_FORMAT

From: BD <bobby_dread_at_hotmail.com>
Date: 5 Aug 2005 14:54:33 -0700
Message-ID: <1123278873.651416.62840@g49g2000cwa.googlegroups.com>

Hey, all.

Shockingly, RMAN (8.1.7.4 on AIX 5.2) is still refusing to give up all its secrets.

I am working on TSPITR.

I have created the auxiliary instance, and am able to connect to it with the RMAN connect string.

and tried a tablespace restore up to a certain point. Frustration is that RMAN continually balks at me about the year being out of range.

Here is my process to this point:

• My line from init.ora in both TARGET and AUX dbs: nls_date_format = "YYYY-MM-DD HH24:MI:SS"
• at OS prompt: set nls_date_format = "YYYY-MM-DD HH24:MI:SS"
• From SQLPLUS: NOSID> alter session set nls_date_format='YYYY-MM-DD HH24:MI:SS'; Session altered.

NOSID> select to_date('2005-08-05 20:00:01') from sys.dual;

TO_DATE('2005-08-05

---

2005-08-05 20:00:01

• This is all looking okay...****
• From RMAN: run {allocate auxiliary channel dev1 type disk;sql "alter session set nls_date_format=''YYYY-MM-DD HH24:MI:SS''"; recover tablespace small_tables_2 until time '2005-08-05 20:00:01';}

RMAN-06003: ORACLE error from target database: ORA-01841: (full) year must be between -4713 and +9999, and not be 0 RMAN-06097: text of failing SQL statement: select to_date('AUG 05 2005 20:00:01') from sys.dual

• So - where is rman getting that date format from?? ****

I expect this is not complicated (for those many who know RMAN well), but I tell ya - wading through this for the first time is getting a little bit deflating.

Thanks for all feedback, as always.

BD Received on Fri Aug 05 2005 - 16:54:33 CDT