Data Guard in maximum protection and maximum availability mode, the standby database must be configured with standby redo log, and the following experiments demonstrate the principles and procedures created.
1. Principles
1). Standby redo log has the same file size as the primary database online redo log file
2). The number of standby redo log file groups is calculated according to the following principle
Standby Redo Log Group number formula >= (number of log groups per instance + 1) *instance number
For example, in my environment, there is only one node, this node has three groups of redo, so
Standby Redo Log Group number formula >= (3+1) * = = 4
So you need to create 4 groups of standby redo log
3). Each log group can contain multiple member files for security purposes
2. Configuration process, normally only need to be configured on the standby side, considering the primary and standby switch, also configured at the primary end
1) Standby library add four groups standby redo log, recovery of user standby library
[Email protected]> ALTER DATABASE add standby logfile Group 4 ('/oracle/u02/ora10gdg/standbyrd01. LOG ') size 200M;
Database altered.
[Email protected]> ALTER DATABASE add standby logfile Group 5 ('/oracle/u02/ora10gdg/standbyrd02. LOG ') size 200M;
Database altered.
[Email protected]> ALTER DATABASE add standby logfile Group 6 ('/oracle/u02/ora10gdg/standbyrd03. LOG ') size 200M;
Database altered.
[Email protected]> ALTER DATABASE add standby logfile Group 7 ('/oracle/u02/ora10gdg/standbyrd04. LOG ') size 200M;
Database altered.
2) Primary Library add four groups standby redo log for primary and standby switching
[Email protected]> ALTER DATABASE add standby logfile Group 4 ('/oracle/u02/ora10g/standbyrd01. LOG ') size 200M;
Database altered.
[Email protected]> ALTER DATABASE add standby logfile Group 5 ('/oracle/u02/ora10g/standbyrd02. LOG ') size 200M;
Database altered.
[Email protected]> ALTER DATABASE add standby logfile Group 6 ('/oracle/u02/ora10g/standbyrd03. LOG ') size 200M;
Database altered.
[Email protected]> ALTER DATABASE add standby logfile Group 7 ('/oracle/u02/ora10g/standbyrd04. LOG ') size 200M;
Database altered.
3.Standby Redo Log Delete method
[Email protected]> ALTER DATABASE drop standby logfile Group 4;
[Email protected]> ALTER DATABASE drop standby logfile Group 5;
[Email protected]> ALTER DATABASE drop standby logfile Group 6;
[Email protected]> ALTER DATABASE drop standby logfile Group 7;
4. Verify that the STANDBY redo log filegroup was created successfully through the V$standby_log view
[Email protected]> 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 End- - http:// blog.csdn.net/techsupporter/article/details/52205052
Configuring standby Redo Log