Sujatha, I tried doing that but it failed
Set the NLS_DATE_FORMAT="DD-MON-YYYY HH24:MI:SS" at OS level. RMAN script is run { set until time '30-JAN-2002 14:53:56'; allocate clone channel c1 type disk; allocate clone channel c2 type disk; set newname for datafile 3 to '/ora/data01/bkuptest/clone/admin.1.dbf'; recover tablespace admin; } RMAN-03022: compiling command: set RMAN-03022: compiling command: allocate RMAN-03026: error recovery releasing channel resources RMAN-00571: =========================================================== RMAN-00569: =====ERROR MESSAGE STACK FOLLOWS RMAN-00571: =========================================================== RMAN-03002: failure during compilation of command RMAN-03013: command type: allocate RMAN-06136: ORACLE error from auxiliary database: ORA-01858: a non-numeric character was found where a numeric was expected RMAN-06097: text of failing SQL statement: select to_date('30-JAN-2002 14:53:56') from sys.dual RMAN-06099: error occurred in source file: krmk.pc, line: 4354 Am I missing something? I also set the nls_date_format for the target database to DD-MON-YYYY HH24:MI:SS Sona ----- Original Message ----- To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, January 31, 2002 3:40 PM > Sona, > > Try setting the NLS_DATE_FORMAT="DD-MON-YYYY 24HH:MI:SS" at the OS level. > > Then in your RMAN script you should specify the point in time date as > follows: > > set until time '31-JAN-2002 23:05:00'; > > It should work (I've tested it). > > Regards, > > Sujatha > > -----Original Message----- > Sent: Friday, 1 February 2002 9:50 AM > To: Multiple recipients of list ORACLE-L > > > What do i set the NLS_DATE_FORMAT as? I tried setting it as > export NLS_DATE_FORMAT=MON DD YYYY HH24:MI:SS > > But got this error : > ksh: HH24:MI:SS: is not an identifier > > Setting it to export NLS_DATE_FORMAT=MON-DD-YYYYHH24:MI:SS worked but i > still get the same error. > > > > Sona > > > > > ----- Original Message ----- > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, January 31, 2002 10:38 AM > > > IIRC the manuals suggest that you set NLS_DATE_FORMAT anyway. > > Jared > > > > > > [EMAIL PROTECTED] > Sent by: [EMAIL PROTECTED] > 01/30/02 11:45 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject: Re: RMAN error while TSPITR > > > > > Hi, > > I had problems duplicating to a point in time and the workaround was to > set > the nls_date_format on OS level > so I started my script with export NLS_DATE_FORMAT=<format mask> and that > fixed my problem > > > Jack > > > > > > "Sona" <[EMAIL PROTECTED]>@fatcity.com on 31-01-2002 01:11:30 > > Please respond to [EMAIL PROTECTED] > > Sent by: [EMAIL PROTECTED] > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) > > Hi, > I encountered the following error while performing TSPITR using RMAN > Below is the script being executed > run > { > allocate channel c1 type disk; > set newname for datafile 3 to '/ora/data01/test/clone/admin.1.dbf'; > recover tablespace admin until time "to_date('JAN 30 2002 14:53:56','MON > DD > YYYY HH24:MI:SS')"; > } > > Teh error stack is as follows > > RMAN-03022: compiling command: allocate > RMAN-03023: executing command: allocate > RMAN-08030: allocated channel: c1 > RMAN-08500: channel c1: sid=9 devtype=DISK > > RMAN-03022: compiling command: set > > RMAN-03022: compiling command: recover > > RMAN-03027: printing stored script: Memory Script > { > # set the until clause > set until time 'JAN 30 2002 14:53:56'; > # restore the controlfile > restore clone controlfile to clone_cf; > # replicate the controlfile > replicate clone controlfile from clone_cf; > # mount the controlfile > sql clone 'alter database mount clone database'; > # archive current online log for tspitr to a resent until time > sql 'alter system archive log current'; > # resync catalog after controlfile restore > resync catalog; > } > RMAN-03021: executing script: Memory Script > > RMAN-03022: compiling command: set > > RMAN-03022: compiling command: restore > > RMAN-03022: compiling command: IRESTORE > RMAN-03026: error recovery releasing channel resources > RMAN-08031: released channel: c1 > RMAN-00571: =========================================================== > RMAN-00569: ======= ERROR MESSAGE STACK FOLLOWS============ > RMAN-00571: =========================================================== > RMAN-03002: failure during compilation of command > RMAN-03013: command type: recover > RMAN-03015: error occurred in stored script Memory Script > RMAN-03002: failure during compilation of command > RMAN-03013: command type: restore > RMAN-03002: failure during compilation of command > RMAN-03013: command type: IRESTORE > RMAN-06136: ORACLE error from auxiliary 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('JAN 30 2002 > 14:53:56') from sys.dual > RMAN-06099: error occurred in source file: krmk.pc, line: 4354 > > NLS_DATE_FORMAT is set to MON DD YYYY HH24:MI:SS for the target database. > I even tried this but got the same error. > > run > { > set until time '30-JAN-2002 14:53:56'; > allocate channel c1 type disk; > set newname for datafile 3 to '/ora/data01/bkuptest/clone/admin.1.dbf'; > recover tablespace admin; > release channel c1; > } > > Any ideas about this one? > TIA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sona > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > > ================================================================== > De informatie verzonden in dit e-mailbericht is vertrouwelijk en is > uitsluitend bestemd voor de geadresseerde. Openbaarmaking, > vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan > derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & > Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en > volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch > voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een > verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten > worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. > > Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u > vriendelijk doch dringend het e-mailbericht te retourneren aan de > verzender > en het origineel en eventuele kopieën te verwijderen en te vernietigen. > > Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene > voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De > algemene voorwaarden worden u op verzoek kosteloos toegezonden. > ===================================================================== > The information contained in this communication is confidential and is > intended solely for the use of the individual or entity to whom it is > addressed. You should not copy, disclose or distribute this communication > without the authority of Ernst & Young. Ernst & Young is neither liable > for > the proper and complete transmission of the information contained in this > communication nor for any delay in its receipt. Ernst & Young does not > guarantee that the integrity of this communication has been maintained nor > that the communication is free of viruses, interceptions or interference. > > If you are not the intended recipient of this communication please return > the communication to the sender and delete and destroy all copies. > > In carrying out its engagements, Ernst & Young applies general terms and > conditions, which contain a clause that limits its liability. A copy of > these terms and conditions is available on request free of charge. > =================================================================== > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sona > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sujatha Madan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > -------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sona INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).