Oracle Data Guard, Oracle Data Guard Broker and Oracle Active Data Guard are the commercial names for technologies that allows physical and logical standby (slave) databases to be configured and managed with Oracle Database Enterprise Edition

learn more… | top users | synonyms

3
votes
0answers
39 views

Dataguard: preventing logical standby to loose track after flashback database on primary

We have 2 Oracle databases; a primary and a logical standby, configured with Dataguard. Whenever we have an application rollout on the primary, we create a restore point in case anything goes wrong. ...
1
vote
1answer
48 views

Dataguard parameter changed after DB bounce

I have a production environment of Oracle 11g R2 patchset 4 primary database configured with 2 standby machines. Primary database unique_name is DBIDI 1st standby database unique_name is DBIFI 2nd ...
1
vote
1answer
181 views

Gap resolution of Logical Standby Database via Archive Log Backups

Due to reasons outside the scope of this question, we had to flashback our Logical Standby Database (at the VM level) to the previous day. So, now i'm trying to resolve gaps in missing archivelogs ...
0
votes
1answer
48 views

data guard / network failure: deadline before global crash?

In a Maximum Availability scenario where there's one primary and one physical standby database, how long can we expect the system to run without problem when the standby site becomes out of reach (...
1
vote
1answer
77 views

Can standby database of a physical database be pluggable or vice versa?

We are currently planning to upgrade our databases from 11g to 12c. But I have some confusions regarding 12c. Here are my questions. Can standby database of a non-container database be pluggable or ...
1
vote
0answers
145 views

Sync oracle DBs using archive log when not connected to each other

I'm trying to synchronize 2 dbs which are not connected to each other, and located in a separated networks. The 'copy db' (aka: standby) can be read only, but still should be active. My intuition (...
0
votes
0answers
115 views

From RAC to Standby RAC With Active Dataguard

I have oracle database 11.2.0.3 with RAC feature , with 2 node on oracle linux 6.4 : ol6-112-rac1 and ol6-112-rac2 I want to create active data guard with RAC feature from this database , these ...
0
votes
1answer
70 views

Pointing DB to new Oracle home in primary and standby oracle database

I needed to apply a security patch to production database. To minimize the outage time, I cloned the oracle home and applied the patch to this newly created oracle home. With production DB there is a ...
1
vote
1answer
124 views

Configuring Oracle Data Guard or GoldenGate Standby DB replication while restricting DELETE DMLs

How can I use Data Guard or GoldenGate to create a slave database where the master does not propagate delete queries to the slave database? I want to have a replication/slave database to have all the ...
1
vote
2answers
106 views

Testing on Logical Standby Database

Primary DB: 11.2.0.3 Enterprise Standby DB: 12.1.0.2 Enterprise I've found several articles on making changes on a Physical Standby DB, but I've been having difficulty locating how to enable user ...
0
votes
0answers
40 views

Oracle Primary alert log error

I have a data guard setup operating in max performance mode. While checking the alert log entry of primary I observed this: I have checked the database roles, its showing properly as primary and ...
1
vote
1answer
203 views

Difference between ASYNC & SYNC real time apply

What is the difference between a data guard (Oracle 11g) operating in max performance ASYNC mode and enabling real time apply and a data guard operating in maximum availability SYNC and enabling real ...
1
vote
1answer
111 views

Grid Control Standby database status: Creation status unknown

After using Grid Control to add standby database, Data Guard status of standby database is showing "Creation status unknown". However, dataguard status on both primary and standby databases are OK. ...
0
votes
0answers
65 views

Strange entry in alert log - Oracle

I'm having a primary database which is a single instance database and it has a standby database running in maximum performance mode. Recently I added standby redo logs in my standby database and after ...
1
vote
1answer
70 views

Differentiating physical standby to cascaded standby

Why is it that for non-real time apply from cascading to cascaded standby that we have to mention as SYNC as the redo transport mode? Ideally we mention SYNC for real time apply right? Also, should ...
0
votes
1answer
163 views

Query on Standby redo logs - Oracle

I have a oracle 11g (11.3) database running with two standby databases (at different locations) in Maximum performance mode. The platform is Linux. Log transport parameters are: log_archive_dest_5 ...
1
vote
0answers
29 views

Oracle DataGuard [closed]

Maximum performance and Maximum Availability modes has only difference right? Former is async mode and the latter is sync mode wherein it waits for acknowledgement for up to a time and after that it ...
1
vote
1answer
979 views

Oracle DataGuard: Find primary from standby DB

I have SYS access to a data guard standby DB, but i need to find the primary one. I was searching in Oracle Docs but couldn't find anything that could help.
0
votes
1answer
396 views

Strange error in trace file for NSAn standby process

One of the Oracle databases I help manage is the primary in a standby configuration, with two standby databases. I started finding repeated entries in the alert log on the primary for a failure to ...
6
votes
1answer
998 views

