rman duplicate 记录
来源:互联网 发布:bim设计方案优化 编辑:程序博客网 时间:2024/05/01 01:29
前期工作:
备份源库。
创建相应的目录: 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
Copyright (c) 1982, 2007, Oracle. All rights reserved.
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
executing command: SET NEWNAME
executing command: SET NEWNAME
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
executing command: SET NEWNAME
executing command: SET NEWNAME
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
- rman duplicate 记录
- rman duplicate
- RMAN Duplicate复制数据库
- RMAN duplicate database
- RMAN创建duplicate数据库
- RMAN DUPLICATE详解
- RMAN DUPLICATE详解
- rman duplicate 介绍
- rman duplicate数据库
- rman duplicate 总结
- RMAN duplicate数据库
- RMAN - duplicate DATABASE
- RMAN duplicate 方式 做个备库
- RMAN duplicate 错误越来越离奇!
- RMAN duplicate 异机恢复
- RMAN 异机duplicate复制数据库
- oracle11G rman duplicate 复制数据库
- rman的duplicate复制数据库
- js 返回值 并刷新父界面
- 使用Entity Framework时,如何构建动态排序条件
- 支持IE和FF的ASP.NET弹出层
- 内核配置与编译
- oracle中自增列!
- rman duplicate 记录
- SQL各种连接学习 ——转载
- Cpp深入:多重继承
- 数据结构与算法学习之查找技术
- 热烈祝贺CSDN Norains 同志的wince 书籍《Windows CE大排档》出版了
- 公司一份java面试题
- python tutorial 学习笔记(七)Errors and Exceptions
- eclipse中修改工程名及发布时的路径名
- LINQ To Xml:按条件删除element