[12C] switch between snapshot database and physical backup database (cloud control mode)

Time:2021-2-21

This article demonstrates how to experiment with cloud control to switch between snapshot database and physical backup database.

1 switch from physical backup database to snapshot database

1) Switch to physical backup library orcldg

2) Click Convert in the standby database column

3) Click to continue

4) To confirm the conversion of the database, click Yes

5) Conversion processing

6) When the conversion is completed, it will automatically refresh to the data guard configuration

7) View snapshot backup database roles

SQL> select name,open_mode,database_role,db_unique_name,dataguard_broker from v$database;



NAME OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME DATAGUAR

--------- -------------------- ---------------- ------------------------------ --------

ORCL READ WRITE SNAPSHOT STANDBY ORCLDG ENABLED

 

2. Switch snapshot database to physical backup database

1) Click Convert

2) Click to continue

3) To confirm the conversion, click Yes

4) Conversion processing

5) Conversion complete

6) View physical standby roles

SQL> select name,open_mode,database_role,db_unique_name,dataguard_broker from v$database;



NAME OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME DATAGUAR

--------- -------------------- ---------------- ------------------------------ --------

ORCL READ ONLY WITH APPLY PHYSICAL STANDBY ORCLDG ENABLED

3. Open the backup block change tracking file

1) Click backup settings

2) Select strategy, check enable block change tracking, and click Apply after configuration

3) Processing completed

 

 

 

 

 

Recommended Today

Python series crawlers monitor bitcoin price trend

preface Use Python to monitor and save bitcoin price information. development tool Python version: 3.6.4 Related modules: Requests module; Matplotlib module; Openpyxl module; Numpy module; And some modules that come with Python. Environment construction Install Python and add it to the environment variable. PIP can install the required modules. Main ideas Google can create an […]