Re: RMAN restore and the location backupset is different

"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<3f8fece7$0$4845$afc38c87_at_news.optusnet.com.au>...
> Domenic G. wrote:
>
> > Your toast ... if you use RMAN without a recovery catalog, it stores
> > the backup/recovery information in the controlfile -- you cannot use a
> > backup controlfile and expect it to work.
>
>
> The whole point of setting autobackup on, of course.
>
> Which our OP did.
>
> Therefore he is not toast.
>
> However, under no circumstances can a backup done to /bin/bong suddenly
> appear in /bing/bong and be expected to work.
>
> Sym links are the only way I know of to make this work.
>
> Regards
> HJR
Well, there's always hacking. But of course, symlinks are supported.

An interesting exercise is to examine the actual contents of the original controlfile. Make a copy of it with the OS, called, say xxx.  od -c xxx|grep "b o " (assuming your known backup dir is /bin/bong, and you don't have data files or arcs in a directory with bo in the path). This gives you most of the line numbers od would need, then you can od -c xxx|more , then slash to search for the first of those line numbers, then you can see the ASCII path encoded in the controlfile.

So one can guess that the restored controlfile from the backupset has this same directory in it. I would go further and say that RMAN ought to be able to change it during a restore or duplicate, and if there is indeed still a lack of such ability, it is an obvious design flaw.

And for those to whom it is not obvious, don't try to edit a controlfile on a running system :-O

>
>
>
>
> >
> > Domenic.
> >
> > hvcao_vn_at_yahoo.com (Vinh) wrote in message
> > news:<d387a07.0310152350.2f60eebc_at_posting.google.com>...
> >> RMAN restore and the location backupset is different
> >>
> >> Hi,
> >> Here is scenario:
> >> - RDBMS: 9.2.0.3
> >> - rman backup using controlfile (no catalog db)
> >> - Rman backup with CONTROLFILE AUTOBACKUP ON and backup set was
> >> pointed to /prod/prod_backup.bk of prod server.
> >> - ftp the auto control file backupset and databse backupset to /uat of
> >> uat server.
> >> - Proceed restore database on uat node
> >> - Succeed restore control file using:
> >> RMAN> restore controlfile from '/u02/control_backup.bk'
> >>
> >> - However, I can not restore database, I receive message
> >> ORA-19505: "failed to identify file '/prod/prod_backup.bk'."
> >>
> >> Anybody know how to update for rman to know my new backupset location
> >> (as now it's in /uat/prod_backup.bk)?
> >>
> >> Note: I don't want to use soft link on this case.

jg

--
@home.com is bogus.
http://www.signonsandiego.com/news/uniontrib/tue/business/news_1b21kodak.html