RMAN学习笔记_ Duplicate创建DataGuard

目标:利用RMAN Duplicate 创建Standby
ENV:
Oracle9i + Suse9 + DataGuard + 默认的最大性能模式

Primary 192.168.1.101 ORACLE_SID=dupdb
Standby 192.168.1.102 ORACLE_SID=dupdb

此文档要求读者具备RMAN,DataGuard的基本知识. 更多的内容参考官方文档<>

操作步骤

1 Make a backup of the primary database and  Create a standby control file(Primary)

BACKUP DATABASE
INCLUDE CURRENT CONTROLFILE FOR STANDBY
PLUS ARCHIVELOG;

 

2 将备份Piece, 参数文件,密码文件 打包传过去,参数文件包在Backup Piece中(Standby)
或通过NFS共享

scp oracle@192.168.1.101:/opt/oracle/product/9ir2/dbs/01l51899_1_1 /opt/oracle/product/9ir2/dbs/
scp oracle@192.168.1.101:/opt/oracle/product/9ir2/dbs/02l518a4_1_1 /opt/oracle/product/9ir2/dbs/
scp oracle@192.168.1.101:/opt/oracle/product/9ir2/dbs/03l518bj_1_1 /opt/oracle/product/9ir2/dbs/
#create pfile='?/dbs/pfile_20100202' from spfile
scp oracle@192.168.1.101:/opt/oracle/product/9ir2/dbs/pfile_20100202 /opt/oracle/product/9ir2/dbs/
scp oracle@192.168.1.101:/opt/oracle/product/9ir2/dbs/orapwdupdb   /opt/oracle/product/9ir2/dbs/

注意:在将备份文件拷贝到Standby上时,存放备份文件的目录必须与Primary备份文件所在的目录结构一样,
这样控制文件才能找到备份文件

3 配置Primary NET

3.1 配置tnsnames.ora(Primary)
standby =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dupdb)
    )
  )

3.2 手工注册监听(Primary)
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = dupdb)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (SID_NAME = dupdb)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
      )
    )
  )
 

3.3 lsnrctl start 打开监听

3.4 tnsping standby 测试连接

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 29-JAN-2010 14:03:54

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))) (CONNECT_DATA = (SID = dupdb)))
OK (10 msec)

 

4 配置Standby NET

4.1  配置tnsnames.ora(Standby)
dupdb =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = dupdb)
    )
  )

4.2 手工注册监听(Standby)
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (PROGRAM = extproc)
    )
    (SID_DESC =
      (GLOBAL_DBNAME = dupdb)
      (ORACLE_HOME = /opt/oracle/product/9ir2)
      (SID_NAME = dupdb)
    )
  )
 
LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.102)(PORT = 1521))
      )
    )
  )

4.3 lsnrctl start 打开监听

4.4 tnsping dupdb

TNS Ping Utility for Linux: Version 9.2.0.4.0 - Production on 29-JAN-2010 13:14:17

Copyright (c) 1997 Oracle Corporation.  All rights reserved.

Used parameter files:
/opt/oracle/product/9ir2/network/admin/sqlnet.ora

Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.101)(PORT = 1521))) (CONNECT_DATA = (SID = dupdb)))
OK (10 msec)

 

5  编辑参数文件

5.1 编辑Primary参数文件

pfile='/opt/oracle/product/9ir2/dbs/pfile_20100202.ora';
去掉log_archive_dest

添加
*.log_archive_dest_1='LOCATION=/opt/oracle/archive'
*.log_archive_dest_state_1=enable
*.log_archive_dest_2='SERVICE=standby LGWR'
*.log_archive_dest_state_2=enable

5.1 编辑Standby参数文件
修改standby的pfile_20100202.ora 参数文件,即从Primay传过来的
加入以下行
*.fal_server='dupdb'
*.fal_client='standby'
#DB_FILE_NAME_CONVERT=('/opt/oracle/oradata/dupdb','/opt/oracle/oradata/dupdb') 如果路径不一致才用
#LOG_FILE_NAME_CONVERT=('/opt/oracle/oradata/dupdb','/opt/oracle/oradata/dupdb')
*.standby_file_management=auto
*.standby_archive_dest='/opt/oracle/archive'
#LOG_ARCHIVE_DEST_1='LOCATION=/opt/oracle/archive'
#LOG_ARCHIVE_DEST_STATE_1=ENABLE

6 启动实例

#以修改后的参数文件 startup Primary Instance;(Primary)

#恢复Spfile:
Create spfile from pfile='/opt/oracle/product/9ir2/dbs/pfile_20100202.ora';
startup;

#以修改后的参数文件Start Standby Instance (Standby)
Create spfile from pfile='/opt/oracle/product/9ir2/dbs/pfile_20100202.ora';
startup nomount

不打开控制文件,控制文件通过Duplicate 来传输

7 Duplicate Standby

rman target / catalog rman/rmanpwd@catalogdb auxiliary sys/sys@standby
RUN
{
# If desired, issue a SET command to terminate recovery at a specified point.
# SET UNTIL SCN 143508;
DUPLICATE TARGET DATABASE FOR STANDBY NOFILENAMECHECK
DORECOVER;
}

#NOFILENAMECHECK 表示主备的数据文件路径一致

8 Duplicate 完成后Standby只处于正常的Mount状态.应打开Recover

 ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

 

 

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10248702/viewspace-626765/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10248702/viewspace-626765/