当前位置:  数据库>oracle

同系统Oracle RMAN 异机数据库移植,Oracle RMAN 备份和恢复详解

    来源: 互联网  发布时间:2017-04-28

    本文导语: 环境:源服务器: VM7.14 rhel5.5-32 Oracle 11.2.0.0g 172.16.3.202目标服务器 VM7.14 rhel5.5-32 oracle 11.2.0.0g 172.16.3.204 源服务器 一、在数据库中加入验证表和数据:  [oracle@ebs01 ~]$ sqlplus "/as sysdba"  SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 10 1...

环境:
源服务器:
 VM7.14 rhel5.5-32 Oracle 11.2.0.0g
 172.16.3.202
目标服务器
 VM7.14 rhel5.5-32 oracle 11.2.0.0g
 172.16.3.204





源服务器

一、在数据库中加入验证表和数据:

 [oracle@ebs01 ~]$ sqlplus "/as sysdba"

 SQL*Plus: Release 11.2.0.1.0 Production on Sun Jun 10 13:09:43 2012

 Copyright (c) 1982, 2009, Oracle.  All rights reserved.


 Connected to:
 Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
 With the Partitioning, OLAP, Data Mining and Real Application Testing options


 SQL> create table addr1(city varchar(20),phone number);

 Table created.
 SQL> insert into addr1 values('beijing',1580118);

 1 row created.
 SQL> insert into addr1 values('shanghai',1501005);

 1 row created.
 SQL> insert into addr1 values('nanjing',1598888);

 1 row created.

 SQL> commit;

 Commit complete.

 SQL> select * from addr;

 CITY                      PHONE
 -------------------- ----------
 beijing              1.5801E+10
 shanghai             1.5010E+10
 nanjing              1.5988E+10



二、清空备份目录,或者新建一个都行,并备份必要文件。

 [oracle@ebs01 ~]$ cd /u01/backup
 [oracle@ebs01 backup]$ rm *

