Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: RE: RMAN error - can someone help ?

Re: RE: RMAN error - can someone help ?

From: Prem Khanna J <jprem_at_kssnet.co.jp>
Date: Wed, 17 Sep 2003 06:34:42 -0800
Message-ID: <F001.005D0398.20030917063442@fatcity.com>


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 bkadmin_at_pe92 catalog rman_at_lat92 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/password_at_target catalog rman/rman_at_rcat 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: 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).
Received on Wed Sep 17 2003 - 09:34:42 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US