DBCS - Database is not coming and error its throwing is ORA-00257

 Archival Error - ORA-00257  and database not starting up

This week one of my database is not starting up, when i checked the trace files i was able to see the errors

  

Once i tried to start the database it was non mountable, it was starting but in the end it was throwing an error 

ORA-03113: end-of-file on communication channel

Cause: The connection between Client and Server process was broken.

      Action: There was a communication error that requires further investigation.  

 Hence database was not in the condition to start.

After a search i got this blog and helped me to start up the database with nomount option.

> sqlplus / as sysdba 

> startup nomount 

This open up the database for the administration purpose and from the trc file i am able to identify that redo log file was completely full and i have to increase the size of it. 

now we need to increase size of the recovery file 

QL> alter system set db_recovery_file_dest_size=10g scope=both;

Once file size is been increased open the database. 

> open database 

> mount 

Database is now ready to server.

just for yourself you can shutdown and startup the database if you want else error must have gone.