异机恢复ORACLE数据库(NBU)

ORACLE数据库异机恢复(NBU)一．恢复的前提条件.1.)日常备份都是成功的。

至少有一次全备份及全备份以来的增量备份和Archivelog.2.)原主机的OS及ORACLE版本与目标主机的OS及ORACLE版本保持一致.3.)需要原数据库的下列信息：1）IP Address, Hostname, Nbu media server/client2）Oracle DB version, SID,DBID,Datafile Path,Controlfile Path,Archivelog Path3）Catalog DB IP,SID/Service name ,user/password4.)在目标主机上安装与原数据库版本相同的oracle软件（Install type :Softwareonly）5.)在目标主机上安装Veritas 软件，安装类型与原主机一致 (media server or client)二. 下面以aush49上的s1rel DB恢复到aush61为例对veritas及oracle进行配置.1 ）在目标主机上（aush61）配置veritas1) Edit $ORACLE_HOME/bp.conf file(aush61) s3pis> cd $ORACLE_HOME(aush61) s3pis> vi bp.confSERVER = aush06 /*master server host name*/CLIENT_NAME = aush49 /*source host name ,如果aush49是media server则写 SERVER = aush49*/CLINET_READ_TIMEOUT = 18002）Edit /usr/openv/netbackup/bp.conf ( aush61)aush61#vi bp.confSERVER = aush06 /*master servername*/CLIENT_NAME = aush49 /*source host name , 如果aush49是media server则写 SERVER = aush49*/CLIENT_NAME = aush61 /*target host name */VERBOSE = 5CLIENT_READ_TIMEOUT = 1800CLIENT_CONNECT_TIMEOUT = 18003) Touch a file on Master Server (aush06)aush06#cd /usr/openv/netbackup/db/altnamesaush06#touchaush61 /*target host name */2 ) 在master server （aush06）与目标主机(aush61)上配置/etc/hosts 文件aush61#vi /etc/hosts127.0.0.1 localhost10.5.15.61 aush6110.5.15.6 aush0610.5.15.49 aush4910.5.15.58 aush58aush06#vi /etc/hosts127.0.0.1 localhost10.5.15.61 aush6110.5.15.6 aush0610.5.15.49 aush4910.5.15.58 aush583) 在目标主机上（aush61）配置ORACLE.1 ）创建于原数据库（aush49）相同的oracle user/group : s3pis/dba2 ) 配置s3pis环境变量(aush61) s3pis> more .profileORACLE_HOME=/u01/s3pis;export ORACLE_HOMEORACLE_SID=s3rel;export ORACLE_SIDPATH=$PATH:$ORACLE_HOME/bin;export PATHPS1="(`hostname`) `whoami`> "LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH3 ) 安装与原数据库相同版本的Oracle 软件，安装类型：SOFTWARE ONLY.4 ) 创建$ORACLE_HOME/network/admin/tnsnames.ora 文件连接catalog DB.(aush61) s3pis> more tnsnames.oracatalog =(description=(address_list=(address=(protocol=tcp)(host=10.5.13.178)(port=1521)))(connect_data=(service_name=catalog)))5 ) 创建pfile如果有原数据库（s1rel db）的pfile 或spfile ，可以直接使用；如果没有可以手动创建pfile ！6 ）创建与原数据库（s1rel db）相同的文件存放路径！1）根据对原数据库（s1rel ）的日常维护信息，可以知道controlfile,datafile,archivelog file 的存取路径。

