*.FAL_SERVER='dg_pd'st

*.FAL_CLIENT='dg_sd'

--

保存为std.ora

4. 修改listener.ora 和 tnsnames.ora 文件，如果不存在，就从主库上copy 过去。

至此，Data Guard 的操作已经完成，下面来开始验证。

补充：

启动备库

SQL>startup nomount pfile='/u01/app/oracle/product/10.2.0/db1/dbs/initdgtest.ora'

SQL>create spfile from pfile='/u01/app/oracle/product/10.2.0/db1/dbs/initdgtest.ora'

------------------------------------环境 End-----------------------------------

-----------start------------

--注意Data Guard 启动顺序：

启动顺序：先standby ,后primary;

关闭顺序：先primary 后standby;

在备库将实例启动到mount 状态：

SQL> startup nomount;

SQL>alter database mount standby database ;

启动redo apply: SQL>alter database recover managed standby database disconnect from session;

(停止redo apply: SQL>ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;)

在备库启动监听：

$lsnrctl start

在主库启动实例：

SQL> startup;

在主库启动监听：

$lsnrctl start

--------------------DataGuard Acitve OK------------

Now

Primary：open

Standby:mount

--Standby只读模式打开

--停止redo应用

SQL>alter database recover managed standby database cancel

SQL>alter database open;

SQL>select open_mode from v$database;

OPEN_MODE

----------

READ ONLY

--Standby重新回到redo apply状态

SQL>shutdown immediate

SQL>startup nomount

SQL>alter database mount standby database;

SQL>alter database recover managed standby database disconnect from session;

--验证是否传输到了Standby database

--Primary database

SQL>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SQL> SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME

7 23-FEB-11 23-FEB-11

7 23-FEB-11 23-FEB-11

8 23-FEB-11 23-FEB-11

8 23-FEB-11 23-FEB-11

9 23-FEB-11 23-FEB-11

9 23-FEB-11 23-FEB-11

SQL> alter system switch logfile;

System altered.

--Standby database

SQL>SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# FIRST_TIM NEXT_TIME

---------- --------- ---------

7 23-FEB-11 23-FEB-11

8 23-FEB-11 23-FEB-11

9 23-FEB-11 23-FEB-11

10 23-FEB-11 23-FEB-11

--验证Standby redo 是否应用

SQL>SELECT SEQUENCE#,APPLIED FROM V$ARCHIVED_LOG ORDER BY SEQUENCE#;

SEQUENCE# APP

---------- ---

3 YES

4 YES

5 YES

6 YES

7 YES

8 YES

9 YES

10 YES

8 rows selected.

--如果出错

在主库验证归档目录是否有效：

SQL> SELECT STATUS,DESTINATION, ERROR FROM V$ARCHIVE_DEST;

如果有错误，要排查原因。

SQL> SELECT STATUS ,ERROR FROM V$ARCHIVE_DEST;

STATUS ERROR

--------- -----------------------------------------------------------------

VALID

VALID

INACTIVE

INACTIVE

INACTIVE

INACTIVE

INACTIVE

INACTIVE

INACTIVE

INACTIVE

注意：如果在主库执行 alter database clear unarchived logfile或alter database open resetlogs ,　则dataguard要重建。

补充：

--监控日志应用服务

SQL>select database_role,db_unique_name,open_mode,protection_mode,protection_level,switchover_status from v$database;

--设置新的数据保护模式并重启数据库

当保护模式更改顺序：

maximize protection ---> maximize availability ----> maximize performance