Wednesday, May 21, 2008

How to create a flash recovery area.

Hi,

To create a flash recovery area from scratch the following two commands need to be executed:

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST_SIZE = (Size of FRA for example 10G) SCOPE=BOTH;

and

ALTER SYSTEM SET DB_RECOVERY_FILE_DEST = (Path to FRA for example '/u01/flash_recovery_area') SCOPE=BOTH;

That is it.


Thanks,
Sergey.

No comments: