Linux 6.4平台利用RMAN迁移Oracle 11g R2数据库

Linux 6.4平台利用RMAN迁移Oracle 11g R2数据库

测试环境分别在虚拟机安装a,b主机
系统：linux 6.4，
数据库：oracle 11g r2
a主机：安装oracle 11g r2数据库
b主机：只安装oracle 11g r2软件

第一步，运行下面rman命令备份数据库
run{
configure controlfile autobackup on;
configure controlfile autobackup format for device type disk to '/u01/app/dbback/config_%f';
allocate channel c1 type disk format '/u01/app/dbback/full_%u';
backup database tag 'full_gpodb_data' filesperset 10 plus archivelog filesperset 20 delete all input;
release channel c1;
}


[root@bogon ~]# su - oracle
[oracle@bogon ~]$ rman target /

recovery manager: release 11.2.0.1.0 - production on sat oct 26 05:16:55 2013

copyright (c) 1982, 2009, oracle and/or its affiliates. all rights reserved.

connected to target database: db (dbid=1587060738) ------------记住这个dbid恢复数据库会用到
rman> run{
2> configure controlfile autobackup on;
3> configure controlfile autobackup format for device type disk to '/u01/app/dbback/config_%f';
4> allocate channel c1 type disk format '/u01/app/dbback/full_%u';
5> backup database tag 'full_gpodb_data' filesperset 10 plus archivelog filesperset 20 delete all input;
6> release channel c1;
7> }

old rman configuration parameters:
configure controlfile autobackup on;
new rman configuration parameters:
configure controlfile autobackup on;
new rman configuration parameters are successfully stored

old rman configuration parameters:
configure controlfile autobackup format for device type disk to '/u01/app/dbback/gpofullbak/%f';
new rman configuration parameters:
configure controlfile autobackup format for device type disk to '/u01/app/dbback/config_%f';
new rman configuration parameters are successfully stored

allocated channel: c1
channel c1: sid=47 device type=disk


starting backup at 26-oct-13
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=21 recid=12 stamp=829805117
channel c1: starting piece 1 at 26-oct-13
channel c1: finished piece 1 at 26-oct-13
piece handle=/u01/app/dbback/full_08onbkhu_1_1 tag=tag20131026t052518 comment=none
channel c1: backup set complete, elapsed time: 00:00:01
channel c1: deleting archived log(s)
archived log file name=/u01/app/archiv/1_21_823244933.dbf recid=12 stamp=829805117
finished backup at 26-oct-13

starting backup at 26-oct-13
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00001 name=/u01/app/oracle/oradata/db/system01.dbf
input datafile file number=00002 name=/u01/app/oracle/oradata/db/sysaux01.dbf
input datafile file number=00005 name=/u01/app/oracle/oradata/db/anfei01.dbf
input datafile file number=00003 name=/u01/app/oracle/oradata/db/undotbs01.dbf
input datafile file number=00006 name=/u01/app/oracle/oradata/db/db/datafile/o1_mf_dbs_91x4vt9f_.dbf
input datafile file number=00007 name=/u01/app/oracle/oradata/db/dbt.dbf
input datafile file number=00004 name=/u01/app/oracle/oradata/db/users01.dbf
channel c1: starting piece 1 at 26-oct-13
channel c1: finished piece 1 at 26-oct-13
piece handle=/u01/app/dbback/full_09onbkhv_1_1 tag=full_gpodb_data comment=none
channel c1: backup set complete, elapsed time: 00:01:36
finished backup at 26-oct-13

starting backup at 26-oct-13
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=22 recid=13 stamp=829805216
channel c1: starting piece 1 at 26-oct-13
channel c1: finished piece 1 at 26-oct-13
piece handle=/u01/app/dbback/full_0aonbkl1_1_1 tag=tag20131026t052657 comment=none
channel c1: backup set complete, elapsed time: 00:00:01
channel c1: deleting archived log(s)
archived log file name=/u01/app/archiv/1_22_823244933.dbf recid=13 stamp=829805216
finished backup at 26-oct-13

starting control file and spfile autobackup at 26-oct-13
piece handle=/u01/app/dbback/config_c-1587060738-20131026-01 comment=none
finished control file and spfile autobackup at 26-oct-13

released channel: c1

rman>

更多详情见请继续阅读下一页的精彩内容：

Oracle基础教程之通过RMAN复制数据库

RMAN备份策略制定参考内容

Tana

“节点式”AI智能笔记工具，支持超级标签。

80

查看详情

RMAN备份学习笔记

Oracle数据库备份加密 RMAN加密