RMAN to copy database

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 Received on Wed Mar 19 2003 - 19:54:45 CST