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.
