RMAN： 从NBU备份磁带库恢复到异机案例（原创）

人力资源系统数据库

恢复案例

 

人力资源系统数据库于2010-05-18号开始进行恢复测试到2010-05-19号早上恢复成功。

本次恢复主要是获取人力资源系统生产库在NBU  Veritas 磁带库上的全备份数据到应急系统数据库上进行完全恢复。

   下面是具体的操作步骤及过程：

1.      在应急系统数据库上创建新的数据库实例：

1)       登录应急数据库服务器：

      #su – oracle

      $who

      $export DISPLAY=10.xxx.xx.xxx:0.0

      $dbca

      （然后在图型界面中进行ORACLE数据库安装）

2)       配置相关数据库信息：

设置实例名，数据文件存放位置等,本次数据库的实例名：JMHRMS

2.      在应急系统数据库上安装配置NBU管理客户端：

1）  安装NBU的CLIENT：

#mount -rv cdrfs /dev/cd0 /mnt

#cd /mnt

#ls

#./install                           *nbuserver:jmbackupsrv  (10.151.17.21)

2）  安装NBU的AGENT：

#mount -rv cdrfs /dev/cd0 /mnt

#cd /mnt

#ls

#./install                           *nbuserver:jmbackupsrv 

3）  配置NBU的AGENT：

#su - oracle

#cd /usr/openv/netbackup/bin

#./oracle_link

     

LIBOBK path: /usr/openv/netbackup/bin    

ORACLE_HOME: /oracle/10.2

Oracle version: 10.2.0.4.0

Linking LIBOBK:

ln -s /usr/openv/netbackup/bin bobk.a64 /oracle/10.2  b bobk.a

Done

Please check the trace file located in /tmp/make_trace.684536

to make sure the linking process was successful.

4）  测试AGENT是否成功：

#su – oracle

$rman target /

RMAN>run {

allocate channel ch01 TYPE 'SBT_TAPE';

release channel ch01;

}                      **测试连接磁带库是否成功

3.      登录人力资源生产数据库检查该机的RMAN配置是否正确：

1）  检查并修改RAMAN配送配置：

jm_hr_db[/]#su - oracle

$ORACLE_SID: jmhrms

$ORACLE_HOME: /oracle/product/10.2.0/db

 

jm_hr_db[/home/oracle]@rman target /

 

Recovery Manager: Release 10.2.0.4.0 - Production on Fri May 21 08:38:56 2010

 

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 

connected to target database: JMHRMS (DBID=3805380100)

 

RMAN> show all;

 

using target database control file instead of recovery catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/product/10.2.0/db/dbs/snapcf_jmhrms.f'; # default

 

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP ON;

new RMAN configuration parameters are successfully stored

**配置修改成功

2）  进行SPFILE文件备份：

RMAN> run {

2> allocate channel ch1 type 'sbt_tape';

3> backup current controlfile;

4> release channel ch1;

5> }

 

released channel: ORA_DISK_1

allocated channel: ch1

channel ch1: sid=1065 devtype=SBT_TAPE

channel ch1: VERITAS NetBackup for Oracle - Release 6.0 (2005090703)

 

Starting backup at 21-MAY-10

channel ch1: starting full datafile backupset

channel ch1: specifying datafile(s) in backupset

including current control file in backupset

channel ch1: starting piece 1 at 21-MAY-10

channel ch1: finished piece 1 at 21-MAY-10

piece handle=25le7hpk_1_1 tag=TAG20100521T084540 comment=API Version 2.0,MMS Version 5.0.0.0

channel ch1: backup set complete, elapsed time: 00:27:35

Finished backup at 21-MAY-10

 

Starting Control File and SPFILE Autobackup at 21-MAY-10

       

piece handle=c-3805380100-20100521-00 comment=API Version 2.0,MMS Version 5.0.0.0

Finished Control File and SPFILE Autobackup at 21-MAY-10