Monthly Archives: December 2014

how to figure out the issues with flash recovery area in oracle database.

Space usage in the flash recovery area is automatically monitored by Oracle database. Warning messages are written to the alert logs when the space usage has reached 85% and a critical warning is issued when the space usage nears 97%. Oracle also removes files that are on the obsolete file list when there is less than 10 percent free space available. Alternatively dba_outstanding_alerts view can be queried to get the details about the warnings and suggested actions:

SQL> SELECT OBJECT_TYPE, MESSAGE_TYPE, MESSAGE_LEVEL,
REASON, SUGGESTED_ACTION
FROM DBA_OUTSTANDING_ALERTS;

Leave a comment

Filed under Oracle

Oracle database – What is the difference between restoring and recovering?

Restoring involves copying backup files from secondary storage (backup media) to disk. This can be done to replace damaged files or to copy/move a database to a new location. The data file is at a prior point of time than the current database.

Recovery is the process of applying redo logs to the database to roll it forward. One can roll-forward until a specific point-in-time, or roll-forward until the last transaction recorded in the log files.

Leave a comment

Filed under Oracle