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

1. Check the status of the main library:

SQL > SELECT SWITCHOVER_STATUS FROM V$DATABASE

SWITCHOVER_STATUS

-

TO STANDBY

two。 Set the main library to standby role

Alter database commit to switchover to physical standby

Shutdown immediate

Startup mount

3. Convert standby to primary

SQL > select NAME, DB_UNIQUE_NAME, open_mode,DATABASE_ROLE from v$database

NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE

-

ORCL sty MOUNTED PHYSICAL STANDBY

SQL > SELECT SWITCHOVER_STATUS FROM V$DATABASE

SWITCHOVER_STATUS

-

TO PRIMARY

Alter database commit to switchover to primary

Alter database open

SQL > select NAME, DB_UNIQUE_NAME, open_mode,DATABASE_ROLE from v$database

NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE

-

ORCL sty READ WRITE PRIMARY

4. Execute on the original primary library:

Alter database recover managed standby database disconnect from session

SQL > select NAME, DB_UNIQUE_NAME, open_mode,DATABASE_ROLE from v$database

NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE

-

ORCL pri MOUNTED PHYSICAL STANDBY

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.