ORACLE 11G HANBU異機恢復過程

1、ORACLE 11G AIX HA -NBU 異機恢復過程恢復前提兩臺機器上NUB軟件都已經(jīng)安裝好指定 Master SERVER 上的 /usr/openv/netbackup/bp.conf恢復源 FORCE_RESTORE_MEDIA_SERVER =生產(chǎn)庫 hostname 測試庫 hostname 從生產(chǎn)庫恢復到測試庫。操作目的節(jié)點POTLDB01數(shù)據(jù)庫恢復到POTLDB02即在節(jié)點POTLDB01上運行，并在節(jié)點POTLDB01上備份，恢復到POTLDB02上節(jié)點POTLDB01機器檢查過程1.檢查環(huán)境變量檢查rootPOTLDB01:/usr/openv/rmanscript#p

2、s -ef |grep smonroot 385272 4672740 10:40:22 pts/2 0:00 grep smonoracle 65548410 Jul 25- 0:06 ora_smon_portaldb機器名字rootPOTLDB01:/usr/openv/rmanscript#hostnamePOTLDB01rootPOTLDB01:/usr/openv/rmanscript#pwd -rman 腳本位置/usr/openv/rmanscriptrootPOTLDB01:/usr/openv/rmanscript#lshot_database_portaldb.sh ho

3、t_database_portaldb.sh.out hot_database_portaldb.sh_bak/etc/hosts 文件172.16.3.115172.16.3.116172.16.3.116172.16.3.1151.1.3.1151.1.3.116POTLDB01_bootPOTLDB02_bootPOTLDB02POTLDB01POTLDB01_stbyPOTLDB02_stby172.16.3.117172.16.7.142172.16.7.14310.11.233.124172.16.10.250POTLDB_svcSHYQ-PS-MV-SV03-POTLDB01-n

4、buSHYQ-PS-MV-SV03-POTLDB02-nbu 網(wǎng)關(guān) IP nbumaster yqbf原備份腳本：$RMAN target $TARGET_CONNECT_STR nocatalog msglog $RMAN_LOG_FILE append select dbid from v$database;DBID603295704查看備份記錄rootPOTLDB01:/usr/openv/netbackup/bin#./bplist -C SHYQ-PS-MV-SV03-POTLDB01-nbu -S nbumaster -t 4-R /c-603295704-20110728-02/

5、cntrl_21_1_757683165/c-603295704-20110728-01/al_bk_19_1_757682964/c-603295704-20110728-00/bk_17_1_757682762/bk_16_1_757682227/bk_603295704_11_1_757680386/cntrl_10_1_757680271/al_bk_603295704_8_1_757680166/bk_603295704_7_1_757680069/bk_603295704_6_1_757679974/cntrl_5_1_757679319/al_4_1_757679223/bk_3

6、_1_757679124/bk_2_1_757678789模擬數(shù)據(jù)庫文件被刪掉redo401.logredo402.logrootPOTLDB01:/oradata/datafiles/portaldb#pwd /oradata/datafiles/portaldb rootPOTLDB01:/oradata/datafiles/portaldb#ls archivescontrol02.ctl redo101.log redo201.log redo301.logredo501.log sysaux01.dbf temp01.dbf users01.dbf control01.ctlcont

7、rol03.ctlredo102.logredo202.log redo302.logredo502.logsystem01.dbfundotbs01.dbfrootPOTLDB01:/oradata/datafiles/portaldb#cd ./ rootPOTLDB01:/oradata/datafiles#ls portaldb rootPOTLDB01:/oradata/datafiles#ls portaldb rootPOTLDB01:/oradata/datafiles#mv portaldb portal_col rootPOTLDB01:/oradata/datafiles

8、#mkdir portaldb rootPOTLDB01:/oradata/datafiles#cd portaldb rootPOTLDB01:/oradata/datafiles/portaldb#ls rootPOTLDB01:/oradata/datafiles/portaldb#mkdir archives rootPOTLDB01:/oradata/datafiles/portaldb#chown R oracle:dba /oradata/datafiles異機恢復到POTLDB02過程rootPOTLDB02:/#lspvhdisk000c5c5666830b3farootvg

9、activehdisk100c5c5666c01952brootvgactivehdisk200c5c5366a63d937datavghdisk300c5c5366a65b992hbvgrootPOTLDB02:/#varyonvg datavgrootPOTLDB02:/#mount /dev/data_lv /oradatarootPOTLDB02:/#su - oracleoraclePOTLDB02:/home/oracle$sqlplus /nologconnSQL*Plus: Release 11.1.0.7.0 - Production on Thu Jul 28 13:32:

