Dear all,
Is it possible to clone a database from one host to another host using RMAN without manually copying the backups? I have done it in same host but its not working for diffrent host.
this is the error I am getting...
[oracle@localhost ~]$ rman target/ catalog rman/rman@rmancat AUXILIARY sys/123456@stby
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 14 21:41:53 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DB1 (DBID=1251008640, not open)
connected to recovery catalog database
connected to auxiliary database: DUP (not mounted)
RMAN> exit
Recovery Manager complete.
exit[oracle@localhost ~]$ rman target/ catalog rman/rman@rmancat AUXILIARY sys/123456@stby
Recovery Manager: Release 10.2.0.1.0 - Production on Sat Jun 14 21:42:43 2008
Copyright (c) 1982, 2005, Oracle. All rights reserved.
connected to target database: DB1 (DBID=1251008640)
connected to recovery catalog database
connected to auxiliary database: DUP (not mounted)
RMAN> DUPLICATE TARGET DATABASE TO dup;
Starting Duplicate Db at 14-JUN-08
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=158 devtype=DISK
allocated channel: ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: sid=155 devtype=DISK
contents of Memory Script:
{
set until scn 2601857;
set newname for datafile 1 to
"/oradata2/nishant/mydataguard/db1/datafile/system.264.657145091";
set newname for datafile 2 to
"/oradata2/nishant/mydataguard/db1/datafile/undotbs1.265.657145127";
set newname for datafile 3 to
"/oradata2/nishant/mydataguard/db1/datafile/sysaux.266.657145143";
set newname for datafile 4 to
"/oradata2/nishant/mydataguard/db1/datafile/sales01.dbf";
set newname for datafile 5 to
"/oradata2/nishant/mydataguard/db1/datafile/users01.dbf";
set newname for datafile 6 to
"/oradata2/nishant/mydataguard/db1/datafile/users02.dbf";
restore
check readonly
clone database
;
}
executing Memory Script
executing command: SET until clause
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
executing command: SET NEWNAME
Starting restore at 14-JUN-08
using channel ORA_AUX_DISK_1
using channel ORA_AUX_DISK_2
channel ORA_AUX_DISK_2: starting datafile backupset restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata2/nishant/mydataguard/db1/datafile/system.264.657145091
restoring datafile 00002 to /oradata2/nishant/mydataguard/db1/datafile/undotbs1.265.657145127
restoring datafile 00006 to /oradata2/nishant/mydataguard/db1/datafile/users02.dbf
channel ORA_AUX_DISK_2: reading from backup piece /home/oracle/oracle10g/backup/rman/ora_df657407299_s31_s1
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /oradata2/nishant/mydataguard/db1/datafile/sysaux.266.657145143
restoring datafile 00004 to /oradata2/nishant/mydataguard/db1/datafile/sales01.dbf
restoring datafile 00005 to /oradata2/nishant/mydataguard/db1/datafile/users01.dbf
channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/oracle10g/backup/rman/ora_df657407299_s32_s1
ORA-19870: error reading backup piece /home/oracle/oracle10g/backup/rman/ora_df657407299_s31_s1
ORA-19505: failed to identify file "/home/oracle/oracle10g/backup/rman/ora_df657407299_s31_s1"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /home/oracle/oracle10g/backup/rman/ora_df657407299_s32_s1
ORA-19505: failed to identify file "/home/oracle/oracle10g/backup/rman/ora_df657407299_s32_s1"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup
channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata2/nishant/mydataguard/db1/datafile/system.264.657145091
restoring datafile 00002 to /oradata2/nishant/mydataguard/db1/datafile/undotbs1.265.657145127
restoring datafile 00006 to /oradata2/nishant/mydataguard/db1/datafile/users02.dbf
channel ORA_AUX_DISK_1: reading from backup piece /home/oracle/oracle10g/backup/rman/ora_df657405996_s25_s1
channel ORA_AUX_DISK_2: starting datafile backupset restore
channel ORA_AUX_DISK_2: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /oradata2/nishant/mydataguard/db1/datafile/sysaux.266.657145143
restoring datafile 00004 to /oradata2/nishant/mydataguard/db1/datafile/sales01.dbf
restoring datafile 00005 to /oradata2/nishant/mydataguard/db1/datafile/users01.dbf
channel ORA_AUX_DISK_2: reading from backup piece /home/oracle/oracle10g/backup/rman/ora_df657405996_s26_s1
ORA-19870: error reading backup piece /home/oracle/oracle10g/backup/rman/ora_df657405996_s25_s1
ORA-19505: failed to identify file "/home/oracle/oracle10g/backup/rman/ora_df657405996_s25_s1"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
ORA-19870: error reading backup piece /home/oracle/oracle10g/backup/rman/ora_df657405996_s26_s1
ORA-19505: failed to identify file "/home/oracle/oracle10g/backup/rman/ora_df657405996_s26_s1"
ORA-27037: unable to obtain file status
Linux Error: 2: No such file or directory
Additional information: 3
failover to previous backup
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 06/14/2008 21:43:07
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore
RMAN>
My OS is RHEL AS 4 (U 5 )
Thanks in advance