NBURman异机恢复Oracle.docVIP

NBU Rman异机恢复Oracle 2009-05-12 00:30 背景：HostA上oracle通过NBU进行RMAN备份至带库，从HostB上恢复该库； 目的：在丢失了一部分数据的情况下，但因为没有足够的空间不能做整库恢复，只想恢复部分表； so假设：源主机HostA，目标主机HostB，NBUMaster主机Po，Oracle_sid均为test， Oracle用户均为ora。 步骤: 1、增加Po主机上文件 [Po:root]#touch /usr/openv/netbackup/db/altnames/No.Restrictions //取消nbu的异机恢复限制 2、修改Po主机上文件，修改参数 [Po:root]#vi /usr/openv/netbackup/bp.conf FORCE_RESTORE_MEDIA_SERVER = HostA HostB ??这步需要重启netbackup 下面开始恢复步骤（均为ora用户操作） 3、copy spfile 在HostA上test数据库的pfile（create pfile from spfile）ftp至HostB中的 ?? $ORACLE_HOME/db下 4、HostB上，密码文件、相应的dump目录 ?? [HostB:ora]#orapwd file=fname password=password entries=users ?? [HostB:ora]#mkdir $admin/test/*dump 5、启动数据库至nomount ?? [HostB:ora]#sqlplus / as sysdba Connected to an idle instance. SQL startup nomount ORACLE instance started. Total System Global Area 1526726656 bytes Fixed Size?????????????????? 2191720 bytes Variable Size???????????? 1430245016 bytes Database Buffers??????????bytes Redo Buffers??????????????bytes 6、登录catalog，进行rman恢复 [HostB:ora]#rman target / catalog user/pwd@rman connected to target database: TEST (not mounted) connected to recovery catalog database 7、set dbid（HostA上test库的dbid） RMAN set dbid=2091611406 executing command: SET DBID database name is TEST and DBID is 2091611406 8、恢复control file RMAN RUN { 2?????? ALLOCATE CHANNEL D1 TYPE sbt_tape; 3?????? send NB_ORA_SERV=Po,NB_ORA_CLIENT=HostA; //一定需要NB_ORA_CLIENT，否则找不到介质4?????? RESTORE CONTROLFILE; 5?????? RELEASE CHANNEL D1; 6?????? } allocated channel: D1 channel D1: sid=166 devtype=SBT_TAPE channel D1: VERITAS NetBackup for Oracle - Release 6.0 (2006110304) sent command to channel: D1 Starting restore at 2009-05-11:21:24:58 channel D1: starting datafile backupset restore channel D1: restoring control file channel D1: reading from backup piece c-338195538902 channel D1: restored backup piece 1 piece handle=c-338195538902 tag=TA170809 channel D1: restore c