How to make database availabe after audit tablespace full
My database had turn on audit and it accident excess the audit tablespace,
I can't logon my database now, do you have any solution can help on this, thank you very much!
/db>sqlplus
SQL*Plus: Release 10.2.0.5.0 - Production on Mon May 7 16:40:55 2012
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
Enter user-name: sys as sysdba
Enter password:
ERROR:
ORA-09817: Write to audit file failed.
IBM AIX RISC System/6000 Error: 28: No space left on device
ORA-01075: you are currently logged on
Enter user-name:
/db>rman target /
Recovery Manager: Release 10.2.0.5.0 - Production on Mon May 7 16:41:06 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============