lunes, 21 de septiembre de 2009

RMAN Using the Flash Recovery Area

1. Disable the parameters log_archive_dest and log_archive_duplex_dest, if they are set
in the database. You can do that by issuing the following commands:

SQL> alter system set log_archive_duplex_dest = '';
SQL> alter system set log_archive_dest = '';

2. Log on as a user with the sysdba role (such as the user sys) in preparation to create the
flash recovery area:

sqlplus / as sysdba (if logged in as the Oracle software owner)
sqlplus sys/ as sysdba

3. Issue the following commands to size and create the flash recovery area:

SQL> alter system set db_recovery_size = 4G;
SQL> alter system set db_recovery_dest = '/home/oracle/flasharea';