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:. Set you ORACLE_SID which will be the target and try again.
HTH, Ruth p.s I do not have any databases on Windows so I am not sure how to set the SID. -----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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini 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).
