[Oracle Mgmt]Use RMAN to Duplicate Database in the Same Host (Based on Windows Platform)

有时候可能需要去创建一个跟target数据库一样的一个数据库副本， 用RMAN可以很方便地通过Target数据库的备份文件(backup sets)来clone一个同样的数据库。

本文主要讲述如何用RMAN在同一个Host上duplicate一个数据库, (target database and duplicated database reside in the same machine).

 

因为RMAN是通过target数据库的备份文件来创建数据库副本，因此首先需要同RMAN来给target数据库做一个全面的备份，如下

RMAN> backup database plus archivelog;

 

 

Step 1:

Target数据库叫orcl, 我们想创建一个副本叫orcl3, 该怎么做呢？ 首先需要建一个数据库instance启动的参数文件，暂命名为initorcl3.ora, 与initorcl.ora放在同一个目录(默认数目-<ORACLE_HOME>\database, 我的机器上路径是E:\oracle\product\10.2.0\db_1\database).

文件initorcl3.ora的内容如下， 

 
db_name=orcl3
db_block_size=8192
compatible=10.2.0.4
remote_login_passwordfile=exclusive
#sga_target=500m
#sga_max_size=600m
control_files=('E:\oracle\product\10.2.0\oradata\orcl3\control01.ctl', 
               'E:\oracle\product\10.2.0\oradata\orcl3\control02.ctl', 
               'E:\oracle\product\10.2.0\oradata\orcl3\control03.ctl')
db_file_name_convert=('E:\oracle\product\10.2.0\oradata\orcl', 'E:\oracle\product\10.2.0\oradata\orcl3')
log_file_name_convert=('E:\oracle\product\10.2.0\oradata\orcl', 'E:\oracle\product\10.2.0\oradata\orcl3')

 

这些参数里面有些是必须的，比如db_name, control_files, db_file_name_convert, log_file_name_convert.

control_files设置了orcl3数据库的控制文件的名字和位置（RMAN在duplicate database的时候会自动创建)

db_file_name_convert和log_file_name_convert用来设置Target数据库(orcl)和duplicated database（orcl3)中数据文件和日志文件的目录对应关系，因为默认情况下rman在duplicate database的时候只是把target database(从backup set)中的datafile, redo logfile拷贝到指定的目录下，不会改名字, 因此目录必须不一样才行。这里就放在了同target 数据库orcl相同的“父”目录下—E:\oracle\product\10.2.0\oradata.

 

另外，注意里面有两个参数被注释了(#)

sga_target=500m

sga_max_size=600m

 

这两个参数用来控制instance的内存分配，如果不设置这两个参数，可能会出现问题，下面会见到。

 

Step 2:

接下来在listener.ora和tnsname.ora中加入如下内容，这个主要是用在后面rman来连接这个auxiliary数据库时用到。

 

-- listener.ora

 
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    
    (SID_DESC =
      (GLOBAL_DBNAME=orcl)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (SID_NAME=orcl)
    )
 
    (SID_DESC =
      (GLOBAL_DBNAME=orcl2)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (SID_NAME=orcl2)
    )
 
    (SID_DESC =
      (GLOBAL_DBNAME=orcl3)
      (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)
      (SID_NAME=orcl3)
    )
  )

 

-- tnsname.ora

ORCL3 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.80.15.117)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl3)
    )
  )

 

Step 3:

 

用oradim来新建instance – orcl3, 如下 

C:\Documents and Settings\szuser>oradim -new -sid orcl3
Instance created.

 

启动orcl3到nomount阶段 （因为这个时候还没有Control文件，因此只能启动到nomount阶段）

C:\Documents and Settings\szuser>sqlplus /nolog
 
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 18 16:17:13 2010
 
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
 
SQL> conn /@orcl3 as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
 
 
SQL> conn sys/sys@orcl3 as sysdba
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
 
 
SQL> exit
 
C:\Documents and Settings\szuser>set ORACLE_SID=orcl3
 
C:\Documents and Settings\szuser>sqlplus /nolog
 
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 18 16:18:58 2010
 
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
 
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup force nomount pfile=E:\oracle\product\10.2.0\db_1\database\initorcl
3.ora
ORACLE instance started.
 
