Tuesday, April 16, 2013

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

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

Details: This error occurs when attempting to login via sqlplus

Cause:One of the drives was out of space, the one that stored archive logs.

Solution:Removing old archive logs by starting RMAN and running the following script:
run {
delete noprompt archivelog all completed before 'sysdate-7';
}
The above will remove all archive logs older than 7 days

No comments:

Post a Comment