NBU70forlinuxOracle异机恢复详解.docx

1、NBU70forlinuxOracle异机恢复详解NBU7.0_for linux_Oracle_异机恢复1. 在目标客户机安装NBU Client软件，运行/usr/openv/netbackup/bin/oracle_link.sh 连接数据库；2. 编辑/usr/openv/netbackup/bp.conf文件，写入源客户机主机名# cat bp.confSERVER = waanbu1CLIENT_NAME = p520-1CLIENT_NAME = svc3. 编辑etc/hosts文件，写入Master Server和源客户机的解析4. 在Master Server上面创建文件/

2、netbackup/db/altnames/No.Restriction，文件内容为空；5. 重启目标客户机的NBU服务；6. 数据库准备工作：a. 数据库版本一致；b. 数据库SID一致；c. 数据库ORACLE_HOME一致；d. 数据库监听服务，目录结构和pfile文件需要一致；7. 恢复控制文件：打开Master Server恢复控制台选择FileSpecify Netbackup Machines and Policy Type。点击编辑客户机列表；添加目标和源客户机主机名选择源客户机和目标客户机以及备份类型点击 Select for Restore选择最新的控制文件点击Action

3、Restore选择恢复目标文件目录查看恢复状态。控制文件恢复到异机磁盘完毕后：a. 进入oracle用户$rmanRMANconnect target /Connected to target database: DCTM(not mount)RMANset dbid=3248879935set dbid=702089904b. 使用RMAN restore已经恢复到本地磁盘的控制文件RMANrun2allocate channel ch00 type disk;3restore controlfile from /usr/openv/script/control.ora;4release c

4、hannel ch00;5c. 将数据库置于mount状态：RMANAlter database mount;d. 使用RMAN恢复数据文件；8. 异机恢复数据文件RMAN run2 allocate channel ch00 typesbt_tape;3 send NB_ORA_CLIENT=eas02,NB_ORA_SERV=backup;4 restore database;5 release channel ch00;6 以上执行的是将数据文件基本恢复到oradata中，然后执行recoverRMAN run2 allocate channel ch00 typesbt_tape;3

5、send NB_ORA_CLIENT=svc,NB_ORA_SERV=waanbu1;4 recover database;5 release channel ch00;6 allocated channel: ch00channel ch00: sid=1639 devtype=SBT_TAPEchannel ch00: Veritas NetBackup for Oracle - Release 7.0 (2010010501)sent command to channel: ch00Starting recover at 16-MAR-11channel ch00: starting i

6、ncremental datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup setdestination for restore of datafile 00120: /oraapp1/oradata/dctm/dm_CNPDC_PK_db.dbfdestination for restore of datafile 00129: /oraapp1/oradata/dctm/dm_CNPDC_XA_ind.dbfdestination for restore of datafi

7、le 00131: /oraapp1/oradata/dctm/dm_CNPDC_CQ_ind.dbfdestination for restore of datafile 00133: /oraapp1/oradata/dctm/dm_CNPDC_JA_ind.dbfdestination for restore of datafile 00135: /oraapp1/oradata/dctm/dm_CNPDC_LJ_ind.dbfchannel ch00: reading from backup piece bk_789_1_745784966channel ch00: restored

8、backup piece 1piece handle=bk_789_1_745784966 tag=HOT_DB_BK_LEVEL0channel ch00: restore complete, elapsed time: 00:01:05channel ch00: starting incremental datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup setdestination for restore of datafile 00009: /oraapp1/orad

9、ata/dctm/dm_CNPDC_AC_db.dbfdestination for restore of datafile 00023: /oraapp1/oradata/dctm/dm_CNPDC_MX_ind.dbfdestination for restore of datafile 00048: /oraapp1/oradata/dctm/dm_CNPDC_BZ_db.dbfdestination for restore of datafile 00089: /oraapp1/oradata/dctm/dm_CNPDC_CK_ind.dbfdestination for restor

10、e of datafile 00096: /oraapp1/oradata/dctm/dm_CNPDC_HY_db.dbfchannel ch00: reading from backup piece bk_798_1_745785550channel ch00: restored backup piece 1piece handle=bk_798_1_745785550 tag=HOT_DB_BK_LEVEL0channel ch00: restore complete, elapsed time: 00:01:05channel ch00: starting incremental dat

11、afile backupset restorechannel ch00: specifying datafile(s) to restore from backup setdestination for restore of datafile 00058: /oraapp1/oradata/dctm/dm_CNPDC_WA_db.dbfdestination for restore of datafile 00082: /oraapp1/oradata/dctm/dm_CNPDC_CG_db.dbfdestination for restore of datafile 00109: /oraa

12、pp1/oradata/dctm/dm_CNPDC_AZ_ind.dbfdestination for restore of datafile 00116: /oraapp1/oradata/dctm/dm_CNPDC_BN_db.dbfdestination for restore of datafile 00128: /oraapp1/oradata/dctm/dm_CNPDC_XA_db.dbfchannel ch00: reading from backup piece bk_808_1_745786140channel ch00: restored backup piece 1pie

13、ce handle=bk_808_1_745786140 tag=HOT_DB_BK_LEVEL0channel ch00: restore complete, elapsed time: 00:01:05starting media recoverychannel ch00: starting archive log restore to default destinationchannel ch00: restoring archive logarchive log thread=1 sequence=14970channel ch00: restoring archive logarch

14、ive log thread=1 sequence=14971channel ch00: restoring archive logarchive log thread=1 sequence=14972channel ch00: reading from backup piece al_821_1_745786849channel ch00: restored backup piece 1piece handle=al_821_1_745786849 tag=TAG20110314T185921channel ch00: restore complete, elapsed time: 00:0

