> 데이터 베이스 > MySQL 튜토리얼 > 同系统Oracle RMAN 异机数据库移植,Oracle RMAN 备份和恢复详解

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

WBOY
풀어 주다: 2016-06-07 17:14:39
원래의
1161명이 탐색했습니다.

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

环境:
源服务器:
 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>

linux

원천:php.cn
본 웹사이트의 성명
본 글의 내용은 네티즌들의 자발적인 기여로 작성되었으며, 저작권은 원저작자에게 있습니다. 본 사이트는 이에 상응하는 법적 책임을 지지 않습니다. 표절이나 침해가 의심되는 콘텐츠를 발견한 경우 admin@php.cn으로 문의하세요.
최신 이슈
인기 튜토리얼
더>
최신 다운로드
더>
웹 효과
웹사이트 소스 코드
웹사이트 자료
프론트엔드 템플릿