Re: archiver problems

From: joel garry <joel-garry_at_home.com>
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.html
Received on Tue Jun 17 2008 - 12:48:34 CDT

Original text of this message