红联Linux门户
Linux帮助

NBU异机恢复ORACLE 数据库.

发布时间:2006-08-17 00:44:39来源:红联作者:严寒
一.恢复的前提条件.
1. )日常备份都是成功的。至少有一次全备份及全备份以来的增量备份和Archivelog.
2. )原主机的OS及ORACLE版本与目标主机的OS及ORACLE版本保持一致.
3. )需要原数据库的下列信息:
1) IP Address, Hostname, Nbu media server/client
2) Oracle DB version, SID,DBID,Datafile Path,Controlfile Path,Archivelog Path
3) Catalog DB IP,SID/Service name ,user/password
4. )在目标主机上安装与原数据库版本相同的oracle软件 (Install type :Software only)
5. )在目标主机上安装Veritas 软件,安装类型与原主机一致 (media server or client)

二. 下面以aush49上的s1rel DB恢复到aush61为例对veritas及oracle进行配置.
1 )在目标主机上(aush61)配置veritas
1) Edit $ORACLE_HOME/bp.conf file (aush61) s3pis> cd $ORACLE_HOME (aush61) s3pis> vi bp.conf SERVER = aush06 /*master server host name*/ CLIENT_NAME = aush49 /*source host name ,如果aush49是media server则写 SERVER = aush49*/ CLINET_READ_TIMEOUT = 1800
2)Edit /usr/openv/netbackup/bp.conf ( aush61) aush61#vi bp.conf SERVER = aush06 /*master server name*/ CLIENT_NAME = aush49 /*source host name , 如果aush49是media server则写 SERVER = aush49*/ CLIENT_NAME = aush61 /*target host name */ VERBOSE = 5 CLIENT_READ_TIMEOUT = 1800
CLIENT_CONNECT_TIMEOUT = 1800
3) Touch a file on Master Server (aush06) aush06#cd /usr/openv/netbackup/db/altnames aush06#touch aush61 /*target host name */

2 ) 在master server (aush06)与目标主机(aush61)上配置/etc/hosts 文件
aush61#vi /etc/hosts 127.0.0.1 localhost 10.5.15.61 aush61 10.5.15.6 aush06 10.5.15.49 aush49 10.5.15.58 aush58
aush06#vi /etc/hosts 127.0.0.1 localhost 10.5.15.61 aush61 10.5.15.6 aush06 10.5.15.49 aush49 10.5.15.58 aush58


3 ) 在目标主机上(aush61)配置ORACLE.
1 )创建于原数据库(aush49)相同的oracle user/group : s3pis/dba
2 ) 配置s3pis环境变量
(aush61) s3pis> more .profileORACLE_HOME=/u01/s3pis;export ORACLE_HOMEORACLE_SID=s3rel;export ORACLE_SIDPATH=$PATH:$ORACLE_HOME/bin;export PATHPS1="(`hostname`) `whoami`> "LD_LIBRARY_PATH=$ORACLE_HOME/lib;export LD_LIBRARY_PATH

3 ) 安装与原数据库相同版本的Oracle 软件,安装类型:SOFTWARE ONLY.

4 ) 创建$ORACLE_HOME/network/admin/tnsnames.ora 文件连接catalog DB.
(aush61) s3pis> more tnsnames.oracatalog =(description= (address_list= (address=(protocol=tcp)(host=10.5.13.178)(port=1521)) ) (connect_data= (service_name=catalog) ) )

5 ) 创建pfile
如果有原数据库(s1rel db)的pfile 或spfile ,可以直接使用;如果没有可以手动创建pfile !

6 )创建与原数据库(s1rel db)相同的文件存放路径!
1) 根据对原数据库(s1rel )的日常维护信息,可以知道controlfile,datafile,archivelog file 的存取路径。可以通过link 方式在目标主机(aush61)上创建相应的目录,并赋予oracle 用户(s1pis)读写权限.
2) 如果要将数据文件恢复到不同位置,需要在恢复语句上用set newname 及switch datafile 的参数!
3) 根据pfile或spfile 创建cdump ,bdump ,udump 目录

三. 恢复步骤.
1) 使用pfile或spfile在目标主机(aush61)上启动数据库(s1rel)到nomount 状态
(aush61) s3pis> sqlplus "/ as sysdba";

SQL*Plus: Release 9.0.1.4.0 - Production on Thu Dec 9 11:00:24 2004

(c) Copyright 2001 Oracle Corporation. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile=/u01/s3pis/dbs/inits3rel.oraORACLE instance started.

Total System Global Area 806283128 bytesFixed Size 436088 bytesVariable Size 268435456 bytesDatabase Buffers 536870912 bytesRedo Buffers 540672 bytesSQL>

2.恢复控制文件

(aush61) s3pis> rman catalog auss3pis/auss3pis@catalog;

Recovery Manager: Release 9.0.1.4.0 - Production

(c) Copyright 2001 Oracle Corporation. All rights reserved.

connected to recovery catalog database

RMAN> set dbid=4227459251 (aush49 s3rel dbid )

executing command: SET DBID

RMAN> connect target /

connected to target database: (not mounted)

RMAN> run {2> allocate channel ch00 type 'sbt_tape';3> send 'nb_ora_serv=aush06';4> send 'nb_ora_client=aush49';5> restore controlfile;6> }allocated channel: ch00channel ch00: sid=11 devtype=SBT_TAPEchannel ch00: VERITAS NetBackup for Oracle - Release 4.5FP_3GA (2002121901)

sent command to channel: ch00

sent command to channel: ch00

Starting restore at 09-DEC-04

