Oracle 12c R1 physical standby uard physical standby database enable real-time apply

Oracle 12c R1 physical standby uard physical standby database enable real-time apply

The physical standby database is always in the mount state, which is inconvenient for Data Synchronization verification.

Enabling real-time apply enables real-time query.

In the standby database mount status:

SQL> select open_mode from v $ database;

OPEN_MODE
------------------------------------------------------------
MOUNTED

SQL> alter database recover managed standby database cancel;

The database has been changed.

SQL> ALTER DATABASE OPEN;

The database has been changed.

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT;

The database has been changed.

SQL> select open_mode from v $ database;

OPEN_MODE
------------------------------------------------------------
READ ONLY WITH APPLY

In the master database:

SQL> create table john (id number, name varchar2 (40 ));

The table has been created.

SQL> insert into john values (1, 'john ');

One row has been created.

SQL> insert into john values (2, 'cai ');

One row has been created.

SQL> commit;

Submitted.

Standby database query:

SQL> select * from john;

ID NAME
---------- Success ----------------------------------------------------------------------------------------------------------------------------------
1 john
2 cai

Visible data is synchronized in real time!

Recommended reading:

Use the Duplicate function of RMAN to create a physical partition uard

Basic Oracle tutorial-copying a database through RMAN

Reference for RMAN backup policy formulation

RMAN backup learning notes

Oracle Database Backup encryption RMAN Encryption

Use RMAN to back up duplicate to create a replica uard