Making a backup to a network share (Windows NT)

From: Tjeerd Kaastra <tskaastra_at_yahoo.com>
Date: 1 Nov 2001 01:41:02 -0800
Message-ID: <e0143ccf.0111010141.65672f1b@posting.google.com>

I have a problem making backups using recovery manager to a network share and I hope someone can help me. The database that I am using is Oracle 8.0.6.0.0 on Windows NT 4 (SP6).

When I try to create a backup using rman on a drive (W:) that I mapped to another server, I get the following errors:

RMAN> run {

           allocate channel ch1 type disk;

           backup incremental level=0 tag 'lvl0' format 'w:\LVL0_%d_%u'

             (database filesperset = 10 include current controlfile);

           backup (archivelog from time 'SYSDATE-1' all
             format 'w:\ARCH_%d_%u');

           release channel ch1;

}

RMAN-08031: released channel: ch1
RMAN-03022: compiling command: allocate
RMAN-03023: executing command: allocate
RMAN-08030: allocated channel: ch1
RMAN-08500: channel ch1: sid=11 devtype=DISK

RMAN-03022: compiling command: backup
RMAN-03023: executing command: backup
RMAN-08008: channel ch1: starting datafile backupset
RMAN-08502: set_count=23 set_stamp=444647409
RMAN-08010: channel ch1: including datafile 3 in backupset
RMAN-08010: channel ch1: including datafile 2 in backupset
RMAN-08010: channel ch1: including datafile 5 in backupset
RMAN-08010: channel ch1: including datafile 4 in backupset
RMAN-08010: channel ch1: including datafile 1 in backupset

RMAN-08011: channel ch1: including current controlfile in backupset

RMAN-00569: ================error message stack
follows================

RMAN-03007: retryable error occurred during execution of command: backup
RMAN-07004: unhandled exception during command execution on channel ch1
RMAN-10035: exception raised in RPC: ORA-19624: operation failed, retry possible

ORA-19504: failed to create file "w:\LVL0_SENS_0nd81hvh"
ORA-27040: skgfrcre: create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 5) Access is denied.
ORA-06512: at "SYS.DBMS_BACKUP_RESTORE", line 408

RMAN-10031: ORA-19624 occurred during call to DBMS_BACKUP_RESTORE.BACKUPPIECECREATE I understand from previous postings that this error probably occurs because the Oracle server is running as the NT System account and it has no permissions on the network share.

Is it so bad to create a backup to a network share? I cannot see why (yet).

Anyway, I tried to run the Oracle services as an Administrator, and as another user that has Administrator rights, but then I cannot contact the database anymore. I get the following error from sqlplus: ORA-12500: TNS:listener failed to start a dedicated server process. The only way to connect is setting the SID in the environment and using SQLplus commandline.

Also, giving the System account full permissions on the share does not work.

The easiest way out is ofcourse to just create the backups locally and then move them onto the network drive that is backed up, but it would then report all my backups as deleted. So I really do not prefer this solution. Besides, a time might come that the Oracle server has no space left for making backups on its local drives.

I hope that someone can give me some hints on how to solve this.

Your help is greatly appreciated.

Kind regards,

Tjeerd Kaastra
PS: This was posted using Deja, so I hope that no HTML is contained, otherwise I am sorry for it. Received on Thu Nov 01 2001 - 03:41:02 CST