1,为了理解physical standby db,在其上添加standby logfile group,

SQL> alter database add standby logfile group 4 ('/oracle/oradata/centos/redo04') size 50m;
alter database add standby logfile group 4 ('/oracle/oradata/centos/redo04') size 50m
*
ERROR at line 1:
ORA-01156: recovery in progress may need access to files
--以上错误表明：此时备库处于recover mode
2,取消备库的recover状态
SQL> alter database recover managed standby database cancel immediate;

Database altered.
3,再次重复1步骤，成功添加standby logfile group
SQL> alter database add standby logfile group 4 ('/oracle/oradata/centos/redo04') size 50m;

Database altered.

4,查询添加的standby logfile group 信息，可通过如下视图
SQL> select group#,dbid,thread#,sequence#,bytes/1024/1024,archived,status from v$standby_log;

    GROUP# DBID                                        THREAD# SEQUENCE#
---------- ---------------------------------------- ---------- ----------
BYTES/1024/1024 ARC STATUS
--------------- --- ----------
         4 UNASSIGNED                                        0          0
             50 YES UNASSIGNED
(group#要全局唯一，不能与v$log对应重复）

ITPub博客

为物理备库添加standby logfile group相关事则

最新文章