#### rman 手动备份脚本rman msglog /home/oracle/adg_setup.log << EOF
connect target
RUN {
allocate channel c1 device type disk;
allocate channel c2 device type disk;
allocate channel c3 device type disk;
allocate channel c4 device type disk;
backup full database format '/rman/bak/tmp/bak_%U_%s_%T.db';
release channel c1;
release channel c2;
release channel c3;
release channel c4;
sql 'alter system archive log current';
allocate channel d1 type disk MAXPIECESIZE = 4G;
allocate channel d2 device type disk;
backup archivelog all format='/rman/bak/tmp/arc_%d_%s_%p.bak' ;
release channel d1;
release channel d2;
allocate channel d3 device type disk;
backup current controlfile for standby format '/rman/bak/tmp/bak_%U_%s_%T.ctl';
release channel d3;
}
exit;EOF
###RMAN restroe 恢复脚本：
#####需要配置 DB_CREATE_FILE_DEST 参数：
批量生成set newname 命令：
select 'set newname for datafile '||file#||' to NEW;' from v$datafile;
-- select 'set newname for datafile '||file#||' to /newpath/NEW;' from v$datafile;rman msglog /home/oracle/adg_setup_restore.log << EOF
connect target
run {
allocate channel ch001 type disk;
allocate channel ch002 type disk;
allocate channel ch003 type disk;
allocate channel ch004 type disk;set newname for datafile 1 to NEW;
set newname for datafile 2 to NEW;
set newname for datafile 3 to NEW;
set newname for datafile 4 to NEW;
set newname for datafile 5 to NEW;
set newname for datafile 6 to NEW;
set newname for datafile 7 to NEW;
set newname for datafile 8 to NEW;
set newname for datafile 9 to NEW;
set newname for datafile 10 to NEW;
set newname for datafile 11 to NEW;
set newname for datafile 12 to NEW;
set newname for datafile 13 to NEW;
set newname for datafile 14 to NEW;
set newname for datafile 15 to NEW;
set newname for datafile 16 to NEW;
set newname for datafile 17 to NEW;
set newname for datafile 18 to NEW;
set newname for datafile 19 to NEW;
set newname for datafile 20 to NEW;
set newname for datafile 21 to NEW;
set newname for datafile 22 to NEW;
set newname for datafile 23 to NEW;
set newname for datafile 24 to NEW;
set newname for datafile 25 to NEW;
set newname for datafile 26 to NEW;
set newname for datafile 27 to NEW;
set newname for datafile 28 to NEW;
set newname for datafile 29 to NEW;
set newname for datafile 30 to NEW;
set newname for datafile 31 to NEW;
set newname for datafile 32 to NEW;
set newname for datafile 33 to NEW;
set newname for datafile 34 to NEW;
set newname for datafile 35 to NEW;
set newname for datafile 36 to NEW;
set newname for datafile 37 to NEW;
set newname for datafile 38 to NEW;
set newname for datafile 39 to NEW;
set newname for datafile 40 to NEW;
set newname for datafile 41 to NEW;
set newname for datafile 42 to NEW;
set newname for datafile 43 to NEW;
set newname for datafile 44 to NEW;
set newname for datafile 45 to NEW;
set newname for datafile 46 to NEW;
set newname for datafile 47 to NEW;
set newname for datafile 48 to NEW;
set newname for datafile 49 to NEW;
set newname for datafile 50 to NEW;
set newname for datafile 51 to NEW;
set newname for datafile 52 to NEW;
set newname for datafile 53 to NEW;
set newname for datafile 54 to NEW;
set newname for datafile 55 to NEW;
set newname for datafile 56 to NEW;
set newname for datafile 57 to NEW;
set newname for datafile 58 to NEW;
set newname for datafile 59 to NEW;
set newname for datafile 60 to NEW;
set newname for datafile 61 to NEW;
set newname for datafile 62 to NEW;
set newname for datafile 63 to NEW;
set newname for datafile 64 to NEW;
set newname for datafile 65 to NEW;
set newname for datafile 66 to NEW;
set newname for datafile 67 to NEW;
set newname for datafile 68 to NEW;
set newname for datafile 69 to NEW;
set newname for datafile 70 to NEW;
set newname for datafile 71 to NEW;
set newname for datafile 72 to NEW;
set newname for datafile 73 to NEW;
set newname for datafile 74 to NEW;
set newname for datafile 75 to NEW;
set newname for datafile 76 to NEW;
set newname for datafile 77 to NEW;
set newname for datafile 78 to NEW;
set newname for datafile 79 to NEW;
set newname for datafile 80 to NEW;
set newname for datafile 81 to NEW;
set newname for datafile 82 to NEW;
set newname for datafile 83 to NEW;
set newname for datafile 84 to NEW;
set newname for datafile 85 to NEW;
set newname for datafile 86 to NEW;
set newname for datafile 87 to NEW;
set newname for datafile 88 to NEW;
set newname for datafile 89 to NEW;
set newname for datafile 90 to NEW;
set newname for datafile 91 to NEW;
set newname for datafile 92 to NEW;
set newname for datafile 93 to NEW;
set newname for datafile 94 to NEW;
set newname for datafile 95 to NEW;
set newname for datafile 96 to NEW;
set newname for datafile 97 to NEW;
set newname for datafile 98 to NEW;
set newname for datafile 99 to NEW;
set newname for datafile 100 to NEW;
set newname for datafile 101 to NEW;
set newname for datafile 102 to NEW;
set newname for datafile 103 to NEW;
set newname for datafile 104 to NEW;set newname for tempfile 1 to NEW;
set newname for tempfile 2 to NEW;
set newname for tempfile 3 to NEW;
restore database;
switch datafile all;
switch tempfile all;release channel ch001;
release channel ch002;
release channel ch003;
release channel ch004;
}
EOF