数据库恢复演练
目 录
一、安装NBU客户端及Oracle代理
二、恢复控制文件
三、恢复数据库的数据文件
四、恢复数据库的归档日志
五、恢复后的数据库打开
六、检查数据库状态
七、总结
一、安装NBU客户端及Oracle代理
安装前准备工作：
NBU7.0客户端集成了oracle数据库代理，无需单独安装。
1、通过ftp将安装介质传送到测试机
Microsoft Windows [版本 5.2.3790]
(C) 版权所有 1985-2003 Microsoft Corp.
C:\Documents and Settings\Administrator>d:
D:\>cd D:\nbu-media\nbu安装介质\NBU7
D:\nbu-media\nbu安装介质\NBU7>ftp 10.138.11.89
Connected to 10.138.11.89
220 dcods1 FTP ready.
User (10.138.11.89:(none)): root
331 Password required for root.
Password:
230 User root logged in.
ftp> cd tmp
250 CWD command successful.
ftp> bin
200 Type set to I.
ftp> put NetBackup_7.0_CLIENTS_GA.tar.gz
200 PORT command successful.
150 Opening BINARY mode data connection for NetBackup_7.0_CLIENTS_GA.tar.gz.
226 Transfer complete.
ftp: 1636510252 bytes sent in 23.92Seconds 68413.12Kbytes/sec.
ftp> bye
221-You have transferred 1636510252 bytes in 1 files.
221-Total traffic for this session was 1636510733 bytes in 1 transfers.
221-Thank you for using the FTP service on test2.
221 Goodbye.
2、在备份服务器端配置一般服务器：
3、在 /etc/hosts中添加备份主服务器的主机名和IP地址：
dcods1:/#cat /etc/hosts
## Configured using SAM by root on Fri Aug 19 07:21:23 2011
## Configured using SAM by root on Fri Aug 19 07:20:36 2011
# @(#)B11.23_LRhosts $Revision: 1.9.214.1 $ $Date: 96/10/08 13:20:01 $
#
# The form for each entry is:
#
#
# For example:
# 192.1.2.34 hpfcrm loghost
#
# See the hosts(4) manual page for more information.
# Note: The entries cannot be preceded by a space.
# The format described in this file is the correct format.
# The original Berkeley manual page contains an error in
# the format description.
#
127.0.0.1 localhost loopback
10.138.11.89 dcods1
10.138.11.90 pmosdb2
192.168.100.1 dcods1_priv
192.168.100.2 pmosdb2_priv
10.138.11.121 dcods1-vip
10.138.11.122 pmosdb2-vip
10.138.17.122 yx-nbu
10.138.2.65 ERPDBCI1
dcods1:/#
4、配置bp.conf文件
# cat bp.conf
SERVER = yx-nbu
CLIENT_NAME = dcods1
5、在测试恢复演练机dcods1上安装NBU客户端
Symantec Installation Script
Copyright 1993 - 2010 Symantec Corporation, All Rights Reserved.
Installing NetBackup Client Software
Do you wish to continue? [y,n] (y) y
Do you want to install the NetBackup client software for this client? [y,n] (y) y
This package will install RS6000/AIX53 client.
This package will install NetBackup client 7.0.
Enter the name of the NetBackup server : nbuserver1
Would you like to use "dcods1" as the configured
name of the NetBackup client? [y,n] (y) y
tar: can't create openv/lib/libcatbackup.so: Text file busy
x openv
x openv/lib
x openv/lib/map
x openv/lib/map/aix64
x openv/lib/map/aix64/libaixlvm.so, 81220 bytes, 159 tape blocks
x openv/lib/map/aix64/libdisk.so, 74721 bytes, 146 tape blocks
x openv/lib/map/aix64/libemcpower.so, 74900 bytes, 147 tape blocks
x openv/lib/map/aix64/libgfsp.so, 98059 bytes, 192 tape blocks
x openv/lib/map/aix64/libjfs.so, 123146 bytes, 241 tape blocks
x openv/lib/map/aix64/libjfs2.so, 129175 bytes, 253 tape blocks
x openv/lib/vxfi
x openv/lib/vxfi/data
x openv/lib/vxfi/data/vfiid_schema.xsd, 5495 bytes, 11 tape blocks
x openv/lib/vxfi/providers
x openv/lib/vxfi/providers/libaixlvmfiST.so, 2903542 bytes, 5671 tape blocks
x openv/lib/vxfi/providers/libaixlvmfi.so, 2944478 bytes, 5751 tape blocks
x openv/lib/vxfi/providers/libdevicefiST.so, 2991365 bytes, 5843 tape blocks
x openv/lib/vxfi/providers/libdevicefi.so, 3050844 bytes, 5959 tape blocks
x openv/lib/vxfi/providers/libemcclariionfi.so, 3870779 bytes, 7561 tape blocks
x openv/lib/vxfi/providers/libemcsymfi.so, 5204662 bytes, 10166 tape blocks
x openv/lib/vxfi/providers/libemcclariionfiST.so, 3830199 bytes, 7481 tape blocks
x openv/lib/vxfi/providers/libhpevafi.so, 3512547 bytes, 6861 tape blocks
x openv/lib/vxfi/providers/libemcsymfiST.so, 5164729 bytes, 10088 tape blocks
x openv/lib/vxfi/providers/libibmtsfi.so, 3714445 bytes, 7255 tape blocks
x openv/lib/vxfi/providers/libhpevafiST.so, 3464555 bytes, 6767 tape blocks
x openv/lib/vxfi/providers/libibmdsfi.so, 3597468 bytes, 7027 tape blocks
x openv/lib/vxfi/providers/libibmdsfiST.so, 3551648 bytes, 6937 tape blocks
x openv/lib/vxfi/providers/libvxfsfi.so, 2287778 bytes, 4469 tape blocks
x openv/lib/vxfi/providers/libibmtsfiST.so, 3665517 bytes, 7160 tape blocks
x openv/lib/vxfi/providers/libjfsfi.so, 2482921 bytes, 4850 tape blocks
x openv/lib/vxfi/providers/libjfsfiST.so, 2434933 bytes, 4756 tape blocks
x openv/lib/vxfi/providers/libnetappfi.so, 3541761 bytes, 6918 tape blocks
x openv/lib/vxfi/providers/libnetappfiST.so, 3486058 bytes, 6809 tape blocks
x openv/lib/vxfi/providers/libvxvmfi.so, 4364694 bytes, 8525 tape blocks
x openv/lib/vxfi/providers/libvxfsfiST.so, 2254130 bytes, 4403 tape blocks
x openv/lib/vxfi/providers/libvxvmfiST.so, 4286904 bytes, 8373 tape blocks
x openv/lib/lib32
x openv/lib/lib32/libvxACEST.so.3, 2180812 bytes, 4260 tape blocks
x openv/lib/lib32/libvxACE.so.3, 2518960 bytes, 4920 tape blocks
x openv/lib/lib32/libvxicui18n.so, 1394889 bytes, 2725 tape blocks
x openv/lib/lib32/libvxicudata.so, 8564349 bytes, 16728 tape blocks
x openv/lib/lib32/libvxicudataST.so, 8563259 bytes, 16726 tape blocks
x openv/lib/lib32/libvxicuuc.so, 1104895 bytes, 2158 tape blocks
x openv/lib/lib32/libvxicui18nST.so, 1394763 bytes, 2725 tape blocks
x openv/lib/lib32/libvxustdio.so, 143961 bytes, 282 tape blocks
x openv/lib/lib32/libvxicuucST.so, 1100382 bytes, 2150 tape blocks
x openv/lib/lib32/libvxustdioST.so, 143679 bytes, 281 tape blocks
x openv/lib/libbpora64.so.9.0, 50985 bytes, 100 tape blocks
x openv/lib/libVmangle.so, 21091 bytes, 42 tape blocks
x openv/lib/libbpfsmap.so, 308847 bytes, 604 tape blocks
x openv/lib/libfi_BusinessCopy.so, 141751 bytes, 277 tape blocks
x openv/lib/libcatbackupMT.so, 42401 bytes, 83 tape blocks
x openv/lib/libdbsb.so, 101956 bytes, 200 tape blocks
x openv/lib/libdbsbdb2.so, 1897718 bytes, 3707 tape blocks
x openv/lib/libdbsbrman.so, 1784131 bytes, 3485 tape blocks
x openv/lib/libdmpclaim.so, 828067 bytes, 1618 tape blocks
x openv/lib/libdmpclaimST.so, 809947 bytes, 1582 tape blocks
x openv/lib/libfi.so, 1256787 bytes, 2455 tape blocks
x openv/lib/libfiST.so, 1250393 bytes, 2443 tape blocks
x openv/lib/libfiprocessbackups.so, 623139 bytes, 1218 tape blocks
x openv/lib/libfi_NAS_Snapshot.so, 667502 bytes, 1304 tape blocks
x openv/lib/libfi_FlashSnap.so, 147782 bytes, 289 tape blocks
x openv/lib/libfi_ShadowImage.so, 142079 bytes, 278 tape blocks
x openv/lib/libnbbase.so, 3492006 bytes, 6821 tape blocks
x openv/lib/libnbbase32.so, 1915938 bytes, 3743 tape blocks
x openv/lib/libnbbaseST.so_new, 3080236 bytes, 6017 tape blocks
x openv/lib/libnbbaseST32.so_ntar: can't create openv/lib/libnborbST.so: Text file busy
ew, 1722871 bytes, 3365 tape blocks
x openv/lib/libnbbasecST.so, 796697 bytes, 1557 tape blocks
x openv/lib/libnbbasecST32.so, 700155 bytes, 1368 tape blocks
x openv/lib/libnbclient.so, 564525 bytes, 1103 tape blocks
x openv/lib/libnbclient32.so, 476331 bytes, 931 tape blocks
x openv/lib/libnbclientST.so_new, 577238 bytes, 1128 tape blocks
x openv/lib/libnbclientST32.so_new, 489607 bytes, 957 tape blocks
x openv/lib/libnbclientcST.so, 372156 bytes, 727 tape blocks
x openv/lib/libxbsa64.so, 637629 bytes, 1246 tape blocks
x openv/lib/libnbclientcST32.so, 327649 bytes, 640 tape blocks
x openv/lib/libonline_util_data.so, 8359 bytes, 17 tape blocks
x openv/lib/aix64
x openv/lib/aix64/libvfutil.so, 248573 bytes, 486 tape blocks
x openv/lib/aix64/libmap.so, 86629 bytes, 170 tape blocks
x openv/lib/libvxSigScheduleJNI2.so, 2530175 bytes, 4942 tape blocks
x openv/lib/libfi_TimeFinder.so, 180068 bytes, 352 tape blocks
x openv/lib/libfi_VVR.so, 141129 bytes, 276 tape blocks
x openv/lib/libfi_auto.so, 33542 bytes, 66 tape blocks
x openv/lib/libfi_vxfs.so, 66184 bytes, 130 tape blocks
x openv/lib/libfi_vxfs_ckpt.so, 117193 bytes, 229 tape blocks
x openv/lib/libfi_vxvm.so, 156822 bytes, 307 tape blocks
x openv/lib/libficmn_4_4.so, 1339553 bytes, 2617 tape blocks
x openv/lib/libficmn_4_4ST.so, 1338861 bytes, 2615 tape blocks
x openv/lib/libfipdk_4_4.so, 5453487 bytes, 10652 tape blocks
x openv/lib/libfipdk_4_4ST.so, 5377176 bytes, 10503 tape blocks
x openv/lib/libvrtsLogFormatMsg.so.3, 63048 bytes, 124 tape blocks
x openv/lib/libfiprocessbackupsST.so, 623086 bytes, 1217 tape blocks
x openv/lib/libfiutil.so, 884191 bytes, 1727 tape blocks
x openv/lib/libfiutilST.so, 864065 bytes, 1688 tape blocks
x openv/lib/libnbccl.so, 231904 bytes, 453 tape blocks
x openv/lib/libsthpitar.so, 82018 bytes, 161 tape blocks
x openv/lib/libnbmangle.so_new, 2790450 bytes, 5451 tape blocks
x openv/lib/libnbmangleMT.so, 2790202 bytes, 5450 tape blocks
x openv/lib/libnborb.so, 4797572 bytes, 9371 tape blocks
x openv/lib/libnbservercom.so, 1929964 bytes, 3770 tape blocks
x openv/lib/libnbservice.so, 1304767 bytes, 2549 tape blocks
x openv/lib/libncf.so, 10864659 bytes, 21221 tape blocks
x openv/lib/libonline_util.so, 448731 bytes, 877 tape blocks
x openv/lib/libscsitool.so, 2009639 bytes, 3926 tape blocks
x openv/lib/libscsitoolST.so, 1970806 bytes, 3850 tape blocks
x openv/lib/libsprtool.so, 629925 bytes, 1231 tape blocks
x openv/lib/libsprtoolST.so, 606950 bytes, 1186 tape blocks
x openv/lib/libsth.so, 23064 bytes, 46 tape blocks
x openv/lib/libsthMT.so, 28034 bytes, 55 tape blocks
x openv/lib/libsthpitarMT.so, 89129 bytes, 175 tape blocks
x openv/lib/libvnbln.so, 220448 bytes, 431 tape blocks
x openv/lib/libsts.so, 275766 bytes, 539 tape blocks
x openv/lib/libstsMT.so, 287109 bytes, 561 tape blocks
x openv/lib/libstspicp.so, 81724 bytes, 160 tape blocks
x openv/lib/libxm.so, 67832 bytes, 133 tape blocks
x openv/lib/libubs.so, 197038 bytes, 385 tape blocks
x openv/lib/libvdes40.so, 27371 bytes, 54 tape blocks
x openv/lib/libvdes40_32.so, 24681 bytes, 49 tape blocks
x openv/lib/libvdes56.so, 6256 bytes, 13 tape blocks
x openv/lib/libvdes56_32.so, 5382 bytes, 11 tape blocks
x openv/lib/libvfms.so, 198078 bytes, 387 tape blocks
x openv/lib/libvfms_glue.so, 62427 bytes, 122 tape blocks
x openv/lib/libtfi.so, 6308006 bytes, 12321 tape blocks
x openv/lib/libvxexticuST.so.3_new, 105292 bytes, 206 tape blocks
x openv/lib/libvrtsLogFormatMsgST.so.3_new, 63034 bytes, 124 tape blocks
x openv/lib/libvrtsLogRead.so.3, 120228 bytes, 235 tape blocks
x openv/lib/libvrtsLogReadST.so.3_new, 120216 bytes, 235 tape blocks
x openv/lib/libvrtsLogSL.so.3, 46849 bytes, 92 tape blocks
x openv/lib/libvrtsLogSLST.so.3_new, 46883 bytes, 92 tape blocks
x openv/lib/libvxACE.so.3, 2541696 bytes, 4965 tape blocks
x openv/lib/libvxACEST.so.3_new, 2226579 bytes, 4349 tape blocks
x openv/lib/libvxACEXML.so.3, 361123 bytes, 706 tape blocks
x openv/lib/libvxACEXML_Parser.so.3, 105164 bytes, 206 tape blocks
x openv/lib/libvxPBX.so, 65668 bytes, 129 tape blocks
x openv/lib/libvxPBXCommon.so, 3031tar: can't create openv/lib/libvxPBXST.so: Text file busy
tar: can't create openv/lib/libvxPBXCommonST.so: Text file busy
tar: can't create openv/lib/libvxPBXIOPST.so: Text file busy
tar: can't create openv/lib/libvxPBXVxSSST.so: Text file busy
tar: can't create openv/lib/libvxVxSSIOPST.so: Text file busy
2 bytes, 60 tape blocks
x openv/lib/libvxPBXIOP.so, 1086658 bytes, 2123 tape blocks
x openv/lib/libvxPBXVxSS.so, 650709 bytes, 1271 tape blocks
x openv/lib/libxbsaMT64.so, 640961 bytes, 1252 tape blocks
x openv/lib/libvxTAO.so.3, 4997506 bytes, 9761 tape blocks
x openv/lib/libvxTAO_BiDirGIOP.so.3, 171167 bytes, 335 tape blocks
x openv/lib/libvxTAO_CosNaming.so.3, 2072037 bytes, 4047 tape blocks
x openv/lib/libvxTAO_CosNotification.so.3, 19669285 bytes, 38417 tape blocks
x openv/lib/libvxTAO_DynamicAny.so.3, 1054888 bytes, 2061 tape blocks
x openv/lib/libvxTAO_ETCL.so.3, 113670 bytes, 223 tape blocks
x openv/lib/libvxTAO_IORTable.so.3, 155697 bytes, 305 tape blocks
x openv/lib/libvxVxSSIOP.so, 2356699 bytes, 4603 tape blocks
x openv/lib/libstspicpMT.so, 80426 bytes, 158 tape blocks
x openv/lib/libvxTAO_Messaging.so.3, 860033 bytes, 1680 tape blocks
x openv/lib/libvxTAO_PortableServer.so.3, 3717384 bytes, 7261 tape blocks
x openv/lib/libvxTAO_Security.so.3, 1802807 bytes, 3522 tape blocks
x openv/lib/libvxTAO_Svc_Utils.so.3, 79353 bytes, 155 tape blocks
x openv/lib/libvxcrypto.so, 2981645 bytes, 5824 tape blocks
x openv/lib/libvxcryptoST.so, 2980411 bytes, 5822 tape blocks
x openv/lib/libvxexticu.so.3, 105307 bytes, 206 tape blocks
x openv/lib/libvxicudataST.so_new, 8488448 bytes, 16579 tape blocks
x openv/lib/libvxicudata.so, 8492164 bytes, 16587 tape blocks
x openv/lib/libvxicui18nST.so_new, 1574808 bytes, 3076 tape blocks
x openv/lib/libvxicui18n.so, 1575116 bytes, 3077 tape blocks
x openv/lib/libvxicuucST.so_new, 1260292 bytes, 2462 tape blocks
x openv/lib/libvxicuuc.so, 1265340 bytes, 2472 tape blocks
x openv/lib/libvxlisST.so.3_new, 49302 bytes, 97 tape blocks
x openv/lib/libvxlis.so.3, 49288 bytes, 97 tape blocks
x openv/lib/libvxulST.so.3_new, 250416 bytes, 490 tape blocks
x openv/lib/libvxssl.so, 487504 bytes, 953 tape blocks
x openv/lib/libvxsslST.so, 487425 bytes, 953 tape blocks
x openv/lib/libvxul.so.3, 255640 bytes, 500 tape blocks
x openv/lib/libvxustdioST.so_new, 164809 bytes, 322 tape blocks
x openv/lib/libvxustdio.so, 165144 bytes, 323 tape blocks
x openv/lib/libvxxml4cST.so, 5953089 bytes, 11628 tape blocks
x openv/lib/libvxxml4c.so, 5957556 bytes, 11636 tape blocks
x openv/lib/libxbsa.so, 572264 bytes, 1118 tape blocks
x openv/lib/libxbsaMT.so, 569430 bytes, 1113 tape blocks
x openv/lib/libnbci.so, 340733 bytes, 666 tape blocks
x openv/lib/libpibeds.so, 346591 bytes, 677 tape blocks
x openv/lib/libpidb2.so, 1841253 bytes, 3597 tape blocks
x openv/lib/libpioracle.so, 2383128 bytes, 4655 tape blocks
x openv/lib/libpitar.so, 404159 bytes, 790 tape blocks
x openv/lib/libpivxms.so, 375356 bytes, 734 tape blocks
x openv/lib/libpiwin.so, 333608 bytes, 652 tape blocks
x openv/lib/librai.so, 804824 bytes, 1572 tape blocks
x openv/lib/libnbcclST.so, 231898 bytes, 453 tape blocks
x openv/lib/libstspishmem.so, 112953 bytes, 221 tape blocks
x openv/lib/libstspishmemMT.so, 113824 bytes, 223 tape blocks
x openv/msg
x openv/msg/.conf, 20720 bytes, 41 tape blocks
x openv/netbackup
x openv/netbackup/bin
x openv/netbackup/bin/goodies
x openv/netbackup/bin/goodies/support
x openv/netbackup/bin/goodies/support/versioninfo, 292197 bytes, 571 tape blocks
x openv/netbackup/bin/goodies/migrate_vxul_logs, 3545 bytes, 7 tape blocks
x openv/netbackup/bin/goodies/jlu.jar, 2032430 bytes, 3970 tape blocks
x openv/netbackup/bin/goodies/netbackup, 17510 bytes, 35 tape blocks
x openv/netbackup/bin/private
x openv/netbackup/bin/private/nblogcfg, 77938 bytes, 153 tape blocks
x openv/netbackup/bin/private/nbloggen, 52183 bytes, 102 tape blocks
x openv/netbackup/bin/private/nblogmgr, 55331 bytes, 109 tape blocks
x openv/netbackup/bin/private/nblogview, 80468 bytes, 158 tape blocks
x openv/netbackup/bin/support
x openv/netbackup/bin/support/nbcplogs, 4398758 bytes, 8592 tape blocks
x openv/netbackup/bin/support/nbsu, 1503062 bytes, 2936 tape blocks
x openv/netbackup/bin/bpbackup, 68281 bytes, 134 tape blocks
x openv/netbackup/bin/bp, 205847 bytes, 403 tape blocks
x openv/netbackup/bin/SPSRecoveryAsst, 24717 bytes, 49 tape blocks
x openv/netbackup/bin/backint, 1741095 bytes, 3401 tape blocks
x openv/netbackup/bin/bmrbd, 45262073 bytes, 88403 tape blocks
x openv/netbackup/bin/bmrc, 39253295 bytes, 76667 tape blocks
x openv/netbackup/bin/bmrsavecfg, 53168655 bytes, 103846 tape blocks
x openv/netbackup/bin/bmrsetupboot, 41101280 bytes, 80276 tape blocks
x openv/netbackup/bin/bmrsetupclient, 35887324 bytes, 70093 tape blocks
x openv/netbackup/bin/bmrsrtadm, 46330921 bytes, 90491 tape blocks
x openv/netbackup/bin/bpdynamicclient, 32359 bytes, 64 tape blocks
x openv/netbackup/bin/bp.kill_all, 21456 bytes, 42 tape blocks
x openv/netbackup/bin/bp.start_all, 5308 bytes, 11 tape blocks
x openv/netbackup/bin/bpbkar, 882143 bytes, 1723 tape blocks
x openv/netbackup/bin/bpcd_new, 1094012 bytes, 2137 tape blocks
x openv/netbackup/bin/bpclimagelist, 50676 bytes, 99 tape blocks
x openv/netbackup/bin/bpclntcmd, 68651 bytes, 135 tape blocks
x openv/netbackup/bin/bpdb2proxy, 1234305 bytes, 2411 tape blocks
x openv/netbackup/bin/bpdbsbdb2, 1247157 bytes, 2436 tape blocks
x openv/netbackup/bin/bpdbsbora, 102634 bytes, 201 tape blocks
x openv/netbackup/bin/bpdgclone, 82000 bytes, 161 tape blocks
x openv/netbackup/bin/bpjava-msvc, 402872 bytes, 787 tape blocks
x openv/netbackup/bin/bpfilter, 826994 bytes, 1616 tape blocks
x openv/netbackup/bin/bpfis, 155289 bytes, 304 tape blocks
x openv/netbackup/bin/bpVMreq, 27757 bytes, 55 tape blocks
x openv/netbackup/bin/bphdb, 111834 bytes, 219 tape blocks
x openv/netbackup/bin/bpjava-usvc, 404918 bytes, 791 tape blocks
x openv/netbackup/bin/bpkeyfile, 56039 bytes, 110 tape blocks
x openv/netbackup/bin/bpkeyutil, 802855 bytes, 1569 tape blocks
x openv/netbackup/bin/bplist, 51749 bytes, 102 tape blocks
x openv/netbackup/bin/bpmount, 45520 bytes, 89 tape blocks
x openv/netbackup/bin/bpnbat, 90495 bytes, 177 tape blocks
x openv/netbackup/bin/bporaexp64, 161251 bytes, 315 tape blocks
x openv/netbackup/bin/bporaimp64, 174839 bytes, 342 tape blocks
x openv/netbackup/bin/bppfi, 168220 bytes, 329 tape blocks
x openv/netbackup/bin/bpps, 194019 bytes, 379 tape blocks
x openv/netbackup/bin/bprestore, 92786 bytes, 182 tape blocks
x openv/netbackup/bin/bptpcinfo, 70788 bytes, 139 tape blocks
x openv/netbackup/bin/bpubsdb2, 58356 bytes, 114 tape blocks
x openv/netbackup/bin/bpubsora, 58444 bytes, 115 tape blocks
x openv/netbackup/bin/bpvxver, 4771 bytes, 10 tape blocks
x openv/netbackup/bin/informix_config, 8641 bytes, 17 tape blocks
x openv/netbackup/bin/nbcs, 2207318 bytes, 4312 tape blocks
x openv/netbackup/bin/nbfirescan, 657811 bytes, 1285 tape blocks
x openv/netbackup/bin/db2_config, 7155 bytes, 14 tape blocks
x openv/netbackup/bin/db2rhf.64, 65176 bytes, 128 tape blocks
x openv/netbackup/bin/db2uext2.64, 112721 bytes, 221 tape blocks
x openv/netbackup/bin/fsmap, 73049 bytes, 143 tape blocks
x openv/netbackup/bin/infxbsa.so, 1333987 bytes, 2606 tape blocks
x openv/netbackup/bin/infxbsa.so64, 1497901 bytes, 2926 tape blocks
x openv/netbackup/bin/libobk.a64, 1605289 bytes, 3136 tape blocks
x openv/netbackup/bin/libsapora.a64, 1605289 bytes, 3136 tape blocks
x openv/netbackup/bin/libsybackup.sl, 44214 bytes, 87 tape blocks
x openv/netbackup/bin/lotusnotes_config, 5743 bytes, 12 tape blocks
x openv/netbackup/bin/mkfifo, 5408 bytes, 11 tape blocks
x openv/netbackup/bin/mkisofs, 885545 bytes, 1730 tape blocks
x openv/netbackup/bin/mtfrd, 220556 bytes, 431 tape blocks
x openv/netbackup/bin/nbdb2.sl64, 122559 bytes, 240 tape blocks
x openv/netbackup/bin/rc.bmrbd, 1673 bytes, 4 tape blocks
x openv/netbackup/bin/nbfs, 37963 bytes, 75 tape blocks
x openv/netbackup/bin/nbftclnt, 6008064 bytes, 11735 tape blocks
x openv/netbackup/bin/nbliveup, 68842 bytes, 135 tape blocks
x openv/netbackup/bin/nblnagent, 87338 bytes, 171 tape blocks
x openv/netbackup/bin/nblnagent64, 98391 bytes, 193 tape blocks
x openv/netbackup/bin/nblndb2, 25276 bytes, 50 tape blocks
x openv/netbackup/bin/nblu_registration, 31043 bytes, 61 tape blocks
x openv/netbackup/bin/ndmpclient, 1512333 bytes, 2954 tape blocks
x openv/netbackup/bin/oracle_link, 25427 bytes, 50 tape blocks
x openv/netbackup/bin/vxlogcfg, 999 bytes, 2 tape blocks
x openv/netbackup/bin/sybase_config, 11145 bytes, 22 tape blocks
x openv/netbackup/bin/vnetd_new, 69037 bytes, 135 tape blocks
x openv/netbackup/bin/vxlogmgr, 994 bytes, 2 tape blocks
x openv/netbackup/bin/vxlogview, 996 bytes, 2 tape blocks
x openv/netbackup/bin/nbostpxy, 11346003 bytes, 22161 tape blocks
x openv/netbackup/bin/nbbrowse, 815430 bytes, 1593 tape blocks
x openv/netbackup/bin/nborautil, 797799 bytes, 1559 tape blocks
x openv/netbackup/bin/bptestnetconn, 308767 bytes, 604 tape blocks
x openv/netbackup/ext
x openv/netbackup/ext/db_ext
x openv/netbackup/ext/db_ext/db2
x openv/netbackup/ext/db_ext/db2/scripts
x openv/netbackup/ext/db_ext/db2/scripts/db2_all_backup_mpp, 5269 bytes, 11 tape blocks
x openv/netbackup/ext/db_ext/db2/scripts/db2.conf, 2514 bytes, 5 tape blocks
x openv/netbackup/ext/db_ext/db2/scripts/db2_backup, 1736 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/db2/scripts/db2_all_restore_mpp, 5383 bytes, 11 tape blocks
x openv/netbackup/ext/db_ext/db2/scripts/db2_restore, 1245 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/informix
x openv/netbackup/ext/db_ext/informix/scripts
x openv/netbackup/ext/db_ext/informix/scripts/informix_dbspace_list, 17 bytes, 1 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/informix_onbar_backup_of_dbspace1, 2035 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/informix_logical_log_backup, 1806 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/informix_onbar_backup_using_file_list, 2180 bytes, 5 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/informix_onbar_backup_of_rootdbs, 2024 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/infx_remove_expired_images, 2375 bytes, 5 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/informix_onbar_backup_of_rootdbs_and_dbspace1, 2062 bytes, 5 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/informix_onbar_restore_dbspace1, 1130 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/informix_onbar_restore_rootdbs, 1109 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/informix/scripts/informix_onbar_whole_backup, 1958 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle
x openv/netbackup/ext/db_ext/oracle/bin
x openv/netbackup/ext/db_ext/oracle/bin/setup_bli_scripts, 18091 bytes, 36 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples
x openv/netbackup/ext/db_ext/oracle/samples/bporaexp
x openv/netbackup/ext/db_ext/oracle/samples/bporaexp/bporaexp_help.param, 733 bytes, 2 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaexp/bporaexp_table_to_files.param, 1652 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaexp/bporaexp_partitions.param, 1605 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaexp/bporaexp_tables_rows.param, 1868 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaexp/bporaexp_tables.param, 1669 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaexp/data_archiver_export.sh, 5124 bytes, 11 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaexp/data_archiver_export64.sh, 5130 bytes, 11 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_archive.param, 1242 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/data_archiver_import.sh, 5044 bytes, 10 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_archive_schema_to_files.param, 1317 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_archive_to_users.param, 1510 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_bfile_table.param, 1604 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_help.param, 733 bytes, 2 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_ignore_rows_table.param, 1530 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_large_table.param, 1542 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_list.param, 1594 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_old_archive.param, 1556 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_partitions.param, 1513 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_table_from_files.param, 1370 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_table_to_files.param, 1301 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_table_to_user.param, 1656 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/bporaimp_tables.param, 1289 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bporaimp/data_archiver_import64.sh, 5050 bytes, 10 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/rman
x openv/netbackup/ext/db_ext/oracle/samples/rman/cold_database_backup.sh, 11875 bytes, 24 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/rman/cold_duplex_database_backup_full.sh, 12789 bytes, 25 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/rman/database_restore.sh, 7155 bytes, 14 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/rman/hot_database_backup.sh, 11538 bytes, 23 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/rman/hot_tablespace_backup.sh, 11154 bytes, 22 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/rman/hot_database_backup_proxy.sh, 9983 bytes, 20 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/rman/pit_database_restore.sh, 10307 bytes, 21 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/rman/hot_tablespace_backup_proxy.sh, 8575 bytes, 17 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bpstart_notify.oracle_bli.sh, 31867 bytes, 63 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/bpend_notify.oracle_bli.sh, 27764 bytes, 55 tape blocks
x openv/netbackup/ext/db_ext/oracle/samples/post_checkpoint_notify.oracle_bli.sh, 21844 bytes, 43 tape blocks
x openv/netbackup/ext/db_ext/sap
x openv/netbackup/ext/db_ext/sap/scripts
x openv/netbackup/ext/db_ext/sap/scripts/sap_maxdb
x openv/netbackup/ext/db_ext/sap/scripts/sap_maxdb/sap_maxdb_backup, 2319 bytes, 5 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/sap_custom_sort_file, 1055 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/bplist_filter, 1240 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/initSAP.sap, 6868 bytes, 14 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/initSAP.utl, 15240 bytes, 30 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/restore_filter, 1240 bytes, 3 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/sap_redo_log_backup, 2557 bytes, 5 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/sap_offline_backup, 1795 bytes, 4 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/sap_online_backup, 3746 bytes, 8 tape blocks
x openv/netbackup/ext/db_ext/sap/scripts/sap_oracle/sap_rman_backup, 2352 bytes, 5 tape blocks
x openv/netbackup/ext/db_ext/sybase
x openv/netbackup/ext/db_ext/sybase/scripts
x openv/netbackup/ext/db_ext/sybase/scripts/sybase_mydb_restore, 3031 bytes, 6 tape blocks
x openv/netbackup/ext/db_ext/sybase/scripts/sybase_mydb_backup, 5870 bytes, 12 tape blocks
x openv/netbackup/ext/db_ext/sybase/scripts/sybase_mydb_load, 282 bytes, 1 tape blocks
x openv/netbackup/sec
x openv/netbackup/sec/at
x openv/netbackup/sec/at/bin
x openv/netbackup/sec/at/bin/vssatbin, 15254393 bytes, 29794 tape blocks
x openv/netbackup/sec/at/bin/vssat, 12233 bytes, 24 tape blocks
x openv/netbackup/sec/at/catalog
x openv/netbackup/sec/at/catalog/en
x openv/netbackup/sec/at/catalog/en/atclimsg.txt, 81872 bytes, 160 tape blocks
x openv/netbackup/sec/at/lib
x openv/netbackup/sec/at/lib/libauthlocalhostc.so, 531323 bytes, 1038 tape blocks
x openv/netbackup/sec/at/lib/libAtWrapper.so, 498115 bytes, 973 tape blocks
x openv/netbackup/sec/at/lib/libauthgssapic.so, 1710745 bytes, 3342 tape blocks
x openv/netbackup/sec/at/lib/libauthlocalhostc_t.so, 549466 bytes, 1074 tape blocks
x openv/netbackup/sec/at/lib/libvrtsat.so, 3333954 bytes, 6512 tape blocks
x openv/netbackup/sec/at/lib/libvrtsat4L.so, 29183 bytes, 57 tape blocks
x openv/netbackup/sec/at/lib/libvrtsat4L_t.so, 31269 bytes, 62 tape blocks
x openv/netbackup/sec/at/lib/libvrtsat_t.so, 3352210 bytes, 6548 tape blocks
x openv/netbackup/nblu.conf.template, 1012 bytes, 2 tape blocks
x openv/netbackup/nblog.conf.template, 7662 bytes, 15 tape blocks
x openv/netbackup/vfm.conf, 10370 bytes, 21 tape blocks
x openv/resources
x openv/resources/bmrcommon_root.res, 167752 bytes, 328 tape blocks
x openv/resources/SPSV2RecoveryAsst_root.res, 4692 bytes, 10 tape blocks
x openv/resources/aggs_root.res, 244 bytes, 1 tape blocks
x openv/resources/bmrc_root.res, 3864 bytes, 8 tape blocks
x openv/resources/bmrlaunch_root.res, 100 bytes, 1 tape blocks
x openv/resources/bmrd_root.res, 5836 bytes, 12 tape blocks
x openv/resources/bmrrestore_root.res, 31108 bytes, 61 tape blocks
x openv/resources/bmrmedia_root.res, 100 bytes, 1 tape blocks
x openv/resources/bmrpkg_root.res, 100 bytes, 1 tape blocks
x openv/resources/libemcclariionfi_root.res, 3696 bytes, 8 tape blocks
x openv/resources/bmrsavecfg_root.res, 8796 bytes, 18 tape blocks
x openv/resources/bmrsetup_root.res, 6744 bytes, 14 tape blocks
x openv/resources/bmrsrt_root.res, 72808 bytes, 143 tape blocks
x openv/resources/ftclient_root.res, 324 bytes, 1 tape blocks
x openv/resources/libaixlvmfi_root.res, 4108 bytes, 9 tape blocks
x openv/resources/libdevicefi_root.res, 1780 bytes, 4 tape blocks
x openv/resources/libemcsymfi_root.res, 2396 bytes, 5 tape blocks
x openv/resources/libfi_root.res, 18308 bytes, 36 tape blocks
x openv/resources/libhpevafi_root.res, 6728 bytes, 14 tape blocks
x openv/resources/libibmdsfi_root.res, 7048 bytes, 14 tape blocks
x openv/resources/libibmtsfi_root.res, 7244 bytes, 15 tape blocks
x openv/resources/libjfsfi_root.res, 3540 bytes, 7 tape blocks
x openv/resources/libnetappfi_root.res, 2132 bytes, 5 tape blocks
x openv/resources/libraries_root.res, 19808 bytes, 39 tape blocks
x openv/resources/libvxfsfi_root.res, 2064 bytes, 5 tape blocks
x openv/resources/libvxvmfi_root.res, 5260 bytes, 11 tape blocks
x openv/resources/nbecmsg_root.res, 52856 bytes, 104 tape blocks
x openv/resources/vxul_root.res, 65136 bytes, 128 tape blocks
x openv/resources/ncf_root.res, 6212 bytes, 13 tape blocks
x openv/resources/ncfbedspi_root.res, 60 bytes, 1 tape blocks
x openv/resources/ncfdb2pi_root.res, 1912 bytes, 4 tape blocks
x openv/resources/ftserver_root.res, 344 bytes, 1 tape blocks
x openv/resources/ftsm_root.res, 740 bytes, 2 tape blocks
x openv/resources/ncfgre_root.res, 1848 bytes, 4 tape blocks
x openv/resources/ncfive_root.res, 60 bytes, 1 tape blocks
x openv/resources/ncflbc_root.res, 532 bytes, 2 tape blocks
x openv/resources/ncfnbbrowse_root.res, 172 bytes, 1 tape blocks
x openv/resources/ncfnbrestore_root.res, 60 bytes, 1 tape blocks
x openv/resources/ncfnbservercom_root.res, 1204 bytes, 3 tape blocks
x openv/resources/ncforaclepi_root.res, 2232 bytes, 5 tape blocks
x openv/resources/ncforautil_root.res, 320 bytes, 1 tape blocks
x openv/resources/ncfrai_root.res, 4444 bytes, 9 tape blocks
x openv/resources/ncftarpi_root.res, 212 bytes, 1 tape blocks
x openv/resources/ncftfi_root.res, 980 bytes, 2 tape blocks
x openv/resources/ncfvxmspi_root.res, 60 bytes, 1 tape blocks
x openv/resources/ncfwinpi_root.res, 60 bytes, 1 tape blocks
x openv/resources/ncfnbcs_root.res, 812 bytes, 2 tape blocks
x openv/share
x openv/share/ciphers.txt, 749 bytes, 2 tape blocks
x openv/var
x openv/var/vnetd
x openv/var/vnetd/inetd_bpcd.txt, 47 bytes, 1 tape blocks
x openv/var/vnetd/inetd_bpjava-msvc.txt, 92 bytes, 1 tape blocks
x openv/var/vnetd/inetd_nbcs.txt, 75 bytes, 1 tape blocks
x openv/swidtag.xml, 5435 bytes, 11 tape blocks
......
Mon Jun 6 12:00:08 BEIDT 2012
All Oracle instances should be shutdown before running this script.
Please log into the Unix system as the Oracle owner for running this script
Do you want to continue? (y/n) [n] y
LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /oracle/app/product/10.2.0
Oracle version: 10.2.0.5.0
Linking LIBOBK:
Moving libobk.a to libobk.a.back
ln -s /usr/openv/netbackup/bin/libobk.a64 /oracle/app/product/10.2.0/lib/libobk.a
Done
二、恢复控制文件
1、配置参数文件
dcods2.__db_cache_size=2566914048
dcods1.__db_cache_size=2516582400
dcods1.__java_pool_size=16777216
dcods2.__java_pool_size=16777216
dcods1.__large_pool_size=16777216
dcods2.__large_pool_size=16777216
dcods2.__shared_pool_size=3657433088
dcods1.__shared_pool_size=3690987520
dcods2.__streams_pool_size=16777216
dcods1.__streams_pool_size=33554432
*.audit_file_dest='/oracle/product/10.2.0/admin/dcods/adump'
*.background_dump_dest='/oracle/product/10.2.0/admin/dcods/bdump'
*.cluster_database_instances=2
*.cluster_database=true
*.compatible='10.2.0.3.0'
*.control_files='/dev/dcodsvg/rcontrol1_128m','/dev/dcodsvg/rcontrol2_128m','/dev/dcodsvg/rcontrol3_128m'
*.core_dump_dest='/oracle/product/10.2.0/admin/dcods/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='dcods'
dcods2.instance_number=2
dcods1.instance_number=1
*.job_queue_processes=10
*.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.11.122)(PORT=1521))'
dcods1.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.11.121)(PORT=1521))'
dcods2.local_listener='(ADDRESS=(PROTOCOL=TCP)(HOST=10.138.11.122)(PORT=1521))'
dcods2.log_archive_dest='/arch2'
dcods1.log_archive_dest='/arch1'
*.open_cursors=300
*.pga_aggregate_target=2097152000
*.processes=500
*.recyclebin='OFF'
*.remote_listener='LISTENERS_DCODS'
*.remote_login_passwordfile='exclusive'
*.sessions=555
*.sga_target=6291456000
dcods1.thread=1
dcods2.thread=2
*.undo_management='AUTO'
dcods1.undo_tablespace='UNDOTBS2'
dcods2.undo_tablespace='UNDOTBS1'
*.user_dump_dest='/oracle/product/10.2.0/admin/dcods/udump'
2、图形界面恢复控制文件
1)、在master 服务器上启动客户端备份恢复窗口
2)、定义客户端的属性
3)、定义源客户端和目标客户端分别为ods1和dcods1
4)、启动恢复控制文件到恢复演练机dcods1的/tmp
5)、查看controlfile
/tmp#ls
lost+found controlfile.dbf NetBackup_7.0_CLIENTS_GA.tar
6)、启动数据库到nomount状态,恢复控制文件
$ rman target /
Recovery Manager: Release 10.2.0.4.0 - Production on Thu Mar 29 15:47:07 2012
Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database: dcods (not mounted)
RMAN> restore controlfile from '/tmp/ods_controlfile.dbf';
Starting restore at 29-MAR-12
using target database control file instead of recovery catalog
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=533 instance=dcods1 devtype=DISK
channel ORA_DISK_1: copied control file copy
output filename=/dev/dcodsvg/rcontrol1_128m
output filename=/dev/dcodsvg/rcontrol2_128m
output filename=/dev/dcodsvg/rcontrol3_128m
Finished restore at 29-MAR-12
三、恢复数据库的数据文件
1、启动数据库到mount状态
alter database mount;
2、恢复数据库数据文件
RMAN> run{
2> allocate channel ch01 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
3> allocate channel ch02 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
4> allocate channel ch03 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
5> allocate channel ch04 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
6> allocate channel ch05 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
7> allocate channel ch06 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
8> restore database;
9> switch datafile all;
10> release channel ch01;
release channel ch02;
release channel ch03;
11> 12> 13> release channel ch04;
14> release channel ch05;
15> release channel ch06;
16> }
allocated channel: ch01
channel ch01: sid=533 instance=dcods1 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
allocated channel: ch02
channel ch02: sid=532 instance=dcods1 devtype=SBT_TAPE
channel ch02: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
allocated channel: ch03
channel ch03: sid=531 instance=dcods1 devtype=SBT_TAPE
channel ch03: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
allocated channel: ch04
channel ch04: sid=530 instance=dcods1 devtype=SBT_TAPE
channel ch04: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
allocated channel: ch05
channel ch05: sid=529 instance=dcods1 devtype=SBT_TAPE
channel ch05: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
allocated channel: ch06
channel ch06: sid=528 instance=dcods1 devtype=SBT_TAPE
channel ch06: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
Starting restore at 29-MAR-12
channel ch01: starting datafile backupset restore
channel ch01: specifying datafile(s) to restore from backup set
restoring datafile 00003 to /dev/dcodsvg/rsysaux01_4g
restoring datafile 00004 to /dev/dcodsvg/rundotbs2_4g
restoring datafile 00005 to /dev/dcodsvg/ruser01_1g
restoring datafile 00009 to /dev/dcodsvg/rlvdata_59_20g
restoring datafile 00020 to /dev/dcodsvg/rlvdata_64_20g
restoring datafile 00025 to /dev/dcodsvg/rlvdata_69_20g
restoring datafile 00027 to /dev/dcodsvg/rlvdata_45_1g
restoring datafile 00032 to /dev/dcodsvg/rlvdata_12_10g
restoring datafile 00043 to /dev/dcodsvg/rlvdata_51_10g
channel ch01: reading from backup piece bk_4640_1_779133435
channel ch02: starting datafile backupset restore
channel ch02: specifying datafile(s) to restore from backup set
restoring datafile 00007 to /dev/dcodsvg/rlvdata_57_20g
restoring datafile 00011 to /dev/dcodsvg/rlvdata_10_10g
restoring datafile 00014 to /dev/dcodsvg/rlvdata_10_1g
restoring datafile 00018 to /dev/dcodsvg/rlvdata_62_20g
restoring datafile 00023 to /dev/dcodsvg/rlvdata_67_20g
restoring datafile 00029 to /dev/dcodsvg/rlvdata_13_1g
restoring datafile 00037 to /dev/dcodsvg/rlvdata_14_10g
restoring datafile 00040 to /dev/dcodsvg/rlvdata_52_5g
channel ch02: reading from backup piece bk_4641_1_779133435
channel ch03: starting datafile backupset restore
channel ch03: specifying datafile(s) to restore from backup set
restoring datafile 00008 to /dev/dcodsvg/rlvdata_58_20g
restoring datafile 00016 to /dev/dcodsvg/rlvdata_11_1g
restoring datafile 00019 to /dev/dcodsvg/rlvdata_63_20g
restoring datafile 00024 to /dev/dcodsvg/rlvdata_68_20g
restoring datafile 00028 to /dev/dcodsvg/rlvdata_11_10g
restoring datafile 00030 to /dev/dcodsvg/rlvdata_14_1g
restoring datafile 00041 to /dev/dcodsvg/rlvdata_53_5g
restoring datafile 00042 to /dev/dcodsvg/rlvdata_52_10g
channel ch03: reading from backup piece bk_4642_1_779134892
channel ch04: starting datafile backupset restore
channel ch04: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /dev/dcodsvg/rsystem01_4g
restoring datafile 00006 to /dev/dcodsvg/rlvdata_11_5g
restoring datafile 00010 to /dev/dcodsvg/rlvdata_60_20g
restoring datafile 00013 to /dev/dcodsvg/rlvdata_10_2g
restoring datafile 00021 to /dev/dcodsvg/rlvdata_65_20g
restoring datafile 00026 to /dev/dcodsvg/rlvdata_12_5g
restoring datafile 00031 to /dev/dcodsvg/rlvdata_15_1g
restoring datafile 00034 to /dev/dcodsvg/rlvdata_56_10g
restoring datafile 00038 to /dev/dcodsvg/rlvdata_70_20g
channel ch04: reading from backup piece bk_4643_1_779135088
channel ch05: starting datafile backupset restore
channel ch05: specifying datafile(s) to restore from backup set
restoring datafile 00002 to /dev/dcodsvg/rundotbs1_4g
restoring datafile 00012 to /dev/dcodsvg/rlvdata_10_5g
restoring datafile 00015 to /dev/dcodsvg/rlvdata_11_2g
restoring datafile 00017 to /dev/dcodsvg/rlvdata_61_20g
restoring datafile 00022 to /dev/dcodsvg/rlvdata_66_20g
restoring datafile 00033 to /dev/dcodsvg/rlvdata_16_1g
restoring datafile 00035 to /dev/dcodsvg/rlvdata_13_10g
restoring datafile 00036 to /dev/dcodsvg/rlvdata_13_5g
restoring datafile 00039 to /dev/dcodsvg/rlvdata_71_20g
channel ch05: reading from backup piece bk_4644_1_779136264
channel ch01: restored backup piece 1
piece handle=bk_4640_1_779133435 tag=HOT_DB_BK_LEVEL0
channel ch01: restore complete, elapsed time: 00:25:37
channel ch02: restored backup piece 1
piece handle=bk_4641_1_779133435 tag=HOT_DB_BK_LEVEL0
channel ch02: restore complete, elapsed time: 00:32:22
channel ch03: restored backup piece 1
piece handle=bk_4642_1_779134892 tag=HOT_DB_BK_LEVEL0
channel ch03: restore complete, elapsed time: 00:51:18
channel ch04: restored backup piece 1
piece handle=bk_4643_1_779135088 tag=HOT_DB_BK_LEVEL0
channel ch04: restore complete, elapsed time: 01:00:34
channel ch05: restored backup piece 1
piece handle=bk_4644_1_779136264 tag=HOT_DB_BK_LEVEL0
channel ch05: restore complete, elapsed time: 01:20:20
Finished restore at 29-MAR-12
released channel: ch01
released channel: ch02
released channel: ch03
released channel: ch04
released channel: ch05
released channel: ch06
四、恢复数据库的归档日志
1、恢复归档日志
1）、恢复一节点的归档
RMAN> run{
2> allocate channel ch01 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
3> allocate channel ch02 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
4> set archivelog destination to '/arch1';
5> restore archivelog logseq 2757 thread 1;
6> release channel ch01;
7> release channel ch02;
8> }
allocated channel: ch01
channel ch01: sid=533 instance=dcods1 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
allocated channel: ch02
channel ch02: sid=532 instance=dcods1 devtype=SBT_TAPE
channel ch02: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 29-MAR-12
channel ch01: starting archive log restore to user-specified destination
archive log destination=/arch1
channel ch01: restoring archive log
archive log thread=1 sequence=2757
channel ch01: reading from backup piece al_4656_1_779198234
channel ch01: restored backup piece 1
piece handle=al_4656_1_779198234 tag=TAG20120329T115713
channel ch01: restore complete, elapsed time: 00:11:26
Finished restore at 29-MAR-12
released channel: ch01
released channel: ch02
RMAN> run{
2> allocate channel ch01 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
3> allocate channel ch02 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods1)";
4> set archivelog destination to '/arch1';
5> restore (archivelog sequence between 2758 and 2771 thread 1);
6> release channel ch01;
7> release channel ch02;
8> }
allocated channel: ch01
channel ch01: sid=533 instance=dcods1 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
allocated channel: ch02
channel ch02: sid=532 instance=dcods1 devtype=SBT_TAPE
channel ch02: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 29-MAR-12
channel ch01: starting archive log restore to user-specified destination
archive log destination=/arch1
channel ch02: starting archive log restore to user-specified destination
archive log destination=/arch1
channel ch01: restoring archive log
archive log thread=1 sequence=2758
channel ch02: restoring archive log
archive log thread=1 sequence=2767
channel ch01: restoring archive log
archive log thread=1 sequence=2759
channel ch02: restoring archive log
archive log thread=1 sequence=2768
channel ch01: restoring archive log
archive log thread=1 sequence=2760
channel ch02: restoring archive log
archive log thread=1 sequence=2769
channel ch01: restoring archive log
archive log thread=1 sequence=2761
channel ch02: restoring archive log
archive log thread=1 sequence=2770
channel ch01: restoring archive log
archive log thread=1 sequence=2762
channel ch02: restoring archive log
archive log thread=1 sequence=2771
channel ch02: reading from backup piece al_4659_1_779199074
channel ch01: restoring archive log
archive log thread=1 sequence=2763
channel ch01: restoring archive log
archive log thread=1 sequence=2764
channel ch01: restoring archive log
archive log thread=1 sequence=2765
channel ch01: restoring archive log
archive log thread=1 sequence=2766
channel ch01: reading from backup piece al_4656_1_7791982
channel ch01: restored backup piece 1
piece handle=al_4656_1_779198234 tag=TAG20120329T115713
channel ch01: restore complete, elapsed time: 00:07:45
channel ch02: restored backup piece 1
piece handle=al_4659_1_779199074 tag=TAG20120329T11571
channel ch02: restore complete, elapsed time: 00:13:01
Finished restore at 29-MAR-12
released channel: ch01
released channel: ch02
RMAN>
2）、恢复二节点的归档
RMAN> run{
2> allocate channel ch01 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods2)";
3> allocate channel ch02 type sbt_tape parms="ENV=(NB_ORA_SERV=yx-nbu,NB_ORA_CLIENT=ods2)";
4> set archivelog destination to '/arch1';
5> restore (archivelog sequence between 2701 and 2708 thread 2);
6> release channel ch01;
7> release channel ch02;
8> }
allocated channel: ch01
channel ch01: sid=533 instance=dcods1 devtype=SBT_TAPE
channel ch01: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
allocated channel: ch02
channel ch02: sid=532 instance=dcods1 devtype=SBT_TAPE
channel ch02: Veritas NetBackup for Oracle - Release 7.0 (2010010419)
executing command: SET ARCHIVELOG DESTINATION
Starting restore at 29-MAR-12
channel ch01: starting archive log restore to user-specified destination
archive log destination=/arch1
channel ch01: restoring archive log
archive log thread=2 sequence=2701
channel ch01: restoring archive log
archive log thread=2 sequence=2702
channel ch01: restoring archive log
archive log thread=2 sequence=2703
channel ch01: restoring archive log
archive log thread=2 sequence=2704
channel ch01: restoring archive log
archive log thread=2 sequence=2705
channel ch01: restoring archive log
archive log thread=2 sequence=2706
channel ch01: restoring archive log
archive log thread=2 sequence=2707
channel ch01: restoring archive log
archive log thread=2 sequence=2708
channel ch01: reading from backup piece al_4637_1_779116154
channel ch01: restored backup piece 1
piece handle=al_4637_1_779116154 tag=TAG20120328T125711
channel ch01: restore complete, elapsed time: 00:07:16
Finished restore at 29-MAR-12
released channel: ch01
released channel: ch02
2、应用归档
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Thu Mar 29 18:56:41 2012
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> connect /as sysdba;
Connected.
SQL> recover database using backup controlfile until cancel;
ORA-00279: change 10797554026228 generated at 03/28/2012 17:57:15 needed for
thread 1
ORA-00289: suggestion : /arch1/1_2771_761863731.dbf
ORA-00280: change 10797554026228 for thread 1 is in sequence #2771
Specify log: {=suggested | filename | AUTO | CANCEL}
auto
ORA-00279: change 10797554026228 generated at 03/28/2012 16:26:17 needed for
thread 2
ORA-00289: suggestion : /arch1/2_2711_761863731.dbf
ORA-00280: change 10797554026228 for thread 2 is in sequence #2711
ORA-00279: change 10797554089085 generated at 03/28/2012 19:06:44 needed for
thread 2
ORA-00289: suggestion : /arch1/2_2712_761863731.dbf
ORA-00280: change 10797554089085 for thread 2 is in sequence #2712
ORA-00278: log file '/arch1/2_2711_761863731.dbf' no longer needed for this
recovery
ORA-00279: change 10797554089093 generated at 03/28/2012 19:06:51 needed for
thread 1
ORA-00289: suggestion : /arch1/1_2772_761863731.dbf
ORA-00280: change 10797554089093 for thread 1 is in sequence #2772
ORA-00278: log file '/arch1/1_2771_761863731.dbf' no longer needed for this
recovery
五、恢复后的数据库打开
1)、打开第一个节点的实例
alter database open resetlogs;
Database altered.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL>
SQL>
SQL>
2）、改spfile文件，启动第二节实例
登陆到节点一，创建spfile
$ sqlplus /nolog
SQL> connect /as sysdba;
Connected.
SQL> create spfile='/dev/rspfile' from pfile;
File created.
$ vi initdcods1.ora
"initdcods2.ora" [New file]
spfile='/dev/rspfile'
登陆到节点二机器上
# su - oracle
$ cd $ORACLE_HOME
$ cd dbs
$ vi initdcods2.ora
"initdcods2.ora" [New file]
spfile='/dev/rspfile'
"initdcods2.ora" [New file] 1 line, 22 characters
$ cd $ORACLE_BASE
$ ls
admin app lost+found oraInventory
$ cd admin
$ ls
$ mkdir dcods
$ cd *
$ ls
$ mkdir adump
$ mkdir bdump
$ mkdir cdump
$ mkdir udmp
重启第一个节点实例
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> connect /as sysdba;
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2097800 bytes
Variable Size 503319928 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14675968 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> show parameters spfile;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string /dev/rspfile
SQL>
SQL> show parameters instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string dcods1
SQL>
启动第二个实例
$ sqlplus /nolog
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> connect /as sysdba;
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2097800 bytes
Variable Size 503319928 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14675968 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> show parameters instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string dcods2
SQL>
$ sqlplus /nolog
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> connect /as sysdba;
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area 2147483648 bytes
Fixed Size 2097800 bytes
Variable Size 503319928 bytes
Database Buffers 1627389952 bytes
Redo Buffers 14675968 bytes
Database mounted.
Database opened.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> show parameters instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string dcods2
SQL>
3）、注册数据库和实例到CRS
srvctl add database -d dcods -o $ORACLE_HOME
srvctl add instance -d dcods -n dcods1 -i dcods1
srvctl add instance -d dcods -n pmosdb2 -i dcods2
六、检查数据库状态
$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora....E1.lsnr application 0/5 0/0 ONLINE ONLINE pmosdb 1
ora.dcods1.gsd application 0/5 0/0 ONLINE ONLINE pmosdb 1
ora.dcods1.ons application 0/3 0/0 ONLINE ONLINE pmosdb 1
ora.dcods1.vip application 0/0 0/0 ONLINE ONLINE pmosdb 1
ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE pmosdb2
ora.dcods2.gsd application 0/5 0/0 ONLINE ONLINE pmosdb2
ora.dcods2.ons application 0/3 0/0 ONLINE ONLINE pmosdb2
ora.dcods2.vip application 0/0 0/0 ONLINE ONLINE pmosdb2
ora.dcods.db application 0/0 0/1 ONLINE ONLINE pmosdb2
ora....b1.inst application 0/5 0/0 ONLINE ONLINE pmosdb 1
ora....b2.inst application 0/5 0/0 ONLINE ONLINE pmosdb2
SQL> connect /as sysdba;
Connected.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> show parameters instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string dcods2
SQL>
$ sqlplus /nolog
Copyright (c) 1982, 2010, Oracle. All Rights Reserved.
SQL> connect /as sysdba;
Connected.
SQL> select status from v$instance;
STATUS
------------
OPEN
SQL> show parameters instance_name;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
instance_name string dcods1
SQL>
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27571661/viewspace-740722/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/27571661/viewspace-740722/
311
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
