使用RMAN进行Active Database Duplication

最新推荐文章于 2021-07-29 10:06:16 发布
最新推荐文章于 2021-07-29 10:06:16 发布
阅读量204 收藏
点赞数
文章标签： 数据库 网络

1. 配置listener文件,需要指定静态的SID

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /oracle/product/10.2/db_2)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = orcl11)
(ORACLE_HOME = /oracle/product/11.1.0/db_1)
(SID_NAME = orcl11)
)
(SID_DESC =
(GLOBAL_DBNAME = test1)
(ORACLE_HOME = /oracle/product/11.1.0/db_1)
(SID_NAME = test1)
)

)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodeA)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)


2.为clone数据库配置一个tnsnames

test1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = nodeA)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = test1)
(UR=A)
)
)

使用基于tnsnames的联接,auxiliary DB可以在本机,也可以在不同的机器上.


3.创建一个密码文件

orapwd password=admin entries=5 file=orapwtest1

注意target和clone的密码应该一样.


4.准备一个初始化参数文件

db_name = test1


5. 启动auxiliary数据库

export ORACLE_SID=test1

startup nomount pfile='/oracle/product/11.1.0/db_1/dbs/inittest1.ora'

6 启动RMAN,连接到target和auxiliary

export ORACLE_SID=orcl11

$ORACLE_HOME/bin/rman
connect target sys/admin@orcl11

连接到target数据库时需要指定密码,duplicate会使用这个用户名和密码连接到auxiliary实例.

connect auxiliary sys/admin@test1

如果出现ora-12528错误,那么需要在 tnsnames.ora里添加一个选项:(UR=A)
如果出现ora-1031,那么可能是密码文件配置错误

7.执行duplicate操作.

duplicate target database to test1 from active database
spfile
parameter_value_convert = '/oracle/oradata/orcl11','/oracle/oradata/test1'
set log_file_name_convert ='/oracle/oradata/orcl11','/oracle/oradata/test1'
db_file_name_convert = '/oracle/oradata/orcl11','/oracle/oradata/test1';

如果使用不同的机器和相同的目录结构,那么需要指定nofilenamecheck选项;
如果要忽略某个表空间,可以指定skip tablespace

duplicate target database to test1 from active database
nofilenamecheck
skip tablespace data;


以下是该命令的输出,看一下有助于理解rman到底作了什么:
-------------------------------------
Starting Duplicate Db at 18-JUN-09
using target database control file instead of recovery catalog
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=97 device type=DISK

contents of Memory Script:
{
backup as copy reuse
file '/oracle/product/11.1.0/db_1/dbs/spfileorcl11.ora' auxiliary format
'/oracle/product/11.1.0/db_1/dbs/spfiletest1.ora' ;
sql clone "alter system set spfile= ''/oracle/product/11.1.0/db_1/dbs/spfiletest1.ora''";
}
executing Memory Script

Starting backup at 18-JUN-09
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=155 device type=DISK
Finished backup at 18-JUN-09

sql statement: alter system set spfile= ''/oracle/product/11.1.0/db_1/dbs/spfiletest1.ora''

contents of Memory Script:
{
sql clone "alter system set db_name =
''TEST1'' comment=
''duplicate'' scope=spfile";
sql clone "alter system set control_files =
''/oracle/oradata/test1/control01.ctl'', ''/oracle/oradata/test1/control02.ctl'', ''/oracle/oradata/test1/control03.ctl'' comment=
'''' scope=spfile";
sql clone "alter system set log_file_name_convert =
''/oracle/oradata/orcl11'', ''/oracle/oradata/test1'' comment=
'''' scope=spfile";
shutdown clone immediate;
startup clone nomount ;
}
executing Memory Script

sql statement: alter system set db_name = ''TEST1'' comment= ''duplicate'' scope=spfile

sql statement: alter system set control_files = ''/oracle/oradata/test1/control01.ctl'', ''/oracle/oradata/test1/control02.ctl'', ''/oracle/oradata/test1/control03.ctl'' comment= '''' scope=spfile

sql statement: alter system set log_file_name_convert = ''/oracle/oradata/orcl11'', ''/oracle/oradata/test1'' comment= '''' scope=spfile

Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 392495104 bytes

Fixed Size 2144744 bytes
Variable Size 117442072 bytes
Database Buffers 268435456 bytes
Redo Buffers 4472832 bytes

