在本机创建DG
1、环境：RHEL 4.5、Oracle Database 10.2.0.1
2、主库名称：ORCL；备库名称：STDBY
3、主库路径：/oracle/admin/orcl、/oradata/orcl；归档路径：/rman/orcl
备库路径：/oracle/admin/stdby、/dg/stdby；归档路径：/rman/stdby
4、配置listener和tnsnames：加入ORCL和STDBY两个tnsnames；执行lsnrctl start
5、主库设置：ARCHIVE LOG、FORCE LOGGING

startup mount
alter database archivelog;
alter database force logging;

6、生成主库的PFILE文件，编辑主库的PFILE；复制主库PFILE文件为备库的PFILE文件，编辑备库的PFILE

主库

db_unique_name=
log_archive_dest_1=''
log_archive_dest_2=''

备库

7、生成stadnby controlfile，并根据CONTROL_FILES参数复制多份

alter database create standby controlfile as '/dg/stdby/control01.ctl';

8、生成备库的密码文件orapwstdby

orapwd file=orapwstdby password=oracle entries=5

9、关闭主库，复制数据文件、日志文件到备库指定的位置
10、启动主库
11、启动备库

startup nomount
alter database mount standby database;
alter database recover managed standby database disconnect from session;

12、Alter SWITCHOVER_STATUS from V$DATABASE
主库orcl：TO STANDBY；备库stdby：NOT ALLOWED
13、切换

先切主库：alter database commit to switchover to physical standby with session shutdown;
然后在查看备库的状态：select switchover_status from v$database;
TO_PRIMARY
最后切备库：alter database commit to switchover to physical primary ;

14、Alter SWITCHOVER_STATUS from V$DATABASE
主库stdby：TO STANDBY；备库orcl：TO PRIMARY

ITPub博客

Create 10gR2 DG

最新文章