Hi all,

I am on windows and Oracle 9.2.0.6.

I am testing RMAN backup to backup database onto different server and I had issue with permission. Any way, below is what I did:

Al little about the whole environment setup: I have catalog database running on my desktop and I have SERVER1 which is the server I am going to store the backup of SERVER2 database:




RMAN> configure channel device type disk format '\\SERVER1\d$\%d_DB_%u_%s_%p';

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\SERVER1\j\%d_DB_%u_%s_%p';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '\\SERVER1\d$\%d_DB_%u_%s_%p';
new RMAN configuration parameters are successfully stored
starting full resync of recovery catalog
full resync complete
released channel: ORA_DISK_1

RMAN> run {
2> backup database plus archivelog;
3> delete noprompt obsolete;
4> }


Starting backup at 25-AUG-05
current log archived
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=10 devtype=DISK
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=22278 recid=43 stamp=567255098
input archive log thread=1 sequence=22279 recid=44 stamp=567255555
channel ORA_DISK_1: starting piece 1 at 25-AUG-05
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 08/25/2005 10:59:19
ORA-19504: failed to create file "\\SERVER1\d$\DB1_DB_0jgsv8g5_19_1"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.

I was able to copy/write any files on the SERVER1 even I have asked the SYSADMIN to log in as his logiD and it still had the same issues. If I changed RMAN to backup on the same server as the SERVER2 and it's working just fine; however, I really want to store the SERVER2 backup on SERVER1.

Any thoughts????

RMAN>