Re: Rman Question

On Dec 2, 12:35 pm, ddf <orat..._at_msn.com> wrote:
> On Dec 2, 12:25 pm, mrdjmag..._at_aol.com wrote:
>
>
>
> > 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
>
> > David,
>
> > You seem to know a lot about this.
>
> > We backup every night with RMAN.  A weekly (incremental level 0) is
> > done every Sunday.  We do not use a recovery catalog, we use our
> > control file.
>
> > However, how can this be explained???
>
> > RMAN> LIST INCARNATION OF DATABASE NI00;
>
> > using target database control file instead of recovery catalog
>
> > List of Database Incarnations
> > DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset
> > Time
> > ------- ------- -------- ---------------- --- ---------- ----------
> > 1       1       NI00     3577991968       CURRENT 1          17-NOV-07
>
> > I do not understand?  Why only 1 incarnation???- Hide quoted text -
>
> > - Show quoted text -
>
> Each time you open the database in the following manner:
>
> SQL> alter database open resetlogs;
>
> you create a new incarnation of the database.  You, apparently, have
> not opened the database in that manner, thus there is only one
> incarnation.
>
> David Fitzjarrell

I see you can do a 'test' restore. We can try that and see if everything will work....... Received on Tue Dec 02 2008 - 13:06:03 CST