RMAN异机迁移实战操作-附加常用命令
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了RMAN异机迁移实战操作-附加常用命令,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含4436字,纯文字阅读大概需要7分钟。
内容图文
![RMAN异机迁移实战操作-附加常用命令](/upload/InfoBanner/zyjiaocheng/563/3e2940fd8dba45be8f62839bfc8ac77d.jpg)
操作操作场景 源服务器 OEL 6.3 11G R2 11.2.0.3目标服务器 OEL 6.3 11G R2 11.2.0.3源服务器和目标服务器存放数据路
操作操作场景
源服务器 OEL 6.3 11G R2 11.2.0.3
目标服务器 OEL 6.3 11G R2 11.2.0.3
源服务器和目标服务器存放数据路径一样
源服务器
[Oracle@mxq ~]$ rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Sat May 16 08:51:05 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database: ORACLE11 (DBID=2573050700)
RMAN> run
{allocate channel orademo type disk MAXPIECESIZE 1024m;
backup incremental level 0 as compressed backupset database include current controlfile tag='full' format '/home/oracle/db_%s_%p_%t' plus archivelog tag='arch_all' format '/home/oracle/arch_%s_%p_%t' delete input;
}2> 3> 4>
released channel: ORA_DISK_1
allocated channel: orademo
channel orademo: SID=147 device type=DISK
Starting backup at 16-MAY-15
current log archived
channel orademo: starting compressed archived log backup set
channel orademo: specifying archived log(s) in backup set
input archived log thread=1 sequence=96 RECID=69 STAMP=879840530
channel orademo: starting piece 1 at 16-MAY-15
channel orademo: finished piece 1 at 16-MAY-15
piece handle=/home/oracle/arch_59_1_879840531 tag=ARCH_ALL comment=NONE
channel orademo: backup set complete, elapsed time: 00:00:01
channel orademo: deleting archived log(s)
archived log file name=/orafile/arc/1_96_879804940.arc RECID=69 STAMP=879840530
Finished backup at 16-MAY-15
Starting backup at 16-MAY-15
channel orademo: starting compressed incremental level 0 datafile backup set
channel orademo: specifying datafile(s) in backup set
including current SPFILE in backup set
including current control file in backup set
input datafile file number=00002 name=/orafile/oradata/sysaux01.dbf
input datafile file number=00001 name=/orafile/oradata/system01.dbf
input datafile file number=00003 name=/orafile/oradata/undotbs01.dbf
input datafile file number=00004 name=/orafile/oradata/users01.dbf
channel orademo: starting piece 1 at 16-MAY-15
channel orademo: finished piece 1 at 16-MAY-15
piece handle=/home/oracle/db_60_1_879840533 tag=FULL comment=NONE
channel orademo: backup set complete, elapsed time: 00:02:55
Finished backup at 16-MAY-15
Starting backup at 16-MAY-15
current log archived
channel orademo: starting compressed archived log backup set
channel orademo: specifying archived log(s) in backup set
input archived log thread=1 sequence=97 RECID=72 STAMP=879840713
channel orademo: starting piece 1 at 16-MAY-15
channel orademo: finished piece 1 at 16-MAY-15
piece handle=/home/oracle/arch_61_1_879840714 tag=ARCH_ALL comment=NONE
channel orademo: backup set complete, elapsed time: 00:00:01
channel orademo: deleting archived log(s)
archived log file name=/orafile/arc/1_97_879804940.arc RECID=72 STAMP=879840713
Finished backup at 16-MAY-15
released channel: orademo
把新的备份集拷贝到目标服务器
[oracle@mxq ~]$ cd /home/oracle/
[oracle@mxq ~]$ ls
arch_59_1_879840531 arch_61_1_879840714 db_60_1_879840533
[oracle@mxq ~]$ ll
total 248900
-rw-r----- 1 oracle oinstall 219648 May 16 08:08 arch_59_1_879840531
-rw-r----- 1 oracle oinstall 1256448 May 16 08:11 arch_61_1_879840714
-rw-r----- 1 oracle oinstall 253394944 May 16 08:11 db_60_1_879840533
[oracle@mxq ~]$ scp * [email protected]:/home/oracle/
[email protected]'s password:
arch_59_1_879840531 100% 215KB 214.5KB/s 00:00
arch_61_1_879840714 100% 1227KB 1.2MB/s 00:00
db_60_1_879840533 100% 242MB 13.4MB/s 00:18
目标服务器
提示:
如果已经数据文件、控制文件、在线日志文件、参数文件那么新删除掉在进行做恢复不然后面报错
[oracle@mxq ~]$ rman target /
Recovery Manager: Release 11.2.0.2.0 - Production on Sun May 17 12:10:05 2015
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup force nomount;
Oracle instance started
Total System Global Area 521936896 bytes
Fixed Size 2228072 bytes
Variable Size 159383704 bytes
Database Buffers 352321536 bytes
Redo Buffers 8003584 bytes
RMAN> restore spfile from '/home/oracle/db_54_1_879855779';
Starting restore at 17-MAY-15
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
内容总结
以上是互联网集市为您收集整理的RMAN异机迁移实战操作-附加常用命令全部内容,希望文章能够帮你解决RMAN异机迁移实战操作-附加常用命令所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。