1)开始备份,备份数据文件连同归档日志:

 [oracle@ebs01 backup]$ rman target /

 Recovery Manager: Release 11.2.0.1.0 - Production on Mon Jun 11 09:16:52 2012

 Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

 connected to target database: ORCL (DBID=1290854593)

 RMAN>   run {          
  allocate channel c1 device type disk;      
  allocate channel c2 device type disk;
  backup incremental level 0        
  format '/u01/backup/db_full_%U.bkp'        
  tag '2012-06-11-FULL'      
  database plus archivelog;      
  release channel c1;      
  release channel c2;
  } 2> 3> 4> 5> 6> 7> 8> 9> 10>








 using target database control file instead of recovery catalog
 allocated channel: c1
 channel c1: SID=41 device type=DISK

 allocated channel: c2
 channel c2: SID=28 device type=DISK


 Starting backup at 11-JUN-12
 current log archived
 channel c1: starting archived log backup set
 channel c1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=19 RECID=1 STAMP=784809253
 input archived log thread=1 sequence=20 RECID=2 STAMP=784809551
 input archived log thread=1 sequence=21 RECID=3 STAMP=785592038
 channel c1: starting piece 1 at 11-JUN-12
 channel c2: starting archived log backup set
 channel c2: specifying archived log(s) in backup set
 input archived log thread=1 sequence=22 RECID=4 STAMP=785592147
 input archived log thread=1 sequence=23 RECID=5 STAMP=785595880
 channel c2: starting piece 1 at 11-JUN-12
 channel c1: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/db_full_0mnd8mo1_1_1.bkp tag=2012-06-11-FULL comment=NONE
 channel c1: backup set complete, elapsed time: 00:00:08
 channel c1: starting archived log backup set
 channel c1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=24 RECID=6 STAMP=785668864
 channel c1: starting piece 1 at 11-JUN-12
 channel c2: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/db_full_0nnd8mo1_1_1.bkp tag=2012-06-11-FULL comment=NONE
 channel c2: backup set complete, elapsed time: 00:00:08
 channel c1: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/db_full_0ond8mo9_1_1.bkp tag=2012-06-11-FULL comment=NONE
 channel c1: backup set complete, elapsed time: 00:00:01
 Finished backup at 11-JUN-12


























 Starting backup at 11-JUN-12
 channel c1: starting incremental level 0 datafile backup set
 channel c1: specifying datafile(s) in backup set
 input datafile file number=00001 name=/u01/app/oracle/oradata/orcl/system01.dbf
 input datafile file number=00005 name=/u01/app/oracle/oradata/orcl/example01.dbf
 channel c1: starting piece 1 at 11-JUN-12
 channel c2: starting incremental level 0 datafile backup set
 channel c2: specifying datafile(s) in backup set
 input datafile file number=00002 name=/u01/app/oracle/oradata/orcl/sysaux01.dbf
 input datafile file number=00003 name=/u01/app/oracle/oradata/orcl/undotbs01.dbf
 input datafile file number=00004 name=/u01/app/oracle/oradata/orcl/users01.dbf
 channel c2: starting piece 1 at 11-JUN-12
 channel c2: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/db_full_0qnd8mob_1_1.bkp tag=2012-06-11-FULL comment=NONE
 channel c2: backup set complete, elapsed time: 00:00:56
 channel c2: starting incremental level 0 datafile backup set
 channel c2: specifying datafile(s) in backup set
 including current control file in backup set
 channel c2: starting piece 1 at 11-JUN-12
 channel c2: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/db_full_0rnd8mq4_1_1.bkp tag=2012-06-11-FULL comment=NONE
 channel c2: backup set complete, elapsed time: 00:00:09
 channel c2: starting incremental level 0 datafile backup set
 channel c2: specifying datafile(s) in backup set
 including current SPFILE in backup set
 channel c2: starting piece 1 at 11-JUN-12
 channel c2: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/db_full_0snd8mqs_1_1.bkp tag=2012-06-11-FULL comment=NONE
 channel c2: backup set complete, elapsed time: 00:00:07
 channel c1: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/db_full_0pnd8mob_1_1.bkp tag=2012-06-11-FULL comment=NONE
 channel c1: backup set complete, elapsed time: 00:01:48
 Finished backup at 11-JUN-12































 Starting backup at 11-JUN-12
 current log archived
 channel c1: starting archived log backup set
 channel c1: specifying archived log(s) in backup set
 input archived log thread=1 sequence=25 RECID=7 STAMP=785668983
 channel c1: starting piece 1 at 11-JUN-12
 channel c1: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/db_full_0tnd8mro_1_1.bkp tag=2012-06-11-FULL comment=NONE
 channel c1: backup set complete, elapsed time: 00:00:01
 Finished backup at 11-JUN-12








 released channel: c1

 released channel: c2
2)备份当前控制文件:
 RMAN> backup current controlfile format '/u01/backup/controlfile20120611.bak';

 Starting backup at 11-JUN-12
 allocated channel: ORA_DISK_1
 channel ORA_DISK_1: SID=41 device type=DISK
 channel ORA_DISK_1: starting full datafile backup set
 channel ORA_DISK_1: specifying datafile(s) in backup set
 including current control file in backup set
 channel ORA_DISK_1: starting piece 1 at 11-JUN-12
 channel ORA_DISK_1: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/controlfile20120611.bak tag=TAG20120611T093224 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
 Finished backup at 11-JUN-12
3)备份参数文件
 RMAN> backup spfile format '/u01/backup/spfile20120611.bak';











 Starting backup at 11-JUN-12
 using channel ORA_DISK_1
 channel ORA_DISK_1: starting full datafile backup set
 channel ORA_DISK_1: specifying datafile(s) in backup set
 including current SPFILE in backup set
 channel ORA_DISK_1: starting piece 1 at 11-JUN-12
 channel ORA_DISK_1: finished piece 1 at 11-JUN-12
 piece handle=/u01/backup/spfile20120611.bak tag=TAG20120611T093402 comment=NONE
 channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
 Finished backup at 11-JUN-12








 RMAN>


    
 
 

