Rman Question

On Dec 1, 10:19 pm, mrdjmag....RemoveThis@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 free http://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?
 >> Stay informed about: Rman Question 

On Dec 2, 9:48 am, hpuxrac wrote:
> On Dec 1, 10:19 pm, mrdjmag... DeleteThis @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?


Thanks for all your help. We are running 10gR2. We do not know
exactly when the error occurred, sometime within the last 2 weeks.
So, we figure we restore a copy from 2 weeks ago and roll forward and
start checking as we go........

What about getting the archive logs and mining them? Can that be done
to tell us exactly when and how it happened?

As far as duplicating the database. Are you suggesting we duplicate
it on a different server, then recover it the duplicated one?

Thanks!
 >> Stay informed about: Rman Question 

On Dec 2, 9:48 am, hpuxrac wrote:
> On Dec 1, 10:19 pm, mrdjmag....RemoveThis@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!
 >> Stay informed about: Rman Question 

Comments embedded.

On Dec 1, 9:19 pm, mrdjmag....RemoveThis@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.  

What 'problem'? Why do you feel a need to restore a copy on a
different server? You haven't provided much in the way of useful
information for others to use in their attempts to assist you. Please
provide more detail on this operation so others can have a decent
starting point.

> So, I figure I can restore
> the earilest copy, and if that is not it, restore the next full
> backup......
>

If the 'problem' exists in the earliest copy then any subsequent copy
will be no better. One presumes you're looking for a backup where
this 'problem' hasn't yet occurred..

> 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.......

Then you visit

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupd...tm#i100

and start reading. You should also read here:

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14194/rcmsynt...1.htm#R

Look for the section named "Identifying Needed Backups with RESTORE...
PREVIEW: Example".



David Fitzjarrell
 >> Stay informed about: Rman Question 

On Dec 2, 10:17 am, "ame...@iwc.net" wrote:
> On Dec 2, 9:48 am, hpuxrac wrote:
>
>
>
>
>
> > On Dec 1, 10:19 pm, mrdjmag... DeleteThis @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/rcmdupd...tm#i100

Reading the documentation would have answered these questions for you.


David Fitzjarrell
 >> Stay informed about: Rman Question 

On Dec 2, 10:33 am, ddf wrote:
> On Dec 2, 10:17 am, "ame...@iwc.net" wrote:
>
>
>
> > On Dec 2, 9:48 am, hpuxrac wrote:
>
> > > On Dec 1, 10:19 pm, mrdjmag... RemoveThis @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.......
 >> Stay informed about: Rman Question 

On Dec 2, 10:38 am, "ame...@iwc.net" wrote:
> On Dec 2, 10:33 am, ddf wrote:
>
>
>
>
>
> > On Dec 2, 10:17 am, "ame...@iwc.net" wrote:
>
> > > On Dec 2, 9:48 am, hpuxrac wrote:
>
> > > > On Dec 1, 10:19 pm, mrdjmag....TakeThisOut@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
 >> Stay informed about: Rman Question 

On Dec 2, 10:44 am, ddf wrote:
> On Dec 2, 10:38 am, "ame...@iwc.net" wrote:
>
>
>
> > On Dec 2, 10:33 am, ddf wrote:
>
> > > On Dec 2, 10:17 am, "ame...@iwc.net" wrote:
>
> > > > On Dec 2, 9:48 am, hpuxrac wrote:
>
> > > > > On Dec 1, 10:19 pm, mrdjmag....RemoveThis@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!
 >> Stay informed about: Rman Question 

On Dec 2, 10:44 am, ddf wrote:
> On Dec 2, 10:38 am, "ame...@iwc.net" wrote:
>
>
>
> > On Dec 2, 10:33 am, ddf wrote:
>
> > > On Dec 2, 10:17 am, "ame...@iwc.net" wrote:
>
> > > > On Dec 2, 9:48 am, hpuxrac wrote:
>
> > > > > On Dec 1, 10:19 pm, mrdjmag....RemoveThis@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???
 >> Stay informed about: Rman Question 

On Tue, 2 Dec 2008 10:25:29 -0800 (PST), mrdjmagnet DeleteThis @aol.com wrote:

>On Dec 2, 10:44 am, ddf wrote:
>> On Dec 2, 10:38 am, "ame...@iwc.net" wrote:
>>
>>
>>
>> > On Dec 2, 10:33 am, ddf wrote:
>>
>> > > On Dec 2, 10:17 am, "ame...@iwc.net" wrote:
>>
>> > > > On Dec 2, 9:48 am, hpuxrac wrote:
>>
>> > > > > On Dec 1, 10:19 pm, mrdjmag... DeleteThis @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
 >> Stay informed about: Rman Question 

On Tue, 02 Dec 2008 08:09:20 -0800, amerar DeleteThis @iwc.net wrote:

> As far as duplicating the database. Are you suggesting we duplicate it
> on a different server, then recover it the duplicated one?
>
> Thanks!

How about something like this:

connect target sys/qwerty@test11
connect auxiliary /
run {
allocate channel c0 device type disk;
allocate auxiliary channel aux device type disk;
duplicate target database for standby;
}

The output looks something like this:

executing command: SET NEWNAME

executing command: SET NEWNAME

connect target sys/qwerty @test11
executing command: SET NEWNAME

executing command: SET NEWNAME


executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting restore at 05-DEC-08

channel aux: starting datafile backup set restore
channel aux: specifying datafile(s) to restore from backup set
channel aux: restoring datafile 00001 to /oradata/test11/data/STBY11/
datafile/o1_mf_system_%u_.dbf
channel aux: restoring datafile 00002 to /oradata/test11/data/STBY11/
datafile/o1_mf_sysaux_%u_.dbf
channel aux: restoring datafile 00003 to /oradata/test11/data/STBY11/
datafile/o1_mf_undotbs1_%u_.dbf
channel aux: restoring datafile 00004 to /oradata/test11/data/STBY11/
datafile/o1_mf_users_%u_.dbf
channel aux: restoring datafile 00005 to /oradata/test11/data/STBY11/
datafile/o1_mf_test_%u_.dbf
channel aux: reading from backup piece /backup/db_0gk1dstt_1_1.bak

BTW, this is a test config, not allowed to register in catalog. This is
not really complicated. You can go to Amazon.com and search for "Robert
G. Freeman". One of the results will probably be this one:

http://tinyurl.com/6jq5eh


Click on the "add to shopping cart" button and follow the instructions.

--
Mladen Gogala
http://mgogala.freehostia.com
 >> Stay informed about: Rman Question