What are the Oracle Dataguard Implications of Migrating to a PDB?

If I have an OLTP database with two physical standby instances (one remote) what are the implications of migrating the primary DB to being an Oracle 12c PDB? i.e. Does the process of migrating to ...
0
votes
3answers
2k views

How to tell from the OS whether Oracle instance is a standby, assuming no DB access?

One can easily check via SELECT database_role FROM v$database; whether your Oracle database is a primary or standby database. Is it possible to make the same determination without database access, ...
1
vote
1answer
238 views

Error while duplicating Oracle database after failover, using 11.2.0.4

I've recently updated oracle from version 11.2.0.1 to 11.2.0.4 and my redundant system is no longer able to recover from failover. I'm using scripts both on primary and standby node to get back to a ...
1
vote
1answer
1k views

How to retire a physical standby in Oracle 11.2

I have a production Oracle 11gR2 RAC database with a single node physical standby. Now it has become the time to retire the old standby and pass that role to a RAC on fresher hardware. We don't use ...
0
votes
1answer
68 views

Oracle dataguard - Redo apply

In a low bandwidth environment when a transaction commits that generates a large amount of redo data will cause other independent transactions to slow down. This is because the redo data of small ...
0
votes
0answers
3k views

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor at the time of switchover using data guard broker

I have a oracle data guard setup with nodes - one as primary and other as physical standby. I also, have configured the data guard broker on it. The problem is when I tried to switch over , I just ...
1
vote
1answer
58 views

How to verify that a certain commit has been transmitted to standby

Scenario: Oracle Data guard 12c with 1 primary and 1 standby, Max. Av. protection mode Primary open, standby mounted (all green in OEM) Perform a dummy CTAS in primary Question: Without opening ...
0
votes
1answer
526 views

RAC, data guard, physical stand by and impdp

We're setting up a RAC 2 nodes data guard 11g environment, with a remote physical standby (2 nodes also) We receive the client's data he exports with expdp. We have imported his dump in the primary ...
0
votes
1answer
112 views

Modify an Oracle Dataguard destination database

I'd like to set up some Oracle triggers to take action after rows are inserted, but I can't do this on our production database because it's controlled by a vendor. One alternative I was looking at is ...
2
votes
1answer
362 views

How does direct path load work when dataguard is enabled?

There's a few posts about direct path and dataguard but I just want to understand exactly how it actually works. How maybe I made an incorrect assumption, but if direct path means it writes to the ...
1
vote
1answer
5k views

Startup NOMOUNT and Startup MOUNT on dataguard oracle

I have a question here about Oracle data guard. After performing a switchover, we shutdown the new standby database and startup it. At this stage, sometimes I find DBA performance in 2 different ...
0
votes
1answer
296 views

ERP (Oracle) real time backup [closed]

I work in a small company, that runs an ERP that holds about 600MB of data. My task at hand is, to find a way to always have real time backup of the erp (Oracle 11g) that can be retrieved easily (so ...
0
votes
3answers
117 views

Oracle Data Guard - redo logs not in chronological order?

The disadvantages section of the Wikipedia entry for Oracle Data Guard says: If the network link connecting primary and standby is over-subscribed, the redo logs are not applied in chronological ...
1
vote
1answer
206 views

Can a production Oracle DB server also have a dataguard active standby for a different production database?

If you have a production oracle database (PRIM1) protected using Oracle Dataguard to a standby (STBY1) physical server in a different data centre, the standby server needs to be a similar ...
4
votes
1answer
1k views

Oracle: How to gather stats in a logical standby database?

I have a Primary and a (logical) Standby Database. The Schema 'APP' gets synced. Now a User has performance issues running a query against some tables in this 'APP' schema of the Standby Database. On ...
1
vote
0answers
975 views

What is the nature of “LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2”?

I'm not sure when this started, but for the time being the primary database instances in a physical standby configuration logs this message on every redo log switch. *********************************...
1
vote
2answers
5k views

Oracle RAC with single node Data Guard physical standby

Best practices for Oracle 11gR2 Data Guard implies that the primary and standby databases should have the same layout, eg. RAC to RAC. What special considerations would one need to take into account ...
0
votes
0answers
675 views

Oracle 10gR2 Data Guard Switchover

I need some help! I have a scenario of oracle 10gR2 database replication using data guard. I have selected the data guard command line interface. After my initial setup I can ship and apply logs from ...
4
votes
1answer
1k views

Standby controlfile error

I am doing dataguard. I have manually done a backup for the standby database. It was working fine. Problem arose when I used the standby controlfile. On the primary, I have created a standby ...
1
vote
1answer
521 views

Ora - 00088 error: command cannot be executed by shared server

I get this error from the database when I run the query: select status, error from v$archive_dest where dest_id=2; It's a dataguard environment. I have never seen this problem before. I'm not ...