rman duplicate 记录

最新推荐文章于 2025-06-05 01:02:19 发布

原创最新推荐文章于 2025-06-05 01:02:19 发布 · 448 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#database #command #disk #character #oracle #maf

本文介绍了一种使用RMAN工具进行Oracle数据库克隆的具体步骤，包括启动备用数据库、设置新的数据文件路径、恢复并切换数据文件等内容。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

前期工作：

备份源库。

创建相应的目录： adump cdump bdump等

创建密码文件： orapwd

export ORACLE_SID= new sid

以nomount pfile= 方式启动备库。

[oracle@db1 dbs]$ rman target sys/sys@db1 auxiliary /

Recovery Manager: Release 10.2.0.4.0 - Production on ▒▒▒▒▒▒ 4▒▒ 23 03:26:10 2011

connected to target database: DB1 (DBID=1341870041)
connected to auxiliary database: DB1_2 (not mounted)

RMAN> run{
2> SET NEWNAME for datafile 1 to '/oradata/db1_2/SYSTEM01.DBF';
3> SET NEWNAME for datafile 2 to '/oradata/db1_2/undotbs01.DBF';
4> SET NEWNAME for datafile 3 to '/oradata/db1_2/sysaux01.DBF';
SET NEWNAME for datafile 4 to '/oradata/db1_2/users01.DBF';
5> 6> SET NEWNAME for tempfile 1 to '/oradata/db1_2/temp01.DBF';
7> duplicate target database to db1_2
8> pfile='/oracle/product/10.2.0.1/db_1/dbs/initdb1_2.ora'
9> logfile
10> '/oradata/db1_2/redo01.dbf' size 10M,
11> '/oradata/db1_2/redo02.dbf' size 10M;
12> }

executing command: SET NEWNAME
using target database control file instead of recovery catalog

executing command: SET NEWNAME

Starting Duplicate Db at 23-4▒▒ -11
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK

contents of Memory Script:
{
   set newname for datafile 1 to
"/oradata/db1_2/SYSTEM01.DBF";
   set newname for datafile 2 to
"/oradata/db1_2/undotbs01.DBF";
   set newname for datafile 3 to
"/oradata/db1_2/sysaux01.DBF";
   set newname for datafile 4 to
"/oradata/db1_2/users01.DBF";
   restore
   check readonly
   clone database
   ;
}
executing Memory Script

executing command: SET NEWNAME

Starting restore at 23-4▒▒ -11
using channel ORA_AUX_DISK_1

channel ORA_AUX_DISK_1: starting datafile backupset restore
channel ORA_AUX_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /oradata/db1_2/SYSTEM01.DBF
restoring datafile 00002 to /oradata/db1_2/undotbs01.DBF
restoring datafile 00003 to /oradata/db1_2/sysaux01.DBF
restoring datafile 00004 to /oradata/db1_2/users01.DBF
channel ORA_AUX_DISK_1: reading from backup piece /oracle/product/10.2.0.1/db_1/                       dbs/03maf690_1_1
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=/oracle/product/10.2.0.1/db_1/dbs/03maf690_1_1 tag=TAG20110423T0153                       36
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:00:26
Finished restore at 23-4▒▒ -11
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DB1_2" RESETLOGS NOARCHIVE                       LOG
MAXLOGFILES     16
MAXLOGMEMBERS      3
MAXDATAFILES      100
MAXINSTANCES     8
MAXLOGHISTORY      292
LOGFILE
GROUP 1 '/oradata/db1_2/redo01.dbf' SIZE 10 M ,
GROUP 2 '/oradata/db1_2/redo02.dbf' SIZE 10 M
DATAFILE
'/oradata/db1_2/SYSTEM01.DBF'
CHARACTER SET ZHS16GBK

contents of Memory Script:
{
switch clone datafile all;
}
executing Memory Script

released channel: ORA_AUX_DISK_1
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=749186807 filename=/oradata/db1_2/undotbs01.DB F
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=749186807 filename=/oradata/db1_2/sysaux01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=749186807 filename=/oradata/db1_2/users01.DBF

contents of Memory Script:
{
   recover
   clone database
   noredo
   ,
    delete archivelog
   ;
}
executing Memory Script

Starting recover at 23-4▒▒ -11
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=156 devtype=DISK
Finished recover at 23-4▒▒ -11

contents of Memory Script:
{
shutdown clone;
startup clone nomount pfile= '/oracle/product/10.2.0.1/db_1/dbs/initdb1_2.ora ';
}
executing Memory Script

database dismounted
Oracle instance shut down

connected to auxiliary database (not started)
Oracle instance started

Total System Global Area 167772160 bytes

Fixed Size                     2082464 bytes
Variable Size                 79694176 bytes
Database Buffers              79691776 bytes
Redo Buffers                   6303744 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "DB1_2" RESETLOGS NOARCHIVE                       LOG
MAXLOGFILES     16
MAXLOGMEMBERS      3
MAXDATAFILES      100
MAXINSTANCES     8
MAXLOGHISTORY      292
LOGFILE
GROUP 1 '/oradata/db1_2/redo01.dbf' SIZE 10 M ,
GROUP 2 '/oradata/db1_2/redo02.dbf' SIZE 10 M
DATAFILE
'/oradata/db1_2/SYSTEM01.DBF'
CHARACTER SET ZHS16GBK

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

executing command: SET NEWNAME

renamed temporary file 1 to /oradata/db1_2/temp01.DBF in control file

cataloged datafile copy
datafile copy filename=/oradata/db1_2/undotbs01.DBF recid=1 stamp=749186817

cataloged datafile copy
datafile copy filename=/oradata/db1_2/sysaux01.DBF recid=2 stamp=749186817

cataloged datafile copy
datafile copy filename=/oradata/db1_2/users01.DBF recid=3 stamp=749186817

datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=749186817 filename=/oradata/db1_2/undotbs01.DB F
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=749186817 filename=/oradata/db1_2/sysaux01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=749186817 filename=/oradata/db1_2/users01.DBF

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

database opened
Finished Duplicate Db at 23-4▒▒ -11

RMAN> quit