Re: Rman Question

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 Received on Tue Dec 02 2008 - 12:35:31 CST