FIX- ora-01033

 FIX-ora-01033:

“alter database open”


SQL> alter database open;
alter database open
*
ERROR at line 1:
ORA-16038: log 1 sequence# 230 cannot be archived
ORA-19809: limit exceeded for recovery files
ORA-00312: online log 1 thread 1: '/opt/oracle/db/home/data/imapdb/redo01.log'



SQL> ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE=4G SCOPE=BOTH;

rman target / nocatalog
startup mount;
delete archivelog all;
alter database open;



SQL> shutdown abort
SQL> startup

open sqlplus an logon "/ as sysdba"
then try execute shutdown abort.
Next try start database step by step:

startup nomount
alter database mount
alter database open