Re: RMAN NEWNAME FEATURE

From: joel garry <joel-garry_at_home.com>
Date: Tue, 27 Jan 2009 10:33:34 -0800 (PST)
Message-ID: <6059d796-bb2c-4dc0-a715-69707a57816b_at_w1g2000prk.googlegroups.com>



On Jan 27, 7:28 am, p..._at_paulpowell.plus.com wrote:
> We have recently upgrade one of our systems to a new server which has
> a different file structure in both location and size.
>
>  Is there a way to split a single datafile over many datafiles when
> using RMAN clone features.
>
> For Example
>
> Source file INDEX_01.dbf size 20GB
>
> Destination file(s) INDEX_01.dbf size 10GB and INDEX_02.dbf size 10GB
>
> RUN
>
> {
>
> set newname for datafile 1 to 'e:\Oracle\oradata\INDEX_01.DBF','e:
> \Oracle\oradata\INDEX_02.DBF';
>
> }
>
> Many Thanks for all your advice.

RMAN is a physical backup, so won't make a structural change like this. You either need to use logical backups or make the change before or after the clone. You may want to specify tablespaces with create index to control where things go.

jg

--
_at_home.com is bogus.
stupid now or stupid later.
http://media.www.thelantern.com/media/storage/paper333/news/2009/01/27/Campus/Marijuana.Could.Prevent.Alzheimers-3598061.shtml
Received on Tue Jan 27 2009 - 12:33:34 CST

Original text of this message