Ruth, >Set you ORACLE_SID which will be the target and try again.
c:> set ORACLE_SID=AUX92 AUX92 is the name of my auxiliary instance on Host A ( target host ). c:> rman target [EMAIL PROTECTED] catalog [EMAIL PROTECTED] auxiliary sys trace=c:\tspitr.log where "PE92" is the target on same Host A and "LAT92" is my recovery catalog on a diff. host. This is what metalink doc. 180436.1 says: "rman target sys/[EMAIL PROTECTED] catalog rman/[EMAIL PROTECTED] auxiliary / trace=d:\tspitr.log" >It looks like you don't have your ORACLE_SID specified correctly since, if I >read this correctly, the database you are trying to restore is on dick c:. my target database is in d:\oracle\ but even then where did this path come from ?? ORA-19504: failed to create file "D:\ORACLE\ORA92\DATABASE\;\SYSTEM01.DBF" those ;\ in the path look strange and wonder oracle appends that ?? any clues Ruth.just stuck up here and not able to proceed further. i tried it repeatedly. Thanx once again. Jp. > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of > Prem Khanna J > Sent: Tuesday, September 16, 2003 10:35 PM > To: Multiple recipients of list ORACLE-L > Subject: RMAN error - can someone help ? > > > 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).