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;
,