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.
There is no free space in the archive directory (default: $ORACLE_HOME/saparch). Oracle can no longer archive the online redologs; the database freezes.
SolutionThe 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
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