Question: I am using Flashback and I want
to understand the maximum size of my flashback recovery area (FRA)
MOSC note ID 829254.1 says that Oracle can crash with ORA-19815,
ORA-19809 and/or ORA-16038 errors when you attempt to flash back
beyond your resources.
How do I compute the maximum guaranteed flashback recovery
Answer: You cannot always compute an exact
flashback recovery time because of many transactions competing for
oerr utility has this on the ORA-19815 error:
WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes
Cause: DB_RECOVERY_FILE_DEST is running out of
Action: One of the
1. Add disk space and increase
2. Backup files to tertiary device using RMAN.
changing RMAN retention policy.
4. Consider changing RMAN archivelog deletion
files from recovery area using RMAN
ORA-19809: limit exceeded for recovery files
Cause: The limit for recovery files specified by
the DB_RECOVERY_FILE_DEST_SIZE was exceeded.
Action: The error is accompanied by 19804. See
message 19804 for further details.
You can use the oerr
utility look up the
ORA-19804: cannot reclaim
string bytes disk space from string limit
Cause: Oracle cannot reclaim disk space of
specified bytes from the DB_RECOVERY_FILE_DEST_SIZE limit.
Action: There are five possible solutions:
1) Take frequent backup of
recovery area using RMAN.
2) Consider changing RMAN retention policy.
changing RMAN archivelog deletion policy.
4) Add disk space and
5) Delete files from recovery area using RMAN
Get the Complete
Oracle SQL Tuning Information
The landmark book
SQL Tuning The Definitive Reference" is
filled with valuable information on Oracle SQL Tuning.
This book includes scripts and tools to hypercharge Oracle 11g
performance and you can
for 30% off directly from the publisher.