Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DB hang due to archive log full

user8850066Oct 11 2010 — edited Oct 11 2010
DB:10.2.0.4
OS:Solaris 5.10

i have a 2 node RAC db. nobody able to connect to db because archive is full. the archive is in
db_recovery_file_dest='+FRA_01'
db_recovery_file_dest_size=5G

Archive log is under asm +FRA_01 diskgroup so i am trying to delete archive log using rman as i cant do manually by OS command.

but from rman i am unable to connect the database as it is showing below as the dba is hang

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
ORA-00020: maximum number of processes (%s) exceeded

please tell me what to do and how to delete the archive logs
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2010
Added on Oct 11 2010
16 comments
6,112 views