Rman: Duplicate database to remote host with same structure

From: Vikas Agnihotri <onlyforposting_at_yahoo.com>
Date: 18 May 2001 14:04:07 -0700
Message-ID: <77e87b58.0105181304.61fe8d81@posting.google.com>

I am trying to use the 'duplicate' database feature of RMAN to clone my database onto another hostwith the EXACT same directory structure. I followed the instructions in the docsto the letter. But when I do the 'duplicate target database to dupdb', I get theerror (see below)

Please, please, tell me that I am not expected to physically copy all my backup pieces comprising the backup to the remote host using FTP or'rcp'!!

If so, whats the point? How is RMAN helping me here? If I do the physical copy, I could as well go to the other database and do a 'restore', right?

I thought that RMAN transfers the backup via the Net8 connection and builds the auxiliary database.

### If you are receiving errors, please list exact error messages and text: ###

RMAN-03022: compiling command: IRESTORE
RMAN-03023: executing command: IRESTORE
RMAN-08016: channel aux2: starting datafile backupset restore
RMAN-08502: set_count=30 set_stamp=430063352creation_time=18-MAY-01
RMAN-08089: channel aux2: specifying datafile(s) to restore from backup set
RMAN-08523: restoring datafile 00030 to 

/oradata/oracle7/application/sysapps/sysapps_data_02.dbf
RMAN-08523: restoring datafile 00037 to
/oradata/oracle7/application/secled_data/secled_data_06.dbf
RMAN-08523: restoring datafile 00049 to
/oradata/oracle7/application/mailer/mailer_data_03.dbf
RMAN-08523: restoring datafile 00051 to
/oradata/oracle7/application/secled_index/secled_index_12.dbf

RMAN-08016: channel aux3: starting datafile backupset restore
RMAN-08502: set_count=31 set_stamp=430063360 creation_time=18-MAY-01
RMAN-08089: channel aux3: specifyingdatafile(s) to restore from backup set
RMAN-08523: restoring datafile 00007 to 

/oradata/oracle7/application/employee/employee_data_01.dbf
RMAN-08523: restoring datafile 00013 to
/oradata/oracle7/application/ps_index/ps_index_01.dbf
RMAN-08523: restoring datafile 00048 to
/oradata/oracle7/application/secled_data/secled_data_07.dbf
RMAN-08523: restoring datafile 00060 to
/oradata/oracle7/application/secled_index/secled_index_13.dbf

RMAN-08016: channel aux1: starting datafile backupset restore
RMAN-08502: set_count=27 set_stamp=430063339 creation_time=18-MAY-01
RMAN-08089: channel aux1: specifyingdatafile(s) to restore from backup set
RMAN-08523: restoring datafile 00001 to 

/oradata/oracle7/system/system_data_01.dbf
RMAN-08523: restoring datafile 00019to
/oradata/oracle7/application/secled_data/secled_data_03.dbf
RMAN-08523: restoring datafile 00027 to /oradata/oracle7/system/rbs_data_02.dbf RMAN-08523: restoring datafile 00032 to
/oradata/oracle7/application/secled_index/secled_index_09.dbf

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00601: fatal error in recovery manager
RMAN-03012: fatal error during compilation of command
RMAN-03028: fatal error code: 3015
RMAN-03013: command type: Duplicate Db
RMAN-03015: error occurred in stored script Memory Script
RMAN-03002: failureduring compilation of command
RMAN-03013: command type: restore
RMAN-03007: retryable error occurred during execution of command: IRESTORE

RMAN-07004: unhandled exception during command execution on channel aux2 RMAN-10035: exception raised in RPC: ORA-19505: failed to identify file "/disk6/backup/bkp.0ucq4fno_1_1"
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory Additional information: 3 Received on Fri May 18 2001 - 16:04:07 CDT