Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Add redo log member to flash recovery area

713057Jul 21 2009 — edited Jul 21 2009

I have an Oracle 10g database.

Database is in archivelog mode, using Flash Recovery Area for storage of the archive redo files.

It is not using Oracle Managed Files (db_create_file_dest is not set) - all examples so far use OMF in order to multiplex redo and control files to FRA.

Is is possible to multiplex redo log files to the flash recovery area? Same question for the contro file also.

What I tried, but not sucessfully:

My FRA is set to C:\ORACLE\PRODUCT\10.2.0FLASH_RECOVERY_AREA\ALEQ.

I added a redo log member to
C:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ALEQ\ONLINELOG\

The problem is that through EM I do not see any usage of "Online Log", but also when I query V$FLASH_RECOVERY_AREA_USAGE (there I see only usage of archivelog and backuppiece)

My assumption is that FRA is not utilized.

Thanks in advance.

This post has been answered by Uwehesse-Oracle on Jul 21 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 18 2009

Added on Jul 21 2009

#general-database-discussions

4 comments

1,624 views