[oracle@pri oradata]$ mkdir standbylog
[oracle@pri oradata]$ ls
pri standbylog
新建 4 个日志组作为 standby redolog 日志组,大小与原来的日志组一致:
由于已经存在 group1-3,,所以 group 号只能从 4 开始
SYS@pri> alter database add standby logfile group 4
2 '/u01/app/oracle/oradata/standbylog/std_redo04.log'
3 size 50m;
Database altered.
SYS@pri> alter database add standby logfile group 5
2 '/u01/app/oracle/oradata/standbylog/std_redo05.log'
3 size 50m;
Database altered.
SYS@pri> alter database add standby logfile group 6
2 '/u01/app/oracle/oradata/standbylog/std_redo06.log'
3 size 50m;
Database altered.
SYS@pri> alter database add standby logfile group7
2 '/u01/app/oracle/oradata/standbylog/std_redo07.log'
3 size 50m;
Database altered.
查看 standby 日志组的信息:
SYS@pri> select group#,sequence#,status, bytes/1024/1024 from v$standby_log;
GROUP# SEQUENCE# STATUS BYTES/1024/1024
---------- ------------------ ------------------- ------------------------
4 0 UNASSIGNED 50
5 0 UNASSIGNED 50
6 0 UNASSIGNED 50
7 0 UNASSIGNED 50
查看当前有哪些日志组及其成员:
SYS@pri> set pagesize 100
SYS@pri> col member for a60
SYS@pri> select group#,member from v$logfile order by group#;