contents of Memory Script:
{
set newname for datafile 1 to
"/oracle/oradata/test1/system01.dbf";
set newname for datafile 2 to
"/oracle/oradata/test1/sysaux01.dbf";
set newname for datafile 3 to
"/oracle/oradata/test1/undotbs01.dbf";
set newname for datafile 4 to
"/oracle/oradata/test1/users01.dbf";
backup as copy reuse
datafile 1 auxiliary format
"/oracle/oradata/test1/system01.dbf" datafile
2 auxiliary format
"/oracle/oradata/test1/sysaux01.dbf" datafile
3 auxiliary format
"/oracle/oradata/test1/undotbs01.dbf" datafile
4 auxiliary format
"/oracle/oradata/test1/users01.dbf" ;
sql 'alter system archive log current';
}
executing Memory Script

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

executing command: SET NEWNAME

Starting backup at 18-JUN-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/oracle/oradata/orcl11/system01.dbf
output file name=/oracle/oradata/test1/system01.dbf tag=TAG20090618T111156 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/oracle/oradata/orcl11/sysaux01.dbf
output file name=/oracle/oradata/test1/sysaux01.dbf tag=TAG20090618T111156 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:25
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/oracle/oradata/orcl11/undotbs01.dbf
output file name=/oracle/oradata/test1/undotbs01.dbf tag=TAG20090618T111156 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:15
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/oracle/oradata/orcl11/users01.dbf
output file name=/oracle/oradata/test1/users01.dbf tag=TAG20090618T111156 RECID=0 STAMP=0
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 18-JUN-09

sql statement: alter system archive log current
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TEST1" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oracle/oradata/test1/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oracle/oradata/test1/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oracle/oradata/test1/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oracle/oradata/test1/system01.dbf'
CHARACTER SET AL32UTF8


contents of Memory Script:
{
backup as copy reuse
archivelog like "/oracle/flash_recovery_area/orcl11/archivelog/2009_06_18/o1_mf_1_19_53md6tmq_.arc" auxiliary format
"/oracle/product/11.1.0/db_1/dbs/arch1_19_683741214.dbf" ;
catalog clone archivelog "/oracle/product/11.1.0/db_1/dbs/arch1_19_683741214.dbf";
switch clone datafile all;
}
executing Memory Script

Starting backup at 18-JUN-09
using channel ORA_DISK_1
channel ORA_DISK_1: starting archived log copy
input archived log thread=1 sequence=19 RECID=66 STAMP=689858011
output file name=/oracle/product/11.1.0/db_1/dbs/arch1_19_683741214.dbf RECID=0 STAMP=0
channel ORA_DISK_1: archived log copy complete, elapsed time: 00:00:01
Finished backup at 18-JUN-09

cataloged archived log
archived log file name=/oracle/product/11.1.0/db_1/dbs/arch1_19_683741214.dbf RECID=1 STAMP=689858169

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=689858169 file name=/oracle/oradata/test1/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=689858169 file name=/oracle/oradata/test1/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=689858169 file name=/oracle/oradata/test1/users01.dbf

contents of Memory Script:
{
set until scn 2736101;
recover
clone database
delete archivelog
;
}
executing Memory Script

executing command: SET until clause

Starting recover at 18-JUN-09
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: SID=153 device type=DISK

starting media recovery

archived log for thread 1 with sequence 19 is already on disk as file /oracle/product/11.1.0/db_1/dbs/arch1_19_683741214.dbf
archived log file name=/oracle/product/11.1.0/db_1/dbs/arch1_19_683741214.dbf thread=1 sequence=19
media recovery complete, elapsed time: 00:00:00
Finished recover at 18-JUN-09

