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

数据库|mysql教程

Oracle存储过程,同系统Oracle RMAN 异机数据

数据库-mysql教程

java订餐系统源码,ubuntu退出vi命令,tomcat报错是日文吗,快手爬虫hook,php 引流软件源码,越秀区一站式seo优化哪家好lzw

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

建行来源码,群晖 挂载 ubuntu,艾瑞爬虫系统,php restart,怎么收集seolzw

展示电影网站源码,ubuntu麒麟和xp,js实现提交 爬虫,saemysql php,商丘seo外包lzw

环境：

源服务器：

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

源服务器

A、在数据库中加入验证表和数据：

[oracle@ebs01 ~]$ sqlplus “/as sysdba”

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

Copyright (c) 1982, , 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;

CITYPHONE

——————– ———-

beijing 1.5801E+10

shanghai 1.5010E+10

nanjing 1.5988E+10

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

[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

Copyright (c) 1982, , 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 ‘-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=-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=-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=-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=-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=-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=-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=-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=-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/controlfile0611.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/controlfile0611.bak tag=TAG0611T093224 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/spfile0611.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/spfile0611.bak tag=TAG0611T093402 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01

Finished backup at 11-JUN-12

RMAN>

，