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

Seberg
Here a doc:

Manual Standby Database under Oracle Standard Edition

http://www.databasejournal.com/features/oracle/article.php/3682421/Manual-Standby-Database-under-Oracle-Standard-Edition.htm
Aman....
Answer
SANCHIT GUPTA wrote:
Hi experts,

i want to create standby database on 11gR2 standard edition one on both environment linux to linux and window to window. i have invested my 4-5 days on that but i didn't able to create, due to standard edition. plz provide me step by step creation. it wil bel great help.....

Did you have a look at the dataguard docs,
http://docs.oracle.com/cd/E11882_01/server.112/e10700/standby.htm#i72073

Which has this mentioned quite clearly,
>
Oracle Data Guard is available only as a feature of Oracle Database Enterprise Edition. It is not available with Oracle Database Standard Edition.

Note:
It is possible to simulate a standby database environment with databases running Oracle Database Standard Edition. You can do this by manually transferring archived redo log files using an operating system copy utility or using custom scripts that periodically send archived redo log files from one database to the other. The consequence is that this configuration does not provide the ease-of-use, manageability, performance, and disaster-recovery capabilities available with Data Guard>

So if you want to have data guard, use Enterprise Edition.

Aman....
Marked as Answer by SANCHITGUPTA · Sep 27 2020
SANCHITGUPTA
i read that in standard edition we cant use data guard... data guard facility is available on enterprise edition
420678
Hello,

Data Guard is only available for Oracle Enterprise Edition. If you are using Oracle Standard edition, then there are 3rd party products that you can use as Data Guard alternatives. One such product is Dbvisit Standby. Read a review of Dbvisit Standby on oracle-base: http://www.oracle-base.com/articles/misc/dbvisit-standby.php

Regards,
Hemant K Chitale
Besides the external web sites, there is an Oracle Support note Alternative for standby database in standard edition [ID 333749.1]


Hemant K Chitale
SANCHITGUPTA
Plz can u provide me a link
SANCHITGUPTA
Still my problem is pending
Hemant K Chitale
333749.1 is the Article ID on https://support.oracle.com

Hemant K Chtale
SANCHITGUPTA
by the rman is possible to create standby database on standard edition one
kuljeet singh -
sanchit,
by the rman is possible to create standby database on standard edition one
you can create standby in standard edition but all major DG functionality will not available in this version ,See below detail


automatically redo apply is not possible in standard edition As Oracle Data Guard is available only as a feature of Oracle Database Enterprise Edition. It is not available with Oracle Database Standard Edition.
Note:
It is possible to simulate a standby database environment with databases running Oracle Database Standard Edition. You can do this by manually transferring archived redo log files using an operating system copy utility or using custom scripts that periodically send archived redo log files from one database to the other. The consequence is that this configuration does not provide the ease-of-use, manageability, performance, and disaster-recovery capabilities available with Data Guard

http://docs.oracle.com/cd/B28359_01/server.111/b28294/standby.htm#i72073
1 - 10
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,253 views