Re: BackUp : RMAN and Network Disks

"Alex" <vlgera_at_hotmail.com> wrote in message news:50105e9a.0205170443.15593ed_at_posting.google.com...
> Dear Sirs,
> I need your help.
>
> Some days ago we decided to use RMAN to backup our database. We have
problem
> now, because of RMAN doesn't want to write to network disk. Here is the
log.
>
> Recovery Manager: Release 8.1.7.0.0 - Production
>
> RMAN> connect target sys/...
> 2> connect catalog rman/...
> 3> run {
> 4> allocate channel c1 type disk;
> 5> backup
> 6> format 'Z:\cf_%d_%u'
> 7> tag backup_cf
> 8> current controlfile;
> 9> release channel c1;
> 10> }
> 11> exit;
> RMAN-06005: connected to target database: TMC (DBID=1497649469)
>
> RMAN-06008: connected to recovery catalog database
>
> RMAN-03022: compiling command: allocate
> RMAN-03023: executing command: allocate
> RMAN-08030: allocated channel: c1
> RMAN-08500: channel c1: sid=72 devtype=DISK
>
> RMAN-03022: compiling command: backup
> RMAN-03025: performing implicit partial resync of recovery catalog
> RMAN-03023: executing command: partial resync
> RMAN-08003: starting partial resync of recovery catalog
> RMAN-08005: partial resync complete
> RMAN-03023: executing command: backup
> RMAN-08008: channel c1: starting full datafile backupset
> RMAN-08502: set_count=4 set_stamp=462101731 creation_time=17.05.02
> RMAN-08010: channel c1: specifying datafile(s) in backupset
> RMAN-08011: including current controlfile in backupset
> RMAN-00571: ===========================================================
> RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
> RMAN-00571: ===========================================================
> RMAN-03007: retryable error occurred during execution of command: backup
> RMAN-07004: unhandled exception during command execution on channel c1
> RMAN-10035: exception raised in RPC: ORA-19504: failed to create file
> "Z:\cf_TMC_04dom773"
> ORA-27040: skgfrcre: create error, unable to create file
> OSD-04002: unable to open file
> O/S-Error: (OS 5) Access is denied.
> RMAN-10031: ORA-19624 occurred during call to
> DBMS_BACKUP_RESTORE.BACKUPPIECECREATE
>
> Recovery Manager complete.
>
> A little explanation :
> Both PCs have O/S - Windows NT 4 and RDBMS 8.1.7 Disk Z: is sharing
network
> folder on other PC (in future we are going to hold all our backups there).
I
> have Full Control on this folder. Both PCs have the same acounts (name and
> password). If I use disk D: (local disk) instead of the disk Z: (network
> disk), everything is OK.
>
> Please, tell what's problem.

The problem is using a network disk. If the remote system goes down your backup is toast.
Please don't try to be pennywise and pound foolish: you can easily get a backup product backing up your whole network, which is compatible with RMAN so the issue disappears.

Regards

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address