Oracle 11g搭建dataguard流程

应客户要求，11g搭建dataaguard做了简单整理
1、假设生产库数据库名字，SID为orcl。备份库数据库名字，SID为stdby。sys密码为oracle
2、生产库datafile,controlfile,redolog存放目录为/app/oradata/orcl。备份库datafile,controlfile,redolog存放目录为/app/oradata/stdby
3、备份库archlog存放目录/app/archlog/stadby
4、生产库处于归档模式

1）创建备库存放目录
su - root
mkdir -p /app/oradata/stdby
mkdir -p /app/archive/stdby
chown -R oracle:dba /app

2)连接生产库创建spfile文件，standby控制文件
su - oracle
export ORACLE_SID=orcl
sqlplus "/as sysdba"
create spfile from pfile;
alter database create standby controlfile as '/app/oradata/stdby/stdby.ctl';
3）拷贝参数文件，密码文件
su - oracle
cp $ORACLE_HOME/dbs/spfileorcl.ora $ORACLE_HOME/dbs/spfilestdby.ora
cp $ORACLE_HOME/dbs/orapworcl $ORACLE_HOME/dbs/orapwstdby
4）生产库拷贝数据文件至备份库
su - oracle
export ORACLE_SID=orcl
sqlplus "/as sysdba"
alter database begin backup;
set pagesize 0
set head off
set linesize 100
select 'cp '||name||' /app/oradata/stdby/'||substr(name,instr(name,'/',-1)+1) from v$datafile;
exit
复制拷贝命令在操作系统中执行
alter database end backup;

5）修改生产库参数
su - oracle
export ORACLE_SID=orcl
sqlplus "/as sysdba"
alter system set db_unique_name='orcl' scope=spfile;
alter system set db_file_name_convert='/app/oradata/stdby/','/app/oradata/orcl/' scope=spfile;
alter system set log_file_name_convert='/app/oradata/stdby/','/app/oradata/orcl/' scope=spfile;
alter system set fal_client='orcl' scope=spfile;
alter system set fal_server='stdby' scope=spfile;
alter system set standby_file_management='AUTO' scope=spfile;
alter system set log_archive_config='dg_config=(orcl,stdby)' scope=spfile;
alter system set log_archive_dest_2='service=stdby  valid_for=(ALL_LOGFILES,PRIMARY_ROLE) db_unique_name=stdby' scope=spfile;
alter system set log_archive_dest_state_2='enable' scope=spfile;
alter system set memory_target=0 scope=spfile;
shutdown immediate
6)修改监听为静态注册
listener.ora添加
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (GLOBAL_DBNAME = orcl)
      (ORACLE_HOME = /app/product/11.2.0/dbhome_1)
      (SID_NAME = orcl)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = stdby)
      (ORACLE_HOME = /app/product/11.2.0/dbhome_1)
      (SID_NAME = stdby)
    )
  )
 
tnsnames.ora添加

stdby =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost.localdomain)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (sid = stdby)
    )
  )

lsnrctl stop
lsnrctl start

7)修改备份库参数
su - oracle
export ORACLE_SID=stdby
sqlplus "/as sysdba"
startup nomount
alter system set db_unique_name='stdby' scope=spfile;
alter system set control_files='/app/oradata/stdby/stdby.ctl' scope=spfile;
alter system set db_file_name_convert='/app/oradata/orcl/','/app/oradata/stdby/' scope=spfile;
alter system set log_file_name_convert='/app/oradata/orcl/','/app/oradata/stdby/' scope=spfile;
alter system set fal_client='stdby' scope=spfile;
alter system set fal_server='orcl' scope=spfile;
alter system set log_archive_dest_1='location=/app/archive/stdby' scope=spfile;
alter system set standby_file_management='AUTO' scope=spfile;
alter system set log_archive_config='dg_config=(stdby,orcl)' scope=spfile;
alter system set log_archive_dest_2='service=orcl valid_for=(ALL_LOGFILES,PRIMARY_ROLE) db_unique_name=orcl' scope=spfile;
alter system set log_archive_dest_state_2='enable' scope=spfile;
shutdown immediate
startup mount



8)启动生产库
su - oracle
export ORACLE_SID=stdby
sqlplus "/as sysdba"
startup

9)备份库后台运行
open状态下：
alter database recover managed standby database disconnect from session;