| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RMAN error while TSPITR
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) yearmust 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
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: sona_us_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Wed Jan 30 2002 - 18:12:53 CST
 |
 |