RE: RMAN Duplicate DB between servers
Date: Wed, 5 Dec 2012 07:36:42 -0700
Message-ID: <E0EB12A04CA242378D01D5F85176F5E7_at_StevePC>
I tried changing the DEV service owner to my domain account for testing (which I'll undo before go live because I don't want my domain account permanently listed as having the run as a service right).
Doing duplicate target database to DEV still failed because it couldn't read the mapped drive.
However, when I did:
Rman auxiliary /
Duplicate database to DEV backup location '\\host\i$\backups\prod';
It seems to have started to work.
I'll repeat it again after it's done after returning ownership of the service to Local System and see how it goes.
Also, I'll compare times to doing it this way, vs copying the backup files from the prod node to the dev node and doing it that way to see whether it's faster to let RMAN drag across the network or have me do it manually.
Thanks to all who have replied.
Regards
Steve
-----Original Message-----
From: Chris Taylor [mailto:christopherdtaylor1994_at_gmail.com]
Sent: Tuesday, December 04, 2012 9:36 PM
To: sjwales_at_comcast.net
Cc: <oracle-l_at_freelists.org>
Subject: Re: RMAN Duplicate DB between servers
2 things:
1.) IIRC, I would assume that the SYSTEM account has to be able to access that drive as RMAN connects to the running instance (the nomount instance).
When you share drives between machines, the SYSTEM account is unaware of that share I believe.
To get around this, you have to mount the UNC path as a system service - so that Oracle can read from it.
You can use autoexNT to run a batch file as a service where the batch file does the drive mounting.
2.). If I'm not totally mistaken, 11g has the ability to read UNC path names natively but I havent tested it - I'm pretty sure I read/saw that somewhere....
Regards,
Chris Taylor
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 05 2012 - 15:36:42 CET