Databases Reference
In-Depth Information
■
as this recipe illustrates, reducing the size of the fast recovery area may not result in a reduction of the
actual space consumed. When you reduce the size, oracle tries to remove the nonessential backups to reduce the space
consumed; however, if the backups are considered essential, then they are not removed, and the fast recovery area may
consume more than what you had requested it to be shrunk to. as a best practice, check the actual space consumed
after a resize operation.
Caution
Configuring Archived Redo Logs to Go to FRA
Problem
You want to configure your database so that archived redo log files are written to the fast recovery area.
Solution
When you run the database in archivelog mode, you have to configure a location to which the archived redo logs are
written when they are generated. The default location for archived redo logs is $ORACLE_HOME/dbs in Unix-based
system and %ORACLE_HOME%\database for Windows-based systems. Of course, you can always configure a specific
location by executing the command
alter system set log_archive_dest_1
. In this recipe, you will see how to use
the fast recovery area as the destination of the archived redo logs.
Here are the steps to follow to send archived redo logs to the fast recovery area:
1.
Configure the fast recovery area with adequate space (Recipe 3-1).
2.
If the fast recovery area is already defined, then make sure you have enough space to hold
at least one archived log (Recipe 3-4).
Log on to the database as a user with the
sysdba
privilege (such as
sys
), and issue the
following command:
3.
alter system set log_archive_dest_1 = 'LOCATION=USE_DB_RECOVERY_FILE_DEST';
This command instructs the database to use the fast recovery area as the destination for
archived redo logs.
4.
Make sure the archived redo log destination 1 is enabled. By default it's enabled,
but someone may have disabled it. Issue the following SQL:
SQL>show parameter log_archive_dest_state_1
NAME TYPE VALUE
------------------------------------ --------------- ---------------- ----------
log_archive_dest_state_1 string ENABLE
5.
The presence of ENABLE confirms that the destination is enabled.
6.
If the destination is not enabled, enable it now by issuing this:
alter system set log_archive_dest_state_1 = enable;
