19.12.10

SAP Note 14562 - BRARCHIVE - archiver stuck

Symptom:

ORACLE error ORA-00257: archiver error / archiver is stuck.
During a databank save with brbackup, the following errors are reported: BR301E with ORA-00257 and BR310E.
When you use brarchive to attempt to cancel the the archiver stuck, various warning messages are issued:
BR121W, BR252W, BR253W, BR301W with ORA-00257, and BR310W.

Cause and prerequisites

There is no free space in the archive directory (default: $ORACLE_HOME/saparch). Oracle can no longer archive the online redologs; the database freezes.

Solution
The archive logs in the archive directory must be backed up and deleted. To do this, you can call brarchive with option -sd or -ssd. Brarchive may issue several warning messages in the process, such as BR121W, BR252W, BR253W, BR301W with ORA-00257, and BR310W. You can ignore these warnings; they do not affect data security. If brarchive issues message BR018I immediately after startup:
BR018I Waiting for the next archive log...
you should cancel it with Control-C and start with an additional option, -n , where is the number of archive logs in the archive directory minus 1.

Caution:
Do not start BRARCHIVE with the database user "internal", but with the standard user "system" because, as a result, the system hangs.

No comments:

Post a Comment