Re: archiver problems
Date: Tue, 17 Jun 2008 10:48:34 -0700 (PDT)
Message-ID: <d72bee74-4d51-4d99-94b5-f1c5ce368bf3@q27g2000prf.googlegroups.com>
On Jun 17, 3:41 am, yossarian <yossaria..._at_operamail.com> wrote:
> gazzag wrote:
> > SQL> show parameter recovery
>
> SQL> show parameter recovery
>
> NAME TYPE VALUE
> ------------------------------------ ----------- -----------------------
> db_recovery_file_dest string
> /var/oracle/disk02/flash_recovery_area
> db_recovery_file_dest_size big integer 100G
> recovery_parallelism integer 0
>
> /var/oracle/disk02/flash_recovery_area exists, is writable and there are
> 7.9GB of free space in /var partition. Its size is 11G, so it's far
> from the maximum limit.
SELECT * FROM V$RECOVERY_FILE_DEST;
SELECT * FROM V$FLASH_RECOVERY_AREA_USAGE;
Does your alert log have anything to say about it? Have you
considered not lying to Oracle about the dest size? Do you do
backups? Does /var seem to go away sometimes?
jg
-- @home.com is bogus. Miss it every year, dang it. http://www.signonsandiego.com/uniontrib/20080616/news_1c16scenebam.htmlReceived on Tue Jun 17 2008 - 12:48:34 CDT