[#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"

Change by ubTools Support - 18/Sep/08 02:54 PM
Field	Original Value	New Value
Description	(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: {noformat} run { allocate channel ch0 device type disk format '\\nist1004xfs\RMAN\RMAN_%U'; ... } {noformat} An excerpt from the output log of EM: {noformat} RMAN> run 2> { 3> allocate channel ch0 device type disk format '\nist1004xfs\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:\NIST1004XFS\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. {noformat}	(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: {noformat} run { allocate channel ch0 device type disk format '\\host\RMAN\RMAN_%U'; ... } {noformat} An excerpt from the output log of EM: {noformat} 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. {noformat}

[ 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.

Change by ubTools Support - 18/Sep/08 02:57 PM
Status	Open [ 1 ]	Closed [ 6 ]
Resolution		Answered [ 10 ]

Change by ubTools Support - 18/Sep/08 03:02 PM
Resolution	Answered [ 10 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Change by ubTools Support - 18/Sep/08 03:02 PM
Status	Reopened [ 4 ]	Closed [ 6 ]
Resolution		Answered [ 10 ]

Change by ubTools Support - 18/Sep/08 03:03 PM
Resolution	Answered [ 10 ]
Status	Closed [ 6 ]	Reopened [ 4 ]

Change by ubTools Support - 18/Sep/08 03:03 PM
Summary	ORA-27040 ORA-19504 OSD-04002: While backing up RMAN to shared disk on Windows.	ORA-27040 ORA-19504 OSD-04002: While backing up by RMAN to shared disk on Windows.

Change by ubTools Support - 18/Sep/08 03:04 PM
Status	Reopened [ 4 ]	Closed [ 6 ]
Resolution		Answered [ 10 ]