Re: ORA-27086: skgfglk: unable to lock file - already in use -> Instance "BOCHUM", status BLOCKED
Date: Fri, 27 Jun 2008 02:55:14 -0700 (PDT)
Message-ID: <39bea971-1aec-4959-9a3d-5c242c216d2c@e53g2000hsa.googlegroups.com>
Hello,
I've followed your advice and
issued "shutdown immediate" from sqlplus, then:
On 27 ÉÀÎ, 11:47, machao <machao2..._at_gmail.com> wrote:
> Was your cotrolfile DAMAGED ?
>
> Backup your control file and try to restart instance
> mv '/abl/apps/oracle/oradata/BOCHUM/control01.ctl' '/abl/apps/oracle/
> oradata/BOCHUM/control01.bak'
> mv '/abl/apps/oracle/oradata/BOCHUM/control02.ctl' '/abl/apps/oracle/
> oradata/BOCHUM/control02.bak'
> mv '/abl/apps/oracle/oradata/BOCHUM/control03.ctl' '/abl/apps/oracle/
> oradata/BOCHUM/control03.bak'
Then I've tried to "startup" from sqlplus and:
> cp '/abl/apps/oracle/oradata/BOCHUM/control01.bak' '/abl/apps/
> oracle/oradata/BOCHUM/control01.ctl'
> cp '/abl/apps/oracle/oradata/BOCHUM/control02.bak' '/abl/apps/
> oracle/oradata/BOCHUM/control02.ctl'
> cp '/abl/apps/oracle/oradata/BOCHUM/control03.bak' '/abl/apps/
> oracle/oradata/BOCHUM/control03.ctl'
Now I have an even worse looking error message:
SQL> startup
ORACLE instance started.
Total System Global Area 135336712 bytes
Fixed Size 451336 bytes Variable Size 109051904 bytes Database Buffers 25165824 bytes Redo Buffers 667648 bytesDatabase mounted.
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/abl/apps/oracle/oradata/BOCHUM/system01.dbf'
Regards
Alex
Received on Fri Jun 27 2008 - 04:55:14 CDT