NBU-DATADOMAIN-ORACLE-DATAGUARD-异机恢复

注意事项,解决 NBU 2801错误

NBU恢复客户端需要关注 bp.conf /etc/hosts文件

bp.conf

SERVER = backup251
SERVER = madb1
SERVER = madb2
SERVER = gzdbsrv1
SERVER = ysdbsrv2
SERVER = tjdbsrv2
SERVER = fmsdb34.minanins.com
SERVER = cwdbsrv1
CLIENT_NAME = weixindb2
CONNECT_OPTIONS = localhost 1 0 2

/etc/hosts

所有media server 需要在/etc/hosts 解析恢复客户端


恢复数据库

1. 从源库备份一个standby 控制文件恢复 (主要是catalog在控制文件)

backup current controlfile for standby format '/oracle/backup/c_%T_%t.bak';

2. 在目标库恢复控制文件

restore controlfile from '/oracle/backup/c_20190401_1004446688.bak';

3.查找恢复用control file

/usr/openv/netbackup/bin/bplist -S 'backup251' -C 'weixindb1' -t 4 -R -l / |more

4.从NBU恢复控制文件

RUN { 
allocate channel D1 type SBT_TAPE; 
send 'NB_ORA_SERV=backup251,NB_ORA_CLIENT=weixindb1'; 
RESTORE CONTROLFILE FROM 'cntrl_132375_1_988097540'; 
RELEASE CHANNEL D1; 
} 

5.还原和恢复数据库

run { 
allocate channel D1 type SBT_TAPE; 
allocate channel D2 type SBT_TAPE; 
allocate channel D3 type SBT_TAPE; 
allocate channel D4 type SBT_TAPE; 
send 'NB_ORA_SERV=backup251,NB_ORA_CLIENT=weixindb1'; 
restore database; 
recover database; 
RELEASE CHANNEL D1; 
RELEASE CHANNEL D2; 
RELEASE CHANNEL D3; 
RELEASE CHANNEL D4; 
} 

6.继续恢复数据库

RUN { 
allocate channel D1 type SBT_TAPE; 
send 'NB_ORA_SERV=backup251,NB_ORA_CLIENT=weixindb1'; 
recover database; 
RELEASE CHANNEL D1; 
}  

7.启动备库日志应用 (如果是全新搭建还需要考虑参数文件,密码文件,文件目录,TNSNAME等配置)

startup nomount 
alter database mount standby database; 
alter database recover managed standby database using current logfile disconnect from session; 
alter database recover managed standby database  disconnect from session; 
©著作权归作者所有,转载或内容合作请联系作者
平台声明:文章内容(如有图片或视频亦包括在内)由作者上传并发布,文章内容仅代表作者本人观点,简书系信息发布平台,仅提供信息存储服务。

推荐阅读更多精彩内容