Home » RDBMS Server » Backup & Recovery » backup db to remote server (oracle 9i/10g , windows2000/2003)
backup db to remote server [message #394918] Mon, 30 March 2009 18:13 Go to next message
ruipedromachado
Messages: 1
Registered: March 2009
Junior Member
hi

i have server1 and server2

server1 has oracle running
server2 as lots of disk space

i have created some scritps that backup the oracle database. i run them on server 1 with this rman parameters

CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'C:\FLASH_RECOVERY_AREA\RMAN_BACKUP_SETS\cf_%F';
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE DEVICE TYPE DISK PARALLELISM 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = 'C:\FLASH_RECOVERY_AREA\RMAN_BACKUP_SETS\df0_%d_%s_%t';
CONFIGURE RETENTION POLICY TO REDUNDANCY 3;
CONFIGURE MAXSETSIZE TO 10G;

this works just fine ....except for the fact that im running out of disk space .

know i change the parameters to goto server2 for storage .

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '\\server2\c$\FLASH_RECOVERY_AREA\RMAN_BACKUP_SETS\cf_%F';
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT = '\\server2\c$\FLASH_RECOVERY_AREA\RMAN_BACKUP_SETS\df0_%d_%s_%t';

all the same only diference is the path .

now my problem is im always getting rman error saying access denied .

RMAN-03009: failure of backup command on ORA_DISK_1 channel at 03/30/2009 21:54:06
ORA-19504: failed to create file "\\server2\C$\FLASH_RECOVERY_AREA\RMAN_BACKUP_SETS\DF0_TONY_1767_682898044"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

i have given all possible rigths to the destination folder . used domain admin account.olso in the same script if i include a simple OS copy c:\*.* \\server2\c$\...it copies without any problems .

im missing something !

any ideias ?

thks in advanced
Re: backup db to remote server [message #394920 is a reply to message #394918] Mon, 30 March 2009 18:27 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
ORA-19504: failed to create file "\\server2\C$\FLASH_RECOVERY_AREA\RMAN_BACKUP_SETS\DF0_TONY_1767_682898044"

UNC may not work.
Instead ,mount (share in windows?) the remote drive locally into a named drive.
Something like F:\
Re: backup db to remote server [message #394938 is a reply to message #394918] Mon, 30 March 2009 19:19 Go to previous message
ebrian
Messages: 2794
Registered: April 2006
Senior Member
Check How to Configure RMAN to Write to Shared Drives on Windows NT/2000 for how this configuration needs to be setup.
Previous Topic: Backing up rman backupsets to tape
Next Topic: 9i DataGuard
Goto Forum:
  


Current Time: Fri Nov 22 06:51:39 CST 2024