保证主库test在database logging,archive状态下,并能正常运行状态。
一.修改$ORACLE_HOME/dbs/inittest.ora
*.control_files='/u01/app/oracle/oradata/control01.ctl'#Restore Controlfile
*.db_cache_size=37748736
*.db_name='test'
*.db_unique_name='test'
*.local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=blliu)(PORT=1521))'
*.log_archive_dest_1='LOCATION=/u01/app/oracle/archivelogs VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=test'
*.log_archive_dest_state_1=enable
*.log_archive_format='%t_%s_%r.ARC'
*.streams_pool_size=12582912
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.log_archive_config='DG_CONFIG=(test,test222)'
*.log_archive_dest_2='SERVICE=test222 LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=test222'
*.log_archive_dest_state_2=enable
*.compatible=10.2.0.4.0
fal_server='test'
fal_client='test222'
standby_file_management=auto
db_file_name_convert=/u01/app/oracle/test222/oradata,/u01/app/oracle/oradata
log_file_name_convert=/u01/app/oracle/test222/oradata,/u01/app/oracle/oradata
db_recovery_file_dest=/u01/app/oracle/flashback_recovery_area
db_recovery_file_dest_size=2G
二.修改$ORACLE_HOME/dbs/inittest222.ora
control_files='/u01/app/oracle/test222/oradata/ctlstandby.ctl'
db_cache_size=37748736
db_name='test'
db_unique_name='test222'
local_listener='(ADDRESS=(PROTOCOL=tcp)(HOST=blliu)(PORT=1521))'
log_archive_dest_1='LOCATION=/u01/app/oracle/test111/archivelogs VALID_FOR=(ALL_LOGFILES,ALL_ROLES) DB_UNIQUE_NAME=test222'
log_archive_dest_state_1=enable
log_archive_format='%t_%s_%r.ARC'
streams_pool_size=12582912
undo_management='AUTO'
undo_tablespace='UNDOTBS1'
log_archive_config='DG_CONFIG=(test,test222)'
log_archive_dest_2='SERVICE=test LGWR ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLES) DB_UNIQUE_NAME=test'
log_archive_dest_state_2=enable
db_file_name_convert=/u01/app/oracle/oradata,/u01/app/oracle/test222/oradata
log_file_name_convert=/u01/app/oracle/oradata,/u01/app/oracle/test222/oradata
background_dump_dest=/u01/app/oracle/test222/admin/bdump/
user_dump_dest=/u01/app/oracle/test222/admin/udump/
core_dump_dest=/u01/app/oracle/test222/admin/cdump/
fal_server='test222'
fal_client='test'
standby_file_management=auto
compatible=10.2.0.4.0
三.创建相应目录:
mkdir -p /u01/app/oracle/test222/admin/bdump
mkdir -p /u01/app/oracle/test222/admin/cdump
mkdir -p /u01/app/oracle/test222/admin/udump
mkdir -p /u01/app/oracle/test222/oradata
mkdir -p /u01/app/oracle/test222/archivelogs
mkdir -p /u01/app/oracle/test222/rman
四.创建密码文件:
orapwd file=$ORACLE_HOME/dbs/orapwtest password=oracle entries=5
orapwd file=$ORACLE_HOME/dbs/orapwtest222 password=oracle entries=5
五.修改$ORACLE_HOME/network/admin/listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = test)
(ORACLE_HOME = /u01/app/oracle/db_1)
(SID_NAME = test)
)
(SID_DESC =
(GLOBAL_DBNAME = test222)
(ORACLE_HOME = /u01/app/oracle/db_1)
(SID_NAME = test222)
)
)
完成后重启监听!
六.修改$ORACLE_HOME/network/admin/tnsnames.ora
TEST222 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test222)
)
)
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
七.启动standby到nomount模式:
[oracle@blliu admin]$ export ORACLE_SID=test222
[oracle@blliu admin]$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Jan 28 23:28:29 2010
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
Connected to an idle instance.
SQL> startup nomount
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 2082496 bytes
Variable Size 125831488 bytes
Database Buffers 37748736 bytes
Redo Buffers 6303744 bytes
八.利用rman工具中的duplicate进行standby控制文件、数据文件的创建:
[oracle@blliu dbs]$ echo $ORACLE_SID
test
[oracle@blliu dbs]$ rman target / auxiliarysys/oracle@test222
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Jan 28 23:31:38 2010
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: TEST (DBID=2003741378)
connected to auxiliary database: TEST (not mounted)
RMAN> backup database include current controlfile for standby;
RMAN> duplicate target database for standby;
九.启动standby到管理模式(第八步完成后,standby已经是mount状态):
[oracle@blliu dbs]$ export ORACLE_SID=test222
[oracle@blliu dbs]$ sqlplus / as sysdba
SQL> alter database recover managed standby database disconnect from session;
Database altered.
十.重启主数据库:
[oracle@blliu dbs]$ export ORACLE_SID=test
[oracle@blliu dbs]$ sqlplus / as sysdba
SQL> shutdown immediate
SQL> startup
十一.查看/u01/app/oracle/test222/admin/bdump/alert_test222.log
如果有以下文字表示standby创建成功,并开始正常运行了:
Thu Jan 28 23:37:58 2010
Media Recovery Log /u01/app/oracle/test111/archivelogs/1_13_709083440.ARC
Media Recovery Waiting for thread 1 sequence 14 (in transit)
至此,单机上一个最简单的Data Guard环境搭建完毕。
发表评论
-
oracle10G转为共享模式
2010-02-08 15:25 909oracle10G转为共享模式,我做了如下操作:STEP01: ... -
单机上快速搭建一个Data Guard环境
2010-02-08 15:24 805保证主库test在database logging,archi ... -
单机上快速搭建一个Data Guard环境
2010-02-08 15:23 759保证主库test在database logging,archi ... -
oracle数据库管理常用语句
2010-02-08 15:20 7591.删除用户及其用户下面的所有对象drop user br ... -
Oracle性能参数查看
2010-02-08 15:18 6660、数据库参数属性col PROPERTY_NAME form ... -
mysql的集群配置
2010-02-08 15:12 690文档旨在介绍如何安装配置基于2台服务器的MySQL集群 ... -
Oracle RAC日常基本维护命令
2010-02-08 15:09 918所有实例和服务的状态 ... -
oracle表空间的操作命令
2010-02-08 15:03 727CREATE TABLESPACE data01 DATAFI ...
相关推荐
关于oracle数据库data guard环境中rman备份问题
大牛出手Oracle 11.2.0.3 RAC 与 RAC 之间搭建Data Guard 案例 -- Aative Data Guard 案例
数据库RAC架构Data_Guard及_异地单机Data_Guard_实施方案
数据库RAC架构Data Guard及 异地单机Data Guard 实施方案
Oracle 11gR2 使用copy 数据文件搭建物理 Data Guard
Oracle 11.2.0.3 使用 ADG 搭建Data Guard 案例
oracle data guard文档
linux下 oracle 利用rman搭建Data Guard
Oracle Data Guard 11g完全参考手册 oracle press
NULL 博文链接:https://yale.iteye.com/blog/1474734
oracle 11g data guard
data guard for oracle database
大牛出手,全是干货,Oracle 11gR2使用Active Data Guard 搭建物理 Data Guard。 注:文档打开密码见压缩包注释 看不到注释的 文档打开密码 tianlesoftware
Data guard因为技术简单成熟,成本低廉(Oracle自带的功能,不需要单独购买),是广泛采用的一种数据库的高性能与容灾方案。 Oracle Data Guard 确保企业数据的高可用性、数据保护以及灾难恢复。
Linux虚拟机下 配置ORACLE Data Guard (phycial-backup) ufida
Oracle 的Data Guard 基本概念与管理手册
同一操作系统平台的单机普通存储数据库的Data Guard配置 操作系统:Windows 2003 Server 主数据库名称:dgmain 备数据库名称:dgstand 1. 启动主数据库的强制日志记录功能,避免Nologging子句的影响 ALTER DATABASE ...
这是我在以前在工作中总结的Oracle 10g Dataguard在Windows下搭建的详细步骤的总结,希望对大家有帮助哦。
Data Guard Configurations,Primary Database,Standby Databases,Data Guard Services.,Redo Transport Services.,Apply Services, Role Transitions.,Data Guard Broker.,Using Oracle Enterprise Manager ...