CISS(cissdb01)-oracle恢复验证报告

CISS(cissdb01)系统oracle恢复验证报告恢复验证环境:OS版本:oracle版本:ORACLE_HOME:源主机信息:操作系统版本:数据库版本：数据库SID：CISS数据库DBID:2510649594备份策略:每周一四全备,归档每天备份,数据保留两周数据库保护方式:Single/HA/RAC数据量大小:2.73T恢复步骤:实施人员:曹晓辉/吕庚思恢复方式:LAN/SAN恢复时间点:2009-7-141:30:00恢复记录:前提准备:编辑测试机bj1recap01/etc/hosts表,添加:7nsrbk4svc9bj1nsrap052bj1nsrap04在测试机bj1recap01(6)上安装networker7.4.1client,storagenode和nmo4.5模块.并配置nmo.在networkerserverconsole上添加bj1recap01client,storagenode为bj1recap01.配置亦庄3584后三个驱动器为bj1recap01LAN-FREE路径.jbedit-a-frd=bj1recap01:/dev/rmt1.1-E278jbedit-a-frd=bj1recap01:/dev/rmt2.1-E279jbedit-a-frd=bj1recap01:/dev/rmt3.1-E280配置bj1recap01上监听.vi$ORACLE_HOME/network/admin/tnsnames.ora.添加:CATADB4=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=nsrbk4svc)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CATADB4)))实施过程:修改lpcissdb01clientremoteaccess为*@*,recoverstoragenode为:bj1recap01.编辑测试机bj1recap01/etc/hosts表,添加:4lpcissdb05lpcissdb022.修改测试机bj1recap01oracle用户.profile中ORACLE_SID.ORACLE_SID=CISS;exportORACLE_SID修改测试机bj1recap01tnsnames.ora.添加CISS监听.CISS=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=bj1recap01)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=CISS)))恢复CISSspfile.在测试机bj1recap01用oracle用户执行:$RMANRMAN>setdbid=2510649594RMAN>connecttarget/RMAN>startupnomountforce;RMAN>connectXXX/XXX@catadb4;RMAN>run{allocatechannelc1typesbt_tape;setuntiltime"to_date('07-14-2009:01:30:00','MM-DD-YYYY:HH24:MI:SS')";send'NSR_ENV=(NSR_SERVER=nsrbk4svc,NSR_CLIENT=lpcissdb01,NSR_DATA_VOLUME_POOL=CISSDBPool)';restorespfileto'/home/oradata/spfile.0812';releasechannelc1;}通过恢复spfile创建pfile文件.在测试机bj1recap01用oracle用户在SQLPLUS中执行:$sqlplus“/assysdba”SQL>createpfilefromspfile=’/home/oradata/spfile.0812';编辑$ORACLE_HOME/dbs/initCISS.ora文件.修改sga,rac,control_files参数,修改如下:*.control_files=’/home/oradata/CISS/control01.ctl’,’/home/oradata/CISS/control02.ctl’*.sga_max_size=2000000000*.sga_target=2684354560注释掉以下参数:#ciss2.__db_cache_size=22196256768#ciss1.__db_cache_size=24964497408#ciss1.__java_pool_size=16777216#ciss2.__java_pool_size=16777216#ciss1.__large_pool_size=16777216#ciss2.__large_pool_size=16777216#ciss2.__shared_pool_size=4596957184#ciss1.__shared_pool_size=1828716544#ciss1.__streams_pool_size=0#ciss2.__streams_pool_size=0#*.cluster_database_instances=2#*.cluster_database=true#ciss1.cluster_interconnects='7'#ciss2.cluster_interconnects='8'#ciss2.instance_number=2#ciss2.local_listener='LISTENER_CISS2'#*.remote_listener='LISTENERS_CISS'#ciss2.thread=2#ciss2.undo_tablespace='UNDOTBS2'按照initCISS.ora的目录层级结构，创建adump,bdump,cdump,udump目录.数据文件存放目录.归档目录.su–oraclemkdir-p/home/db/oracle/app/admin/CISS/adumpmkdir-p/home/db/oracle/app/admin/CISS/bdumpmkdir-p/home/db/oracle/app/admin/CISS/cdumpmkdir-p/home/db/oracle/app/admin/CISS/udumpmkdir-p/home/db/archlog1mkdir-p/home/oradata/CISS重新关闭启动数据库到nomount状态.SQL>shutdownimmediate;SQL>startupnomount;在/nsr/script/CISS下,创建恢复controlfile和datafile脚本res.sh.脚本内容如下:connecttarget/;connectcatalogxxx/xxx@catadb4;run{allocatechannelt1type'sbt_tape';allocatechannelt2type'sbt_tape';allocatechannelt3type'sbt_tape';allocatechannelt4type'sbt_tape';setuntiltime"to_date('07-14-2009:01:30:00','MM-DD-YYYY:HH24:MI:SS')";send'NSR_ENV=(NSR_SERVER=nsrbk4svc,NSR_CLIENT=lpcissdb01,NSR_DATA_VOLUME_POOL=CISSDBPool)';restorecontrolfile;sql'alterdatabasemount';setnewnamefordatafile'/dev/rora_system'to'/home/oradata/system';setnewnamefordatafile'/dev/rora_undo10'to'/home/oradata/undo10';setnewnamefordatafile'/dev/rora_sysaux'to'/home/oradata/sysaux';setnewnamefordatafile'/dev/rora_undo20'to'/home/oradata/undo20';setnewnamefordatafile'/dev/rora_users'to'/home/oradata/users';setnewnamefordatafile'/dev/rora_undo11'to'/home/oradata/undo11';setnewnamefordatafile'/dev/rora_undo12'to'/home/oradata/undo12';setnewnamefordatafile'/dev/rora_undo13'to'/home/oradata/undo13';setnewnamefordatafile'/dev/rora_undo14'to'/home/oradata/undo14';setnewnamefordatafile'/dev/rora_undo15'to'/home/oradata/undo15';setnewnamefordatafile'/dev/rora_undo16'to'/home/oradata/undo16';setnewnamefordatafile'/dev/rora_undo17'to'/home/oradata/undo17';setnewnamefordatafile'/dev/rora_undo18'to'/home/oradata/undo18';setnewnamefordatafile'/dev/rora_undo19'to'/home/oradata/undo19';setnewnamefordatafile'/dev/rora_undo21'to'/home/oradata/undo21';setnewnamefordatafile'/dev/rora_undo22'to'/home/oradata/undo22';setnewnamefordatafile'/dev/rora_undo23'to'/home/oradata/undo23';setnewnamefordatafile'/dev/rora_undo24'to'/home/oradata/undo24';setnewnamefordatafile'/dev/rora_undo25'to'/home/oradata/undo25';setnewnamefordatafile'/dev/rora_undo29'to'/home/oradata/undo29';setnewnamefordatafile'/dev/rora_undo27'to'/home/oradata/undo27';setnewnamefordatafile'/dev/rora_undo28'to'/home/oradata/undo28';setnewnamefordatafile'/dev/rora_data10G001'to'/home/oradata/data10G001';setnewnamefordatafile'/dev/rora_data10G002'to'/home/oradata/data10G002';setnewnamefordatafile'/dev/rora_data10G003'to'/home/oradata/data10G003';setnewnamefordatafile'/dev/rora_data10G004'to'/home/oradata/data10G004';setnewnamefordatafile'/dev/rora_data10G005'to'/home/oradata/data10G005';setnewnamefordatafile'/dev/rora_data10G006'to'/home/oradata/data10G006';setnewnamefordatafile'/dev/rora_data10G007'to'/home/oradata/data10G007';setnewnamefordatafile'/dev/rora_data10G008'to'/home/oradata/data10G008';setnewnamefordatafile'/dev/rora_data10G009'to'/home/oradata/data10G009';setnewnamefordatafile'/dev/rora_data10G010'to'/home/oradata/data10G010';setnewnamefordatafile'/dev/rora_data10G011'to'/home/oradata/data10G011';setnewnamefordatafile'/dev/rora_data10G012'to'/home/oradata/data10G012';setnewnamefordatafile'/dev/rora_data10G013'to'/home/oradata/data10G013';setnewnamefordatafile'/dev/rora_data10G014'to'/home/oradata/data10G014';setnewnamefordatafile'/dev/rora_data10G015'to'/home/oradata/data10G015';setnewnamefordatafile'/dev/rora_data10G016'to'/home/oradata/data10G016';setnewnamefordatafile'/dev/rora_data10G017'to'/home/oradata/data10G017';setnewnamefordatafile'/dev/rora_data10G018'to'/home/oradata/data10G018';setnewnamefordatafile'/dev/rora_data10G019'to'/home/oradata/data10G019';setnewnamefordatafile'/dev/rora_data10G020'to'/home/oradata/data10G020';setnewnamefordatafile'/dev/rora_data10G021'to'/home/oradata/data10G021';setnewnamefordatafile'/dev/rora_data10G022'to'/home/oradata/data10G022';setnewnamefordatafile'/dev/rora_data10G023'to'/home/oradata/data10G023';setnewnamefordatafile'/dev/rora_data10G024'to'/home/oradata/data10G024';setnewnamefordatafile'/dev/rora_data10G025'to'/home/oradata/data10G025';setnewnamefordatafile'/dev/rora_data10G026'to'/home/oradata/data10G026';setnewnamefordatafile'/dev/rora_data10G027'to'/home/oradata/data10G027';setnewnamefordatafile'/dev/rora_data10G028'to'/home/oradata/data10G028';setnewnamefordatafile'/dev/rora_data10G029'to'/home/oradata/data10G029';setnewnamefordatafile'/dev/rora_data10G030'to'/home/oradata/data10G030';setnewnamefordatafile'/dev/rora_data10G031'to'/home/oradata/data10G031';setnewnamefordatafile'/dev/rora_data10G032'to'/home/oradata/data10G032';setnewnamefordatafile'/dev/rora_data10G033'to'/home/oradata/data10G033';setnewnamefordatafile'/dev/rora_data10G034'to'/home/oradata/data10G034';setnewnamefordatafile'/dev/rora_data10G035'to'/home/oradata/data10G035';setnewnamefordatafile'/dev/rora_data10G036'to'/home/oradata/data10G036';setnewnamefordatafile'/dev/rora_data10G037'to'/home/oradata/data10G037';setnewnamefordatafile'/dev/rora_data10G038'to'/home/oradata/data10G038';setnewnamefordatafile'/dev/rora_data10G039'to'/home/oradata/data10G039';setnewnamefordatafile'/dev/rora_data10G040'to'/home/oradata/data10G040';setnewnamefordatafile'/dev/rora_data10G041'to'/home/oradata/data10G041';setnewnamefordatafile'/dev/rora_data10G042'to'/home/oradata/data10G042';setnewnamefordatafile'/dev/rora_data10G043'to'/home/oradata/data10G043';setnewnamefordatafile'/dev/rora_data10G044'to'/home/oradata/data10G044';setnewnamefordatafile'/dev/rora_data10G045'to'/home/oradata/data10G045';setnewnamefordatafile'/dev/rora_data10G046'to'/home/oradata/data10G046';setnewnamefordatafile'/dev/rora_data10G047'to'/home/oradata/data10G047';setnewnamefordatafile'/dev/rora_data10G048'to'/home/oradata/data10G048';setnewnamefordatafile'/dev/rora_data10G049'to'/home/oradata/data10G049';setnewnamefordatafile'/dev/rora_data10G050'to'/home/oradata/data10G050';setnewnamefordatafile'/dev/rora_data10G051'to'/home/oradata/data10G051';setnewnamefordatafile'/dev/rora_data10G052'to'/home/oradata/data10G052';setnewnamefordatafile'/dev/rora_data10G053'to'/home/oradata/data10G053';setnewnamefordatafile'/dev/rora_data10G054'to'/home/oradata/data10G054';setnewnamefordatafile'/dev/rora_data10G055'to'/home/oradata/data10G055';setnewnamefordatafile'/dev/rora_data10G056'to'/home/oradata/data10G056';setnewnamefordatafile'/dev/rora_data10G057'to'/home/oradata/data10G057';setnewnamefordatafile'/dev/rora_data10G058'to'/home/oradata/data10G058';setnewnamefordatafile'/dev/rora_data10G059'to'/home/oradata/data10G059';setnewnamefordatafile'/dev/rora_data10G060'to'/home/oradata/data10G060';setnewnamefordatafile'/dev/rora_data10G061'to'/home/oradata/data10G061';setnewnamefordatafile'/dev/rora_data10G062'to'/home/oradata/data10G062';setnewnamefordatafile'/dev/rora_data10G063'to'/home/oradata/data10G063';setnewnamefordatafile'/dev/rora_data10G064'to'/home/oradata/data10G064';setnewnamefordatafile'/dev/rora_data10G065'to'/home/oradata/data10G065';setnewnamefordatafile'/dev/rora_data10G066'to'/home/oradata/data10G066';setnewnamefordatafile'/dev/rora_data10G067'to'/home/oradata/data10G067';setnewnamefordatafile'/dev/rora_data10G068'to'/home/oradata/data10G068';setnewnamefordatafile'/dev/rora_data10G069'to'/home/oradata/data10G069';setnewnamefordatafile'/dev/rora_data10G070'to'/home/oradata/data10G070';setnewnamefordatafile'/dev/rora_data10G071'to'/home/oradata/data10G071';setnewnamefordatafile'/dev/rora_data10G072'to'/home/oradata/data10G072';setnewnamefordatafile'/dev/rora_data10G073'to'/home/oradata/data10G073';setnewnamefordatafile'/dev/rora_data10G074'to'/home/oradata/data10G074';setnewnamefordatafile'/dev/rora_data10G075'to'/home/oradata/data10G075';setnewnamefordatafile'/dev/rora_data10G076'to'/home/oradata/data10G076';setnewnamefordatafile'/dev/rora_data10G077'to'/home/oradata/data10G077';setnewnamefordatafile'/dev/rora_data10G078'to'/home/oradata/data10G078';setnewnamefordatafile'/dev/rora_data10G079'to'/home/oradata/data10G079';setnewnamefordatafile'/dev/rora_data10G080'to'/home/oradata/data10G080';setnewnamefordatafile'/dev/rora_data10G081'to'/home/oradata/data10G081';setnewnamefordatafile'/dev/rora_data10G082'to'/home/oradata/data10G082';setnewnamefordatafile'/dev/rora_data10G083'to'/home/oradata/data10G083';setnewnamefordatafile'/dev/rora_data10G084'to'/home/oradata/data10G084';setnewnamefordatafile'/dev/rora_data10G085'to'/home/oradata/data10G085';setnewnamefordatafile'/dev/rora_data10G086'to'/home/oradata/data10G086';setnewnamefordatafile'/dev/rora_data10G087'to'/home/oradata/data10G087';setnewnamefordatafile'/dev/rora_data10G088'to'/home/oradata/data10G088';setnewnamefordatafile'/dev/rora_data10G089'to'/home/oradata/data10G089';setnewnamefordatafile'/dev/rora_data10G090'to'/home/oradata/data10G090';setnewnamefordatafile'/dev/rora_data10G091'to'/home/oradata/data10G091';setnewnamefordatafile'/dev/rora_data10G092'to'/home/oradata/data10G092';setnewnamefordatafile'/dev/rora_data10G093'to'/home/oradata/data10G093';setnewnamefordatafile'/dev/rora_data10G094'to'/home/oradata/data10G094';setnewnamefordatafile'/dev/rora_data10G095'to'/home/oradata/data10G095';setnewnamefordatafile'/dev/rora_data10G096'to'/home/oradata/data10G096';setnewnamefordatafile'/dev/rora_data10G097'to'/home/oradata/data10G097';setnewnamefordatafile'/dev/rora_data10G098'to'/home/oradata/data10G098';setnewnamefordatafile'/dev/rora_data10G099'to'/home/oradata/data10G099';setnewnamefordatafile'/dev/rora_data10G100'to'/home/oradata/data10G100';setnewnamefordatafile'/dev/rora_data10G101'to'/home/oradata/data10G101';setnewnamefordatafile'/dev/rora_data10G102'to'/home/oradata/data10G102';setnewnamefordatafile'/dev/rora_data10G103'to'/home/oradata/data10G103';setnewnamefordatafile'/dev/rora_data10G104'to'/home/oradata/data10G104';setnewnamefordatafile'/dev/rora_data10G105'to'/home/oradata/data10G105';setnewnamefordatafile'/dev/rora_data10G106'to'/home/oradata/data10G106';setnewnamefordatafile'/dev/rora_data10G107'to'/home/oradata/data10G107';setnewnamefordatafile'/dev/rora_data10G108'to'/home/oradata/data10G108';setnewnamefordatafile'/dev/rora_data10G109'to'/home/oradata/data10G109';setnewnamefordatafile'/dev/rora_data10G110'to'/home/oradata/data10G110';setnewnamefordatafile'/dev/rora_data10G111'to'/home/oradata/data10G111';setnewnamefordatafile'/dev/rora_data10G112'to'/home/oradata/data10G112';setnewnamefordatafile'/dev/rora_data10G113'to'/home/oradata/data10G113';setnewnamefordatafile'/dev/rora_data10G114'to'/home/oradata/data10G114';setnewnamefordatafile'/dev/rora_data10G115'to'/home/oradata/data10G115';setnewnamefordatafile'/dev/rora_data10G116'to'/home/oradata/data10G116';setnewnamefordatafile'/dev/rora_data10G117'to'/home/oradata/data10G117';setnewnamefordatafile'/dev/rora_data10G118'to'/home/oradata/data10G118';setnewnamefordatafile'/dev/rora_data10G119'to'/home/oradata/data10G119';setnewnamefordatafile'/dev/rora_data10G120'to'/home/oradata/data10G120';setnewnamefordatafile'/dev/rora_data10G121'to'/home/oradata/data10G121';setnewnamefordatafile'/dev/rora_data10G122'to'/home/oradata/data10G122';setnewnamefordatafile'/dev/rora_data10G123'to'/home/oradata/data10G123';setnewnamefordatafile'/dev/rora_data10G124'to'/home/oradata/data10G124';setnewnamefordatafile'/dev/rora_data10G125'to'/home/oradata/data10G125';setnewnamefordatafile'/dev/rora_data10G126'to'/home/oradata/data10G126';setnewnamefordatafile'/dev/rora_data10G127'to'/home/oradata/data10G127';setnewnamefordatafile'/dev/rora_data10G128'to'/home/oradata/data10G128';setnewnamefordatafile'/dev/rora_data10G129'to'/home/oradata/data10G129';setnewnamefordatafile'/dev/rora_data10G130'to'/home/oradata/data10G130';setnewnamefordatafile'/dev/rora_data10G131'to'/home/oradata/data10G131';setnewnamefordatafile'/dev/rora_data10G132'to'/home/oradata/data10G132';setnewnamefordatafile'/dev/rora_data10G133'to'/home/oradata/data10G133';setnewnamefordatafile'/dev/rora_data10G134'to'/home/oradata/data10G134';setnewnamefordatafile'/dev/rora_data10G135'to'/home/oradata/data10G135';setnewnamefordatafile'/dev/rora_data10G136'to'/home/oradata/data10G136';setnewnamefordatafile'/dev/rora_data10G137'to'/home/oradata/data10G137';setnewnamefordatafile'/dev/rora_data10G138'to'/home/oradata/data10G138';setnewnamefordatafile'/dev/rora_data10G139'to'/home/oradata/data10G139';setnewnamefordatafile'/dev/rora_data10G140'to'/home/oradata/data10G140';setnewnamefordatafile'/dev/rora_data10G141'to'/home/oradata/data10G141';setnewnamefordatafile'/dev/rora_data10G142'to'/home/oradata/data10G142';setnewnamefordatafile'/dev/rora_data10G143'to'/home/oradata/data10G143';setnewnamefordatafile'/dev/rora_data10G144'to'/home/oradata/data10G144';setnewnamefordatafile'/dev/rora_data10G145'to'/home/oradata/data10G145';setnewnamefordatafile'/dev/rora_data10G146'to'/home/oradata/data10G146';setnewnamefordatafile'/dev/rora_data10G147'to'/home/oradata/data10G147';setnewnamefordatafile'/dev/rora_data10G148'to'/home/oradata/data10G148';setnewnamefordatafile'/dev/rora_data10G149'to'/home/oradata/data10G149';setnewnamefordatafile'/dev/rora_data10G150'to'/home/oradata/data10G150';setnewnamefordatafile'/dev/rora_data10G329'to'/home/oradata/data10G329';setnewnamefordatafile'/dev/rora_data10G151'to'/home/oradata/data10G151';setnewnamefordatafile'/dev/rora_data10G152'to'/home/oradata/data10G152';setnewnamefordatafile'/dev/rora_data10G153'to'/home/oradata/data10G153';setnewnamefordatafile'/dev/rora_data10G154'to'/home/oradata/data10G154';setnewnamefordatafile'/dev/rora_data10G155'to'/home/oradata/data10G155';setnewnamefordatafile'/dev/rora_data10G156'to'/home/oradata/data10G156';setnewnamefordatafile'/dev/rora_undo26'to'/home/oradata/undo26';setnewnamefordatafile'/dev/rora_data10G157'to'/home/oradata/data10G157';setnewnamefordatafile'/dev/rora_data10G158'to'/home/oradata/data10G158';setnewnamefordatafile'/dev/rora_data10G159'to'/home/oradata/data10G159';setnewnamefordatafile'/dev/rora_data10G160'to'/home/oradata/data10G160';setnewnamefordatafile'/dev/rora_data10G161'to'/home/oradata/data10G161';setnewnamefordatafile'/dev/rora_data10G162'to'/home/oradata/data10G162';setnewnamefordatafile'/dev/rora_data10G163'to'/home/oradata/data10G163';setnewnamefordatafile'/dev/rora_data10G164'to'/home/oradata/data10G164';setnewnamefordatafile'/dev/rora_data10G165'to'/home/oradata/data10G165';setnewnamefordatafile'/dev/rora_data10G166'to'/home/oradata/data10G166';setnewnamefordatafile'/dev/rora_data10G167'to'/home/oradata/data10G167';setnewnamefordatafile'/dev/rora_data10G168'to'/home/oradata/data10G168';setnewnamefordatafile'/dev/rora_data10G169'to'/home/oradata/data10G169';setnewnamefordatafile'/dev/rora_data10G170'to'/home/oradata/data10G170';setnewnamefordatafile'/dev/rora_data10G171'to'/home/oradata/data10G171';setnewnamefordatafile'/dev/rora_data10G172'to'/home/oradata/data10G172';setnewnamefordatafile'/dev/rora_data10G173'to'/home/oradata/data10G173';setnewnamefordatafile'/dev/rora_data10G174'to'/home/oradata/data10G174';setnewnamefordatafile'/dev/rora_data10G175'to'/home/oradata/data10G175';setnewnamefordatafile'/dev/rora_data10G176'to'/home/oradata/data10G176';setnewnamefordatafile'/dev/rora_data10G177'to'/home/oradata/data10G177';setnewnamefordatafile'/dev/rora_data10G178'to'/home/oradata/data10G178';setnewnamefordatafile'/dev/rora_data10G179'to'/home/oradata/data10G179';setnewnamefordatafile'/dev/rora_data10G183'to'/home/oradata/data10G183';setnewnamefordatafile'/dev/rora_data10G180'to'/home/oradata/data10G180';setnewnamefordatafile'/dev/rora_data10G184'to'/home/oradata/data10G184';setnewnamefordatafile'/dev/rora_data10G181'to'/home/oradata/data10G181';setnewnamefordatafile'/dev/rora_data10G185'to'/home/oradata/data10G185';setnewnamefordatafile'/dev/rora_data10G182'to'/home/oradata/data10G182';setnewnamefordatafile'/dev/rora_data10G186'to'/home/oradata/data10G186';setnewnamefordatafile'/dev/rora_data10G187'to'/home/oradata/data10G187';setnewnamefordatafile'/dev/rora_data10G188'to'/home/oradata/data10G188';setnewnamefordatafile'/dev/rora_data10G192'to'/home/oradata/data10G192';setnewnamefordatafile'/dev/rora_data10G190'to'/home/oradata/data10G190';setnewnamefordatafile'/dev/rora_data10G193'to'/home/oradata/data10G193';setnewnamefordatafile'/dev/rora_data10G191'to'/home/oradata/data10G191';setnewnamefordatafile'/dev/rora_data10G189'to'/home/oradata/data10G189';setnewnamefordatafile'/dev/rora_data10G194'to'/home/oradata/data10G194';setnewnamefordatafile'/dev/rora_data10G195'to'/home/oradata/data10G195';setnewnamefordatafile'/dev/rora_data10G196'to'/home/oradata/data10G196';setnewnamefordatafile'/dev/rora_data10G197'to'/home/oradata/data10G197';setnewnamefordatafile'/dev/rora_data10G198'to'/home/oradata/data10G198';setnewnamefordatafile'/dev/rora_data10G199'to'/home/oradata/data10G199';setnewnamefordatafile'/dev/rora_data10G200'to'/home/oradata/data10G200';setnewnamefordatafile'/dev/rora_data10G201'to'/home/oradata/data10G201';setnewnamefordatafile'/dev/rora_data10G203'to'/home/oradata/data10G203';setnewnamefordatafile'/dev/rora_data10G204'to'/home/oradata/data10G204';setnewnamefordatafile'/dev/rora_data10G205'to'/home/oradata/data10G205';setnewnamefordatafile'/dev/rora_data10G206'to'/home/oradata/data10G206';setnewnamefordatafile'/dev/rora_data10G207'to'/home/oradata/data10G207';setnewnamefordatafile'/dev/rora_data10G208'to'/home/oradata/data10G208';setnewnamefordatafile'/dev/rora_data10G209'to'/home/oradata/data10G209';setnewnamefordatafile'/dev/rora_data10G210'to'/home/oradata/data10G210';setnewnamefordatafile'/dev/rora_data10G211'to'/home/oradata/data10G211';setnewnamefordatafile'/dev/rora_data10G212'to'/home/oradata/data10G212';setnewnamefordatafile'/dev/rora_data10G213'to'/home/oradata/data10G213';setnewnamefordatafile'/dev/rora_data10G214'to'/home/oradata/data10G214';setnewnamefordatafile'/dev/rora_data10G215'to'/home/oradata/data10G215';setnewnamefordatafile'/dev/rora_data10G216'to'/home/oradata/data10G216';setnewnamefordatafile'/dev/rora_data10G217'to'/home/oradata/data10G217';setnewnamefordatafile'/dev/rora_data10G218'to'/home/oradata/data10G218';setnewnamefordatafile'/dev/rora_data10G219'to'/home/oradata/data10G219';restoredatabase;switchdatafileall;releasechannelt1;releasechannelt2;releasechannelt3;releasechannelt4;}在/nsr/script/CISS下,创建恢复归档日志脚本res.arch1,res.arch2.res.arch1内容如下:connecttarget/;connectcatalogxxx/xxx@catadb4;run{allocatechannelc1typesbt_tapesend'NSR_ENV=(NSR_SERVER=nsrbk4svc,NSR_CLIENT=lpcissdb01,NSR_DATA_VOLUME_POOL=CISSDBPool)';restorearchivelogfromsequence10345untilsequence10370thread1;releasechannelc1;}res.arch2内容如下:connecttarget/;connectcatalogxxx/xxx@catadb4;run{allocatechannelc1typesbt_tapesend'NSR_ENV=(NSR_SERVER=nsrbk4svc,NSR_CLIENT=lpcissdb02,NSR_DATA_VOLUME_POOL=CISSDBPool)';restorearchivelogfromsequence12297untilsequence12332thread2;releasechannelc1;}恢复controlfile和datafile.用oracle用户执行:$rmancmdfile=/nsr/script/ciss/res.sh恢复归档日志.用oracle用户执行:$rmancmdfile=/nsr/script/ciss/res.arch1$rmancmdfile=/nsr/script/ciss/res.arch2重建controlfile$sqlplus“/assysdba”SQL>alterdatabasebackupcontrolfiletotrace;SQL>!根据/home/db/oracle/app/admin/CISS/udump/CISS_ora_217162.trc中重建controlfile语句,修改redolog路径到/home/oradata/CISS下.#exitSQL>shutdownimmediate;SQL>startupnomount;SQL>CREATECONTROLFILEREUSEDATABASE"CISS"RESETLOGSARCHIVELOGMAXLOGFILES192MAXLOGMEMBERS3MAXDATAFILES2000MAXINSTANCES32MAXLOGHISTORY1772LOGFILEGROUP1'/home/oradata/ciss/rora_redo11'SIZE2000M,GROUP2'/home/oradata/ciss/rora_redo12'SIZE2000M,GROUP5'/home/oradata/ciss/rora_redo13'SIZE2040M,GROUP6'/home/oradata/ciss/rora_redo14'SIZE2040M,GROUP7'/home/oradata/ciss/rora_redo15'SIZE2040M,GROUP8'/home/oradata/ciss/rora_redo16'SIZE2040M--STANDBYLOGFILEDATAFILE'/home/oradata/ciss/system','/home/oradata/ciss/undo10','/home/oradata/ciss/sysaux','/home/oradata/ciss/undo20','/home/oradata/ciss/users','/home/oradata/ciss/undo11','/home/oradata/ciss/undo12','/home/oradata/ciss/undo13','/home/oradata/ciss/undo14','/home/oradata/ciss/undo15','/home/oradata/ciss/undo16','/home/oradata/ciss/undo17','/home/oradata/ciss/undo18','/home/oradata/ciss/undo19','/home/oradata/ciss/undo21','/home/oradata/ciss/undo22','/home/oradata/ciss/undo23','/home/oradata/ciss/undo24','/home/oradata/ciss/undo25','/home/oradata/ciss/undo29','/home/oradata/ciss/undo27','/home/oradata/ciss/undo28','/home/oradata/ciss/data10G001','/home/oradata/ciss/data10G002','/home/oradata/ciss/data10G003','/home/oradata/ciss/data10G004','/home/oradata/ciss/data10G005','/home/oradata/ciss/data10G006','/home/oradata/ciss/data10G007','/home/oradata/ciss/data10G008','/home/oradata/ciss/data10G009','/home/oradata/ciss/data10G010','/home/oradata/ciss/data10G011','/home/oradata/ciss/data10G012','/home/oradata/ciss/data10G013','/home/oradata/ciss/data10G014','/home/oradata/ciss/data10G015','/home/oradata/ciss/data10G016','/home/oradata/ciss/data10G017','/home/oradata/ciss/data10G018','/home/