LOGICAL STANDBY
PRIMARY
SQL> select name, open_mode, database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
GPROD READ WRITE PRIMARY
SQL>
STANDBY
SQL> select name, open_mode, database_role from v$database;
NAME OPEN_MODE DATABASE_ROLE
——— ——————– —————-
GPROD MOUNTED PHYSICAL STANDBY
SQL>
IN PRIMARY
CHECK THE FLASHBACK IN PRIMARY
SQL> select flashback_on from v$database;
FLASHBACK_ON
——————
YES
SQL>
CHECK THE SUPPLEMENTAL LOG DATA FOR PRIMARY KEY AND UNIQUE KEY
SQL> select SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI from v$database;
SUP SUP
— —
NO NO
SQL>
SQL> alter database add supplemental log data(primary key, unique) columns;
Database altered.
SQL> select SUPPLEMENTAL_LOG_DATA_PK, SUPPLEMENTAL_LOG_DATA_UI from v$database;
SUP SUP
— —
YES YES
SQL>
IN PRIMARY EXECUTE THE LOGBUILDER
SQL> exec dbms_logstdby.build();
PL/SQL procedure successfully completed.
SQL>
IN STANDBY
SQL> alter database recover to logical standby GPROD;
Database altered.
SQL> shu immediate
ORA-01507: database not mounted
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 1006632960 bytes
Fixed Size 8628160 bytes
Variable Size 360712256 bytes
Database Buffers 633339904 bytes
Redo Buffers 3952640 bytes
Database mounted.
SQL> alter database open resetlogs;
Database altered.
SQL> alter database start logical standby apply;
Database altered.
SQL>
Posted by:Sakthi Sethu Perumal S
