What will happen if the archive log distination is full and redo files can't be archived?
Will the instance hang? And automatic archive will stop by itself?
How to solve this without shuting down the instance?
And how can we avoid this situation? Is there any alternative destination that can be specified in the INIT file so that if the primary destination is full , ORACLE starts archiving at secondary destination without any problem.
Could any one explain my queries?