Oracle is doing exactly what you told it to do... don't overwrite a redo log until it as archived off with a different name.
Before you just clean out your archive destination, you need to save them off SOMEWHERE in case you need to do a
db recover.

>>> "will landstrom " <oracledba-ezmlmshield-x35386589.[Email address protected] 3/5/2007 11:14:24 AM >>>
free up space in the archive directory
----- Original Message -----
From: "Sikyala Raquel "
<oracledba-ezmlmshield-x83609548.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Monday, March 05, 2007 11:52 AM
Subject: Archive log directory full


> The space in my archive log directory is full and now I can't log into
> my database. I keep getting the following error:
> ORA-00257: archiver error. Connect internal only, until freed.
>
> How do I fix this?
>
> Raquel Sikyala
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Oracle LazyDBA home page