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
|
|
 |
|
Guarantee your Success!
Oracle is the
world's most complex, robust and flexible database, considered
impossible to master without a mentor.
That's why all BC
Oracle trainers are working professionals, experts in Oracle who
share their tips and secrets. |
|
| |
|
Burleson is the American Team
Note:
This Oracle
documentation was created as a support and Oracle training reference for use by our
DBA performance tuning consulting professionals.
Feel free to ask questions on our
Oracle forum.
Verify
experience!
Anyone
considering using the services of an Oracle support expert should
independently investigate their credentials and experience, and not rely on
advertisements and self-proclaimed expertise. All legitimate Oracle experts
publish
their Oracle
qualifications.
Errata?
Oracle technology is changing and we
strive to update our BC Oracle support information. If you find an error
or have a suggestion for improving our content, we would appreciate your
feedback. Just
e-mail:
 and include the URL for the page.
Copyright ? 1996 - 2012
All rights reserved.
Oracle ?
is the registered trademark of Oracle Corporation.
|
|
