| << Back to previous view |
|
[QA-42] ORA-27040 ORA-19504 OSD-04002: While backing up by RMAN to shared disk on Windows. Created: 18/Sep/08 Updated: 18/Sep/08 |
|
| Status: | Closed |
| Project: | Questions & Answers |
| Fix Version/s: | None |
| Type: | Oracle - Administration | Priority: | Major |
| Reporter: | ubTools Support | Assignee: | ubTools Support |
| Resolution: | Answered | Votes: | 0 |
| Product Version: | 10.2.0.4 |
| Operating System: | Windows |
| Operating System Version: | Windows 2000 |
| 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: 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.
|
| Comments |
| Comment by 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:
|
| Comment by ubTools Support [ 18/Sep/08 02:57 PM ] |
'\' character is a special character in JAVA/C. The correct file name should be:
Three '\' characters should be used before hostname; not two. |