Re: RMAN to copy database

David J. Devejian wrote:
>
> Hopefully someone can point me in the right direction. I am running a
> database (approx 100G) on Oracle 9iR1 on Win2K. I have a backup on
> tape taken through Veritas NetBackup. I also have a machine with
> Oracle 9iR2 on Win2K at my DR site. I have imported the backup images
> into Veritas installation at the DR site, but I am not clear on how to
> restore the database to the new DR server. There does not currently
> exist a copy of the DB on the DR server.
>
> I am not sure if this makes a difference, but the DR server does not
> have its drives configured exactly like the primary. The total size
> is the same, but there are some differences in individual drives sizes
> and lettering. This can be re-arranged, but I would rather not if it
> is not necessary.
>
> This is not an emergency, but rather development of the DR site and
> its proceedures. I have some Oracle DBA experience from 7 years ago
> or so on Oracle 7.x and 8.0. (Yes we need a full time experienced
> DBA, but while I argue for the budget, this needs to get done.)
>
> I have been and will continue to read the RMAN manual but am in a bit
> of information overload. Any direction will be helpful, if only by
> narrowing down the concepts I need to familiarize myself with.
>
> If it helps, here is the run statement from my backup (which seems to
> have been set up at the time of the install of Veritas):
> run {
>
> allocate channel t1 type 'SBT_TAPE';
>
> send 'NB_ORA_SERV=fsi09, NB_ORA_CLIENT=research,
> NB_ORA_CLASS=IP_ORACLE_RESEARCH, NB_ORA_SCHED=Default-Policy';
>
> backup
> incremental level 0
> skip inaccessible
> tag hot_db_bk_level0
> filesperset 10
> # recommended format
> format 'bk_%s_%p_%t'
> (database);
> sql 'alter system archive log current';
> # backup all archive logs
> backup
> filesperset 25
> format 'al_%s_%p_%t'
> (archivelog all
> delete input);
> }
>
> At this point I am thinking that I can create a db instance, shut it
> down, restore control files over it, startup in no mount, alter the
> file locations to match the new server, offline the tablespaces, mount
> and open, then restore the db. Am I correct? Have I made the process
> to complicated?
>
> Any and all help is appreciated.
> Regards,
> Dave

If you've lost 'everything' ie control files as well, there is some rman plsql which can be used to restore a control file from a backup (assuming you backed up the control file). I can't remember it off hand, but its in the rman doco. Once you've got a control file on the DR site, then you can restore/recovery/etc in the normal rman way

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"