Oracle10g RAC环境Rman备份恢复至单机oracle10g方案.doc

Oracle 10g RAC环境Rman备份恢复至单机oracle10g方案说明：使用于oracle 10g ,备份环境是RAC，但是恢复目的环境是单机。l 创建与rac主机相同的目录如/backup/rmanbak/level0/20120209010001/4都是在压缩包所在的目录下tar -cvf oracle0208.tar oracle tar -xvf oracle0113.tarl 传输rac上的备份集到单机上节点2上的备份包含数据文件及归档 的备份集scp dblv0_731_1_774752412 root6:/backup/rmanbak/level0/20120209010001/4scp dblv0_732_1_774752412 root6:/backup/rmanbak/level0/20120209010001/4scp dblv0_733_1_774755639 root6:/backup/rmanbak/level0/20120209010001/4过程如下： 文件大致需要传输6分钟节点1上传输控制文件的备份在（注意不是节点2上 的控制文件的备份）测试机上接收到的备份集注意更改这些文件的属性 chown -R oracle:dba *l 测试机上创建pfile及相关目录*.audit_file_dest=/app/oracle/admin/orcl/adump*.background_dump_dest=/app/oracle/admin/orcl/bdump*.compatible=.0*.control_files=/oradata/orcl/controlfile1.ctl,/oradata/orcl/controlfile2.ctl,/oradata/orcl/controlfile3.ctl*.core_dump_dest=/app/oracle/admin/orcl/cdump*.db_block_size=8192*.db_domain=*.db_file_multiblock_read_count=16*.db_name=orcl*.dispatchers=(PROTOCOL=TCP) (SERVICE=ORCLDB)*.job_queue_processes=10*.log_archive_dest_1=LOCATION=/archive/orcl*.log_archive_format=%t_%s_%r.dbf*.open_cursors=1000*.pga_aggregate_target=2205838336*.processes=1500*.remote_login_passwordfile=EXCLUSIVE*.sessions=1655*.sga_target=5617515008*.undo_management=AUTO*.undo_tablespace=UNDOTBS*.user_dump_dest=/app/oracle/admin/orcl/udump l 测试机上启动实例orcl，并开始恢复数据文件修改profile 改正ORACLE_SID=orcl; export ORACLE_SID使ORACLE_SID=orcl进入到该orcl的实例，以pfile启动的进入到rman中注意应该是restore controlfile from /backup/rmanbak/level0/20120209010001/4/controlfile_c-1129995432-20120209-01;使其进入mount状态查看数据文件一些命令的查看 设置export NLS_DATE_FORMAT=yyyy-mm-dd hh24:mi:ss list backup summary; RMAN list backup of archivelog all summary;RMAN list backup of archivelog all; 注意只有516和518备份集中有2月9日备份的归档 注意恢复的时候 可以用 RMAN restore database preview summary; 这个命令的速度很快！Restore过程，为了加快速度，所以使用了4个通道。本次开始的时间是11:37分。耗时约2小时runallocate 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 /oradata/orcl/system01.dbf;set newname for datafile 2 to /oradata/orcl/user02.dbf;set newname for datafile 3 to /oradata/orcl/sysaux01.dbf;set newname for datafile 4 to /oradata/orcl/users01.dbf;set newname for datafile 5 to /oradata/orcl/geostk_detail01.dbf;set newname for datafile 6 to /oradata/orcl/geo200801.dbf;set newname for datafile 7 to /oradata/orcl/databxstkmdtl02.dbf;set newname for datafile 8 to /oradata/orcl/geo2008index03.dbf;set newname for datafile 9 to /oradata/orcl/geo200805.dbf;set newname for datafile 10 to /oradata/orcl/databxsp01.dbf;set newname for datafile 11 to /oradata/orcl/databxbatch01.dbf;set newname for datafile 12 to /oradata/orcl/databxrob01.dbf;set newname for datafile 13 to /oradata/orcl/databxstkdtl01.dbf;set newname for datafile 14 to /oradata/orcl/databxaccdtl01.dbf;set newname for datafile 15 to /oradata/orcl/databxstkmdtl01.dbf;set newname for datafile 16 to /oradata/orcl/bxbb01.dbf;set newname for datafile 17 to /oradata/orcl/bxbb02.dbf;set newname for datafile 18 to /oradata/orcl/geo200802.dbf;set newname for datafile 19 to /oradata/orcl/geo200803.dbf;set newname for datafile 20 to /oradata/orcl/geo2008index01.dbf;set newname for datafile 21 to /oradata/orcl/geo2008index02.dbf;set newname for datafile 22 to /oradata/orcl/undotbs02.dbf;set newname for datafile 24 to /oradata/orcl/geo200804.dbf;set newname for datafile 25 to /oradata/orcl/benetz_todo01.dbf;set newname for datafile 29 to /oradata/orcl/undotbs1.dbf;set newname for datafile 30 to /oradata/orcl/undotbs2.dbf;restore database; switch datafile all;release channel c1;release channel c2;release channel c3;release channel c4; 关于归档在list backup of archivelog all ;中可以看到BS Key 518中有2月9日备份的归档- 这是1机的归档备份1 1430 93027986917 2012-02-09 01:24:13 93028096781 2012-02-09 02:48:24 1 1431 93028096781 2012-02-09 02:48:24 93028097147 2012-02-09 02:48:48BS Key 516中有2月9日备份的归档-这是2机的归档备份 2 744 93028096783 2012-02-09 02:47:01 93028097108 2012-02-09 02:47:23根据上面的可以看到（1,1431，93028097147）；（2,744，93028097108） 所以选择2恢复RMAN runset until sequence 745 thread 2;recover database;在SQL select THREAD#,SEQUENCE#,NEXT_CHANGE#,name from v$archived_log 中查到为了完全恢复，则不使用上面的until了。看节点1下的归档为了最大限度的恢复 scp 1_143*.dbf root6:/archive/orcl scp 1_144*.dbf root6:/archive/orcl 将2.9日备份时间后的所有归档都考过了恢复完后，我建议先备份恢复出来的数据文件夹然后用 sqlplus 的recover 进行恢复此时不能打开的！alter database rename file +DG_DATA/orcl/onlinelog/redo06.logto /oradata/chunjierac/redo06.log;alter database rename file +DG_DATA/orcl/onlinelog/redo07.logto /oradata/chunjierac/redo07.log;alter database rename file +DG_DATA/orcl/onlinelog/redo01.logto /oradata/chunjierac/redo01.log;alter database rename file +DG_DATA/orcl/onlinelog/redo02.logto /oradata/chunjierac/redo02.log;alter database rename file +DG_DATA/orcl/onlinelog/redo03.logto /oradata/chunjierac/redo03.log;alter database rename file +DG_DATA/orcl/onlinelog/redo04.logto /oradata/chunjierac/redo04.log;alter database rename file +DG_DATA/orcl/onlinelog/redo05.logto /oradata/chunjierac/redo05.log;alter database rename file +DG_DATA/orcl/onlinelog/redo8.log to /oradata/chunjierac/redo8.log;alter database rename file +DG_DATA/orcl/onlinelog/redo9.log to /oradata/chunjierac/redo9.log;alter database rename file +DG_DATA/orcl/onlinelog/redo10.logto /oradata/chunjierac/redo10.log;alter database rename file +DG_DATA/orcl/onlinelog/redo11.logto /oradata/chunjierac/redo11.log;alter database rename file +DG_DATA/orcl/onlinelog/redo12.logto /oradata/chunjierac/redo12.log;alter database rename file +DG_DATA/orcl/onlinelog/redo13.logto /oradata/chunjierac/redo13.log;alter database rename file +DG_DATA/orcl/onlinelog/redo14.logto /oradata/chunjierac/redo14.log;查看下SELECT a.group#, a.member, b.bytes FROM v$logfile a, v$log b WHERE a.group# = b.group#;后续操作SQL select THREAD#, STATUS, ENABLED from v$thread; SQL alter database disable thread 2;SQL select group# from v$log where THREAD#=2; 使用SQL alter database drop logfile group * 或者 SQL alter database clear unarchived logfile group 9;SQL select group#,member from v$logfile;对undo 的处理： 它的redo比较特别，一般的都是UNDOTBS2 和UNDOTBS1 SQL drop tablespace UNDOTBS2 including contents and datafiles;SQLselect tablespace_