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.

archive log destination

972227May 8 2013 — edited May 8 2013
Hello Guys, i am unable to find out the location of my archive logs. The VALUE field is null.
SQL> show parameter log_archive_dest;

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest                     string
log_archive_dest_1                   string
log_archive_dest_10                  string
log_archive_dest_11                  string
log_archive_dest_12                  string
log_archive_dest_13                  string
log_archive_dest_14                  string
log_archive_dest_15                  string
log_archive_dest_16                  string
log_archive_dest_17                  string
log_archive_dest_18                  string

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
log_archive_dest_19                  string
log_archive_dest_2                   string
log_archive_dest_20                  string
log_archive_dest_21                  string
log_archive_dest_22                  string
log_archive_dest_23                  string
SQL> archive log list
Database log mode              Archive Mode
Automatic archival             Enabled
Archive destination            USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence     2907
Next log sequence to archive   2908
Current log sequence           2909
When I do SQL>show parameter USE_DB_RECOVERY_FILE_DEST,I am not getting any result.
when I do *SQL>show parameter DB_RECOVERY_FILE_DEST, I am getting the result. 
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest                string      +BKUP_TSD1
db_recovery_file_dest_size           big integer 500G
So +BKUP_TSD1, is this where my archive logs are present?
This post has been answered by sb92075 on May 8 2013
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 Jun 5 2013
Added on May 8 2013
#general-database-discussions
5 comments
152 views