History | Log In     View a printable version of the current page.  
ubTools is pleased to announce ubGuard 1.0.3 for Oracle. The following links include the details:

The change log: http://www.ubtools.com/jira/browse/PSUP-140
The product home page: http://ubtools.com/web/public/products/ubguard
The download page: http://ubtools.com/web/public/downloads
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
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"

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.