Oracle Standby: Newly added datafiles won't be created on standby
This is a discussion on Oracle Standby: Newly added datafiles won't be created on standby within the Oracle Database forums, part of the Database Server Software category; --> Hi there I've got two servers running Oracle 9.2 and W2K3. One is the primary the other is a ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-23-2008, 08:50 AM
| ||||
| ||||
 Oracle Standby: Newly added datafiles won't be created on standby 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.      |
|
02-23-2008, 08:51 AM
| ||||
| ||||
| 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@yahoo.com wrote in message news:<d9e8e9a8.0404270645.27a47a57@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. |
Linear Mode
