OraFAQ Forum: Backup & Recovery » database clonning with different instances

Home » RDBMS Server » Backup & Recovery » database clonning with different instances

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

database clonning with different instances [message #192459]

Tue, 12 September 2006 08:30

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

Report message to a moderator

Re: database clonning with different instances [message #192461 is a reply to message #192459]

Tue, 12 September 2006 08:39

Mahesh Rajendran
Messages: 10707
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/

Report message to a moderator

Re: database clonning with different instances [message #192466 is a reply to message #192461]

Tue, 12 September 2006 09:00

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]

Report message to a moderator

Re: database clonning with different instances [message #192468 is a reply to message #192466]

Tue, 12 September 2006 09:07

Mahesh Rajendran
Messages: 10707
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.

Report message to a moderator

Previous Topic:	Rename a database
Next Topic:	Recovery in Noarchivelog Mode

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed May 01 04:51:21 CDT 2024