Questions tagged [dataguard]

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

Filter by
Sorted by
Tagged with
6
votes
1answer
2k 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 ...
6
votes
1answer
2k 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 ...
4
votes
1answer
2k 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 ...
3
votes
1answer
3k views

Schema based replication in Oracle using Data Guard

We have active-passive database replication in our system cluster, so passive db belongs to DR class of nodes. We're trying to design zero-downtime deployment so I went out with few ideas. Since we ...
3
votes
1answer
833 views

Data guard broker cascaded standby delay parameter is ignored

I have 3 databases: db01 primary, db02 standby cascading, db03 standby cascaded. I have configured broker parameters by the following way: DGMGRL> show configuration Configuration – DB_HQ_DR ...
3
votes
1answer
4k 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 ...
3
votes
0answers
327 views

Cannot add standby database to the data broker configuration in oracle 11g

I have duplicated the primary database to standby database and then I added the primary database in data broker configuration. But when I'm trying to add standby database I'm getting following error: ...
2
votes
1answer
3k views

How to make dataguard switchover seamlessly

In my Dataguard configuration on a 12c environment, when I perform a switchover from primary (foo) to standby (bar) and then try to sqlplus in with user@foo, I receive the "ORA-011033: ORACLE ...
2
votes
2answers
496 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. ...
2
votes
1answer
808 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 ...
2
votes
1answer
5k 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 ...
2
votes
2answers
7k 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 ...
2
votes
1answer
64 views

Network line switch-over in Oracle Data Guard

We have a Primary database with a remote Standby which established using Oracle Data Guard. They can be syncing over a private Wireless Network and a Wired LAN (There are two options as network medium)...
2
votes
1answer
605 views

MSSQL Mirroring equivalent to Oracle Data Guard Snapshot Standby

Does MSSQL support an operating mode on the failover partner / mirror that is functionally equivalent to Oracle database's Snapshot Standby mode? ie A temporary active copy of the replicated ...
2
votes
1answer
3k views

Setting DataGuardSyncLatency for Oracle Data Guard

With Oracle 12.2 there is a new parameter DataGuardSyncLatency when setting up Data Guard. I keep getting the warning: Warning: ORA-16714: the value of property DataGuardSyncLatency is inconsistent ...
2
votes
1answer
991 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 (...
2
votes
1answer
655 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
381 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 ...
2
votes
1answer
2k views

When trying to configure data guard broker I'm getting Error: ORA - 12154 : TNS: could not resolve the connect identifier specified

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to data broker configuration and ...
2
votes
1answer
909 views

ORA-00205 error during the startup of physical standby database

Steps I have followed:- Created a physical standby database by using DUPLICATE TARGET DATABASE. Then checked the log gap between these two databases which was fine and in sync. After that standby ...
2
votes
0answers
2k 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. *********************************...
2
votes
1answer
257 views

Listener is not starting in my Standby database

I'm facing a serious issue in data guard installation. I'm setting oracle_sid and oracle_home and when I start the listener,error is showing as below: C:\Windows\system32>lsnrctl start LSNRCTL for ...
1
vote
1answer
776 views

What is the standard time delay taken for the data to get reflected in standby database when a new data is inserted in primary database

I've configured Data guard setup using data broker. When I'm inserting new data to the tables in primary database which is suppose to reflect in standby database. When I checked those data's in ...
1
vote
1answer
2k views

Oracle Data Guard:Can archived redo log files be sent from primary database to physical standby database manually?

As a result of the configuration of firewall,the primary database can`t not send the archived redo log to physical standby database in real time,the network connection between primary and physical ...
1
vote
1answer
605 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
1answer
2k 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
1k 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 quite ...
1
vote
1answer
31 views

Move Oracle Database to New Server with Dataguard in place

I have a live Oracle Database with Dataguard in placed. I want to migrate live database to new server as tech refresh, but only Primary database. How I can achieve this? I have ideas on how I want to ...
1
vote
1answer
1k views

Problems with connecting to a remote Oracle 12c database

tl;dr RMAN failing to connect to standby database with correct credentials. RMAN-04006: error from auxiliary database: ORA-01017: invalid username/password; logon denied Password file is correct, ...
1
vote
1answer
1k views

Nologging materialized view

I need to create a materialized view (MV) with auto refresh every hour. After I create it, a lot of redo logs are generated (10GB per hour). I think the solution is to recreate the MV in NOLOGGING ...
1
vote
1answer
916 views

Unable to start listener of standby database

As part of data guard configuration, I've installed standby database using Oracle Software only and configured .ora files/folders as required. But while trying to start the listener or check the ...
1
vote
1answer
412 views

How real-time apply works in logical standby oracle?

I am a little bit confused about real-time apply services. I've read a documentation about the services and I still have a question. Does archived redo logs required for logical standby or not? I've ...
1
vote
1answer
622 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
1k 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
2answers
537 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 ...
1
vote
1answer
8k 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.
1
vote
1answer
443 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
85 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 it, ...
1
vote
2answers
16k 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 ...
1
vote
0answers
73 views

Operation CTL_BOOTSTRAP canceled during phase 0, error = ORA-408

I am currently testing a data guard environment. In the alert.log of the broker I always see the following message after a switchover: 2019-05-23 08:08:54.716 7fffffff 0 Operation ...
1
vote
1answer
416 views

Rebuild dataguard configuration when standby is broken

I have an Oracle Data Guard configuration with two servers: oradb (physical) oradbstb (standby) Both are running with Oracle 11g R2. A few days ago I had problems with the standby (the server ...
1
vote
0answers
569 views

When trying to configure data guard broker I'm getting Error: ORA-16606: unable to find property “”

I'm trying to setup data guard broker in my production instance. I have duplicated the primary database to standby database successfully. I've added primary database to my configuration and when I'm ...
1
vote
0answers
2k views

ORA-17627:invalid username/password;logon denied error message when trying to duplicate database in data broker

I'm trying to duplicate the database for the purpose of Data broker in windows platform. When I'm trying to duplicate using below command DUPLICATE TARGET DATABASE TO LOCALDEV FROM ACTIVE DATABASE; ...
1
vote
0answers
1k views

RMAN Duplicate database errors with password file location could not be found

Running RMAN to duplicate two Oracle 12.1.0 databases, using the below, I'm faced with an error I can't seem to find an answer too. c:\rman TARGET sys/password@TEST AUXILIARY sys/password@TEST_SDBY ...
1
vote
0answers
1k views

Why is my Redo Log Apply service “spotty”?

I have a 12c Dataguard configuration between apple (primary) and orange (physical standby). The following is my entry in ldap: apple= (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS=(...
1
vote
1answer
561 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
3answers
6k 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, ...
0
votes
1answer
235 views

Backup Oracle Data Guard with TDPO

We are using TSM/TDPO SBT to backup Oracle Databases. When using Oracle Data Guard with TDPO, what is the best strategy to ensure backups continue after failover/switchover? TSM/TDPO uses a feature ...
0
votes
1answer
32 views

Force standby de-synchronisation for script testing

Two databases are configured in a production-standby configuration with Oracle Dataguard. I want to test a script that supposedly detects whether the dataguard observer is in the status SYNCHRONIZED ...