Home » RDBMS Server » Backup & Recovery » Add redo log member to flash recovery area (Oracle Database, Version 10.2.0.1.0, Windows Server 2003 32bit)
Add redo log member to flash recovery area [message #413389] Wed, 15 July 2009 08:27 Go to next message
akolev
Messages: 2
Registered: July 2009
Junior Member
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.

Thanks in advance.
Re: Add redo log member to flash recovery area [message #413393 is a reply to message #413389] Wed, 15 July 2009 08:40 Go to previous messageGo to next message
Michel Cadot
Messages: 68716
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Yes, it is possible, just give a name that is in the FRA.

Regards
Michel
Re: Add redo log member to flash recovery area [message #413490 is a reply to message #413393] Thu, 16 July 2009 01:32 Go to previous message
akolev
Messages: 2
Registered: July 2009
Junior Member
Hi,

Thanks for your reply.

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.

What do you think?
Previous Topic: Error running automated TSPITR
Next Topic: RMAN Backup Script (merged 3)
Goto Forum:
  


Current Time: Thu Nov 28 16:02:33 CST 2024