10、28 2011Copyright (c) 1982, 2008, Oracle. All rights reserved.SQL /as sysdba;Connected to an idle instance.SQLSQLSQLSQL exitDisconnectedoraclePOTLDB02:/home/oracle$rman target /Recovery Manager: Release 11.1.0.7.0 - Production on Thu Jul 28 13:32:49 2011Copyright (c) 1982, 2007, Oracle. All rights re

11、served.connected to target database (not started)RMAN startup nomount;Oracle instance startedTotal System Global AreaFixed SizeVariable SizeDatabase BuffersRedo Buffers43025158144 bytes2156784 bytes20669531920 bytes22280142848 bytes73326592 bytesRMAN set dbid=603295704 executing command: SET DBIDRMA

12、N restore controlfile from /oradata/rman_bak/controlfile/portal_bak_25_1_757683479;Starting restore at 28-JUL-11using target database control file instead of recovery catalogallocated channel: ORA_DISK_1channel ORA_DISK_1: SID=2188 device type=DISKchannel ORA_DISK_1: restoring control filechannel OR

13、A_DISK_1: restore complete, elapsed time: 00:00:01output file name=/oradata/datafiles/portaldb/control01.ctloutput file name=/oradata/datafiles/portaldb/control02.ctloutput file name=/oradata/datafiles/portaldb/control03.ctlFinished restore at 28-JUL-11RMAN alter database mount;database mountedRMANR

14、MANRMAN run2 3allocatechannelt1typesbt_tapeparmsENV=(NB_ORA_SERVER=nbumaster,NB_ORA_CLIENT=SHYQ-PS-MV-SV03-POTLDB01-nbu);4allocatechannelt2typesbt_tapeparmsENV=(NB_ORA_SERVER=nbumaster,NB_ORA_CLIENT=SHYQ-PS-MV-SV03-POTLDB01-nbu);5 restore database;6 switch datafile all;7 recover database;8 sql alter

15、 database open resetlogs;9 release channel t1;10 release channel t2;11 allocated channel: t1channel t1: SID=2187 device type=SBT_TAPEchannel t1: Veritas NetBackup for Oracle - Release 6.5 (2009050106)allocated channel: t2channel t2: SID=2188 device type=SBT_TAPEchannel t2: Veritas NetBackup for Orac

16、le - Release 6.5 (2009050106)Starting restore at 28-JUL-11channel t1: starting datafile backup set restorechannel t1: specifying datafile(s) to restore from backup setchannel t1: restoring datafile 00001 to /oradata/datafiles/portaldb/system01.dbfchannel t1: restoring datafile 00002 to /oradata/data

17、files/portaldb/sysaux01.dbfchannel t1: restoring datafile 00003 to /oradata/datafiles/portaldb/undotbs01.dbfchannel t1: restoring datafile 00004 to /oradata/datafiles/portaldb/users01.dbfchannel t1: reading from backup piece bk_16_1_757682227channel t1: piece handle=bk_16_1_757682227 tag=HOT_DB_BK_L

18、EVEL0channel t1: restored backup piece 1channel t1: restore complete, elapsed time: 00:03:55Finished restore at 28-JUL-11Starting recover at 28-JUL-11starting media recoverychannel t1: starting archived log restore to default destinationchannel t1: restoring archived logarchived log thread=1 sequenc

19、e=11channel t1: restoring archived logarchived log thread=1 sequence=12channel t1: reading from backup piece al_bk_19_1_757682964channel t1: piece handle=al_bk_19_1_757682964 tag=TAG20110728T112924channel t1: restored backup piece 1channel t1: restore complete, elapsed time: 00:01:25archived log fil

20、e name=/oradata/datafiles/portaldb/archives/1_11_756554328.dbf thread=1 sequence=11 archived log file name=/oradata/datafiles/portaldb/archives/1_12_756554328.dbf thread=1 sequence=12 unable to find archived logarchived log thread=1 sequence=13released channel: t1released channel: t2RMAN-00571:=RMAN-00569: = ERROR MESSAGE STACK FOLLOWS =RMAN-00571: =RMAN-03002: failure of recover command at 07/28/2011 13:44:17RMAN-06054: media recovery