您可能感兴趣的文章:

  • 如何将Aix上的oracle 物理备份 然后再在linux 系统上还原oracle
  • Linux系统下Oracle的启动与Oracle监听的启动
  • Linux系统下利用java连接Oracle 10G
  • 系统移植,让程序拷过去就可以用 iis7站长之家
  • Oracle终于涉入支持Linux操作系统了
  • 关于系统重装后Oracle数据库完全恢复的解决办法
  • Linux(Oracle系统在上面)系统无缘无故死机 , 可能是由于应用程序引起 , 可是由于重新启动查不到相关信息 , 不知道在哪里有记录系统CPU Lo
  • Oracle 系统变量函数介绍
  • Linux系统查看Oracle服务是否启动
  • 第一块硬盘把第二块UNIX的开发系统及ORACLE拷贝下来吗?
  • Linux系统下查看oracle SID的方法
  • Linux系统下安装Oracle X11错误解决办法
  • Linux系统下创建第二个oracle数据库
  • 重启linux系统,oracle监听服务起不来
  • oracle+jsp 多用户查询系统讨论:
  • radhat8.0系统下oracle9i安装问题
  • Oracle 系统变量函数用法指南
  • 怎样把solaris系统下oracle数据导入access中??请教!!急~
  • Unix系统下oracle sql排版
  • Oracle数据库在NT平台下的系统优化思路与策略
  •  
    本站(WWW.)旨在分享和传播互联网科技相关的资讯和技术,将尽最大努力为读者提供更好的信息聚合和浏览方式。
    本站(WWW.)站内文章除注明原创外,均为转载、整理或搜集自网络。欢迎任何形式的转载,转载请注明出处。












  • 相关文章推荐
  • 请大家帮忙提供资料:如何将windows系统服务程序移植为linux系统服务?
  • UNIX系统下的C程序移植到Linux系统的问题
  • 中文问题:我使用的是MEPIS Linux,系统不能显示中文,我能不能把Redhat中的中文字体移植到这个系统中?
  • 系统移植用英语怎么说
  • 基于skyeye的ucosii系统的移植
  • 涉及到系统头文件的库移植问题
  • 系统移植的时候遇到了困难
  • 系统移植,让程序拷过去就可以用
  • 系统移植:从IBM到HP???
  • 关于从Redhat 上移植程序到嵌入式是系统上的问题
  • 如何将linux中部分代码移植到非操作系统中
  • 为什么ARM下linux移植那么多,但是手机却没有用linux操作系统?
  • 把Win平台的服务端移植到Linux,开发测试用哪个系统比较好?
  • 我在windows下把1.c编译成1.exe可以执行,请问我把1.exe拷贝到unix系统能否执行?怎样移植?
  • 关于系统移植出现的问题hp-unix->linux
  • 关于Mozilla向嵌入式系统移植的问题
  • 不安装ORACLE客户端的系统移植方法
  • 一般单片机的系统是linux的什么版本?是怎样移植进去的?
  • 请教 文件系统/proc移植
  • busybox移植的根文件系统,为什么/dev下没有eth0设备?
  • mount命令(linux操作系统)挂载卸载文件系统(cifs,光驱,nfs等)方法介绍
  • 问一个系统配置的问题:win2k系统能不能于SCO UNIX系统共存?
  • win7/Windows7系统下载地址搜集整理
  • unix下用java.util.Date取系统时间比直接在系统下用date命令查看系统时间早整整一个小时
  • Ubuntu查看系统信息命令介绍
  • windows 系统是否是多用户操作系统,如何理解“多用户操作系统”的“多用户”?
  • python下用os.execl执行centos下的系统时间同步命令ntpdate
  • 我现在想做一个权限管理系统,想让权限系统的利用性更强,我应该怎样设计权限系统呢.
  • 怎样重装win7系统?win7重装系统步骤详细图文介绍
  • 谁知道哪里有用java开发的管理信息系统软件(如:图书馆管理系统,人事部管理系统)的代码?
  • windows server2008上PowerBuilder程序系统错误解决方法


  • 站内导航:


    特别声明:169IT网站部分信息来自互联网,如果侵犯您的权利,请及时告知,本站将立即删除!

    ©2012-2021,