Skip to main content
7 votes

How to make dataguard switchover seamlessly

Starting with 11.2, you do not need to create the trigger, you can define a role based service with Grid Infrastructure. foo: srvctl add service -db foo -service virtual_foo -role primary srvctl ...
Balazs Papp's user avatar
  • 40.8k
5 votes
Accepted

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 think what you want is real time apply, but for that, you'll have to create standby redo logs on your standby database first. As a side note, to make role transitions easier, it is considered best ...
Kris Johnston's user avatar
3 votes
Accepted

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

Yes, you can manually script it. This is covered in the documentation here. In essence, you copy the archive log files to the correct filesystem location on the logical standby host, then register ...
Philᵀᴹ's user avatar
  • 31.8k
3 votes
Accepted

Backup Oracle Data Guard with TDPO

When using Oracle Data Guard with TDPO, what is the best strategy to ensure backups continue after failover/switchover? Use RMAN catalog, because without a catalog, backups taken on one site do not ...
Balazs Papp's user avatar
  • 40.8k
3 votes

Oracle Active Dataguard and User passwords

You can use the same "ugly" mechanism Oracle uses to generate AWR reports for standby hosts. Create a database link that actually points back to primary and execute PL/SQL procedure on ...
ibre5041's user avatar
  • 1,564
2 votes

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

I would change the whole process of deploying. Stop SQL Apply. Create restore point on standby. Deploy to standby When testing is complete, flashback standby. Start SQL Apply. Safe to deploy on ...
Eli's user avatar
  • 29
2 votes

Force standby de-synchronisation for script testing

