oracle 11gr2 创建standby 日志组、删除standby 日志组操作

来源：互联网发布：菲律宾网络编辑：程序博客网时间：2024/06/16 07:18

一、创建standby日志组

奇怪的是上次同样的命令一直报错，今天却能执行完毕，很是不解啊！！

查看standby日志组情况的视图为v$standby_log

sys@TERM> alter database add standby logfile group 5
2 ('/data/oracle11g/oradata/term/stby_redo05.log') size 100m;

Database altered.

sys@TERM> alter database add standby logfile group 6
2 ('/data/oracle11g/oradata/term/stby_redo06.log') size 100m;

Database altered.

sys@TERM> alter database add standby logfile group 7
2 ('/data/oracle11g/oradata/term/stby_redo07.log') size 100m;

Database altered.

sys@TERM> alter database add standby logfile group 8
2 ('/data/oracle11g/oradata/term/stby_redo08.log') size 100m;

Database altered.

sys@TERM> alter database add standby logfile group 9
2 ('/data/oracle11g/oradata/term/stby_redo09.log') size 100m;

Database altered.

二、删除Standby Redo log日志组的语法：

SQL> ALTER DATABASE DROP STANDBY LOGFILE GROUP 4;

三、查询

sys@TERM> select group#,thread#,sequence#,archived,status from v$standby_log;

    GROUP#    THREAD# SEQUENCE# ARC STATUS
---------- ---------- ---------- --- ----------
         5          0          0 YES UNASSIGNED
         6          0          0 YES UNASSIGNED
         7          0          0 YES UNASSIGNED
         8          0          0 YES UNASSIGNED
         9          0          0 YES UNASSIGNED