Oracle 10G windows 平台 DataGuard 实例(一)
?
server A: 10.85.10.44??SID=orcl -
target server B: 10.85.10.43 -
oracle version:10.2.0.1 -
OS platform : windows XP -
?
?
Primary设置：?-
?
1. 设置主数据库为force logging 模式?-
SQL>sqlplus "/as sysdba" -
SQL>alter database force logging; -
2. 设置主数据库为归档模式?-
SQL> archive log list -
SQL> shutdown immediate -
SQL> startup mount -
SQL> alter database archivelog; -
SQL> archive log list -
3. 添加"备用联机日志文件"?-
先查看日志文件位置： -
SQL>select * from v$logfile; -
在添加： -
SQL> alter database add standby logfile group 4 ('D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/redo04.log') size 50m; -
SQL> alter database add standby logfile group 5 ('D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/redo05.log') size 50m; -
SQL> alter database add standby logfile group 6 ('D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/redo06.log') size 50m; -
SQL> alter database add standby logfile group 7 ('D:/ORACLE/PRODUCT/10.2.0/ORADATA/ORCL/redo07.log') size 50m; -
?
4. 创建主库的初始化参数给备库用?-
SQL>Create pfile from spfile; -
产生的文件名为initorcl.ora 存放目录默认放在$ORACLE_HOME/database下 -
?
5. 在主库创建备库的控制文件 和密码文件?-
SQL>Alter database create standby controlfile as 'D:/oracle/product/10.2.0/control01.ctl'; -
D:>orapwd file=D:/PWDorcl.ora password=admin entries=5; -
?
缺省情况下，win下口令文件的格式是pwdsid.ora，unix下的格式是orapwSID(大小写敏感）
?
6.??在主库创建监听和配置tnsnams.ora?-
?
listener.ora配置如下: -
# listener.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/listener.ora-
# Generated by Oracle configuration tools.-
SID_LIST_LISTENER =-
??(SID_LIST =-
????(SID_DESC =-
??????(SID_NAME = PLSExtProc)-
??????(ORACLE_HOME = D:/oracle/product/10.2.0/db_1)-
??????(PROGRAM = extproc)-
????)-
????(SID_DESC =-
??????(GLOBAL_DBNAME = orcl)-
??????(ORACLE_HOME = D:/oracle/product/10.2.0/db_1)-
??????(SID_NAME = orcl)-
????)-
??)-
LISTENER =-
??(DESCRIPTION_LIST =-
????(DESCRIPTION =-
??????(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))-
??????(ADDRESS = (PROTOCOL = TCP)(HOST = 10.85.3.44)(PORT = 1521))-
????)-
??)-
?
tnsnames.ora配置如下: -
# tnsnames.ora Network Configuration File: D:/oracle/product/10.2.0/db_1/network/admin/tnsnames.ora-
# Generated by Oracle configuration tools.-
primary =-
??(DESCRIPTION =-
????(ADDRESS = (PROTOCOL = TCP)(HOST = 10.85.3.44)(PORT = 1521))-
????(CONNECT_DATA =-
??????(SERVER = DEDICATED)-
??????(SERVICE_NAME = orcl)-
????)-
??)-
standby =-
??(DESCRIPTION =-
????(ADDRESS = (PROTOCOL = TCP)(HOST = 10.85.3.43)(PORT = 1521))-
????(CONNECT_DATA =-
??????(SERVER = DEDICATED)-
??????(SERVICE_NAME = orcl)-
????)-
??)-
EXTPROC_CONNECTION_DATA =-
??(DESCRIPTION =-
????(ADDRESS_LIST =-
??????(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))-
????)-
????(CONNECT_DATA =-
??????(SID = PLSExtProc)-
??????(PRESENTATION = RO)-
????)-
??)-
更多信息请查看?java进阶网?http://www.javady.com
