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

This article shows you how to configure Standby Redo Log, the content is concise and easy to understand, can definitely brighten your eyes, through the detailed introduction of this article, I hope you can get something.

Data Guard in maximum protection and maximum availability mode, the Standby database must be configured with standby redo log, and the following lab demonstrates the principles and process of creation.

1. Principle

1). The file size of standby redo log is the same as the online redo log file size of primary database

2). The number of standby redo log log filegroups is calculated according to the following principles

Standby redo log group number formula > = (number of instance log groups + 1) * number of instance

For example, in my environment, there is only one node, and this node has three sets of redo, so

Standby redo log group number formula > = (3x 1) * 1 = = 4

So you need to create 4 groups of Standby redo log

3)。 For security reasons, each log group can contain multiple member files

two。 During the configuration process, it only needs to be configured on the standard side under normal circumstances. Considering the switching between the master and the slave, it is also configured on the primary side.

1) add four groups of Standby redo log to the Standby library, and restore the user slave database.

Sys@ora10g > alter database add standby logfile group 4 ('/ oracle/u02/ORA10GDG/STANDBYRD01.LOG') size 200m

Database altered.

Sys@ora10g > alter database add standby logfile group 5 ('/ oracle/u02/ORA10GDG/STANDBYRD02.LOG') size 200m

Database altered.

Sys@ora10g > alter database add standby logfile group 6 ('/ oracle/u02/ORA10GDG/STANDBYRD03.LOG') size 200m

Database altered.

Sys@ora10g > alter database add standby logfile group 7 ('/ oracle/u02/ORA10GDG/STANDBYRD04.LOG') size 200m

Database altered.

2) add four groups of Standby redo log to Primary library for switching between master and slave

Sys@ora10g > alter database add standby logfile group 4 ('/ oracle/u02/ORA10G/STANDBYRD01.LOG') size 200m

Database altered.

Sys@ora10g > alter database add standby logfile group 5 ('/ oracle/u02/ORA10G/STANDBYRD02.LOG') size 200m

Database altered.

Sys@ora10g > alter database add standby logfile group 6 ('/ oracle/u02/ORA10G/STANDBYRD03.LOG') size 200m

Database altered.

Sys@ora10g > alter database add standby logfile group 7 ('/ oracle/u02/ORA10G/STANDBYRD04.LOG') size 200m

Database altered.

3.Standby redo log deletion method

Sys@ora10g > alter database drop standby logfile group 4

Sys@ora10g > alter database drop standby logfile group 5

Sys@ora10g > alter database drop standby logfile group 6

Sys@ora10g > alter database drop standby logfile group 7

4. Verify that the standby redo log filegroup was created successfully through the V$STANDBY_LOG view

Sys@ora10g > SELECT GROUP#,THREAD#,SEQUENCE#,ARCHIVED,STATUS FROM V$STANDBY_LOG

GROUP# THREAD# SEQUENCE# ARC STATUS

-

4 0 0 YES UNASSIGNED

5 0 0 YES UNASSIGNED

6 0 0 YES UNASSIGNED

7 0 0 YES UNASSIGNED

The above is how to configure Standby Redo Log. Have you learned any knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

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.