Home » RDBMS Server » Server Administration » How much flash recovery area is enough for flashback (10.2.0.4.0, Microsoft Windows IA (32-bit))
How much flash recovery area is enough for flashback [message #520140] Thu, 18 August 2011 14:23 Go to next message
kytemanaic
Messages: 55
Registered: February 2009
Member
here's my settings


SYS@boston>SELECT ESTIMATED_FLASHBACK_SIZE FROM V$FLASHBACK_DATABASE_LOG;

ESTIMATED_FLASHBACK_SIZE
------------------------
                45195264

SYS@boston>select name, value, issys_modifiable from v$parameter where  name='db
_recovery_file_dest_size';

NAME
--------------------------------------------------------------------------------

VALUE
--------------------------------------------------------------------------------

ISSYS_MOD
---------
db_recovery_file_dest_size
9663676416
IMMEDIATE


SYS@boston>select * from v$recovery_file_dest;

NAME
--------------------------------------------------------------------------------

SPACE_LIMIT SPACE_USED SPACE_RECLAIMABLE NUMBER_OF_FILES
----------- ---------- ----------------- ---------------
D:\Ora102\chicago\boston_recover\
 9663676416 1671241216        1103842304              50


SYS@boston>select * from v$flash_recovery_area_usage;

FILE_TYPE    PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES
------------ ------------------ ------------------------- ---------------
CONTROLFILE                   0                         0               0
ONLINELOG                   .04                         0               1
ARCHIVELOG                  .16                       .01              21
BACKUPPIECE               16.84                     11.41              22
IMAGECOPY                     0                         0               0
FLASHBACKLOG                .25                         0               6

6 rows selected.

SYS@boston>



I have configured a flash recovery area of 9g yet the system keeps complaining that i have not enough flashback logs?

SPACE_RECLAIMABLE 1103842304
ESTIMATED_FLASHBACK_SIZE 45195264

the space_reclaimable is more than ESTIMATED_FLASHBACK_SIZE, so how is it possible the system always complain not enough space?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/scenarios.htm#i1050055

Quote:


SQL> SELECT TO_CHAR(STANDBY_BECAME_PRIMARY_SCN) FROM V$DATABASE;




it returns me 0, I try to flashback the now defunct former primary db chicago, the system complains. so how much is really enough?

from http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/dynviews_1111.htm#i1405397

Quote:

V$FLASHBACK_DATABASE_LOG


nothing seems to be right to me.

thanks a lot!

[Updated on: Thu, 18 August 2011 14:25]

Report message to a moderator

Re: How much flash recovery area is enough for flashback [message #520142 is a reply to message #520140] Thu, 18 August 2011 14:42 Go to previous message
Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
the system keeps complaining that i have not enough flashback logs?

When? I don't see anything like that in your post.

Regards
Michel
Previous Topic: partition-key using function issue
Next Topic: Error In Drop Package
Goto Forum:
  


Current Time: Sat Apr 27 03:34:25 CDT 2024