可以通过link 方式在目标主机（aush61）上创建相应的目录，并赋予oracle 用户（s1pis）读写权限.2）如果要将数据文件恢复到不同位置，需要在恢复语句上用set newname 及switch datafile 的参数！3）根据pfile或spfile 创建cdump ,bdump ,udump 目录三. 恢复步骤.1) 使用pfile或spfile在目标主机（aush61）上启动数据库(s1rel)到nomount 状态 (aush61) s3pis> sqlplus "/ as sysdba";SQL*Plus: Release 9.0.1.4.0 - Production on Thu Dec 9 11:00:24 2004(c) Copyright 2001 Oracle Corporation. All rights reserved.Connected to an idle instance.SQL> startup nomount pfile=/u01/s3pis/dbs/inits3rel.oraORACLE instance started.Total System Global Area 806283128 bytesFixed Size 436088 bytesVariable Size 268435456 bytesDatabase Buffers 536870912 bytesRedo Buffers 540672 bytesSQL>2．恢复控制文件(aush61) s3pis> rman catalog auss3pis/auss3pis@catalog;Recovery Manager: Release 9.0.1.4.0 - Production(c) Copyright 2001 Oracle Corporation. All rights reserved.connected to recovery catalog databaseRMAN> set dbid=4227459251 (aush49 s3rel dbid )executing command: SET DBIDRMAN> connect target /connected to target database: (not mounted)RMAN> run {2> allocate channel ch00 type 'sbt_tape';3> send 'nb_ora_serv=aush06';4> send 'nb_ora_client=aush49';5> restore controlfile;6> }allocated channel: ch00channel ch00: sid=11 devtype=SBT_TAPEchannel ch00: VERITAS NetBackup for Oracle - Release 4.5FP_3GA (2002121901) sent command to channel: ch00sent command to channel: ch00Starting restore at 09-DEC-04channel ch00: starting datafile backupset restorechannel ch00: restoring controlfileoutput filename=/u22/oradata/control01.ctlchannel ch00: restored backup piece 1piece handle=cntrl_3973_1_544399339 tag=null params=NULLchannel ch00: restore completereplicating controlfileinput filename=/u22/oradata/control01.ctloutput filename=/u22/oradata/control02.ctloutput filename=/u22/oradata/control03.ctlFinished restore at 09-DEC-04released channel: ch00RMAN> exit3．重新启动数据库到mount 状态SQL> shutdown immediate;ORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL> startup mount pfile=/u01/s3pis/dbs/inits3rel.oraORACLE instance started.Total System Global Area 806283128 bytesFixed Size 436088 bytesVariable Size 268435456 bytesDatabase Buffers 536870912 bytesRedo Buffers 540672 bytesDatabase mounted.SQL>4．对数据库做基于时间点的恢复！(aush61) s3pis> rman catalog auss3pis/auss3pis@catalog;Recovery Manager: Release 9.0.1.4.0 - Production(c) Copyright 2001 Oracle Corporation. All rights reserved.connected to recovery catalog databaseRMAN> set dbid=4227459251executing command: SET DBIDRMAN> connect target /connected to target database: S3REL (DBID=4227459251)RMAN> run {2> allocate channel ch00 type 'sbt_tape';3> send 'nb_ora_serv=aush06';4> send 'nb_ora_client=aush49';5> set until time "to_date('12/8/2004 14:00:00','mm/dd/yyyy hh24:mi:ss')";6> restore database;7> recover database;8> sql "alter database open resetlogs";9> }注：如果将数据文件恢复到与原路径不同的位置则按照如下写法：\\RMAN> run {2> allocate channel ch00 type 'sbt_tape';3> send 'nb_ora_serv=aush06';4> send 'nb_ora_client=aush49';5> set until time "to_date('12/8/2004 14:00:00','mm/dd/yyyy hh24:mi:ss')";6> set newname for datafile ‘filename’ or filenumber to ‘newlocation’ ;7> restore database ;8> switch datafile all;}RMAN> run {2> allocate channel ch00 type 'sbt_tape';3> send 'nb_ora_serv=aush06';4> send 'nb_ora_client=aush49';5> set until time "to_date('12/8/2004 14:00:00','mm/dd/yyyy hh24:mi:ss')";6> set archivelog destination to ‘full path’ ;}//channel ch00: sid=11 devtype=SBT_TAPEchannel ch00: VERITAS NetBackup for Oracle - Release 4.5FP_3GA (2002121901)sent command to channel: ch00sent command to channel: ch00executing command: SET until clauseStarting restore at 09-DEC-04channel ch00: starting datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup setrestoring datafile 00036 to /u23/oraindx/SMSR_I01.dbf.................................................... ....................................................restoring datafile 00051 to /u23/oraindx/SMS_AV_04092.dbfchannel ch00: restored backup piece 1piece handle=bk_3947_1_544370120 tag=HOT_DB_BK_LEVEL0 params=NULLchannel ch00: restore completeFinished restore at 09-DEC-04Starting recover at 09-DEC-04channel ch00: starting incremental datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup setdestination for restore of datafile 00070: /u22/oradata/SMS_ID_04121.dbf channel ch00: restored backup piece 1piece handle=bk_3927_1_544280863 tag=HOT_DB_BK_LEVEL0 params=NULLchannel ch00: restore completechannel ch00: starting incremental datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup set...................................................... ......................................................channel ch00: starting incremental datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup set destination for restore of datafile 00025: /u22/oradata/SCS_T01.dbf destination for restore of datafile 00036: /u23/oraindx/SMSR_I01.dbf destination for restore of datafile 00043: /u23/oraindx/SCS_I02.dbf destination for restore of datafile 00059: /u23/oraindx/SMS_AV_04093.dbf channel ch00: restored backup piece 1piece handle=bk_3931_1_544281553 tag=HOT_DB_BK_LEVEL0 params=NULL channel ch00: restore completestarting media recoverychannel ch00: starting archive log restore to default destination channel ch00: restoring archive logarchive log thread=1 sequence=2562channel ch00: restoring archive log ..................................................... .....................................................archive log filename=/u21/s3rel/archive/1_2574.dbf thread=1 sequence=2574 archive log filename=/u21/s3rel/archive/1_2575.dbf thread=1 sequence=2575 archive log filename=/u21/s3rel/archive/1_2576.dbf thread=1 sequence=2576 archive log filename=/u21/s3rel/archive/1_2577.dbf thread=1 sequence=2577 media recovery completeFinished recover at 09-DEC-04sql statement: alter database open resetlogsreleased channel: ch00RMAN>恢复成功，数据库已经打开！。