Home » RDBMS Server » Backup & Recovery » database clonning with different instances
database clonning with different instances [message #192459] Tue, 12 September 2006 08:30 Go to next message
harooncr2
Messages: 3
Registered: September 2006
Junior Member
I m doing cloning of databases
with a differnet instance name from where the backup was taken. And
while running it gives the following error:
RMAN-00571: ================================================== =========
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ================================================== =========
RMAN-03002: failure of Duplicate Db command at 09/07/2006 15:06:16
RMAN-03015: error occurred in stored script Memory Script
ORA-19505: failed to identify file "E:\BACKUPS\CLONEBKUP\DB03HSMQIF_1_1"
ORA-27041: unable to open file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.

I did following
1. Made Network Drive Mapping
2. Mapped Original System local Drive
but still doesnt work

I really need help if somebody can help out
Re: database clonning with different instances [message #192461 is a reply to message #192459] Tue, 12 September 2006 08:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> "E:\BACKUPS\CLONEBKUP\DB03HSMQIF_1_1
Is this drive shared/mapped?
this should look like a local drive from the system where you run the duplicate.

Are you using catalog? Post your versions/
Re: database clonning with different instances [message #192466 is a reply to message #192461] Tue, 12 September 2006 09:00 Go to previous messageGo to next message
harooncr2
Messages: 3
Registered: September 2006
Junior Member
I have two machines Source and Destination. On source machine i have instance e.g. A on E:\ and i want to clone it to instance B on destination machine on differnt drive or by using drive mappings bec i have only one drive on Destination and i dont want to create another one.
E:
\BACKUPS\CLONEBKUP\DB03HSMQIF_1_1 is not shared and is on source system and then same directory structure on different drive on destination

i m running duplicate on source machine like

duplicate_instance [source_instance_name] [destination_instance_tns] [instance_home]
Re: database clonning with different instances [message #192468 is a reply to message #192466] Tue, 12 September 2006 09:07 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Look into the documentation.
the basic concept is
if your RMAN backup is residing in \BACKUPS\CLONEBKUP\DB03HSMQIF_1_1 (on source) and you want RMAN to use these backupset and clone the database to another host (target) then, the backupsets should visible from the target host.
So, you need to share the /backups across the machines.
Run your duplicate from the target machine.
The directory structure need not be the same in target.
Please refer oracle rman documentation.
Everything is explained in detail.
Previous Topic: Rename a database
Next Topic: Recovery in Noarchivelog Mode
Goto Forum:
  


Current Time: Mon Dec 23 08:14:27 CST 2024