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

2014-11-24 18:54:47 · 作者: · 浏览: 2

源服务器


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


[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