Today I mess around with the Oracle database that can not start and open. I get some error messages from various places such as alert.log, sqlplus, rman.
These errors are,
ORA-03110: end-of-file on communication channel ORA-03135: connection lost contact ORA-00845: MEMORY_TARGET not supported on this system ORA-16038: log 3 sequence# 400 cannot be archived ORA-19502: write error on file "", block number (block size=) ORA-00312: online log 3 thread 1: '/u01/app/oracle/oradata/ITCAPPS/redo03.log' ORA-19816: WARNING: Files may exist in db_recovery_file_dest that are not known to database. ORA-00257: archiver error. Connect internal only, until freed.
I have do this step :
1. replace the current spfile with the old one
2. startup with pfile
3. restore and recover database using rman
But that no help at all.
And the real solution is to enlarge the capacity of the folder where the archivelog is