Oracle之rman异机恢复实施方案(不完全恢复)

在用rman进行异机恢复是，数据库版本要一致，操作系统版本必须统一平台。rman target / cmdfile="/u01/rman/rmanfull.sql"   log=/u01/rman/backuplog_$DATE <<eof  一、备份脚本：   run { crosscheck archivelog all; crosscheck  backup; delete noprompt obsolete;  delete noprompt expired backup; backup format '/u01/bkdata/%T_%d_%s_%p_%u.dat'  database ;           backup format '/u01/bkarch/%T_%d_%s_%p_%u.arc' archivelog all ;    backup format '/u01/bkdata/%T_%d_%s_%p_%u.ctl' current controlfile;  release channel d1; release channel d2; }  备份归档文件脚本 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 format  '/u01/bkarch/%T_%d_%s_%p_%u.arc'  archivelog all delete all input;  release channel c1; release channel c2; release channel c3; release channel c4; }  二、sftp到异机 sftp -P 30001 oracle@192.168.137.103 三、恢复控制文件 在恢复控制文件前把源库的参数文件及密码文件copy到目标库上 （create spfile from pfile；）  在目标库执行如下：  export ORACLE_SID=orclsid rman target / startup nomount; restore controlfile from '/u01/bkdata/fulldb_ORCL_20240820_27172_1.ctl'; alter database mount; } 四、恢复数据库    4.1注册备份集    RMAN>catalog start with '/u01/app/rmanbak';   4.2恢复数据文件及临时文件 rman target / log=/u01/app/log/restore1log_$DATE <<eof 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; set newname for database to '/%b'; restore database; switch datafile all; switch tempfile all; release channel c1; release channel c2; release channel c3; release channel c4; } eof 五、追加归档 nohup rman target / @/u01/app/scripts/rmanarch.sql log=/u01/app/scripts/log/recoarc.log run{  restore archivelog from logseq 5122 until logseq  ; recover database; } 六、修改redo 日志文件文件的路径 在源库上 sqlplus / as sysdba  set line 160 set pagesize 200 select 'alter database rename file '''||member||''' to ''/u01/oradata'||substr(member,instr(member,'/',-1))||''';'  七、关闭数据库开启目标库 sqlplus / as sysdba  alter database open resetlogs;