Tags » Data Guard

Getting Started With Data Guard

Oracle Data Guard is one of the software solutions provided by Oracle Corporation to maximize high availability of Oracle databases. Oracle Data Guard maintains one or many secondary databases as alternatives to the primary production database. 662 more words

DATA GUARD

Oracle Clusterware is restarting database "" | shut down instance "" of database "" | start up instance "" of database ""

When I used data guard broker to switchover primary database to standby database sometimes broker writes “Oracle Clusterware is restarting database”  … hangs and times out. 67 more words

DB

Oracle 11g Active Data Guard

Steps to configure Oracle 11g Active Data Guard:

====================================================
Server details

Primary Server:
hostname: vmnsedb01
Db_name : nsewebdv
DB unique name: nsewebdv
DB Service name: nsewebdv… 826 more words

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

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,268 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
SQL> select name, scn, time from v$restore_point;

NAME SCN TIME
------------------------------ ---------- ---------------------------------------------------------------------------
STANDBY_FLASHBACK_TESTING 241386 04-MAY-16 09.40.06.000000000 PM
… 181 more words
Oracle