Re: Restoring RMAN backed up archivelogs, datafiles

On Sep 12, 12:18 am, trub3101 <mich..._at_bassline01.wanadoo.co.uk> wrote:
> On 10 Sep, 23:05, joel garry <joel-ga..._at_home.com> wrote:
>
>
>
> > On Sep 10, 5:15 am, trub3101 <mich..._at_bassline01.wanadoo.co.uk> wrote:
>
> > > Hi Guru's
>
> > > Basically, I just need to know whether it is possible to restore data
> > > backed by RMAN to a database/server other than the database/server it
> > > was backed up from.
>
> > > I ask for two reasons really:
>
> > > Archivelogs
> > > I have two Standby database instances which have stopped working for
> > > one reason or another I now have a lag in the transported archivelog
> > > files.
>
> > > Can I restore the archivelogs from my RMAN backups of the Primary
> > > databases to the Standby? If so, how is this done?
>
> > > Please bear in mind that the Primary databases reside on a different
> > > server to their respective Standby databases. I know that I can just
> > > FTP the files across but I would like to know if this is possible
> > > using RMAN.
>
> > > Restore to Dev database
> > > Can I restore the RMAN backup to another database other than the
> > > database it was backed up from?
>
> > > For example we have a development database (DEV) that needs
> > > refreshing. Can I use the RMAN backup of LIVE to do the refresh?
>
> > > As earlier the databases reside on different servers. Here are the
> > > data files.
>
> > > Cheers
>
> > > TB3101
>
> > > LIVE Data Files
>
> > It is really important to provide versions, configurations and exactly
> > what you want to do. Certain answers vary. For example, if you are
> > using nocatalog and have taken more recent backups than the ones that
> > have the desired archived logs, in O8 (IIRC) you can play games with
> > crosscheck to fool Oracle, in 10g I think you can use an equivalent of
> > the catalog registration commands, but in O9 you have to use a bunch
> > of undocumented API's and comb painstakingly through RMAN logs to say
> > exactly which backup piece the archived logs are in (see metalink
> > Note: 60545.1, which is unpublished and you have to ask support).
>
> > If you are using a catalog it may simply be a matter of telling RMAN
> > the pieces are available and extracting the logs to whereever you
> > desire, there might even be examples in the docs (I haven't looked
> > lately, but seem to recall seeing them).
>
> > jg
> > --
> > @home.com is bogus.
> > Too many classic quotes to pick just one:http://www.signonsandiego.com/uniontrib/20070910/news_1n10bkmoney.html-Hide quoted text -
>
> > - Show quoted text -
>
> Thanks for all your replys,
>
> Daniel is absolutely right of course I should have provide versions,
> configurations, etc., just for the record the configuration for both
> servers is:
>
> Operating Sys: Solaris 9
> Database: Oracle 9.2.0.1.0
> RMAN is using a catalog however the Development database is not
> registered in the catalog.
>
> Joel, I am not actually trying to recreate a standby database just try
> to restore and recover datafiles to a development DB on another
> server.

I think you got it the wrong way around :) Joel was absolutely right about versions and Daniel's answer was irrelevant to your question.

> Thanks again for all your input.
>
> TB3101
Received on Tue Sep 11 2007 - 20:51:22 CDT