Skip to Main Content
Forums

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.

new online redo log files with OMF

Neo-bAug 28 2011 — edited Aug 28 2011
Hello All,

I am using Oracle 11gR2 i created my DB using Oracle Managed files (OMF).

I wanted to re size my redo logs so i went into dropping old redo logs and create new one.

this how was my redo logs looks like. It was created with the DB creation with OMF format: 
.../app/oradata/ORCL11/onlinelog/o1_mf_1_6pfncw81_.log
.../app/flash_recovery_area/ORCL11/onlinelog/o1_mf_1_6pfncx5z_.log
.../app/oradata/ORCL11/onlinelog/o1_mf_2_6pfncxps_.log
.../app/flash_recovery_area/ORCL11/onlinelog/o1_mf_2_6pfncz1v_.log
.../app/oradata/ORCL11/onlinelog/o1_mf_3_6pfnczhd_.log
.../app/flash_recovery_area/ORCL11/onlinelog/o1_mf_3_6pfnd0vw_.log
using the below script i created new redo logs 
alter database add logfile group 1 (
'.../app/oradata/ORCL11/onlinelog/redo1.log',  
'.../app/flash_recovery_area/ORCL11/onlinelog/redo1.log') size 76m reuse;
.........
and i added new redo log group
alter database add logfile group 4 (
'.../app/oradata/ORCL11/onlinelog/redo4.log',  
'.../app/flash_recovery_area/ORCL11/onlinelog/redo4.log') size 76m reuse;
I was not able to create the redo logs where the name of the redo log file is : o1_mf_1_6pfncw81_.log, since it is OMF format.

My question creating my redo logs in the way that did does it have any impact ? on archiving the redo logs ? any impact on the database since now it is not OMF?

How can i create my redo log files with OMF format ?

Regards,
This post has been answered by rajeysh on Aug 28 2011
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Sep 25 2011
Added on Aug 28 2011
#general-database-discussions
3 comments
2,255 views