最初由 orientzkd 发布
[B].
怎么用rman复制数据库,有详细的步骤么 [/B]
1,用rman做一个数据库的全备份
2,新创建一个辅助的instance,将instance startup nomount
3,根据数据库的rman备份来复制产生一个新库
下面是我做的测试例子,具体还是看看
Oracle9i Recovery Manager User's Guide
Release 2 (9.2)
Part Number A96566-01
6 RMAN Concepts II: Restore, Recovery, and Duplication
C:\>rman target / auxiliary sys/test@test
恢复管理器: 版本9.2.0.1.0 - Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
连接到目标数据库: WORLD (DBID=516573805)
已连接到备用数据库: test (未安装)
RMAN> run {
2> allocate auxiliary channel ch1 type disk;
3> duplicate target database to 'test'
4> logfile group 1 ('c:\oracle\oradata\test\redo01.log') size 100k,
5> group 2 ('c:\oracle\oradata\test\redo02.log') size 100k;
6> release channel ch1;
7> }
正在使用目标数据库控制文件替代恢复目录
分配的通道: ch1
通道 ch1: sid=12 devtype=DISK
启动 Duplicate Db 于 25-8月 -05
正在打印存储的脚本: Memory Script
{
set until scn 2593883;
set newname for datafile 1 to
"C:\ORACLE\ORADATA\TEST\SYSTEM01.DBF";
set newname for datafile 2 to
"C:\ORACLE\ORADATA\TEST\UNDOTBS01.DBF";
set newname for datafile 3 to
"C:\ORACLE\ORADATA\TEST\CWMLITE01.DBF";
set newname for datafile 4 to
"C:\ORACLE\ORADATA\TEST\DRSYS01.DBF";
set newname for datafile 5 to
"C:\ORACLE\ORADATA\TEST\EXAMPLE01.DBF";
set newname for datafile 6 to
"C:\ORACLE\ORADATA\TEST\INDX01.DBF";
set newname for datafile 7 to
"C:\ORACLE\ORADATA\TEST\ODM01.DBF";
set newname for datafile 8 to
"C:\ORACLE\ORADATA\TEST\TOOLS01.DBF";
set newname for datafile 9 to
"C