History | Log In     View a printable version of the current page.  
Issue Details (XML | Word | Printable)

Key: QA-42
Type: Oracle - Administration Oracle - Administration
Status: Closed Closed
Resolution: Answered
Priority: Major Major
Assignee: ubTools Support
Reporter: ubTools Support
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
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
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}

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 ]