You might face this error while starting Database.
SQL> startup
ORACLE instance started.
Total System Global Area 9620525056 bytes
Fixed Size 2261368 bytes
Variable Size 3254783624 bytes
Database Buffers 6341787648 bytes
Redo Buffers 21692416 bytes
Database mounted.
ORA-00600: internal error code, arguments: [kcratr_scan_lastbwr], [], [], [],
[], [], [], [], [], [], [], []
Reason: It is due to server crash might be due to hardware or power failure.
Solution:
Recover the database by following the below steps:
Step 1) Shutdown the instance and open in mount state:
SQL>shutdown immediate;
ORACLE instance shut down.
SQL> startup mount;
ORACLE instance started.
Total System Global Area 9620525056 bytes
Fixed Size 2261368 bytes
Variable Size 3254783624 bytes
Database Buffers 6341787648 bytes
Redo Buffers 21692416 bytes
Database mounted.
Step 2) Recover Database
SQL> recover database;
Media recovery complete.
Step 3) Open the Database
SQL> alter database open;
Database altered.
Step 4) Shutdown and startup normally
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 9620525056 bytes
Fixed Size 2261368 bytes
Variable Size 3254783624 bytes
Database Buffers 6341787648 bytes
Redo Buffers 21692416 bytes
Database mounted.
Database opened.
No comments:
Post a Comment