channel ch00: starting datafile backupset restorechannel ch00: restoring controlfileoutput filename=/u22/oradata/control01.ctlchannel ch00: restored backup piece 1piece handle=cntrl_3973_1_544399339 tag=null params=NULLchannel ch00: restore completereplicating controlfileinput filename=/u22/oradata/control01.ctloutput filename=/u22/oradata/control02.ctloutput filename=/u22/oradata/control03.ctlFinished restore at 09-DEC-04released channel: ch00

RMAN> exit

3.重新启动数据库到mount 状态
SQL> shutdown immediate;ORA-01109: database not open

Database dismounted.ORACLE instance shut down.SQL> startup mount pfile=/u01/s3pis/dbs/inits3rel.oraORACLE instance started.

Total System Global Area 806283128 bytesFixed Size 436088 bytesVariable Size 268435456 bytesDatabase Buffers 536870912 bytesRedo Buffers 540672 bytesDatabase mounted.SQL>

4.对数据库做基于时间点的恢复!
(aush61) s3pis> rman catalog auss3pis/auss3pis@catalog;

Recovery Manager: Release 9.0.1.4.0 - Production

(c) Copyright 2001 Oracle Corporation. All rights reserved.

connected to recovery catalog database

RMAN> set dbid=4227459251

executing command: SET DBID

RMAN> connect target /

connected to target database: S3REL (DBID=4227459251)


RMAN> run {2> allocate channel ch00 type 'sbt_tape';3> send 'nb_ora_serv=aush06';4> send 'nb_ora_client=aush49';5> set until time "to_date('12/8/2004 14:00:00','mm/dd/yyyy hh24:mi:ss')";6> restore database;7> recover database;8> sql "alter database open resetlogs";9> }
注:如果将数据文件恢复到与原路径不同的位置则按照如下写法:
\\RMAN> run {2> allocate channel ch00 type 'sbt_tape';3> send 'nb_ora_serv=aush06';4> send 'nb_ora_client=aush49';5> set until time "to_date('12/8/2004 14:00:00','mm/dd/yyyy hh24:mi:ss')";
6> set newname for datafile ‘filename’ or filenumber to ‘newlocation’ ;
7> restore database ;
8> switch datafile all;
}
RMAN> run {2> allocate channel ch00 type 'sbt_tape';3> send 'nb_ora_serv=aush06';4> send 'nb_ora_client=aush49';5> set until time "to_date('12/8/2004 14:00:00','mm/dd/yyyy hh24:mi:ss')";
6> set archivelog destination to ‘full path’ ;
}
//channel ch00: sid=11 devtype=SBT_TAPEchannel ch00: VERITAS NetBackup for Oracle - Release 4.5FP_3GA (2002121901)

sent command to channel: ch00

sent command to channel: ch00

executing command: SET until clause

Starting restore at 09-DEC-04

channel ch00: starting datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup setrestoring datafile 00036 to /u23/oraindx/SMSR_I01.dbf

........................................................................................................

restoring datafile 00051 to /u23/oraindx/SMS_AV_04092.dbfchannel ch00: restored backup piece 1piece handle=bk_3947_1_544370120 tag=HOT_DB_BK_LEVEL0 params=NULLchannel ch00: restore completeFinished restore at 09-DEC-04

Starting recover at 09-DEC-04

channel ch00: starting incremental datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup setdestination for restore of datafile 00070: /u22/oradata/SMS_ID_04121.dbfchannel ch00: restored backup piece 1piece handle=bk_3927_1_544280863 tag=HOT_DB_BK_LEVEL0 params=NULLchannel ch00: restore completechannel ch00: starting incremental datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup set............................................................................................................

channel ch00: starting incremental datafile backupset restorechannel ch00: specifying datafile(s) to restore from backup setdestination for restore of datafile 00025: /u22/oradata/SCS_T01.dbfdestination for restore of datafile 00036: /u23/oraindx/SMSR_I01.dbfdestination for restore of datafile 00043: /u23/oraindx/SCS_I02.dbfdestination for restore of datafile 00059: /u23/oraindx/SMS_AV_04093.dbfchannel ch00: restored backup piece 1piece handle=bk_3931_1_544281553 tag=HOT_DB_BK_LEVEL0 params=NULLchannel ch00: restore complete

starting media recovery

channel ch00: starting archive log restore to default destinationchannel ch00: restoring archive logarchive log thread=1 sequence=2562channel ch00: restoring archive log..........................................................................................................

archive log filename=/u21/s3rel/archive/1_2574.dbf thread=1 sequence=2574archive log filename=/u21/s3rel/archive/1_2575.dbf thread=1 sequence=2575archive log filename=/u21/s3rel/archive/1_2576.dbf thread=1 sequence=2576archive log filename=/u21/s3rel/archive/1_2577.dbf thread=1 sequence=2577media recovery completeFinished recover at 09-DEC-04

sql statement: alter database open resetlogsreleased channel: ch00

RMAN>

恢复成功,数据库已经打开!
文章评论

共有 78 条评论

  1. 201.210.83.* 于 2007-04-17 20:34:39发表:

    http://67d7126e4dc71fc238193dd5e2b98e83-t.ghoiou0.info 67d7126e4dc71fc238193dd5e2b98e83 http://67d7126e4dc71fc238193dd5e2b98e83-b1.ghoiou0.info 67d7126e4dc71fc238193dd5e2b98e83 http://67d7126e4dc71fc238193dd5e2b98e83-b3.ghoiou0.info 196c3da0ce3e9a23267e7eab02ad2b11