Rman recover 异机恢复

最新推荐文章于 2023-03-10 14:49:32 发布

cuigan6291

最新推荐文章于 2023-03-10 14:49:32 发布

阅读量99

点赞数

Rman 异机恢复步骤: < from Prod to UAT >
1.启动spfile;

< 我们需要把 Prod 数据库的pfile 文件，拷贝至 UAT 环境，然后更改adump,bdump,cdump,udump 的路径，如果这些路径不存在，需要创建。完成后，利用这个pfile 文件，启动UAT数据库之 nomount 状态。

startup nomount pfile='/oradata_uat6/udb007/Tony.pfile ' >

2.恢复备份片到指定目录;
rman target/
restore controlfile to '/oradata_uat6/udb007/oradata_d0/udb007/control01.ctl' from '/stage/rman/control_bak_20091220';
restore controlfile to '/oradata_uat6/udb007/oradata_d1/udb007/control02.ctl' from '/stage/rman/control_bak_20091220';
restore controlfile to '/oradata_uat6/udb007/oradata_d2/udb007/control03.ctl' from '/stage/rman/control_bak_20091220';

3. rman target/
      catalog start with '/stage/rman'; 放备份片的目录

run{
allocate channel c1 type disk;
allocate channel c2 type disk;
allocate channel c3 type disk;
allocate channel c4 type disk;
allocate channel c5 type disk;
allocate channel c6 type disk;
sql "alter session set nls_date_format=''yyyy.mm.dd hh24:mi:ss''";
set until time '2009.12.20 22:31:00'; // 恢复的时间点.
set newname for datafile 1 to '/oradata_uat6/udb007/oradata_d0/udb007/system01.dbf';
set newname for datafile 2 to '/oradata_uat6/udb007/oradata_d0/udb007/undotbs01.dbf';
set newname for datafile 3 to '/oradata_uat6/udb007/oradata_d0/udb007/sysaux01.dbf';
set newname for datafile 4 to '/oradata_uat6/udb007/oradata_d0/udb007/undotbs02.dbf';
set newname for datafile 5 to '/oradata_uat6/udb007/oradata_d0/udb007/users01.dbf';
set newname for datafile 6 to '/oradata_uat6/udb007/oradata_d0/udb007/symadm_user01.dbf';
set newname for datafile 7 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_user.dbf';
set newname for datafile 8 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_data01.dbf';
set newname for datafile 9 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_data02.dbf';
set newname for datafile 10 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_data03.dbf';
set newname for datafile 11 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_part_data01.dbf';
set newname for datafile 12 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_part_data02.dbf';
set newname for datafile 13 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_part_data03.dbf';
set newname for datafile 14 to '/oradata_uat6/udb007/oradata_d1/udb007/symadm_data01.dbf';
set newname for datafile 15 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_indx01.dbf';
set newname for datafile 16 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_indx02.dbf';
set newname for datafile 17 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_indx03.dbf';
set newname for datafile 18 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_part_indx01.dbf';
set newname for datafile 19 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_part_indx02.dbf';
set newname for datafile 20 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_part_indx03.dbf';
set newname for datafile 21 to '/oradata_uat6/udb007/oradata_d0/udb007/symadm_indx01.dbf';
set newname for datafile 22 to '/oradata_uat6/udb007/oradata_d0/udb007/undotbs06.dbf';
set newname for datafile 23 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_part_data04.dbf';
set newname for datafile 24 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_part_data05.dbf';
set newname for datafile 25 to '/oradata_uat6/udb007/oradata_d1/udb007/sysaux02.dbf';
set newname for datafile 26 to '/oradata_uat6/udb007/oradata_d0/udb007/system02.dbf';
set newname for datafile 27 to '/oradata_uat6/udb007/oradata_d0/udb007/undotbs04.dbf';
set newname for datafile 28 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_user01.dbf';
set newname for datafile 29 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_user02.dbf';
set newname for datafile 30 to '/oradata_uat6/udb007/oradata_d0/udb007/beacard_user01.dbf';
set newname for datafile 31 to '/oradata_uat6/udb007/oradata_d1/udb007/beacard_data01.dbf';
set newname for datafile 32 to '/oradata_uat6/udb007/oradata_d0/udb007/beacard_indx01.dbf';
set newname for datafile 33 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_user03.dbf';
set newname for datafile 34 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_user04.dbf';
set newname for datafile 35 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_user05.dbf';
set newname for datafile 36 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_user06.dbf';
set newname for datafile 37 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_data04.dbf';
set newname for datafile 38 to '/oradata_uat6/udb007/oradata_d0/udb007/sysaux03.dbf';
set newname for datafile 39 to '/oradata_uat6/udb007/oradata_d0/udb007/users02.dbf';
set newname for datafile 40 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_user07.dbf';
set newname for datafile 41 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_user08.dbf';
set newname for datafile 42 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_data05.dbf ';
set newname for datafile 43 to '/oradata_uat6/udb007/oradata_d0/udb007/users03.dbf';
set newname for datafile 44 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_indx04.dbf';
set newname for datafile 45 to '/oradata_uat6/udb007/oradata_d0/udb007/users04.dbf';
set newname for datafile 46 to '/oradata_uat6/udb007/oradata_d0/udb007/undotbs07.dbf';
set newname for datafile 47 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_indx05.dbf';
set newname for datafile 48 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_indx06.dbf';
set newname for datafile 49 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_part_data06.dbf';
set newname for datafile 50 to '/oradata_uat6/udb007/oradata_d1/udb007/users05.dbf';
set newname for datafile 51 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_indx07.dbf';
set newname for datafile 52 to '/oradata_uat6/udb007/oradata_d0/udb007/apps_i3.dbf';
set newname for datafile 53 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_indx08.dbf';
set newname for datafile 54 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_part_data07.dbf';
set newname for datafile 55 to '/oradata_uat6/udb007/oradata_d1/udb007/users06.dbf';
set newname for datafile 56 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_indx09.dbf';
set newname for datafile 57 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_indx10.dbf';
set newname for datafile 58 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_indx11.dbf';
set newname for datafile 59 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_indx12.dbf';
set newname for datafile 60 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_indx13.dbf';
set newname for datafile 61 to '/oradata_uat6/udb007/oradata_d1/udb007/users07.dbf';
set newname for datafile 62 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_part_data08.dbf';
set newname for datafile 63 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_part_data08.dbf';
set newname for datafile 64 to '/oradata_uat6/udb007/oradata_d0/udb007/users08.dbf';
set newname for datafile 65 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_data06.dbf ';
set newname for datafile 66 to '/oradata_uat6/udb007/oradata_d0/udb007/users09.dbf';
set newname for datafile 67 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_part_data09.dbf';
set newname for datafile 68 to '/oradata_uat6/udb007/oradata_d0/udb007/beacard_indx02.dbf';
set newname for datafile 69 to '/oradata_uat6/udb007/oradata_d1/udb007/beacard_data02.dbf';
set newname for datafile 70 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_user09.dbf';
set newname for datafile 71 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_user10.dbf';
set newname for datafile 72 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_indx13.dbf';
set newname for datafile 73 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_part_data10.dbf';
set newname for datafile 74 to '/oradata_uat6/udb007/oradata_d2/udb007/quest_tablespace3.dbf';
set newname for datafile 75 to '/oradata_uat6/udb007/oradata_d0/udb007/quest_tablespace1.dbf';
set newname for datafile 76 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_indx14.dbf';
set newname for datafile 77 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_user11.dbf';
set newname for datafile 78 to '/oradata_uat6/udb007/oradata_d2/udb007/beacard_indx03.dbf';
set newname for datafile 79 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_indx10.dbf';
set newname for datafile 80 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_part_data11.dbf';
set newname for datafile 81 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_indx15.dbf';
set newname for datafile 82 to '/oradata_uat6/udb007/oradata_d2/udb007/beacard_data03.dbf';
set newname for datafile 83 to '/oradata_uat6/udb007/oradata_d0/udb007/beacard_indx04.dbf';
set newname for datafile 84 to '/oradata_uat6/udb007/oradata_d1/udb007/beacard_indx05.dbf';
set newname for datafile 85 to '/oradata_uat6/udb007/oradata_d2/udb007/symbols_data07.dbf ';
set newname for datafile 86 to '/oradata_uat6/udb007/oradata_d0/udb007/symbols_data08.dbf ';
set newname for datafile 87 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_data09.dbf ';
set newname for datafile 88 to '/oradata_uat6/udb007/oradata_d0/udb007/beacard_data04.dbf';
set newname for datafile 89 to '/oradata_uat6/udb007/oradata_d1/udb007/symbols_user12.dbf';
restore database;
switch datafile all ;
recover database;
release channel c1;
release channel c2;
release channel c3;
release channel c4;
release channel c5;
release channel c6;
}

注:
catalog start with '/stage/rman'; 放备份片的目录
修改存放归档日志的目录;
resotre 和recover两者不可分开恢复,否则出错;

+++++++++++++++++++++++++++++++++++++++++++++++

完成数据库 restored and recovered ，还需要下列步骤：

1. re-create TEMP tablespace.

2. re-create redo logfiles.

3. change sga or pga if needed.

4. change db_name or SID name if needed.

-----.更改db_name
export ORACLE_SID=uweb001
SQL:> startup mount
SQL:> host nid target=/ dbname=uweb;
exit
SQL:> shutdown immediate
SQL:> startup mount
SQL:> alter system set db_name='uweb' scope=spfile;
SQL:> shutdown immediate
SQL:> startup mount
SQL:> alter database open resetlogs;
SQL:> select DBID,name from v$database;

       DBID          NAME
      ---------- ------------------
      3593636551     UWEB