Tags » Data Guard

Another reason why you should use the Data Guard Broker for your #Oracle Standby — The Oracle Instructor

The Data Guard Broker is recommended for various reasons, this one is less obvious: It prevents a Split-Brain problem that may otherwise occur in certain situations.

45 more words
Data Guard

Another reason why you should use the Data Guard Broker for your #Oracle Standby

The Data Guard Broker is recommended for various reasons, this one is less obvious: It prevents a Split-Brain problem that may otherwise occur in certain situations. 342 more words

TOI

Activating physical standby (cont)

There are two ways to activate a physical standby database: failover (activate it to become a primary) and snapshot standby. We’ll see later that snapshot standby also leverages guaranteed restore point therefore essentially the two methods are the same. 1,220 more words

Oracle

Activate physical standby database and flashback

— standby
SQL> alter database recover managed standby database cancel;
SQL> create restore point standby_flashback_testing guarantee flashback database;
SQL> alter session set nls_date_format=’yyyy-mm-dd hh24:mi:ss’;
SQL> col name for a30… 201 more words

Oracle

Managed Redo Apply using all CPU

Again and again I’m forced to setup Data Guard on Windows platforms. Windows is not my favorite platform but that does not matter sometimes. On the other hand, the Oracle command line tools are identical on every platform. 371 more words

Database

Redo log shipping process in Data Guard

Redo Logs can be shipped either by ARCH process or LNS process.

If the log_archive_dest_2 is configured with “LGWR”, then LNS process will be spawned to ship the Redo Logs to the Standby DB… 82 more words

Oracle

Configuring Data Guard in 11g using Duplicate

Oracle 11.2.0.4.8
Solaris SPARC 10u11

Primary: 200.31.108.103 ORACLE_SID: LCM2DBS1 RAC, ASM
Standby: 200.31.108.21 ORACLE_SID: LCM2DBS single instance, non-ASM

Logging

Check that the primary database is in archivelog mode. 1,763 more words

Oracle