Re: RMAN to copy database

widsith_at_panix.com (David J. Devejian) wrote in message news:<22b115fb.0303191754.564c642d_at_posting.google.com>...
> 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.
> 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);
> }

Hi Dave,
on the DR site prepare your directories and pfile for the copy database. Include db_file_name_convert and log_file_name_convert to be able to adjust for differences in pathnames between source and copy database. Start the copy instance nomount.

connect catalog rman_user/some_secret_at_your_rman_catalog connect target sys/change_on_install_at_your_target_database (acutally the source)
connect auxiliary sys/change_on_install_at_your_copy_db run {

     allocate channel x type whatever you need;
     allocate auxiliary channel y type disk;
     duplicate target database to your_copy_db;

This should take you close to what you want.

Ronald.