Hi,
My target instance is 9.2.0.4 on Host A ( Ms-win2k + SP3 ).
My recovery catalog is also 9.2.0.4 on Host B ( Ms-win2k + SP3 ).
My target destination for backup files is R:\ which resides
on Host C (WinNT).This drive R:\ is common to both Host A and B.
Things work fine accessing R:\ from both Host A and B.
I tried a TSPITR following the doc. 180436.1. It is for 8i.
Question #1: is it applicable for 9i also ?
If YES,
when i say (on Host A,the target),
run {
ALLOCATE AUXILIARY CHANNEL A1 TYPE DISK;
ALLOCATE CHANNEL c1 TYPE DISK;
recover tablespace users until time "TO_DATE('MAR-05-2002 11:27:00', 'MON-DD-YYYY
HH:MI:SS')";
}
i get the error below:
channel a1: starting datafile backupset restore
channel a1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF
released channel: a1
released channel: c1
RMAN-00571: ==========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============
RMAN-00571: ==========================================================
RMAN-03002: failure of recover command at 09/16/2003 17:48:32
RMAN-03015: error occurred in stored script Memory Script
ORA-19504: failed to create file "D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) Path not found.
Question #2:
db_file_name_convert=("d:\oracle\oradata\pe92","d:\oracle\oradata\aux92");
log_file_name_convert=("d:\oracle\oradata\pe92","d:\oracle\oradata\aux92");
why does RMAN try to restore SYSTEM01.DBF to
D:\ORACLE\ORA92\DATABASE\ ?
i have not mentioned this path anywhere in my recovery action.
Question #3:
though it is not restore path,why does RMAN's Memory script append ";\" in the path
i.e.,"D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF"
this is where it fails.
can someone explain me where the problem is ?
TIA.
Jp.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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).