Total System Global Area  117440512 bytes
Fixed Size                  1295320 bytes
Variable Size              58723368 bytes
Database Buffers           50331648 bytes
Redo Buffers                7090176 bytes
SQL> select name from v$database;
select name from v$database
                 *
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 2
ORA-04031: unable to allocate 64 bytes of shared memory ("shared pool","select
di.inst_id,di.didbi,d...","sql area","opn: qkexrInitOpn")
 
 
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options

 

 

注意在这个过程中做了一个测试 select name from v$database, 因为数据库还没有到open阶段，很显然这条SQL语句会出现问题，但是出现的问题显然不应该是ORA-04031, 从错误信息来看就以为shared pool分配的空间不够！暂时先不管这个错误，继续。

 

 

Step 4：

用RMAN连接到target 数据库orcl和auxiliary数据库(orcl3)来duplicate orcl to orcl3

 
C:\Documents and Settings\szuser>rman target /@orcl auxiliary /@orcl3
 
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 18 16:20:37 2010
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
connected to target database: ORCL (DBID=1235521622)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-12528: TNS:listener: all appropri
ate instances are blocking new connections
 
C:\Documents and Settings\szuser>

 

 

但是很不幸，出现了一些问题，这是因为我们之前改了listener.ora文件，需要重启下tns listener.

 

Step 5: Restart TNS Listener

 

C:\Documents and Settings\szuser>lsnrctl stop
 
LSNRCTL for 32-bit Windows: Version 10.2.0.4.0 - Production on 18-JAN-2010 16:23
:52
 
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
 
C:\Documents and Settings\szuser>lsnrctl start
 
LSNRCTL for 32-bit Windows: Version 10.2.0.4.0 - Production on 18-JAN-2010 16:24
:01
 
Copyright (c) 1991, 2007, Oracle.  All rights reserved.
 
Starting tnslsnr: please wait...
 
TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Production
System parameter file is E:\oracle\product\10.2.0\db_1\network\admin\listener.or
a
Log messages written to E:\oracle\product\10.2.0\db_1\network\log\listener.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc
)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.15.117)(PORT=1521)
))
 
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.4.0 - Produ
ction
Start Date                18-JAN-2010 16:24:02
Uptime                    0 days 0 hr. 0 min. 2 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   E:\oracle\product\10.2.0\db_1\network\admin\listener.o
ra
Listener Log File         E:\oracle\product\10.2.0\db_1\network\log\listener.log
 
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.80.15.117)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl" has 1 instance(s).
  Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl2" has 1 instance(s).
  Instance "orcl2", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl3" has 1 instance(s).
  Instance "orcl3", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
 
C:\Documents and Settings\szuser>
 

 

再来尝试下看看，

 
C:\Documents and Settings\szuser>rman target /@orcl auxiliary /@orcl3
 
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 18 16:25:01 2010
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
connected to target database: ORCL (DBID=1235521622)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04006: error from auxiliary database: ORA-00600: internal error code, argum
ents: [15435], [SYS], [X$DBMS_BACKUP_RESTORE], [], [], [], [], []
ORA-04031: unable to allocate 1040 bytes of shared memory ("shared pool","X$DBMS
_BACKUP_RESTORE","PL/SQL DIANA","PAR.C:parapt:Page")
RMAN-04015: error setting target database character set to WE8MSWIN1252

 

这个时候会发现得到的错误信息跟之前执行select * from v$database得到的错误类似，也是因为shared pool空间不够。怎么办呢，我们可以修改initorcl3.ora, 设置下sga_target参数值

db_name=orcl3
db_block_size=8192
compatible=10.2.0.4
remote_login_passwordfile=exclusive
sga_target=500m
sga_max_size=600m
control_files=('E:\oracle\product\10.2.0\oradata\orcl3\control01.ctl', 'E:\oracle\product\10.2.0\oradata\orcl3\control02.ctl', 'E:\oracle\product\10.2.0\oradata\orcl3\control03.ctl')
db_file_name_convert=('E:\oracle\product\10.2.0\oradata\orcl', 'E:\oracle\product\10.2.0\oradata\orcl3')
log_file_name_convert=('E:\oracle\product\10.2.0\oradata\orcl', 'E:\oracle\product\10.2.0\oradata\orcl3')

 

然后重新启动instance orcl3, 

C:\Documents and Settings\szuser>set ORACLE_SID=orcl3
 
C:\Documents and Settings\szuser>sqlplus /nolog
 
SQL*Plus: Release 10.2.0.4.0 - Production on Mon Jan 18 16:31:21 2010
 
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
 
SQL> conn / as sysdba
Connected.
SQL> startup force nomount pfile=E:\oracle\product\10.2.0\db_1\database\initorcl
3.ora
ORACLE instance started.
 
Total System Global Area  629145600 bytes
Fixed Size                  1298304 bytes
Variable Size             251658368 bytes
Database Buffers          369098752 bytes
Redo Buffers                7090176 bytes
SQL> select * from v$database;
select * from v$database
              *
ERROR at line 1:
ORA-01507: database not mounted
 
 
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Pr
oduction
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
C:\Documents and Settings\szuser>rman target /@orcl auxiliary /@orcl3
 
Recovery Manager: Release 10.2.0.4.0 - Production on Mon Jan 18 16:32:25 2010
 
Copyright (c) 1982, 2007, Oracle.  All rights reserved.
 
connected to target database: ORCL (DBID=1235521622)
connected to auxiliary database: ORCL3 (not mounted)
 
RMAN>

 

可以看出RMAN可以成功连接到target database和auxiliary database了！

 

Step 6:

 

执行 RMAN>duplicate target database to orcl3

但是遇到如下问题，

 

ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) The system cannot find the path specified.
failover to previous backup
 
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of Duplicate Db command at 01/18/2010 16:33:45
RMAN-03015: error occurred in stored script Memory Script
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

 

 

