[#QA-42] ORA-27040 ORA-19504 OSD-04002: While backing up by RMAN to shared disk on Windows.

Questions & Answers

ORA-27040 ORA-19504 OSD-04002: While backing up by RMAN to shared disk on Windows.

Created: 18/Sep/08 02:35 PM Updated: 18/Sep/08 03:04 PM

Fix Version/s:

None

Product Version:	10.2.0.4
Operating System:	Windows
Operating System Version:	Windows 2000

Description

« Hide

(The problem solution is simple. But, since it saves setup times, it's doccumented here.)

Note:145843.1 How to Configure RMAN to Write to Shared Drives on Windows NT/2000 is implemented. Although the script works on RMAN command line; it fails if it's defined as a job on Enterprise Manager.

An excerpt from the script:

run
{
 allocate channel ch0 device type disk format '\\host\RMAN\RMAN_%U';
 ...
}

An excerpt from the output log of EM:

RMAN> run

2> {

3> allocate channel ch0 device type disk format '\host\RMAN\RMAN_%U';
...
10> }
...
RMAN-00571: ===========================================================

RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============

RMAN-00571: ===========================================================

RMAN-03002: failure of backup plus archivelog command at 09/18/2008 17:37:36

ORA-19504: failed to create file "C:\host\RMAN\RMAN_1KJQTRAU_1_1"

ORA-27040: file create error, unable to create file

OSD-04002: unable to open file

O/S-Error: (OS 3) The system cannot find the path specified.

All

Comments

Change History

Sort Order:

Ascending order - Click to sort in descending order

[ Permlink | « Hide ]

ubTools Support - 18/Sep/08 02:54 PM

As seen above, the file name in the script is '\\host\RMAN\RMAN_%U'. But, it's converted by EM to:

'\host\RMAN\RMAN_%U'
Then "C:\host\RMAN\RMAN_1KJQTRAU_1_1"

[ Permlink | « Hide ]

ubTools Support - 18/Sep/08 02:57 PM - edited

'\' character is a special character in JAVA/C. The correct file name should be:

'\\\host\RMAN\RMAN_%U'

Three '\' characters should be used before hostname; not two.