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对应重复)
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博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-625468/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-625468/