环境备份恢复至单机方案样本.doc

资源描述

资料内容仅供您学习参考，如有不当之处，请联系改正或者删除。 Oracle 10g RAC环境Rman备份恢复至单机oracle10g方案说明: 使用于oracle 10g ,备份环境是RAC, 可是恢复目的环境是单机。 l 创立与rac主机相同的目录如/backup/rmanbak/level0/ /4 都是在压缩包所在的目录下tar -cvf oracle0208.tar oracle tar -xvf oracle0113.tar l 传输rac上的备份集到单机上节点2上的备份包含数据文件及归档的备份集 scp dblv0_731_1_ :/backup/rmanbak/level0/ /4 scp dblv0_732_1_ :/backup/rmanbak/level0/ /4 scp dblv0_733_1_ :/backup/rmanbak/level0/ /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='10.2.0.1.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= *.processes=1500 *.remote_login_passwordfile='EXCLUSIVE' *.sessions=1655 *.sga_target= *.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/ /4/controlfile_c-- 0209-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小时 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 '/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/geo 01.dbf'; set newname for datafile 7 to '/oradata/orcl/databxstkmdtl02.dbf'; set newname for datafile 8 to '/oradata/orcl/geo index03.dbf'; set newname for datafile 9 to '/oradata/orcl/geo 05.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/geo 02.dbf'; set newname for datafile 19 to '/oradata/orcl/geo 03.dbf'; set newname for datafile 20 to '/oradata/orcl/geo index01.dbf'; set newname for datafile 21 to '/oradata/orcl/geo index02.dbf'; set newname for datafile 22 to '/oradata/orcl/undotbs02.dbf'; set newname for datafile 24 to '/oradata/orcl/geo 04.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 -02-09 01:24:13 -02-09 02:48:24 1 1431 -02-09 02:48:24 -02-09 02:48:48 BS Key 516中有2月9日备份的归档----这是2机的归档备份 2 744 -02-09 02:47:01 -02-09 02:47:23 根据上面的能够看到( 1,1431, ) ; ( 2,744, ) 因此选择2恢复 RMAN> run{ set until sequence 745 thread 2; recover database; } 在SQL> select THREAD#,SEQUENCE#,NEXT_CHANGE#,name from v$archived_log 中查到为了完全恢复, 则不使用上面的until了。看节点1下的归档为了最大限度的恢复 scp 1_143*.dbf :/archive/orcl scp 1_144*.dbf :/archive/orcl 将2.9日备份时间后的所有归档都考过了恢复完后, 我建议先备份恢复出来的数据文件夹然后用 sqlplus 的recover 进行恢复此时不能打开的! alter database rename file '+DG_DATA/orcl/onlinelog/redo06.log'to '/oradata/chunjierac/redo06.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo07.log'to '/oradata/chunjierac/redo07.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo01.log'to '/oradata/chunjierac/redo01.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo02.log'to '/oradata/chunjierac/redo02.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo03.log'to '/oradata/chunjierac/redo03.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo04.log'to '/oradata/chunjierac/redo04.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo05.log'to '/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.log'to '/oradata/chunjierac/redo10.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo11.log'to '/oradata/chunjierac/redo11.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo12.log'to '/oradata/chunjierac/redo12.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo13.log'to '/oradata/chunjierac/redo13.log'; alter database rename file '+DG_DATA/orcl/onlinelog/redo14.log'to '/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; SQL>select tablespace_name from dba_tablespaces where contents='UNDO'; 对temp的处理: SQL> select name from v$tempfile; NAME -------------------------------------------------------------------------------- +DG_DATA/orcl/tempfile/temp02.dbf SQL> select tablespace_name from dba_tablespaces where contents='TEMPORARY'; TABLESPACE_NAME ------------------------------ TEMP SQL> create temporary tablespace TEMP1 tempfile '/oradata/****/temp01.dbf' size 100M autoextend off; Tablespace created. SQL> alter database default temporary tablespace TEMP1; Database altered. SQL> drop tablespace TEMP including contents and datafiles; Tablespace dropped. SQL> select name from v$tempfile; NAME -------------------------------------------------------------------------------- /oradata/chunjierac/temp01.dbf 监听配置 orcl = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = dg02)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) )

展开阅读全文