RMAN异机迁移数据库.docx

1、 旧数据库备份文件查看force_logging信息，该参数在数据库全备前设为YESSQL select force_logging from v$database;如为NO，则修改为YESSQL alter database force logging;RMAN备份脚本runallocate channel c1 type disk;allocate channel c2 type disk;backup database format /home/oracle/rman/full_%d_%T_%s_%p;sql alter system archive log current;backup archivelog all format /home/oracle/rman/arch_%d_%T_%s_%p delete input;backup current controlfile format /home/oracle/rman/controlfile_%d_%T_%s_%p;全库备份$ rman target / nocatalog cmdfile=rman.sql log=rman.log &$ tail -f rman.log根据RMAN日志记录归档序号时间，例如Startingbackupat20-JAN-201512:42:33Finishedbackupat20-JAN-201512:44:18 查看归档序号，记录全备开始前时间点的最后一个序号，和全备完成时的第一个序号，如SQL select THREAD#, SEQUENCE# ,to_char(FIRST_TIME,yyyymmddhh24:mi),to_char(COMPLETION_TIME,yyyymmdd hh24:mi) from v$archived_log order by FIRST_TIME;由结果可得，全备开始前最后一个归档序号为13，全备完成的第一个序号为14，记录线程1的归档序号范围为13-14，如存在多个线程，记录方法类似创建原数据库的PFILE文件SQL create pfile=/oracle/pfile20150120.ora from spfile;将备份集与参数文件复制到目标数据库的相同目录下$scp fullbak/* 192.168.6.22:/home/oracle/fullbak/$scp /oracle/pfile20150120.ora 192.168.6.22:/oracle/2、 新数据库恢复为了恢复数据库，在新数据库上拷贝得到的pfile参数文件需要添加*.local_listener=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=ip)，此处的ip就是oracle数据库所在服务器的ip否则会出现下图错误使用pfile文件启动数据库SQL startup nomount pfile=/oracle/pfile20150120.ora;恢复控制文件RMAN restore controlfile from /home/oracle/fullbak/controlfile_UP_20150120_15_1;MOUNT数据库SQL alter database mount;编写RMAN恢复脚本，如下oracledstdb:/home/oracle$more restore_database.sh 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 datafile 1 to /oracle/app/oracle/oradata/up/system02.dbf;set newname for datafile 2 to /oracle/app/oracle/oradata/up/sysaux02.dbf;set newname for datafile 3 to /oracle/app/oracle/oradata/up/undotbs02.dbf;set newname for datafile 4 to /oracle/app/oracle/oradata/up/users01.dbf;set newname for datafile 5 to /oracle/app/oracle/oradata/up/users03.dbf;set newname for datafile 6 to /oracle/app/oracle/oradata/up/users04.dbf;set newname for datafile 7 to /dev/raw/raw2;restore database; switch datafile all; release channel c1; release channel c2; release channel c3; release channel c4; 执行恢复脚本restore_database.sh$rman target / nocatalog cmdfile=restore_database.sh log=restore_database.log &$ tail -f restore_database.log编写归档日志恢复脚本restore_archive.sh由于源数据库记录的归档序列号为13-14，因此脚本如下$cat restore_archive.sh runallocate channel c1 device type disk;allocate channel c2 device type disk;allocate channel c3 device type disk;allocate channel c4 device type disk;restore archivelog from sequence 13 until sequence 14 thread 1;release channel c1;release channel c2;release channel c3;release channel c4;执行归档日志恢复脚本restore_archive.sh$ rman target / nocatalog cmdfile=restore_archive.sh log=restore_archive.log &$ tail -f restore_archive.log应用归档日志完成数据库的恢复与数据库全备期间的归档恢复后，进行归档的应用，确保数据库在mount状态$ sqlplus / as sysdbaSQLrecover database using backup controlfile until cancel;完成归档应用后，完成后输入cancel退出根据需求，重命名临时数据文件，脚本如下$cat resetname.sh run set newname for tempfile 1 to /oracle/app/oracle/oradata/up/temp02.dbf;switch tempfile all;执行重命名临时数据文件脚本$ rman target / nocatalog cmdfile=resetname.sh log=resetname.log &$ tail -f resetname.log恢复redo log文件在旧系统查看redo文件信息$ sqlplus / as sysdbaSQL set line 200 pagesize 200SQL col member format a60SQL select group#,member from v$logfile;在新系统上进行重命名redo文件确保新数据库处于mount状态下，在SQL窗口下对redo log进行修改：SQL alter database rename file /oracle/app/oracle/oradata/up/redo03.log to /oracle/app/oracle/oradata/up/redo07.log;SQL alter database rename file /oracle/app/oracle/oradata/up/redo02.log to /oracle/app/oracle/oradata/up/redo08.log;SQL alter database rename file /oracle/app/oracle/oradata/up/redo01.log to /oracle/app/oracle/oradata/up/redo09.log;3、 追归档由于在备份和恢复数据库的过程需要时间，但旧数据库依旧在运行。因此需要重新备份旧数据库在全备之后的归档，并恢复到新数据库中3.1、 旧数据库备份归档文件、控制文件和参数文件RMAN sql alter system archive log current;RMAN backup archivelog all format /home/oracle/fullbak/arch_%d_%T_%s_%p delete input;RMAN backup current controlfile format /home/oracle/rman/controlfile_%d_%T_%s_%p;SQL create pfile=/oracle/pfile20150120_1.ora from spfile;查看归档序号，记录全备完成时的第二个序号，和本次归档备份完成后的第一序号，如SQL select THREAD#, SEQUENCE# ,to_char(FIRST_TIME,yyyymmddhh24:mi),to_char(COMPLETION_TIME,yyyymmdd hh24:mi) from v$archived_log order by FIRST_TIME;第一次备份恢复是归档序号已到14，那么本来恢复的归档序号往下类推，即为15-17将备份数据拷到新数据库中$scp /oracle/pfile20150120_1.ora 192.168.6.22:/oracle/$scp /home/oracle/fullbak/arch_UP_20150120_16_1 192.168.6.22:/home/oracle/fullbak/3.2、 新数据库编写归档恢复文件$cat restore_archive_01.sh runallocate channel c1 device type disk;allocate channel c2 device type disk;allocate channel c3 device type disk;allocate channel c4 device type disk;restore archivelog from sequence 15 until sequence 17 thread 1;release channel c1;release channel c2;release channel c3;release channel c4;使用pfile文件启动数据库到mount（参数文件需添加一行参数，参见新数据库恢复）SQL shutdown immediate;SQL startup mount pfile=/oracle/pfile20150120_1.ora;往控制文件中添加最新的备份集RMAN CATALOG BACKUPPIECE /home/oracle/rman/arch_UP_20150120_16_1;执行归档日志恢复脚本restore_archive.sh$ rman target / nocatalog cmdfile=restore_archive_01.sh log=restore_archive_01.log &$ tail -f restore_archive_01.log使用旧的参数文件，应用归档日志进行归档的应用时，必须用数据库恢复时的参数文件引导，不可直接用新的参数文件，确保数据库在mount状态SQL shutdown immediate;SQL startup mount pfile=/oracle/pfile20150120.ora; （恢复时的参数文件）SQL recover database using backup controlfile u