Shulou(Shulou.com)05/31 Report--

This article will explain in detail how physical standby converts snapshot standby database. The content of the article is of high quality, so the editor will share it for you as a reference. I hope you will have a certain understanding of the relevant knowledge after reading this article.

Physical standby- > snapshot standby database

1 if apply service is active, stop redo apply2 to ensure that the database is in mount state 3 to ensure that fast recovery area is configured, but there is no need to start the flashback database function 4ALTER DATABASE CONVERT TO SNAPSHOT STANDBY

How is the process?

1. Verify that fast recovery area is configured

SYS@dogg > show parameter DB_RECOVERY_FILE_DEST

NAME TYPE VALUE

-

Db_recovery_file_dest tring / u01/app/oracle/fast_recovery_area

Db_recovery_file_dest_size big integer 10G

-db_recovery_file_dest_size if it is too small, adjust it through the following statement

Alter system set db_recovery_file_dest_size=10g scope=both

two。 Check to see if redo is redo apply

SYS@dogg > select process,status from v$managed_standby

-if referenced, cancel

SYS@dogg > alter database recover managed standby database cancel

3. Shut down the database and boot to mount

SYS@dogg > shutdown immediate

SYS@dogg > startup mount

4. Perform handover

SYS@dogg > alter database convert to snapshot standby

5. Open the database and view the schema

SYS@dogg > alter database open

SYS@dogg > select open_mode from v$database

OPEN_MODE

-

READ WRITE

-you can see that the standby library is in read-write mode.

6. Go to the main library to view the last archive

SYS@ogg > select max (sequence#) from v$archived_log

MAX (SEQUENCE#)

-

one hundred and one

7. Go to the repository to view the last archive received

SYS@ogg > select max (sequence#) from v$archived_log

MAX (SEQUENCE#)

-

one hundred and one

8. Prepare the database to query the archive of the last application

SYS@dogg > SELECT THREAD#, MAX (SEQUENCE#) AS "LAST_APPLIED_LOG" FROM V$LOG_HISTORY GROUP BY THREAD#

THREAD# LAST_APPLIED_LOG

--

1 97

-it is verified here that snapshot standby database only accepts but does not apply

On how to convert physical standby snapshot standby database to share here, I hope that the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.