Re: Changing DBID

On Jul 10, 2:32 pm, joel garry <joel-ga..._at_home.com> wrote:
> On Jul 10, 11:09 am, Chuck <chuckh1958_nos..._at_gmail.com> wrote:
>
>
>
>
>
> > joel garry wrote:
> > >> Not the same as the source of the copy, but I want the destination of
> > >> the copy to have the same DBID after the duplication as it had before.
>
> > > That is a strange want, as you are saying you want to restore backups
> > > that cannot apply.  If you are duping from another db, why do you
> > > think you should be able to use backups from before the dupe?
> > > Recovery is based on transactions.  The transactional chain is broken
> > > as far as those backups are concerned.
>
> > And why can't I apply them? Anything in the rman catalog can be restored
> > even after a dupe. I'd just be restoring to a point in time before the
> > dupe. As stated in an earlier posting in this thread, this is a TEST
> > database and only gets cold backups. No recovery would be necessary.
>
> > In my specific case I have no intentions of ever restoring the old
> > backups. I just want to delete them with a "delete obsolete" command.
> > But since duplication changes the dbid, "delete obsolete" will not work
> > on those pre-duplication backups and they sit forever in both the rman
> > catalog and the MML.
>
> I'm wondering if this may answer your delete question, at least for
> the catalog:  http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmcat...
> Also see unregister:http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmcat...
>
> And a gentle reminder, it is often better to state what you are aiming
> for, as well as what you have tried, then just ask how to do something
> specific which may or may not be what you really want.
>
> jg
> --
> @home.com is bogus.http://forums.oracle.com/forums/profile.jspa?userID=571114- Hide quoted text -
>
> - Show quoted text -

I agree with Joel. His recommendation would be the better approach.

• Mark D Powell --