Re: Backup problem

"Hans-Peter" <hans-peter.henrichsen_at_capgemini.se> wrote in message news:<3c21cb58$1_at_news.capgemini.se>...
> Hi,
>
> I have problems when I, during the night, try to backup my database server.
> Before the backup a script is executed that shutdown the instance and stop
> the service.
>
> CONNECT INTERNAL/<PWD>@PUCK
> SHUTDOWN IMMEDIATE
> host net stop OracleServicePUCK
>
> The backup is done, but one (of two) controlfiles is in use during the
> backup.
>
> After the backup another script is executed...
> net start OracleServicePUCK
>
> The database is NOT up and running. Error message in the ALRT.log is
>
> Errors in file E:\PUCK\DBLogs\trace\puckCKPT.TRC:
> ORA-00206: Message 206 not found; No message file for product=RDBMS,
> facility=ORA; arguments: [3] [1]
> ORA-00202: Message 202 not found; No message file for product=RDBMS,
> facility=ORA; arguments: [E:\PUCK\DBFILES\CTL2PUCK.ORA]
> ORA-27072: Message 27072 not found; No message file for product=RDBMS,
> facility=ORA
> OSD-04008: WriteFile() failure, unable to write to file
> O/S-Error: (OS 33) The process cannot access the file because another
> process has locked a portion of the file.

That looks like sharing violation problem. You must find what process locked this file. After restart you should be able to start database, then you can do a shutdown normal. After that, you can check if your database is properly shutdown and no Oracle process is in memory. If Oracle is quiet you should check if that control file is still locked by another process (non Oracle).
I've seen a similar problem some time ago, the originator was improperly configured antivirus software.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.