Re: RMAN RESTORE TO NEW SERVER

From: Prasad <p4cldba_at_gmail.com>
Date: Fri, 8 Feb 2008 11:29:30 -0800
Message-ID: <666b99c70802081129i4941f623j639ff0c054f57a32@mail.gmail.com>


How if you try this

run{
ALLOCATE CHANNEL C1 DEVICE TYPE DISK FORMAT '\BACKUP_%U'; SET NEWNAME FOR DATAFILE 1 TO '.\SYSTEM01.DBF'; SWITCH DATAFILE 1;
}

On Fri, Feb 8, 2008 at 11:20 AM, Wolfson Larry - lwolfs < lawrence.wolfson_at_acxiom.com> wrote:

> Hi guys,
>
>
>
> I'm migrating a number of 9.2.0.1.0 32 &64 bit DBs to new
> servers with "rman"
>
> At some point we'll be upgrading them there.
>
>
>
>
>
> They asked me to rename all files to new naming (directory)
> standards.
>
> I'm not big "rman" user, but everything has gone well so far until I hit
> the largest DB.
>
>
>
> It's about 800G and at first only 500 was allocated.
>
> When it was pointed out we needed another 500 it was allocated but to
> another 500G directory.
>
>
>
> When doing the restore how can I get some files to go to the new FS?
>
> Or do I have to have them increase old FS?
>
>
>
> I've tried the SET NEWNAME command and when I run it it says it worked
> but the files always want to go to original place.
>
>
>
>
>
> RUN
>
> {
>
> SET NEWNAME FOR DATAFILE '/x/system01.dbf' TO '/y/system01.dbf' ;
>
> SWITCH DATAFILE ALL;
>
> }
>
>
>
> The others were easy. Just changed initora and moved controlfiles to new
> directory.
>
> Then ran
>
> ALTER DB RENAME (had linked old directories to new ones)
>
>
>
> Again this is 9.2.0.1.0.
>
>
>
> THX
>
> Larry
>
> *************************************************************************
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be
> legally privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any copy
> of it from your computer system.
>
> Thank you.
> *************************************************************************
>
>
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.5.516 / Virus Database: 269.19.18/1254 - Release Date:
> 1/31/2008 8:30 PM
>

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Feb 08 2008 - 13:29:30 CST

Original text of this message