15、0:55archive log filename=/oraapp1/archivelog/1_14970_727030399.dbf thread=1 sequence=14970archive log filename=/oraapp1/archivelog/1_14971_727030399.dbf thread=1 sequence=14971archive log filename=/oraapp1/archivelog/1_14972_727030399.dbf thread=1 sequence=14972channel ch00: starting archive log res

16、tore to default destinationchannel ch00: restoring archive logarchive log thread=1 sequence=14982channel ch00: restoring archive logarchive log thread=1 sequence=14983channel ch00: restoring archive logarchive log thread=1 sequence=14984channel ch00: restoring archive logarchive log thread=1 sequenc

17、e=14985channel ch00: restoring archive logarchive log thread=1 sequence=14986channel ch00: restoring archive logarchive log thread=1 sequence=14987channel ch00: restoring archive logarchive log thread=1 sequence=14988channel ch00: restoring archive logarchive log thread=1 sequence=14989channel ch00:

18、 restoring archive logarchive log thread=1 sequence=14990channel ch00: reading from backup piece al_824_1_745808362channel ch00: restored backup piece 1piece handle=al_824_1_745808362 tag=TAG20110315T005922channel ch00: restore complete, elapsed time: 00:01:15channel ch00: starting archive log resto

19、re to default destinationchannel ch00: restoring archive logarchive log thread=1 sequence=14973channel ch00: restoring archive logarchive log thread=1 sequence=14974channel ch00: restoring archive logarchive log thread=1 sequence=14975channel ch00: restoring archive logarchive log thread=1 sequence=

20、14976channel ch00: restoring archive logarchive log thread=1 sequence=14977channel ch00: restoring archive logarchive log thread=1 sequence=14978channel ch00: restoring archive logarchive log thread=1 sequence=14979channel ch00: restoring archive logarchive log thread=1 sequence=14980channel ch00: r

21、estoring archive logarchive log thread=1 sequence=14981channel ch00: reading from backup piece al_823_1_745808362channel ch00: restored backup piece 1piece handle=al_823_1_745808362 tag=TAG20110315T005922channel ch00: restore complete, elapsed time: 00:01:05archive log filename=/oraapp1/archivelog/1

22、_14973_727030399.dbf thread=1 sequence=14973archive log filename=/oraapp1/archivelog/1_14974_727030399.dbf thread=1 sequence=14974archive log filename=/oraapp1/archivelog/1_14975_727030399.dbf thread=1 sequence=14975archive log filename=/oraapp1/archivelog/1_14976_727030399.dbf thread=1 sequence=149

23、76archive log filename=/oraapp1/archivelog/1_14977_727030399.dbf thread=1 sequence=14977archive log filename=/oraapp1/archivelog/1_14978_727030399.dbf thread=1 sequence=14978archive log filename=/oraapp1/archivelog/1_14979_727030399.dbf thread=1 sequence=14979archive log filename=/oraapp1/archivelog

24、/1_14980_727030399.dbf thread=1 sequence=14980archive log filename=/oraapp1/archivelog/1_14981_727030399.dbf thread=1 sequence=14981archive log filename=/oraapp1/archivelog/1_14982_727030399.dbf thread=1 sequence=14982archive log filename=/oraapp1/archivelog/1_14983_727030399.dbf thread=1 sequence=1

25、4983archive log filename=/oraapp1/archivelog/1_14984_727030399.dbf thread=1 sequence=14984archive log filename=/oraapp1/archivelog/1_14985_727030399.dbf thread=1 sequence=14985archive log filename=/oraapp1/archivelog/1_14986_727030399.dbf thread=1 sequence=14986archive log filename=/oraapp1/archivel

26、og/1_14987_727030399.dbf thread=1 sequence=14987archive log filename=/oraapp1/archivelog/1_14988_727030399.dbf thread=1 sequence=14988archive log filename=/oraapp1/archivelog/1_14989_727030399.dbf thread=1 sequence=14989archive log filename=/oraapp1/archivelog/1_14990_727030399.dbf thread=1 sequence

27、=14990unable to find archive logarchive log thread=1 sequence=14991released channel: ch00RMAN-00571: =RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =RMAN-00571: =RMAN-03002: failure of recover command at 03/16/2011 12:18:06RMAN-06054: media recovery requesting unknown log: thread 1 seq 14991 lowscn 4036

28、66149以上报错是因为需要将数据库置于新的归档中$ sqlplus /nologSQL*Plus: Release 10.2.0.4.0 - Production on Wed Mar 16 12:23:46 2011Copyright (c) 1982, 2007, Oracle. All Rights Reserved.SQL conn /as sysdba;Connected. SQL shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.SQL start

29、up mount ORACLE instance started.Total System Global Area 2.3622E+10 bytesFixed Size 2126584 bytesVariable Size 1.4194E+10 bytesDatabase Buffers 9412018176 bytesRedo Buffers 14647296 bytesDatabase mounted.SQL recover database using backup controlfile until cancel;ORA-00279: change 403666149 generate

30、d at 03/15/2011 00:59:22 needed for thread1ORA-00289: suggestion : /oraapp1/archivelog/1_14991_727030399.dbfORA-00280: change 403666149 for thread 1 is in sequence #14991Specify log: =suggested | filename | AUTO | CANCELcancelMedia recovery cancelled.SQL alter database open resetlogs;Database altered.SQLSQL select * status,instance_name from V$instance;STATUS INSTANCE_NAME- -OPEN dctm确认数据库可正常启动并能使用