配置data guard物理备库(4)

点finish完成

到这可以退出界面 ，点log out退出 到此都正确配置

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

[root@node1 ~]# cd /u01/

[root@node1 u01]# ls

admin database oracle oradata oraInventory [root@node1 u01]# cd oradata/ [root@node1 oradata]# ls

arch dgdemo 建完库有这个 [root@node1 oradata]# ls arch dgdemo

[root@node1 oradata]# cd dgdemo/ [root@node1 dgdemo]# ll total 1054092

-rw-r----- 1 oracle oinstall 7061504 Nov 22 00:26 control01.ctl(控制文件) -rw-r----- 1 oracle oinstall 7061504 Nov 22 00:26 control02.ctl -rw-r----- 1 oracle oinstall 7061504 Nov 22 00:26 control03.ctl -rw-r----- 1 oracle oinstall 104865792 Nov 21 23:24 example01.dbf

-rw-r----- 1 oracle oinstall 52429312 Nov 22 00:24 redo01.log （重做日志 ） -rw-r----- 1 oracle oinstall 52429312 Nov 21 23:24 redo02.log

-rw-r----- 1 oracle oinstall 52429312 Nov 21 23:24 redo03.log

-rw-r----- 1 oracle oinstall 241180672 Nov 22 00:24 sysaux01.dbf（.dbf都是数据文件） -rw-r----- 1 oracle oinstall 503324672 Nov 22 00:24 system01.dbf -rw-r----- 1 oracle oinstall 20979712 Nov 21 23:22 temp01.dbf

-rw-r----- 1 oracle oinstall 26222592 Nov 22 00:24 undotbs01.dbf -rw-r----- 1 oracle oinstall 5251072 Nov 21 23:24 users01.dbf 到此都正确配置

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

在备库用netca配2个文件

以oracle用户登陆，做的工作了和上面一样

以oracle用户登陆

测试从lsnode2可以连接lnnode1

从lsnode1也可以连接lnnode1

[root@node2 admin]# su - oracle

[oracle@node2 ~]$ sqlplus system/oracle@lsnode1

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Nov 22 01:41:19 2011

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options

SQL> show user; USER is \

测试从lsnode1连接lnnode2, 这时备库还没有库还不能连接。

开始配置dg

最佳的配置文档要看官方的，虽然看别人的中文能配置起来，但以后各种问题深入还是要找官方资料 http://download.oracle.com/docs/cd/B19306_01/server.102/b14239/toc.htm

点这个 2 Getting Started with Data Guard

先配置物理standby ，点

2.1.1 Physical Standby Databases

3 Creating a Physical Standby Database（点这个内容）

看到

3 Creating a Physical Standby Database

This chapter steps you through the process of creating a physical standby database. It includes the following main topics: Preparing the Primary Database for Standby Database Creation Step-by-Step Instructions for Creating a Physical Standby Database Post-Creation Steps

这里写得很清楚，(一定要看官方文档啊，很清楚，考个GRE就能看懂)分3步做

3.1 Preparing the Primary Database for Standby Database Creation 可以看到有5小节，

able 3-1 Preparing the Primary Database for Physical Standby Database Creation Reference Section 3.1.1 Section 3.1.2 Section 3.1.3 Section 3.1.4 Section 3.1.5 10G

Task Enable Forced Logging Create a Password File Configure a Standby Redo Log Set Primary Database Initialization Parameters Enable Archiving Release 1 只有4节，要多配置这个 Configure a Standby Redo Log

第一步

3.1.1 Enable Forced Logging

在主库执行这条命令就可以

SQL> ALTER DATABASE FORCE LOGGING;

[oracle@node1 bin]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.1.0 - Production on Wed Nov 23 02:14:52 2011 Copyright (c) 1982, 2005, Oracle. All rights reserved. SQL> conn / as sysdba Connected

SQL> archive log list;

Database log mode Archive Mode Automatic archival Enabled

Archive destination /u01/oradata/arch Oldest online log sequence 1 Next log sequence to archive 3 Current log sequence 3 SQL> ALTER DATABASE FORCE LOGGING;

Database altered.

第二步 3.1.2 Create a Password File

这个不用建，用dbca建库会自动生动一个文件orapwdgdemo在/u01/oracle/dbs/下

[root@node1 ~]# cd /u01/oracle/dbs/ [root@node1 dbs]# ls

hc_dgdemo.dat initdw.ora init.ora lkDGDEMO orapwdgdemo spfiledgdemo.ora

3.1.2standby redlog

先不做

第三步