I often happen when the The Fast Recovery Area (FRA) is full with old
archive log file and so need to be emptied.
Let's get in the RMAN
You may also like to adjust the size of the FRA:
SQL> alter system set db_recovery_file_dest_size=10G;
output: system altered
You will be able to archive
SQL> archive log all;
output: 2 logs archived.
Let's get in the RMAN
- rman> connect target /
- rman> crosscheck archivelog ALL;
- rman> list expired archivelog ALL;
- rman>DELETE expired archivelog ALL;
- rman>delete archivelog all completed before 'SYSDATE-1';
- rman>exit;
You may also like to adjust the size of the FRA:
SQL> alter system set db_recovery_file_dest_size=10G;
output: system altered
You will be able to archive
SQL> archive log all;
output: 2 logs archived.