Re: Reg. Archive Log Problem

On Mar 9, 3:47 am, "calms" <calmsqur..._at_gmail.com> wrote:
> HI All,
> Firstly im NEW to oracle and I have a problem with Archive Log.
>
> archive log is stored under
> c:\oracle\product\10.2.0\flash_recovery_area\DBNAME\ARCHIVELOG
> the default space allocated is 2gb.
>
> When it reached 2GB, i got the following error and i cudnt access my
> database.
>
> "The archiver hung at time/line number: Wed Mar 07 14:44:23
> 2007/10585664."
>
> Later i deleted the old archive log files, now its fine. But within 2
> weeks it reach the limit so anyone help me to permanently solve this
> prob...
>
> thks
> Prasad.N.M

Yea Calms... You really DO need to read up on this one.

I'm a bit new to Oracle 10g myself, after having used 8i/9i for quite some time. Whereas I was FAMILIAR with the flashback area, you actually size this one. You give it the amount of space you want it to use and once it fills that up, it's been my experience that even if you've got additional space, you're out of luck once you've hit that (in your case) 2GB limit.

Do what Sybrand said. Put an RMAN backup solution in place and delete the archivelogs as you've successfully backed them up. That's standard RMAN that's also available in earlier versions of Oracle. It becomes a bit more valuable when you're dealing with a version that tracks how much space you're using and sets a limit on it as Oracle 10g appears to do with the flashback area.

Since you've manually deleted the archivelogs, you'll need to sync RMAN with the ones that are currently there and accessible.

Charles R. Whealton
Charles Whealton @ pleasedontspam.com Received on Sat Mar 10 2007 - 11:19:41 CST