Re: Rman Question

From: <amerar_at_iwc.net>
Date: Tue, 2 Dec 2008 08:53:36 -0800 (PST)
Message-ID: <2bc2033a-27d9-489c-a334-8c805db65f44@v42g2000yqv.googlegroups.com>


On Dec 2, 10:44 am, ddf <orat..._at_msn.com> wrote:
> On Dec 2, 10:38 am, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
>
>
>
> > On Dec 2, 10:33 am, ddf <orat..._at_msn.com> wrote:
>
> > > On Dec 2, 10:17 am, "ame..._at_iwc.net" <ame..._at_iwc.net> wrote:
>
> > > > On Dec 2, 9:48 am, hpuxrac <johnbhur..._at_sbcglobal.net> wrote:
>
> > > > > On Dec 1, 10:19 pm, mrdjmag..._at_aol.com wrote:
>
> > > > > > I need to restore a copy of our database on a different server.  I
> > > > > > have full backups going back 4 weeks plus cumulative backups.
>
> > > > > > I'm not sure where the problem happened.  So, I figure I can restore
> > > > > > the earilest copy, and if that is not it, restore the next full
> > > > > > backup......
>
> > > > > > Anyhow, I am looking for some decent documentation that will tell me
> > > > > > the best way to restore the database onto a new server as well as
> > > > > > choosing which incarnation of the database I want to restore.......
>
> > > > > Well the oracle rman documentation ( available freehttp://tahiti.oracle.com
> > > > > is one place ) is pretty comprehensive in this area.
>
> > > > > Just make sure that you are looking at documentation that matches the
> > > > > same version of oracle and same version of rman that you are going to
> > > > > be using.
>
> > > > > Robert Freeman among others has some pretty good books out in this
> > > > > area.
>
> > > > > It may be best to sit and read for a while before jumping in with a
> > > > > half formed plan of attack.
>
> > > > > If there are "specific" questions ... well fire away.  It makes many
> > > > > of us nervous though when people start throwing in terms like
> > > > > incarnation where it sounds like they might have some idea of recovery
> > > > > related concepts ... but also include questions about ( relatively )
> > > > > basic procedures like restoring on a different server.  Is there any
> > > > > reason you wouldn't want to restore the current incarnation in other
> > > > > words?
>
> > > > Hi,
>
> > > > Sorry for posting twice, but I found out some more info.   We do have
> > > > a test server.  However, the volume names are different.  On our
> > > > production server the volume names are /u01 - /u05.   On the test
> > > > server they are /u11 - /u15.   I assume that because of this a restore
> > > > is not possible???
>
> > > > Thanks!- Hide quoted text -
>
> > > > - Show quoted text -
>
> > > You are incorrect, as you can use the SET NEWNAME command in RMAN to
> > > rename the files as they are written:
>
> > >http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdup...
>
> > > Reading the documentation would have answered these questions for you.
>
> > > David Fitzjarrell
>
> > Ok, our production database is running on SERVER 1, we obviously
> > cannot restore there because the database is up, running, providing
> > data to our website, etc.
>
> > So I figure we can restore to a test server, go in, get the data that
> > was lost, and put it into our production database.  That is pretty
> > simple in terms of what we want to do.  Restore it elsewhere so we do
> > not disturb the production copy and retrieve the lost data.
>
> > Only issue is that the test server has slightly different mount point
> > names.......
>
> > So, is there a way to do this?  I thought I read something that you
> > can rename stuff and tell RMAN where it is.......- Hide quoted text -
>
> > - Show quoted text -
>
> You don't visit links and read the information provided, apparently,
> as the link in my post shows you how to do this.
>
> I'd visit the page and read.
>
> David Fitzjarrell

I had read several RMAN documentations. I did not see this one, sorry.

But, looking at it, I'm just curious of what my best, or possible, approach is. It says I can rename duplicate files. But because the file in question is in the past, I'm not sure if this can be done as the SCN is different. So, they must be referring to restoring an entire database, renaming all the duplicate datafiles, onto the same server or a remote server........is that correct?

And in our case, since we will put it on a remote server with an empty test database (no files, just Oracle) and a different file structure, we can restore to the remote host using the SET NEWNAME operation to take case of the different paths. Right?

This is the first time we've ever had to do this, so we really cannot afford to mess things up, which is why I'm looking for a bit of help from others who may have done this before.

Thanks! Received on Tue Dec 02 2008 - 10:53:36 CST

Original text of this message