原因是我们没有手动创建文件夹orcl3 (E:\oracle\product\10.2.0\oradata\orcl3)

手动创建文件夹orcl3之后才尝试就可以成功了！如下

RMAN> duplicate target database to orcl3;
 
Starting Duplicate Db at 18-JAN-10
using channel ORA_AUX_DISK_1
 
contents of Memory Script:
{
   set until scn  9158499;
   set newname for datafile  1 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\SYSTEM01.DBF";
   set newname for datafile  2 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\UNDOTBS01.DBF";
   set newname for datafile  3 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\SYSAUX01.DBF";
   set newname for datafile  4 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\USERS01.DBF";
   set newname for datafile  5 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\EXAMPLE02.DBF";
   restore
   check readonly
   clone database
   ;
}
executing Memory Script
 
executing command: SET until clause
 
executing command: SET NEWNAME
 
executing command: SET NEWNAME
 
executing command: SET NEWNAME
 
executing command: SET NEWNAME
 
executing command: SET NEWNAME
 
Starting restore at 18-JAN-10
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 E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\SYSTEM01.DBF
restoring datafile 00002 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\UNDOTBS01.DBF
 
restoring datafile 00003 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\SYSAUX01.DBF
restoring datafile 00004 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\USERS01.DBF
restoring datafile 00005 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\EXAMPLE02.DBF
 
channel ORA_AUX_DISK_1: reading from backup piece E:\ORACLE\PRODUCT\10.2.0\FLASH
_RECOVERY_AREA\ORCL\BACKUPSET\2010_01_18\O1_MF_NNNDF_TAG20100118T101131_5O7JTMGD
_.BKP
channel ORA_AUX_DISK_1: restored backup piece 1
piece handle=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\BACKUPSET\2010_01
_18\O1_MF_NNNDF_TAG20100118T101131_5O7JTMGD_.BKP tag=TAG20100118T101131
channel ORA_AUX_DISK_1: restore complete, elapsed time: 00:01:06
Finished restore at 18-JAN-10
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL3" RESETLOGS ARCHIVELO
G
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\REDO01.LOG' ) SIZE 50 M  RE
USE,
  GROUP  2 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\REDO02.LOG' ) SIZE 50 M  RE
USE,
  GROUP  3 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\REDO03.LOG' ) SIZE 50 M  RE
USE
 DATAFILE
  'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\SYSTEM01.DBF'
 CHARACTER SET WE8MSWIN1252
 
 
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=708626171 filename=E:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCL3\UNDOTBS01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=708626171 filename=E:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCL3\SYSAUX01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=708626171 filename=E:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCL3\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=708626171 filename=E:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCL3\EXAMPLE02.DBF
 
contents of Memory Script:
{
   set until scn  9158499;
   recover
   clone database
    delete archivelog
   ;
}
executing Memory Script
 
executing command: SET until clause
 
Starting recover at 18-JAN-10
allocated channel: ORA_AUX_DISK_1
channel ORA_AUX_DISK_1: sid=36 devtype=DISK
 
starting media recovery
 
