Re: Rman Question

On Tue, 2 Dec 2008 10:25:29 -0800 (PST), mrdjmagnet_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???

David 'knows a lot about this' as he contrary to most posters here isn't lazy and *does* read documentation. By default the database will have 1 incarnation. You'll get a new incarnation everytime you open the database with resetlogs. And yes, this is documented in the RMAN documentation you refuse to read.

-- 

Sybrand Bakker
Senior Oracle DBA