Re: Clone a database to another server using RMAN on Windows 2000

lblair_at_adaptisinc.com (Larry) wrote in message news:<a8e19c11.0302061156.62bc6c27_at_posting.google.com>...
> 1. We have a database that is up 24-7.
> 2. We do hot backups everynight using RMAN.
> 3. We need to create clones on other servers for development and test.
> 4. The hard drive architecture is different.
>
> What I have done
> 1. Modified the TNSNames and database services to have a login user
> and password other than Windows system user. This user is a Domain
> user with admin rights.
> 2. I created shares on the servers for the service owner both where
> the hot backup is and where I want to create the new clone database.
> 3. In the rman script I have put SET NEWNAME FOR DATAFILE .... for
> each datafile that is moving to a new location on the remote server.
> 3.5 I have started the clone database in nomount mode and have a valid
> subdirectory structure in place.
> 4. I start the RMAN script and get a lot of messages and then get the
> following.
> Itappears that it can see the remote subdirectories to restore the
> datafiles but it can't see the local subdirectory where rman's hot
> backup files are.
>
> Has anyone done a successful clone of a database to another server
> with Rman. What am I not seeing or setting up corrrect?
>
> Thank
> Larry
>
> channel ch2: starting datafile backupset restore
> channel ch2: specifying datafile(s) to restore from backup set
> restoring datafile 00003 to
> \\STA01DB\E$\ORACLE\ORADATA\MI9I2\USERS01.DBF
> restoring datafile 00012 to
> \\STA01DB\G$\ORACLE\ORADATA\MI9I2\CMIFML12.DBF
> restoring datafile 00029 to
> \\STA01DB\G$\ORACLE\ORADATA\MI9I2\CMIFML07.DBF
> channel ch1: starting datafile backupset restore
> channel ch1: specifying datafile(s) to restore from backup set
> restoring datafile 00001 to
> \\STA01DB\E$\ORACLE\ORADATA\MI9I2\SYSTEM01.DBF
> restoring datafile 00004 to
> \\STA01DB\F$\ORACLE\ORADATA\MI9I2\CMDFSL01.DBF
> restoring datafile 00059 to
> \\STA01DB\E$\ORACLE\ORADATA\MI9I2\RBS06.ORA
> released channel: ch1
> released channel: ch2
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS
> ===============
> RMAN-00571: ===========================================================
> RMAN-03002: failure of Duplicate Db command at 01/16/2003 13:56:51
> RMAN-03015: error occurred in stored script Memory Script
> ORA-19505: failed to identify file
> "F:\ORACLE\ORADATA\MI9I2\MI9I21FED1PAP_1_1"
> ORA-27041: unable to open file
> OSD-04002: unable to open file
> O/S-Error: (OS 2) The system cannot find the file specified.
>
> Recovery Manager complete.

Hi,

   I've also used rman (also to clone a db)....

   Did you specify a path with you did the hot backup?. For example, my    rman script would look something like:

   run {

         allocate channel d1 type disk;
         backup
         format 'd:\backup\dbname_%' (database ....);
          ..
       }

... The reason I ask, when I look at the file name:

    MI9I21FED1PAP_1_1    ... Looks a lot like the backups I did before I included a the format line.     You might look in (assuming oracle is installed on d:)    

         d:\oracle\ora81\database

    That's where mine seemd to end up. Received on Fri Feb 07 2003 - 02:34:25 CET