archive log thread 1 sequence 182 is already on disk as file E:\ORACLE\PRODUCT\1
0.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELOG\2010_01_18\O1_MF_1_182_5O7JVDHV_.ARC
archive log filename=E:\ORACLE\PRODUCT\10.2.0\FLASH_RECOVERY_AREA\ORCL\ARCHIVELO
G\2010_01_18\O1_MF_1_182_5O7JVDHV_.ARC thread=1 sequence=182
media recovery complete, elapsed time: 00:00:03
Finished recover at 18-JAN-10
 
contents of Memory Script:
{
   shutdown clone;
   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     629145600 bytes
 
Fixed Size                     1298304 bytes
Variable Size                251658368 bytes
Database Buffers             369098752 bytes
Redo Buffers                   7090176 bytes
sql statement: CREATE CONTROLFILE REUSE SET DATABASE "ORCL3" RESETLOGS ARCHIVELO
G
  MAXLOGFILES     16
  MAXLOGMEMBERS      3
  MAXDATAFILES      100
  MAXINSTANCES     8
  MAXLOGHISTORY      292
 LOGFILE
  GROUP  1 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\REDO01.LOG' ) SIZE 50 M  RE
USE,
  GROUP  2 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\REDO02.LOG' ) SIZE 50 M  RE
USE,
  GROUP  3 ( 'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\REDO03.LOG' ) SIZE 50 M  RE
USE
 DATAFILE
  'E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\SYSTEM01.DBF'
 CHARACTER SET WE8MSWIN1252
 
 
contents of Memory Script:
{
   set newname for tempfile  1 to
 "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\TEMP01.DBF";
   switch clone tempfile all;
   catalog clone datafilecopy  "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\UNDOTBS01
.DBF";
   catalog clone datafilecopy  "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\SYSAUX01.
DBF";
   catalog clone datafilecopy  "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\USERS01.D
BF";
   catalog clone datafilecopy  "E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\EXAMPLE02
.DBF";
   switch clone datafile all;
}
executing Memory Script
 
executing command: SET NEWNAME
 
renamed temporary file 1 to E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\TEMP01.DBF in
 control file
 
cataloged datafile copy
datafile copy filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\UNDOTBS01.DBF reci
d=1 stamp=708626184
 
cataloged datafile copy
datafile copy filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\SYSAUX01.DBF recid
=2 stamp=708626185
 
cataloged datafile copy
datafile copy filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\USERS01.DBF recid=
3 stamp=708626185
 
cataloged datafile copy
datafile copy filename=E:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL3\EXAMPLE02.DBF reci
d=4 stamp=708626185
 
datafile 2 switched to datafile copy
input datafile copy recid=1 stamp=708626184 filename=E:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCL3\UNDOTBS01.DBF
datafile 3 switched to datafile copy
input datafile copy recid=2 stamp=708626185 filename=E:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCL3\SYSAUX01.DBF
datafile 4 switched to datafile copy
input datafile copy recid=3 stamp=708626185 filename=E:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCL3\USERS01.DBF
datafile 5 switched to datafile copy
input datafile copy recid=4 stamp=708626185 filename=E:\ORACLE\PRODUCT\10.2.0\OR
ADATA\ORCL3\EXAMPLE02.DBF
 
contents of Memory Script:
{
   Alter clone database open resetlogs;
}
executing Memory Script
 
database opened
Finished Duplicate Db at 18-JAN-10

 

最后生成的结果目录如下图，可以看到所有的文件都创建出来了，

飞信截屏未命名4

 

 

下面总结下整个过程：

 

1. Backup target database using RMAN

2. Create parameter file (remember to set the sga size)and directory (e.g. orcl3) wherein the database will reside

3. Add entries to tnsname.ora and listener.ora

4. Restart TNS listerner

5. Use ORADIM to create new instance

6. Start the newly created instance using the parameter file to nomount state.

7. Connect to both Target database and Auxiliary database using RMAN

8. Duplicate target database to auxiliary database

9. Remove the following parameters from the pfile initorcl3.ora

db_file_name_convert=('E:\oracle\product\10.2.0\oradata\orcl', 'E:\oracle\product\10.2.0\oradata\orcl3')
log_file_name_convert=('E:\oracle\product\10.2.0\oradata\orcl', 'E:\oracle\product\10.2.0\oradata\orcl3')
posted @ 2010-01-18 17:20  FangwenYu  阅读(1850)  评论(0)  编辑  收藏  举报