Shulou(Shulou.com)06/01 Report--

Execute on DG:

SQL > select database_role from v$database

DATABASE_ROLE

-

PHYSICAL STANDBY

Physical repository.

SQL > select status from v$instance

STATUS

-

MOUNTED

Originally, DG is in mount state.

SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL

Database altered.

Disconnect application synchronization.

SQL > alter database open read only

Database altered.

SQL > ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION

Database altered.

Turn on application synchronization.

SQL > select RECOVERY_MODE from v$archive_dest_status where rownum CONN SCOTT/TIGER

Connected.

SQL > update dept set DNAME = 'SA' where DEPTNO=30

1 row updated.

After Master Node 1 finished updating the dept table, neither Master Node 2 nor DG updated the data.

Commit is performed on master node 1, and data updates are completed on master node 2 and DG.

It can be synchronized.

OK .

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.