Re: Oracle Standby: Newly added datafiles won't be created on standby

Hi,

All the directories in your path 'Z:\ORACLE\ULOUSR_11\ULOUSR.DATA11' must exist. Oracle create only the datafile.

Dias

blueberry210_at_yahoo.com wrote in message news:<d9e8e9a8.0404270645.27a47a57_at_posting.google.com>...
> Hi there
>
> I've got two servers running Oracle 9.2 and W2K3. One is the primary
> the other is a physical standby server.
> The logshipping works fine. But there's one exception. When I add a
> new datafile on the primary server it isn't automatically created on
> the standby. The primary server runs in "force logging"-mode and on
> the standby server the "standby_file_management"-Parameter is set to
> AUTO. The error message is the following:
>
> File #33 added to control file as 'UNNAMED00033'. Originally created
> as:
> 'Z:\ORACLE\ULOUSR_11\ULOUSR.DATA11'
> Recovery was unable to create the file as:
> 'Z:\ORACLE\ULOUSR_11\ULOUSR.DATA11'
> Errors with log .
> Some recovered datafiles maybe left media fuzzy
> Media recovery may continue but open resetlogs may fail
> Media Recovery failed with error 1274
>
> If I create the directory (e.g. ULOUSR_11) manually the datafile is
> created without problems.
>
> Any ideas? Thanks a lot for your help.
Received on Tue Apr 27 2004 - 14:43:00 CDT