Re: rman restore backup of noarchive database to another server

toto wrote:
> Hi,
>
> I am trying to restore backup taken by rman of database 9.2 running in
> noarchivelog format on 2000. I want to restore database on another
> server with same directory structure. Currently no database is existing
> on new server. My understanding regarding this first nomount dastabase
> and restore controlfile after setting DBID ( pl correct me if I am
> wrong ). My questions regarding this
>
> 1. How can I find out DBID of new database without logging to original
> server ? ( if database is not existing then I can not mount the
> database to see DBID )
>
> 2. How can I tell rman to restore database backup from a particular
> directory ?
>
> thanks & regards
> pjp
>

1 - (I was going to say no, but you're on 9.2) Why would you need another DBID? As long as you do not use RMAN with a catalog, there's no need. And dbid will provide you with a new one. Anyway, you need not to worry about your dbid. Restore first, change dbid later, if you really must.

2 - The location is stored in the control file (not using a catalog),   or in the catalaog db (if you use one). Just put the backups where they were on the original machine. Otherwise, you start messing with the format, even before the restore has taken place.

-- 
Regards,
Frank van Bortel

Top-posting is one way to shut me up...