Just disable sending redo to the standby on the primary (replace with actual dest number): SQL> alter system set log_archive_dest_state_2=defer scope=memory; To re-enable (replace with actual ...
Balazs Papp's user avatar
  • 40.8k
2 votes
Accepted

Schema based replication in Oracle using Data Guard

If you want to do replication from one database to another, but skip certain schemas, then a Data Guard logical standby database may be a good fit for you. However, if you want to perform replication ...
Kris Johnston's user avatar
2 votes

Listener Status Blocked

A NOMOUNT instance stays in BLOCKED status with dynamic registration. You need to use static registration to connect a NOMOUNT instance remotely. Add the below to listener.ora and restart the ...
Balazs Papp's user avatar
  • 40.8k
1 vote
Accepted

How to change the thread of redo logfile group in standby database?

There is nothing wrong with not having the thread parameter explicitly set in a single instance environment. SQL> show parameter thread NAME TYPE VALUE ------...
Balazs Papp's user avatar
  • 40.8k
1 vote

RMAN restore of primary database - impact on standby database

You should be able to use Flashback Database to get the standby back to the point in time (i.e. SCN) to which the primary was restored (Flashback Database is a requirement for automated failover). If ...
Phill  W.'s user avatar
  • 8,915
1 vote
Accepted

How to get the oracle dataguard log transfer and applying status?

Oracle Dataguard does not transfer transactions, it transfers log records. Physical standby knows nothing about transactions (logical things), it knows only about changes to the files (physical ...
Eduard Okhvat's user avatar
1 vote
Accepted

Move Oracle Database to New Server with Dataguard in place

Create a full backup, then restore it to new server and update the dataguard configuration. Problem is, SCN in Standby database maybe different than New Primary database due to old Primary database ...
Balazs Papp's user avatar
  • 40.8k
1 vote

Oracle data Guard status (active/passive)- version 11g

No. The redo (archivelogs) can be transported without applying it on the standby. sequence# alone is not enough. You need to consider resetlogs_change# too. An expired archivelog entry is an ...
Balazs Papp's user avatar
  • 40.8k
1 vote

11g dataguard broken after primary ran out of space

Why would you re-initalize everything just because 1 datafile is missing? On the primary database, create a backup of the datafile: rman target / backup datafile 71 format '/tmp/whatever.bkp'; Copy ...
Balazs Papp's user avatar
  • 40.8k
1 vote

ora-49204: recursive dde invocation at phase i - after switchover to standby

Per Oracle Support, this is probably a bug https://support.oracle.com/knowledge/Oracle%20Database%20Products/2322290_1.html Function kcidr_file_header_check_common is File Header check which cause of ...
DreadPirateRoberts's user avatar
1 vote
Accepted

Network line switch-over in Oracle Data Guard

Sure, you can configure alternate locations. You may have this now on the primary database: log_archive_dest_1='location=use_db_recovery_file_dest' -- FRA for local archivelogs log_archive_dest_2='...
Balazs Papp's user avatar
  • 40.8k
1 vote

Problems with connecting to a remote Oracle 12c database

The problem was down to the TNSNAMES.ORA referring to the SERVICE rather than the SID.
David's user avatar
  • 23
1 vote
Accepted

MSSQL Mirroring equivalent to Oracle Data Guard Snapshot Standby

Mirroring does NOT have this capability. If you are using the Enterprise Edition of SQL Server then an Availability Group (MSSQL's successor to mirroring) with a readable secondary would do this, but ...
Jason Cumberland's user avatar
1 vote

How to instruct Oracle 11g Standby database MRP to bring down as soon as applying the given archive log file?

archive_xyz.log contains the sequence number Smax This is where you are wrong. You have 3 instances, you have 3 redo threads, so you have 3 archivelogs containing the change at Smax. Because of ...
Balazs Papp's user avatar
  • 40.8k
1 vote
Accepted

JDBC Connection on Current Primary Database After Switchover: ORA-01033 encountered

And that is why we use role-based services instead of the default service derived from instance_name and db_unique_name. If your primary database is called PROD_DB (db_unique_name), there will be ...
Balazs Papp's user avatar
  • 40.8k
1 vote

Using Oracle SCN to Calculate RPO

If you see the standby summary in DGMGRL then it is quite straightforward to know whether your configuration is satisfying your RPO and RTO(derived from business needs) or not. DGMGRL> show ...
atokpas's user avatar
  • 8,642
1 vote
Accepted

Oracle Data Guard Error

ORA-12700 to ORA-19400 ORA-16857: standby disconnected from redo source for longer than specified threshold Cause: The amount of time the standby was disconnected from the redo source database ...
Balazs Papp's user avatar
  • 40.8k
1 vote
Accepted

Setting up the Listeners for Oracle Dataguard

You should have a TNS entry, in the client machine, similar to following to connect to the data guard environment. BR = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ...
atokpas's user avatar
  • 8,642
1 vote

Nologging materialized view

Redo log is crucial in data guard environment. Hence we enable force logging before configuring data guard at the database level. So, no matter whether you use NOLOGGING clause or not the operation ...
atokpas's user avatar
  • 8,642
1 vote

Setting DataGuardSyncLatency for Oracle Data Guard

On the primary and standby server I set: ALTER SYSTEM SET DATA_GUARD_SYNC_LATENCY=0 scope=both sid='*'; Not sure if it should be 0.
r0tt's user avatar
  • 1,028
1 vote

Unable to start listener of standby database

Here are the steps I follow when creating a standby for a dataguard environment on windows server, please confirm in comments at which step you currently are to help identify your issue here. (prd1 is ...
A_V's user avatar
  • 1,364
1 vote
Accepted

How real-time apply works in logical standby oracle?

Does archived redo logs required for logical standby or not? Yes, it does. https://docs.oracle.com/cd/B19306_01/server.102/b14239/create_ls.htm#g105412 The archived redo logs (archivelogs, ...
Josh Bonello's user avatar
1 vote

Data guard broker cascaded standby delay parameter is ignored

If you want delay apply on Cascaded Standby you need to set the DELAY of LOG_ARCHIVE_DEST_n on Primary. The DELAY value that a cascaded standby uses is the value that was set for the ...
atokpas's user avatar
  • 8,642
1 vote
Accepted

Oracle Data Guard:When would data rows exist in the view v$archive_gap?

An archivelog gap simply means that the apply service on the standby site cannot continue because there is a missing sequence between the sequence that was applied and the next sequence that is ...
Kris Johnston's user avatar

Only top scored, non community-wiki answers of a minimum length are eligible