1 / 21
文档名称:

Oracle 10G windows 平台 DataGuard 实例.doc

格式:doc   大小:105KB   页数:21页
下载后只包含 1 个 DOC 格式的文档,没有任何的图纸或源代码,查看文件列表

如果您已付费下载过本站文档,您可以点这里二次下载

文档介绍:Oracle 10G windows 平台 DataGuard
server A: 10.85.10.44 SID=orcl
target server B: 10.85.10.43
oracle version:10.2.0置如下:
# 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)
)
)



7. 在initorcl.ora添加以下内容:

*.log_archive_format='%T%S%r.ARC'
*.DB_UNIQUE_NAME='primary'
*.log_archive_config='DG_CONFIG=(primary,standby)'
*.log_archive_dest_1='location=D:\oracle\product\10.2.0\oradata\arch VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=primary'
*.log_archive_dest_2='SERVICE=standby arch ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=standby'
*.STANDBY_FILE_MANAGEMENT=AUTO
*.LOG_ARCHIVE_DEST_STATE_1=ENABLE
*.LOG_ARCHIVE_DEST_STATE_2=ENABLE
*.FAL_SERVER='standby'
*.FAL_CLIENT='primary'

关闭数据库,在用initorcl.ora重启,并创建spfile文件

SQL>startup pfile='$ORACLE_HOME/database/initorcl.ora'

SQL>create spfile from pfile='$ORACLE_HOME/database/initorcl.ora'


8.

A. 拷贝数据文件,参数文件,控制文件,密码文件到备库上

initorcl.ora参数文件,PWDorcl.ora密码文件考到$ORACLE_HOME/database下的,

controlbak.ctl 考到$ORACLE_base/oradata/orcl/下,并分别重命名为control01.ctl,control01.ctl,control01.ctl

数据文件考到$ORACLE_base/oradata/orcl/下


B. 用Rman拷贝,不用停机

$ rman target /

RMAN> backup full format 'D:/FULL_%d_%T_%s.bak' database include current controlfile for standby;

RMAN> sql 'alter system archive log curre

分享好友

预览全文

Oracle 10G windows 平台 DataGuard 实例.doc

上传人:橘子 8/7/2022 文件大小:105 KB

下载得到文件列表

Oracle 10G windows 平台 DataGuard 实例.doc

相关文档