RE: RMAN Duplicate DB between servers
Date: Wed, 5 Dec 2012 14:50:13 -0500
Message-ID: <C95D75DD2E01DD4D81124D104D317ACA1C766D1B02_at_JAXMSG01.crowley.com>
Yes, around 2005, 2006 windows changed its security for SYSTEM accounts. Oracle will have to run under a domain account to see, read/write to network shares. Don't remember if local will do it or all domain administrator account.
I would pick a 'generic' user that can run on all your boxes, not your own network id or anyone elses.
Joel Patterson
Database Administrator
904 727-2546
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Steve Wales
Sent: Tuesday, December 04, 2012 9:29 PM
To: oracle-l_at_freelists.org
Subject: RMAN Duplicate DB between servers
Environment: Windows Server 2008 R2 64-Bit / Oracle 11.2.0.3 64 bit
I have a new environment I'm setting up and testing for an upcoming go live.
I have a database PROD on node1 which backs up to i:\backups\PROD
I have my controlfile autobackups going to i:\backups\PROD\ctl
PROD is backing up just fine, I have all sorts of files on i: for backups.
I want to test doing a refresh of the DEV database.
DEV exists on NODE2.
Being what I thought was clever, I mapped the I: drive on NODE2 to \\NODE1\I$
I went over to NODE1 and shared I:\BACKUPS with my domain account.
I went over to NODE2 and as far as I can tell, I can see everything.
So, I start a CMD window on NODE2, set my environment variables, stop DEV and restart it NOMOUNT with a special PFILE I keep on hand that includes db_file_name_convert and log_file_name_convert parameters.
Then I do my RMAN block:
run
{
allocate auxiliary channel aux1 device type disk; set until time "to_date('2012-12-04:15:00:00','YYYY-MM-DD:HH24:MI:SS')";
duplicate target database to DEV;
}
RMAN starts doing its thing. It identifies the correct controlfile backup from the Prod catalog but when it tries to open it, I'm getting ORA-27041 unable to open file.
Going back to the CMD shell, I can set my current directory to i:\backups\PROD\ctl, do a directory listing and see the file there from NODE2.
I'm sure that there's some funky Windows security thing that I'm missing here. Could it be that even though my CMD shell is running under my domain account, the ORACLE service runs under Local System and thus can't see the network resource ?
I know I could copy the backup files to a local resource and then do "duplicate target database to elldev backup location 'd:\some_other_dir';" but I'd like to see if I can work out how to handle it this way.
I suppose while I'm at it I'd also like to solicit comments on which is likely to be less network intensive - having RMAN pull the backup files over the network or having me do it manually and restoring from local copies.
Thanks for any input.
Steve
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Wed Dec 05 2012 - 20:50:13 CET