Tags » Data Guard

Queries to check primary and standby sync

In Primary:
===========

SQL> select * from v$archive_processes where status <>’STOPPED’;

Primary: SQL> Set lines 200 pages 50
SQL > select dest_id,STATUS,database_mode,recovery_mode, archived_seq#, error,gap_status
from v$archive_dest_status; 182 more words

Data Guard

Incremental restore from primary database to standby database

If we have Dataguard, either with physical or logical standby, our databases will always be synchronized and we will be able to do switchover whenever we want. 300 more words

Oracle

Logical standby troubleshooting

select EVENT_TIME,
EVENT_TIMESTAMP,
CURRENT_SCN,
COMMIT_SCN,
XIDUSN,
XIDSLT,
XIDSQN,
dbms_lob.substr(event,4000,1) as event,
STATUS_CODE,
STATUS
FROM dba_logstdby_events
ORDER BY EVENT_TIMESTAMP DESC;

Data Guard

No standby redo logfiles created for thread XX

After recreating the standby database to fix an archivelog gap, I saw the following in the alert log: No standby redo logfiles created for thread 1. 68 more words

Perform export / expdp from physical standby and logical standby

Expected behiviour
==================
We can run exp in logical standby and physical standby without any issue because, export (exp) will not do any write any information inside database… 754 more words

Backup

DataGuard's reaction when FarSync is off ?

One of the most advantages of Oracle DB 12c is Farsync, like the image below, but what happen when FarSync DB is down? How can DG automatic transport log to DR Site? 414 more words
Data Guard

upgrade on primary or standby first

Upgrading database when you have physical standby database.

in short
1) instal new oracle version in standby and start your standby database with new oracle home and start MRP (note you have to configure listener and tns) 115 more words

Data Guard