Certa vez um ora-600 me apareceu e ai.......
Siga os passos em destaque, é claro né........
Lembrando que as utilizações previstas :
- 20 January 2015
- 14 April 2015
- 14 July 2015
- 20 October 2015
Fonte ( http://www.oracle.com/technetwork/topics/security/alerts-086861.html )
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT;
ORACLE instance started.
Total System Global Area 1870647296 bytes
Fixed Size 2214416 bytes
Variable Size 1073743344 bytes
Database Buffers 771751936 bytes
Redo Buffers 22937600 bytes
Database mounted.
SQL> RECOVER DATABASE
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SQL> recover database until cancel;
Media recovery complete.
SQL> recover database;
ORA-00283: recovery session canceled due to errors
ORA-00264: no recovery required
SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-01589: must use RESETLOGS or NORESETLOGS option for database open
SQL> alter database open resetlogs;
Database altered.
SQL>