Clear Oracle archive logs

After Oracle archive log is cleared and oracle archive log reaches the set limit value, the database cannot be used.

After Oracle archive log is cleared and oracle archive log reaches the set limit value, the database cannot be used.

The database cannot use the archive logs of Oracle when the set limit value is reached.

The error message is:

ORA-00257: archiver error. Connect internal only, until freed

At this time, you can choose to move its log file to another place, and then delete the value in the parameter file.

1. view the location of the archived Log File

Sqlplus/as sysdba

Archive log list;

2. Move archived logs to other places

Cd location

Mv *. * Target backup location

3. Delete values in the parameter file

Enter

Rman target/

Crosscheck archivelog all;

Delete archivelog all;

Or back up the data before deleting it.

Backup archivelog all format'/home/oracle/archbackup/db1_arch _ % U' delete input;

,