ODM fails to create a file because the needed directory is missing

book

Article ID: 100000869

calendar_today

Updated On:

Resolution

This error can occur when adding a data file to the primary Oracle database (and standby_file_management=auto).  Oracle fails on the standby host with:
 
MRP0:Background Media Recovery terminated with error 1119
ORA-01119:error in creating database file '/oracle/PRD/sapdata29/btabd_260/btabd.data260'
ORA-17502:ksfdcre:4 Failed to create file /oracle/PRD/sapdata29/btabd_260/btabd.data260
ORA-17500:ODM err:ODM ERROR V-41-4-1-101-2 No such file or directory
 
Veritas ODM cannot create the file because the necessary directory structure is missing on the backup server.
The ODM specification indicates that odm_create() should fail in this case:
odm_ercodm_create( odm_ctx ctx, oratext *path, odm_fsz fsize,
odm_ftftype, uword fmode,
oratext*name, uword len,
odm_idn*ident );
...
The pathname pointed to by path can be a fully qualified path name or a
path name relative to the current working directory. The new file is
created in the directory specified, or the current working directory if
no directory is named. The file system containing this directory must
support the ODM interface, or no file will be created.
 
The workaround is to create the necessary directory structure on the backup server so the file can be created.
 
 
 
 

 

Issue/Introduction

ODM fails to create a file because the needed directory is missing
Powered by Wolken Software