Database Administration (MOSC)

MOSC Banner

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

Please can help with possible solution to the problem. I used the below script after few days the error happened again.

run {

crosscheck archivelog all;

crosscheck backup;

delete noprompt obsolete;

delete noprompt expired archivelog all;

delete noprompt expired backup;

}

delete noprompt archivelog until time "sysdate-.25";


Below is my db_recovery_file_dest_size

     big integer 100G.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center