contents of Memory Script:
{
shutdown clone immediate;
startup clone nomount ;
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 392495104 bytes

Fixed Size 2144744 bytes
Variable Size 117442072 bytes
Database Buffers 268435456 bytes
Redo Buffers 4472832 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "TEST1" RESETLOGS ARCHIVELOG
MAXLOGFILES 16
MAXLOGMEMBERS 3
MAXDATAFILES 100
MAXINSTANCES 8
MAXLOGHISTORY 292
LOGFILE
GROUP 1 ( '/oracle/oradata/test1/redo01.log' ) SIZE 50 M REUSE,
GROUP 2 ( '/oracle/oradata/test1/redo02.log' ) SIZE 50 M REUSE,
GROUP 3 ( '/oracle/oradata/test1/redo03.log' ) SIZE 50 M REUSE
DATAFILE
'/oracle/oradata/test1/system01.dbf'
CHARACTER SET AL32UTF8


contents of Memory Script:
{
set newname for tempfile 1 to
"/oracle/oradata/test1/temp01.dbf";
switch clone tempfile all;
catalog clone datafilecopy "/oracle/oradata/test1/sysaux01.dbf";
catalog clone datafilecopy "/oracle/oradata/test1/undotbs01.dbf";
catalog clone datafilecopy "/oracle/oradata/test1/users01.dbf";
switch clone datafile all;
}
executing Memory Script

executing command: SET NEWNAME

renamed tempfile 1 to /oracle/oradata/test1/temp01.dbf in control file

cataloged datafile copy
datafile copy file name=/oracle/oradata/test1/sysaux01.dbf RECID=1 STAMP=689858184

cataloged datafile copy
datafile copy file name=/oracle/oradata/test1/undotbs01.dbf RECID=2 STAMP=689858184

cataloged datafile copy
datafile copy file name=/oracle/oradata/test1/users01.dbf RECID=3 STAMP=689858184

datafile 2 switched to datafile copy
input datafile copy RECID=1 STAMP=689858184 file name=/oracle/oradata/test1/sysaux01.dbf
datafile 3 switched to datafile copy
input datafile copy RECID=2 STAMP=689858184 file name=/oracle/oradata/test1/undotbs01.dbf
datafile 4 switched to datafile copy
input datafile copy RECID=3 STAMP=689858184 file name=/oracle/oradata/test1/users01.dbf

contents of Memory Script:
{
Alter clone database open resetlogs;
}
executing Memory Script

database opened
Finished Duplicate Db at 18-JUN-09

[@more@]

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

转载于:http://blog.itpub.net/100682/viewspace-1023252/

cuiju3758
关注
100天精通Oracle-实战系列（第18天）RMAN Duplicate 异机复制 Oracle 数据库
LuciferLiu_DBA
05-23 1408
RMAN Duplicate 是从 Oracle 10G 开始出现的功能，但是在 11G 时增加了很多功能，可以通过 Active Database Duplicate 和 Backup-based Duplicate 两种方法实现。
11g新特性之active databaes duplicate
Linucle的专栏
05-26 1260
一，环境信息 主库：rhel6.2 oracle 11.2.0.4 duplicate库：orace linux 6.6 oracle 11.2.0.3 注意：数据库软件版本一定要相同，最起码compatible参数要一致 二，在duplicate端创建参数文件和密码文件 1.确认主库数据文件和日志文件的路径 SQL> select name from v$datafile
11g RMAN新特性 active database duplication
我的Oracle DBA之路
06-09 502
11g RMAN新特性 active database duplicationhttp://www.itpub.net/viewthread.php?tid=1030938&highlight=11g%2Brman
Oracle Active database duplication
01-18 166
001 理论基础 active database duplication ：A duplicate database that is created over a network without restori...
Oracle 11g 新特性—— Active Database Duplication for A standby database
数据库天地
08-03 199
简介 ------------ 从11G开始Oracle提供了一个新功能Active Database Duplication for A standby database来创建配置物理standby 数据库。 Active Database Duplication for A standby database这个功能主要从一个正在运行的数据库复制数据文件，控制文件等到一个物理备库（phys...
Overview of RMAN Database Duplication
彦祖的小号的博客
07-29 279
Database duplication is the use of theDUPLICATEcommand to copy all or a subset of the data in asource database 使用duplicate实质是数据库的时间点恢复 RMAN must perform database point-in-time recovery, even when no explicit point in time is provided for duplication...
使用RMAN DUPLICATE...FROM ACTIVE DATABASE 创建物理备库.docx
07-08
【使用RMAN DUPLICATE...FROM ACTIVE DATABASE 创建物理备库】 在Oracle数据库管理中，创建物理备用数据库（Physical Standby Database）是数据保护策略的重要组成部分，主要用于实现Data Guard环境中的灾难恢复和...
Oracle Rman Active Database Duplicate 迁移方案V1.1.pdf
09-24
本文档将介绍 Rman Active Database Duplication 迁移方案的概述，包括数据库 Rman 技术介绍、迁移前信息收集、Rman Active Database Duplication 迁移数据库等内容。 第 2 章数据库 Rman 技术介绍 ===============...
RMAN-05501: aborting duplication of target database
congwei2855的博客
07-15 1756
1. 问题： 在搭建DG的时候，d...
使用duplicate from active database创建standby database(Oracle 11g Data Guard)
DoubleJing的博客
11-11 1207
Primary IP: 192.168.33.2 DB_NAME=orcl SID=orcl_pd Standby IP: 192.168.33.3 DB_NAME=orcl SID=orcl_st 一. Primary 端操作： 设置归档模式 这个生产库都是这种模式。 SQL> archive log list; SQL> shu...
OracleRMANDatabaseDuplicationPDFBooks.pdf 英文原版
08-21
Oracle RMAN Database Duplication – PDF Books
Oracle RMAN Database Duplication(Apress,2015)
05-07
RMAN is Oracle's flagship backup and recovery tool, but did you know it's also an effective database duplication tool? Oracle RMAN Database Duplication is a deep dive into RMAN's duplication feature set, showing how RMAN can make it so much easier for you as a database administrator to satisfy the many requests from developers and testers for database copies and refreshes for use in their work. You'll learn to make and refresh duplicate databases with a single command, and of course you can automate and schedule that command so that developers and testers are supplied with regular, known good databases without any manual intervention on your part. Fast and easy provisioning of databases for developers and testers is a driving force in the move to cloud computing and virtualization. RMAN's robust database duplication feature set plays right into this growing need for ease of provisioning, enabling easy duplication of known-good databases on demand, across operating systems such as between Linux and Solaris, and even across storage environments such as when duplicating from a RAC/ASM environment to a single-node instance using regular file system storage. Oracle RMAN Database Duplication is your thorough guide to providing amazing business value to your organization by way of fast and easy provisioning of database duplicates in service of development and testing projects.
oracle 11g RMAN：Active Database Duplication for standby database 创建dg 命令解读
Lixora's DB Home
01-10 1510
基于生产的duplicate 复制，如果事先没有手动配置pfile（设定内存，进程，dg相关配置参数，数据库相关路径参数）则会出现各种参数无法转换的问题； 因为duplicate 会从生产自动拷贝pfile，控制文件，密码文件过来，如果主库和备库环境不一样（数据库软件路径，数据文件存储路径） 如果没在duplicate的命令中完整指定新环境备库的各种参数涉及路径，及转换参数，就会默认使用从主库
Oracle Active Database Duplication
weixin_33971130的博客
10-22 126
Active Database Duplication简介---------Active database duplication功能是从11g开始引入的一个新功能，它是对比以前版本中的基于备份集的复制数据库功能。下面简单的回顾一下关于ORACLE Duplicate Database功能，Duplicate database可以按照用途分为2种，一种是duplicate d...
OracleRMAN备份与恢复之九：Active Database Duplicate
Eric.zhong
09-01 449
对于基于生产环境下的数据库的版本升级或者测试新的应用程序的性能及其影响，备份恢复等等，我们可以采取从生产环境以克隆的方式将其克隆到本地而不影响生产数据库的正常使用。实现这个功能我们可以借助rman duplicate方式以及其简单的方式来完成。 Active Database Duplicate方式与传统Based Backup Duplicate方式有明显的差异，它无需基于备份与直接从源传输到目...
oracle11g：add：活动数据库复制(Active Database Duplication)
viviliving的专栏
03-14 287
Oracle Database 11g中增加了一个重要的功能，可以在不使用现有的RMAN备份或手动拷贝文件的情况下复制数据库。如果您之前不使用RMAN备份，那么现在可以利用RMAN复制功能创建备用数据库、测试环境或开发环境，而不必事先创建RMAN备份。此功能利用网络，所以也被称为网络使能的数据库复制(Network-enabled Database Duplication)或活动数据库复制。 RM...
使用Oracle 11g新特性 Active Database Duplication 搭建Dataguard环境
weixin_34183910的博客
03-10 171
Duplication Database 介绍 Duplicate database可以按照用途分为2种: duplicate database(复制出一个数据库) duplicate standby database(复制出一个dataguard standby数据库) Duplicate Database又可以按照复制数据的来源不同分为2种方式： ...
oracle 11gr2 活动数据库复制(active database duplication)
congse3359的博客
10-29 230
oracle的自动化程度越来越高,在oracle 11g中,可以直接在网络上复制一个数据库而不必备份和提供源数据库文件到目的库. 在测试中发现和以往的duplicate在细节上有此不同,容易出一些小错误,下...
11g RMAN新特性 active database duplication 复制数据库
cucanqi9387的博客
07-31 127
第二.利用active database duplication 复制一个数据库前面1到5步 和创建standby 数据库一样 其中第5步设置dataguard相关初始化参数可以去掉6.登录主库 开始复制C:\Document...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值