cal standby database
SQL> alter database recover managed standby database disconnect from session；
Database altered.
六、验证dataguard是否成功：
主库创建表并插1条数据，并提交
SQL> create table test(id int);
Table created.
SQL> insert into test values(1);
1 row created.
SQL> commit;
Commit complete.
SQL> alter system switch logfile;
System altered.
SQL> alter system switch logfile;
System altered.
SQL> select sequence#,applied from v$archived_log order by sequence#;--查看日志状态
SEQUENCE# APP
---------- ---
36 NO
36 NO
37 NO
37 NO
59 rows selected.
SQL> insert into test values(2);
1 row created.
SQL> commit;
Commit complete.
备库：
SQL> select sequence#,applied from v$archived_log order by sequence#;--查看状态
SEQUENCE# APP
---------- ---
35 NO
36 NO
37 NO
36 rows selected.
SQL> alter database recover managed standby database cancel;--终止接收日志
Database altered.
SQL> alter database open read only;---------打开
数据库
Database altered.
SQL> select * from test;
ID
----------
1
至此dataguard部署完成。
下面是常用命令：
1、启动---只读方式打开备库：
先启动主库：
备库：
startup nomount;
SQL> alter database recover managed standby database disconnect from session;----接收日志
SQL> select sequence#,applied from v$archived_log order by sequence#;--查看状态
SQL> alter database recover managed standby database cancel;--终止接收日志
SQL> alter database open read only;---------打开
数据库
2、备库从打开状态切回恢复状态：
alter database recover managed standby database disconnect from session;
3、备库：检查是否存在归档中断
SQL> select thread#,low_sequence#,high_sequence# from v$archive_gap;
no rows selected
4、启动和关闭：
启动：先备库listener，在启动备库。然后主库listener，在启动主库
关闭：先关闭主库，再关闭备库
5、查看日志是否同步
大小一致说明已同步
select sequence#,applied from v$archived_log order by sequence#;
6、主库归档日志切换，（同步到备库）
alter system switch logfile;
7\查询DataGuard当前处于哪种日志传输方式：
SQL> select process,CLIENT_PROCESS from v$managed_standby;
PROCESS CLIENT_P
--------- --------
ARCH ARCH
ARCH ARCH
RFS LGWR
RFS UNKNOWN