异机恢复走光纤的配置方式,否则就会走网络
在备份服务器的管理控制台里NetBackup Management下面的Host Properties里,找到Master Server,双击编辑属性,找到General Server,进去,
在Media Host Override里把From输入CW1,to输入orctest,然后点OK,重启备份服务
下面是测试MASTER与ORACLE在NBU软件层通信是否正常。
# bpclntcmd -ip 10.10.127.167
bpclntcmd -hn oratest
bpclntcmd -hn CW1
bptestbpcd -client oratest -verbose
### 是否重启nbu服务
# bp.kill_all
# bp.start_all
nbu 的master MEDIA,CW1,oratest 四个主机上确认 host文件中是否有
10.10.127.51 CW1
10.10.127.167 oratest
恢复主机修改了/etc/hosts 参数
[root@orctest netbackup]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
10.10.127.167 orctest
10.10.128.43 NBU-SERVER
10.10.127.51 CW1
---在mast节点上创建文件,允许异机恢复
[root@orctest scripts]# cd/usr/openv/netbackup/db/altnames
[root@orctest altnames]# touch No.Restrictions
windows上是:
cd c:\program files\openv\netbackup\db\altnames\
touch No.Restrictions
---在恢复主机上
[oracle@orctest bin]$ pwd
/usr/openv/netbackup/bin
[oracle@orctest bin]$ ./oracle_link
Thu Dec 15 12:51:20 CST 2016
All Oracle instances should be shutdown before runningthis script.
Please log into the Unix system as the Oracle owner forrunning this script
Do you want to continue? (y/n) [n] y
LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /u01/app/oracle/11.2.0.4/product
Oracle version: 11.2.0.4.0
Platform type: x86_64
Linking LIBOBK:
Moving 64-bit libobk.so to libobk.so.back
ln -s /usr/openv/netbackup/bin/libobk.so64/u01/app/oracle/11.2.0.4/product/lib/libobk.so
Done
Please check the trace file located in/tmp/make_trace.16309
to make sure the linking process was successful.
[oracle@orctest netbackup]$ pwd
/usr/openv/netbackup
[oracle@orctest netbackup]$ cat bp.conf
SERVER = NBU-SERVER ---备份服务器
SERVER = CW1 ---添加备份服务器源端
SERVER = orctest ---恢复服务器
CLIENT_NAME = orctest
CONNECT_OPTIONS = localhost 1 0 2
USE_VXSS = PROHIBITED
VXSS_SERVICE_TYPE = INTEGRITYANDCONFIDENTIALITY
EMMSERVER = nbu-server
HOST_CACHE_TTL = 3600
MEDIA_SERVER = orctest
TELEMETRY_UPLOAD = YES
允许客户端恢复,设置如下(nbu软件服务器上操作master server):
On a Windows master server, run the command:
\VERITAS\NetBackup\bin\admincmd\bpgetconfig
DISALLOW_CLIENT_LIST_RESTORE = YES
DISALLOW_CLIENT_RESTORE = YES
一定要改为DISALLOW_CLIENT_LIST_RESTORE和DISALLOW_CLIENT_RESTORE为NO
DISALLOW_CLIENT_LIST_RESTORE = NO
DISALLOW_CLIENT_RESTORE = NO
否则会报ORA-19507 ORA-27029 ORA-19511错误
[root@orctest data]#/usr/openv/netbackup/bin/admincmd/bptestbpcd -client orctest -verbose -debug
14:39:19.256 [23773] <2> bptestbpcd: VERBOSE = 0
14:39:19.257 [23773] <8>vnet_get_user_credential_path: [vnet_vxss.c:1474] status 35 0x23
14:39:19.257 [23773] <8> vnet_check_user_certificate:[vnet_vxss_helper.c:3728] vnet_get_user_credential_path failed 35 0x23
14:39:19.257 [23773] <2>ConnectionCache::connectAndCache: Acquiring new connection for host NBU-SERVER,query type 223
14:39:19.263 [23773] <2> vnet_pbxConnect:pbxConnectEx Succeeded
14:39:19.272 [23773] <2> logconnections: BPDBMCONNECT FROM 10.10.127.167.45481 TO 10.10.128.43.1556 fd = 3
14:39:19.334 [23773] <2> db_CLIENTsend: resetclient protocol version from 0 to 9
14:39:19.574 [23773] <2> db_end: Need to collectreply
14:39:19.587 [23773] <2> logconnections: BPCDCONNECT FROM 10.10.127.167.38686 TO 10.10.127.167.13782 fd = 3
14:39:19.659 [23773] <2> bpcr_get_version_rqst:bpcd version: 07730000
1 0 2
10.10.127.167:38686 -> 10.10.127.167:13782
10.10.127.167:2196 <- 10.10.127.167:51666
14:39:19.663 [23773] <2> bpcr_get_peername_rqst:Server peername length = 7
14:39:19.663 [23773] <2> bpcr_get_hostname_rqst:Server hostname length = 7
14:39:19.663 [23773] <2> bpcr_get_clientname_rqst:Server clientname length = 7
14:39:19.664 [23773] <2> bpcr_get_version_rqst:bpcd version: 07730000
14:39:19.664 [23773] <2> bpcr_get_platform_rqst:Server platform length = 17
14:39:19.664 [23773] <2> bpcr_get_version_rqst:bpcd version: 07730000
14:39:19.676 [23773] <2> bpcr_patch_version_rqst:theRest == > <
14:39:19.676 [23773] <2> bpcr_get_version_rqst:bpcd version: 07730000
14:39:19.716 [23773] <2> bpcr_patch_version_rqst:theRest == > <
14:39:19.716 [23773] <2> bpcr_get_version_rqst:bpcd version: 07730000
PEER_NAME = orctest
HOST_NAME = orctest
CLIENT_NAME = orctest
VERSION = 0x07730000
PLATFORM = linuxR_x86_2.6.18
PATCH_VERSION = 7.7.3.0
SERVER_PATCH_VERSION = 7.7.3.0
MASTER_SERVER = NBU-SERVER
EMM_SERVER = nbu-server
NB_MACHINE_TYPE = MEDIA_SERVER
10.10.127.167:2297 <- 10.10.127.167:35905
<2>bptestbpcd: EXIT status = 0
14:39:19.731 [23773] <2> bptestbpcd: EXIT status =0
---在恢复主机上查看备份集
-C 是主机名称
[root@orctest data]# /usr/openv/netbackup/bin/bplist -C CW1-t 4 -l -R /
-rw-rw---- oracle asmadmin 20447232 Dec 14 10:33/cntrl_22_1_930565993
-rw-rw---- oracle asmadmin 2883584 Dec 14 10:32/al_21_1_930565957
-rw-rw---- oracle asmadmin 6729472K Dec 14 10:30/al_20_1_930565851
-rw-rw---- oracle asmadmin 6833152K Dec 14 10:28/al_19_1_930565735
-rw-rw---- oracle asmadmin 20447232 Dec 14 10:28/bk_18_1_930565689
-rw-rw---- oracle asmadmin 59652096K Dec 14 10:15/bk_17_1_930564954
-rw-rw---- oracle asmadmin 73436416K Dec 14 09:58/bk_16_1_930563888
-rw-rw---- oracle asmadmin 77425152K Dec 14 09:42/bk_15_1_930562963
-rw-rw---- oracle asmadmin 3668992K Dec 14 09:33/bk_14_1_930562418
-rw-rw---- oracle asmadmin 48852480K Dec 14 09:15/bk_13_1_930561332
-rw-rw---- oracle asmadmin 20447232 Dec 13 15:19/cntrl_11_1_930496792
-rw-rw---- oracle asmadmin 2500864K Dec 13 15:18/al_10_1_930496726
-rw-rw---- oracle asmadmin 2886400K Dec 13 15:17/al_9_1_930496650
-rw-rw---- oracle asmadmin 20447232 Dec 13 15:16/bk_8_1_930496603
-rw-rw---- oracle asmadmin 59616256K Dec 13 15:01/bk_7_1_930495688
-rw-rw---- oracle asmadmin 73434880K Dec 13 14:42/bk_6_1_930494573
-rw-rw---- oracle asmadmin 77423616K Dec 13 14:23/bk_5_1_930493418
-rw-rw---- oracle asmadmin 3667712K Dec 13 14:14/bk_4_1_930492882
-rw-rw---- oracle asmadmin 48848896K Dec 13 13:59/bk_3_1_930491977
RMAN> list backup of spfile;
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
6 Incr 0 19.50M SBT_TAPE 00:00:27 13-DEC-16
BP Key:6 Status: AVAILABLE Compressed: NO Tag: HOT_DB_BK_INC_LVL0
Handle: bk_8_1_930496603 Media: 000052
SPFILE Included:Modification time: 12-DEC-16
SPFILEdb_unique_name: ZJSCW
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbu-server,NB_ORA_CLIENT=CW1,NB_ORA_POLICY=CW1-12751';
set DBID =816687480 ;
restore spfile from 'bk_18_1_930565689';
RELEASE CHANNEL ch00;
}
SQL>alter database backup pfile from spfile;
Cd $ORACLE_HOME/dbs
vi initcw1.ora 参数文件删除集群相关的参数,修改控制文件,audit文件路径
---恢复控制文件
通过在源端可以看到 备份片信息 cntrl_22_1_930565993
RMAN> list backup of controlfile;
List of Backup Sets
===================
BS Key Type LVSize Device Type Elapsed TimeCompletion Time
------- ---- -- ---------- ----------- ---------------------------
19 Full 19.50M SBT_TAPE 00:00:28 14-DEC-16
BP Key:19 Status: AVAILABLE Compressed: NO Tag: TAG20161214T103313
Handle:cntrl_22_1_930565993 Media: 000060
Control FileIncluded: Ckp SCN: 545428559 Ckp time:14-DEC-16
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbu-server,NB_ORA_CLIENT=CW1,NB_ORA_POLICY=CW1-12751';
set DBID = 816687480 ;
restore controlfile from 'cntrl_22_1_930565993';
RELEASE CHANNEL ch00;
}
SQL> alter database mount;
Database altered.
---恢复数据文件
run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbu-server,NB_ORA_CLIENT=CW1,NB_ORA_POLICY=CW1-12751';
set newname for datafile 1 to'/data/oradata/system.259.906653629';
set newname for datafile 2 to '/data/oradata/sysaux.260.906653631';
set newname for datafile 3 to '/data/oradata/undotbs1.261.906653633';
set newname for datafile 4 to '/data/oradata/undotbs2.263.906653645';
set newname for datafile 5 to '/data/oradata/users.264.906653645';
set newname for datafile 6 to '/data/oradata/nnc_data01';
set newname for datafile 7 to '/data/oradata/nnc_data01_01';
set newname for datafile 8 to '/data/oradata/nnc_data01_02';
set newname for datafile 9 to '/data/oradata/nnc_data01_03';
set newname for datafile 10 to '/data/oradata/nnc_data02';
set newname for datafile 11 to '/data/oradata/nnc_data03';
set newname for datafile 12 to '/data/oradata/nnc_data03_01';
set newname for datafile 13 to '/data/oradata/nnc_data03_02';
set newname for datafile 14 to '/data/oradata/nnc_data03_03';
set newname for datafile 15 to '/data/oradata/nnc_index01';
set newname for datafile 16 to '/data/oradata/nnc_index02';
set newname for datafile 17 to '/data/oradata/nnc_index03';
set newname for datafile 18 to '/data/oradata/nnc_index01_1';
set newname for datafile 19 to '/data/oradata/nnc_index02_1';
set newname for datafile 20 to '/data/oradata/nnc_index03_1';
set newname for datafile 21 to '/data/oradata/iufo';
set newname for datafile 22 to '/data/oradata/nnc_data01_04';
set newname for datafile 23 to '/data/oradata/nnc_data01_05';
restore database;
switch datafile all;
RELEASE CHANNEL ch00;
}
恢复归档
run{
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' PARMS'SBT_LIBRARY=/usr/openv/netbackup/bin/libobk.so64';
SEND 'NB_ORA_SERV=nbu-server,NB_ORA_CLIENT=CW1,NB_ORA_POLICY=CW1-12751';
recover database ;
RELEASE CHANNEL ch00;
}
channel ch00: restore complete, elapsed time: 00:02:55
archived log file name=/backup/1_5845_906653624.dbfthread=1 sequence=5845
archived log file name=/backup/2_3606_906653624.dbfthread=2 sequence=3606
archived log file name=/backup/2_3607_906653624.dbfthread=2 sequence=3607
archived log file name=/backup/1_5846_906653624.dbfthread=1 sequence=5846
archived log file name=/backup/2_3608_906653624.dbfthread=2 sequence=3608
channel ch00: starting archived log restore to defaultdestination
channel ch00: restoring archived log
archived log thread=2 sequence=3609
channel ch00: restoring archived log
archived log thread=1 sequence=5847
channel ch00: reading from backup piece al_21_1_930565957
channel ch00: piece handle=al_21_1_930565957tag=TAG20161214T102855
channel ch00: restored backup piece 1
channel ch00: restore complete, elapsed time: 00:00:25
archived log file name=/backup/2_3609_906653624.dbfthread=2 sequence=3609
archived log file name=/backup/1_5847_906653624.dbfthread=1 sequence=5847
unable to find archived log
archived log thread=1 sequence=5848
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS===============
RMAN-00571:===========================================================
RMAN-03002: failure of recover command at 12/15/201614:01:57
RMAN-06054: media recovery requesting unknown archivedlog for thread 1 with sequence 5848 and starting SCN of 545399791
alter database rename file'+ASMDATA/zjscw/onlinelog/group_11' to '/data/oradata/redo01.log';
alter database rename file '+ASMDATA/zjscw/onlinelog/group_12'to '/data/oradata/redo02.log';
alter database rename file'+ASMDATA/zjscw/onlinelog/group_13' to '/data/oradata/redo03.log';
alter database rename file'+ASMDATA/zjscw/onlinelog/group_14' to '/data/oradata/redo04.log';
alter database rename file'+ASMDATA/zjscw/onlinelog/group_15' to '/data/oradata/redo05.log';
alter database rename file'+ASMDATA/zjscw/onlinelog/group_16' to '/data/oradata/redo06.log';
----重建控制文件
SQL> alter database backup controlfile to trace as'/data/c.sql';
Database altered.
SQL> shut immediate
ORA-01109: database not open
Database dismounted.
ORACLE instance shut down.
SQL> SQL> SQL> SQL>
SQL>
SQL> startup nomount;
ORACLE instance started.
Total System Global Area 4125609984 bytes
Fixed Size 2259640 bytes
Variable Size 1962935624 bytes
Database Buffers 2147483648 bytes
Redo Buffers 12931072 bytes
SQL>
SQL>
CREATE CONTROLFILE REUSE DATABASE "ZJSCW"RESETLOGS ARCHIVELOG
MAXLOGFILES 192
MAXLOGMEMBERS 3
MAXDATAFILES1024
MAXINSTANCES 32
MAXLOGHISTORY2920
LOGFILE
GROUP 11'/data/oradata/redo01.log' SIZE 512MBLOCKSIZE 512,
GROUP 12'/data/oradata/redo02.log' SIZE 512MBLOCKSIZE 512,
GROUP 13'/data/oradata/redo03.log' SIZE 512MBLOCKSIZE 512,
GROUP 14'/data/oradata/redo04.log' SIZE 512MBLOCKSIZE 512,
GROUP 15'/data/oradata/redo05.log' SIZE 512MBLOCKSIZE 512,
GROUP 16'/data/oradata/redo06.log' SIZE 512MBLOCKSIZE 512
-- STANDBY LOGFILE
DATAFILE
'/data/oradata/system.259.906653629',
'/data/oradata/sysaux.260.906653631',
'/data/oradata/undotbs1.261.906653633',
'/data/oradata/undotbs2.263.906653645',
'/data/oradata/users.264.906653645',
'/data/oradata/nnc_data01',
'/data/oradata/nnc_data01_01',
'/data/oradata/nnc_data01_02',
'/data/oradata/nnc_data01_03',
'/data/oradata/nnc_data02',
'/data/oradata/nnc_data03',
'/data/oradata/nnc_data03_01',
'/data/oradata/nnc_data03_02',
'/data/oradata/nnc_data03_03',
'/data/oradata/nnc_index01',
'/data/oradata/nnc_index02',
'/data/oradata/nnc_index03',
'/data/oradata/nnc_index01_1',
'/data/oradata/nnc_index02_1',
'/data/oradata/nnc_index03_1',
'/data/oradata/iufo',
'/data/oradata/nnc_data01_04',
'/data/oradata/nnc_data01_05'
CHARACTER SET ZHS16GBK;
SQL> alter database open resetlogs;
Database altered.
SQL> alter database open resetlogs;
Database altered.
SQL> create temporary tablespace TEMP1 TEMPFILE '/data/oradata/temp.dbf' SIZE 50M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED;
Tablespace created.
SQL> alter database default temporary tablespace temp1;
Database altered.
SQL> droptablespace temp including contents and datafiles;
Tablespace dropped.
重建undo 表空间
create undo tablespace undotbs02 datafile '/data/oradata /undotbs02.dbf' size10M
alter system setundo_tablespace='undotbs02';
show parameter undo
drop tablespace undotbs1 including contents anddatafiles;
*******************遇到的问题
RMAN> run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE' ;
SEND 'NB_ORA_SERV=nbu-server,NB_ORA_CLIENT=CW1';
set DBID = 816687480 ;
restore controlfile from 'cntrl_22_1_930565993';
RELEASE CHANNEL ch00;
}
2> 3> 4> 5> 6> 7>
allocated channel: ch00
channel ch00: SID=1082 device type=SBT_TAPE
channel ch00: Veritas NetBackup for Oracle - Release7.7.3 (2016051915)
sent command to channel: ch00
executing command: SET DBID
Starting restore at 14-DEC-16
channel ch00: restoring control file
released channel: ch00
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS===============
RMAN-00571:===========================================================
RMAN-03002: failure of restore command at 12/14/201618:46:07
ORA-19870: error while restoring backup piececntrl_22_1_930565993
ORA-19507: failed to retrieve sequential file,handle="cntrl_22_1_930565993", parms=""
ORA-27029: skgfrtrv: sbtrestore returned error
ORA-19511: Error received from media manager layer, errortext:
Failed to openbackup file for restore.
解决:在恢复主机端
[oracle@orctest netbackup]$ pwd
/usr/openv/netbackup
[oracle@orctest netbackup]$ cat bp.conf
SERVER = NBU-SERVER ---备份服务器
SERVER = CW1 ---添加备份服务器源端
SERVER = orctest ---恢复服务器
CLIENT_NAME = orctest
CONNECT_OPTIONS = localhost 1 0 2
USE_VXSS = PROHIBITED
VXSS_SERVICE_TYPE = INTEGRITYANDCONFIDENTIALITY
EMMSERVER = nbu-server
HOST_CACHE_TTL = 3600
MEDIA_SERVER = orctest
TELEMETRY_UPLOAD = YES
alter database open resetlogs;
报错:
ORA-38856: cannot markinstance UNNAMED_INSTANCE_2 (redo thread 2) as enabled
解决方法:
ALTER DATABASE ADD LOGFILE THREAD 2
GROUP 5 '/u01/app/oradata/rac/redo001.log'SIZE 10M REUSE,
GROUP 6 '/u01/app/oradata/rac/redo001.log' SIZE 10M REUSE;
alter database open resetlogs;
alter database disable thread 2;
select * from v$log;
alter system archive log current;
alter database drop logfile group n;
alter database drop logfile group n+1;