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: Question on RMAN Restore into another server having different file structure

Re: Question on RMAN Restore into another server having different file structure

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Mon, 16 Apr 2007 22:34:51 +0100
Message-ID: <7765c8970704161434l5210a497gf55348e6b03bc082@mail.gmail.com>


Hi anurag

this is covered in the RMAN docs. You have a number of choices

  1. use set newname
  2. use db_file_name_convert initialization parameter

On 4/15/07, Anurag Verma <anuragdba_at_gmail.com> wrote:
>
>
> I have an Oracle 9.2.0.7 database in Server ABC.
>
> The 9.2.0.7 database has to be restored into server XYZ which has same
> 9.2.0.7 installation except the directory structures are different in this
> server.
>
> e.g., Datafiles in the source server are in /u01/ORACLE/ and
> /u02/ORACLE/ and the directory in which datafiles will be stored in XYZ
> Server is /opt/oracle/admin/<database>/datafile/
>
>
> So if I am using RMAN, how can I restore the database files into a
> different directory structure in XYZ Server?
>
> Anurag
>
>
>
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 16 2007 - 16:34:51 CDT

Original text of this message

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