Robin wrote:No need to shutdown, can you look at alert log for any latest errors?
The database archiving is struck up after archive log file system reached(db_recovery_file_dest) 100% but now the disk have enough free space to accommodate . I’ve switched the logfile manually but session hangs for long time.
Will it require db restart?
Version : Oracle 11g R2
Please let me know your suggestion on this.
Post the results of above query and if it showing full, then delete expired archives as below.
set lines 100 col name format a60 select name , floor(space_limit / 1024 / 1024) "Size MB" , ceil(space_used / 1024 / 1024) "Used MB" from v$recovery_file_dest order by name /