Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.
Sign up to join this community
I have followed link to solve the problem.
When it is giving ORA-00600: internal error code, arguments: [kcratr1_lostwrt] then I am using:
SQL> startup mount
the above line should return ORACLE Instance started
but it is showing "cannot start already-running Oracle - shut it down first".
ORA-00600 is Oracle's generic message for un-handled internal exceptions i.e. bugs. Usually they require us to raise an SR with Oracle Support. This can be a problem for sites who are using Oracle without a support contract. In that situation we are thrown on the resources of the internet.
The problem you are experiencing is due to a corrupted block. The top result in Google offers a simple workaround: find out more.
SQL> shutdown immediate;
SQL> startup mount;
SQL> recover database;
SQL> alter database open;
(Of course, this is only a solution if you are running in archivelog mode, and so can recover the lost block).
Also I am guessing that you are running database on disks with write caching enabled. Or RAID controller with write cache enabled and no batteries or flash to preserve unwritten data.
Do not do that if you value your data!
Quite probably you will get some corruptions in case of crash reboot e.g. in case of power loss.
Instead of using
SQL> alter database open;
command use the follwing command
SQL> alter database open resetlogs;
