Skip to Main Content
Forums

Analytics Software

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.

How to compare dates in OBIEE reporting

723000Jul 27 2010 — edited Jul 27 2010
TRUNC(DAY_DT) = TRUNC(SYSDATE)

equalant function in OBIEE reporting.......

Regards,
sp

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 Aug 24 2010
Added on Jul 27 2010
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee
10 comments
5,086 views