Oracle 11g Data Guard配置 - 数据库编程

red.

SYS@PRIMARY>/

System altered.
复制代码
备库：
SYS@PRIMARY>select name,database_role from v$database;

NAME DATABASE_ROLE
--------- ----------------
PRIMARY PHYSICAL STANDBY

SYS@PRIMARY>select sequence#,first_time,next_time from v$archived_log;

SEQUENCE# FIRST_TIME NEXT_TIME
---------- ------------ ------------
15 20-FEB-12 20-FEB-12
8 20-FEB-12 20-FEB-12
10 20-FEB-12 20-FEB-12
9 20-FEB-12 20-FEB-12
11 20-FEB-12 20-FEB-12
13 20-FEB-12 20-FEB-12
7 20-FEB-12 20-FEB-12
14 20-FEB-12 20-FEB-12
12 20-FEB-12 20-FEB-12
18 21-FEB-12 21-FEB-12
20 21-FEB-12 21-FEB-12
......

SYS@PRIMARY>alter database recover managed standby database cancel;

Database altered.

SYS@PRIMARY>alter database open read only;

Database altered.

SYS@PRIMARY>select * from test;

ID
----------
1
2
3
4
5
6
7
8
9
10

10 rows selected.
复制代码
至此，配置完毕
总结
想要玩好oracle的Data Guard、RAC、Golden Gate等高端软件，主要在于细心与耐心。
所谓细心，就是认真读取文档，认真配置各项参数和文件；所谓耐心，就是出现错误后，要认真预读alert log好trace文件，找到错误原因，即使去网上求助，一项一项排除。笔者首次不是DG时，确实遇到不少问题，就是靠逐步啃日志文件解决的

摘自所好者道也

Oracle 11g Data Guard配置 (三)