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).
