Question: I am using Flashback and I want
to understand the maximum size of my flashback recovery area (FRA)
using the
db_recovery_file_dest_size.
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
time?
Answer: You cannot always compute an exact
flashback recovery time because of many transactions competing for
space.
The Oracle
oerr utility has this on the ORA-19815 error:
ORA-19815:
WARNING: %s of %s bytes is %s%% used, and has %s remaining bytes
available.
Cause: DB_RECOVERY_FILE_DEST is running out of
disk space.
Action: One of the
following:
1. Add disk space and increase
DB_RECOVERY_FILE_DEST_SIZE.
2. Backup files to tertiary device using RMAN.
3. Consider
changing RMAN retention policy.
4. Consider changing RMAN archivelog deletion
policy.
5. Delete
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 error:
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.
3) Consider
changing RMAN archivelog deletion policy.
4) Add disk space and
increase DB_RECOVERY_FILE_DEST_SIZE.
5) Delete files from recovery area using RMAN
 |
|
Get the Complete
Oracle SQL Tuning Information
The landmark book
"Advanced Oracle
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
buy it
for 30% off directly from the publisher.
|
