| |
Oracle today reported experiencing this error: ORA-00257
See the next, the original Oracle archive log full, two solutions
A: Increase the log file size two: Remove unnecessary archive logs (we chose this option)
He said nothing on the Linux command:
Linux delete archived files
-> Su - oracle
-> Rman
-> RMAN> connect target sys / sys_passwd
-> RMAN> crosscheck archivelog all;
-> RMAN> DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-7';
or
-> RMAN> delete expired archivelog all;
Red statement is executed more slowly, patiently waiting for the next. Finally, click OK Yes to perform on it
Then use the next statement following verification, can not log in normally
---> Sqlplus / nolog
SQL> conn / as sysdba
or
-> Sqlplus user / pwd @ AXXX |
|
|
|