Re: archiver problems
Date: Tue, 17 Jun 2008 03:16:50 -0700 (PDT)
On 17 Jun, 09:17, yossarian <yossaria..._at_operamail.com> wrote:
> Hello, Oracle 10.2.0.3 on SUSE Linux here.
> Since yesterday, the archiver seem not to be able to archive logs
> anymore. The database is set up to archive logs in the Flash Recovery
> Area, /var/oracle/disk02/flash_recovery_area. The /var partition has
> 7.9G available and I am able to create a file in
> Here's my problem: after some database activity I am not able to connect
> to the database anymore because I get this error:
> ORA-00257: archiver error. Connect internal only, until freed.
> I solved with this workaround:
> alter system archive log all to '/tmp' ;
> alter system archive log stop ;
> But I would like to understand what happened, even if this is just a
> development system.
> Thank you. Kind regards, Yossarian
SQL> show parameter recovery
HTH -g Received on Tue Jun 17 2008 - 05:16:50 CDT