Oracle-L: RMAN-03015 error during TSPITR

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Tue, 16 Sep 2003 02:29:24 -0800
Message-ID: <F001.005D009B.20030916022924@fatcity.com>

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). Received on Tue Sep 16 2003 - 05:29:24 CDT