Hi All,
We're using Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production.
Let me know how to resolve following below errors.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [0], [1443772], [0],
[1448425], [12583040], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [2662], [0], [1443771], [0],
[1448425], [12583040], [], [], [], [], [], []
ORA-01092: ORACLE instance terminated. Disconnection forced
ORA-00600: internal error code, arguments: [2662], [0], [1443769], [0],
[1448425], [12583040], [], [], [], [], [], []
Process ID: 1969
Session ID: 1 Serial number: 5
SQL> startup mount pfile='$ORACLE_HOME/dbs/initatos.ora'
ORACLE instance started.
Total System Global Area 688959488 bytes
Fixed Size 2216544 bytes
Variable Size 276827552 bytes
Database Buffers 406847488 bytes
Redo Buffers 3067904 bytes
Database mounted.
SQL> alter database open resetlogs;
alter database open resetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01113: file 1 needs media recovery
ORA-01110: data file 1: '/oradata/rams/atos/system01.dbf'
SQL> alter database open noresetlogs;
alter database open noresetlogs
*
ERROR at line 1:
ORA-01139: RESETLOGS option only valid after an incomplete database recovery
SQL> recover database using backup controlfile until cancel;
ORA-00283: recovery session canceled due to errors
ORA-16433: The database must be opened in read/write mode.
Regards
Ramesh
Message was edited by: Ramesh