RE: RMAN RESTORE TO NEW SERVER
Date: Fri, 8 Feb 2008 16:19:33 -0600
Message-ID: <7ED53A68952D3B4C9540B4EFA5C76E360431E2A8@CWYMSX04.Corp.Acxiom.net>
Larry, this format has always worked for me:
SET NEWNAME FOR DATAFILE 39 TO '/<mntpoint>/oradata/<SID>/<file name>.dbf';
It requires you've got each datafile file_id ahead of time, but as I said, it's always worked for me.
Dave
Dave Herring, DBA | A c x i o m M I C S / C S O 630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Wolfson Larry - lwolfs Sent: Friday, February 08, 2008 1:21 PM
To: ORACLE-L
Subject: RMAN RESTORE TO NEW SERVER
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.
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 08 2008 - 16:19:33 CST