Re: Lk issue /control file locked . How to start the database?

 It is docker container on linux.
 Oops , i didnt think of fuser/lsof ..Kicking myself. I ran strace and didnt find the output useful to identify the lock. Should have copied all these diagnostic tools into the image itself. Lesson for the future.

I then tried to copy the control files around (some blogs on google) and managed to move the damage to data files :|

alter database open
*
ERROR at line 1:
ORA-01157: cannot identify/lock data file 1 - see DBWR trace file ORA-01110: data file 1: '/u04/app/oracle/oradata/ORCLDB/system01.dbf'

I will move to creating a new database. I can recreate the data.

I am more of a performance tuning specialist who never did the core DBA work, guess i will have to learn it. I remember someone mentioning on twitter 50 backup and scenarios blog to practice few months back. But i forgot to bookmark it. Any suggestions on how can i learn how to create the regular backups quickly using rman and be prepared for such scenarios? I always had the luxury of not working on that part.

Due to database planned move to cloud i dont see myself doing this task anymore. So i didnt stress on learning this skill and focussed on more on learning cloud :)

On Sat, Feb 13, 2021 at 1:20 AM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> What OS are you using, what version of database? How are you trying to
> start it up? From pfile? spfile? What is exactly locking your control
> files? If you are using an operating system, try fuser or lsof to find
> that out. If you are using something that resembles an operating system,
> try using process explorer. If you're not a DBA, how in the world did you
> find yourself in a position of trying to revive an unresponsive database?
> Also "no backup of any kind" sounds extremely funny. Try calling Oracle
> Consulting, they are probably able to revive your database.
> On 2/13/21 1:03 AM, kunwar singh wrote:
>
> No, sorry.
>
> On Sat, Feb 13, 2021 at 12:55 AM Mladen Gogala <gogala.mladen_at_gmail.com>
> wrote:
>
>> Is this some kind of a joke?
>>
>> On 2/13/21 12:42 AM, kunwar singh wrote:
>> > $ srvctl status db -d ORCLDB
>> > ****Unable to retrieve Oracle Clusterware home.
>> > Start Oracle Clusterware stack and try again.
>>
>> --
>> Mladen Gogala
>> Database Consultant
>> https://dbwhisperer.wordpress.com
>>
>> --
> Cheers,
> Kunwar
>
> --
> Mladen Gogala
> Database Consultanthttps://dbwhisperer.wordpress.com
>
>

-- 
Cheers,
Kunwar

--
http://www.freelists.org/webpage/oracle-l