Pages

Thursday, August 10, 2023

ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.

ORA-00257: Archiver error. Connect AS SYSDBA only until resolved.
df -hP

Archive destination /oracle_db/db2 is 100% full

Need to delete some archive files + run RMAN backup

Once /oracle_db/db2 has space, issue 

ALTER SYSTEM SWITCH LOGFILE;

/dev/mapper/OraVG02-OraVol03   200G  25M  200G   100% /oracle_db/db2


To delete old archive files:
rman target /
DELETE OBSOLETE;
or
DELETE FORCE COPY OF ARCHIVELOG ALL;

once there is space, issue
ALTER SYSTEM SWITCH LOGFILE;


/dev/mapper/OraVG02-OraVol03   200G   33M  200G   1% /oracle_db/db2

No comments:

Post a Comment