Oracle-L: RE: RMAN error - can someone help ?

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Wed, 17 Sep 2003 05:54:40 -0800
Message-ID: <F001.005D0393.20030917055440@fatcity.com>

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: ml-errors_at_fatcity.com [mailto:ml-errors_at_fatcity.com]On 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: jprem_at_kssnet.co.jp

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Ruth Gramolini
INET: rgramolini_at_tax.state.vt.us

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------