--1.根据pfile创建目录
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/admin/rac11g/adump
mkdir -p /u01/app/oracle/oradata/DBSRV/
mkdir -p /u01/app/oracle/fast_recovery_area/DBSRV/
mkdir -p /oracle/oradata/rac11g/data
mkdir -p /oracle/oradata/rac11g/recovery
mkdir -p /oracle/oradata/rac11g/arch
restore controlfile from '/data/rmanbk/control_RAC11G_20190912_fcubjqfr_1_1.bak';
--2.注册rman备份集
catalog start with '/data/rmanbk/db_RAC11G_20190912_f4ubirjl_1_1.bak';
catalog start with '/data/rmanbk/arch_RAC11G_20190912_fbubjpn9_1_1.bak';
catalog start with '/data/rmanbk/arch_RAC11G_20190912_f7ubjj1j_1_1.bak';
catalog start with '/data/rmanbk/arch_RAC11G_20190912_f6ubjgle_1_1.bak';
catalog start with '/data/rmanbk/';
--2.1查看rman备份集是否注册成功
list backup;
--3.根据源库数据库文件名称更改目标库地址
select * from dba_data_files t order by t.file_id asc;
RMAN>
run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
set newname for datafile 1 to '/oracle/oradata/rac11g/data/System01.dbf';
我的内容管理
展开
