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

PS: this experiment is based on the previous DG blog.

The state before the main library, the execution of the transition statement, the state after the main library

15:00:01 SYS @ slow > select name,database_role,protection_mode from v$database

NAME DATABASE_ROLE PROTECTION_MODE

SLOW PRIMARY MAXIMUM PROTECTION

1 row selected.

Elapsed: 00:00:00.00

15:00:35 SYS @ slow > select status from v$instance

STATUS

-

OPEN

1 row selected.

Elapsed: 00:00:00.00

18:57:24 SYS @ slow > startup mount force

ORACLE instance started.

Total System Global Area 521936896 bytes

Fixed Size 2254824 bytes

Variable Size 377489432 bytes

Database Buffers 138412032 bytes

Redo Buffers 3780608 bytes

Database mounted.

18:57:44 SYS @ slow > select name,database_role,protection_mode from v$database

NAME DATABASE_ROLE PROTECTION_MODE

SLOW PRIMARY MAXIMUM PROTECTION

1 row selected.

Elapsed: 00:00:00.01

18:58:20 SYS @ slow > select status from v$instance

STATUS

-

MOUNTED

1 row selected.

Elapsed: 00:00:00.01

18:58:39 SYS @ slow > alter database set standby database to maximize availability

Database altered.

Elapsed: 00:00:00.00

19:00:09 SYS @ slow > alter database open

Database altered.

Elapsed: 00:00:03.03

19:00:25 SYS @ slow > select name,database_role,protection_mode from v$database

NAME DATABASE_ROLE PROTECTION_MODE

SLOW PRIMARY MAXIMUM AVAILABILITY

1 row selected.

Elapsed: 00:00:00.00

19:01:20 SYS @ slow >

The state before the preparation of the library, the conversion statement of the main library, the state after the preparation of the library, everything is normal, the transition is successful!

14:56:33 SYS @ gotime > select name,database_role,protection_mode from v$database

NAME DATABASE_ROLE PROTECTION_MODE

SLOW PHYSICAL STANDBY MAXIMUM PROTECTION

1 row selected.

Elapsed: 00:00:00.00

14:57:21 SYS @ gotime > select status from v$instance

STATUS

-

OPEN

1 row selected.

Elapsed: 00:00:00.00

18:56:45 SYS @ gotime > startup mount force

ORACLE instance started.

Total System Global Area 521936896 bytes

Fixed Size 2254824 bytes

Variable Size 377489432 bytes

Database Buffers 138412032 bytes

Redo Buffers 3780608 bytes

Database mounted.

18:57:07 SYS @ gotime > select name,database_role,protection_mode from v$database

NAME DATABASE_ROLE PROTECTION_MODE

SLOW PHYSICAL STANDBY MAXIMUM AVAILABILITY

1 row selected.

Elapsed: 00:00:00.04

19:02:08 SYS @ gotime >

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.