History | Log In     View a printable version of the current page.  
ubTools is pleased to announce ubGuard 1.1.3 for Oracle:

  • Change Log
  • Download
  • Product Home
  • Concept and Administration

  • 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

    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:
    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:

     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.