Solution for Oracle 10 Gb archiving logs full

If the archive log of Oracle is full, an error occurs when the application connects to the database. You need to manually delete the expired archive log as follows:
1. Specify database instance $ export ORACLE_SID = db1
2. Enter rman $ rman
3. connect to the database RMAN> connect target sys/password;
4. view the archiving log status RMAN> list archivelog all;
5. manually delete archived log files
6. Update the archive log RMAN> crosscheck archivelog all; RMAN> delete expired archivelog all; -- a confirmation prompt is displayed in the middle. Enter "yes ".
7. exit rmanRMAN> exit author xuzhendong