當前位置:首頁 » 數據倉庫 » nbu如何配置ddboost
擴展閱讀
webinf下怎麼引入js 2023-08-31 21:54:13
堡壘機怎麼打開web 2023-08-31 21:54:11

nbu如何配置ddboost

發布時間: 2023-06-03 20:21:41

⑴ nbu怎樣恢復oracle資料庫

1、安裝操作系統
2、安裝資料庫系統
3、安裝nbu軟體及配置
--安裝客戶端
上傳SYMCnbclient_Linux-RedHat2.6.18_7.5.0.2.tar編輯本機hosts
vi /etc/hosts
添加:192.168.99.252 hdnbu1
解壓:
[root@scmtest u01]# tar -xvf SYMCnbclient_Linux-RedHat2.6.18_7.5.0.2.tar[root@scmtest u01]# cd SYMCnbclient_Linux-RedHat2.6.18_7.5.0.2[root@scmtest SYMCnbclient_Linux-RedHat2.6.18_7.5.0.2]# ./install過程當中要輸入備份服務端:hdnbu1
然後再用oracle用戶執行:
[root@scmtest bin]# su - oracle
[oracle@scmtest ~]$ cd /usr/openv/netbackup/bin[oracle@scmtest bin]$ ./oracle_link
Thu Feb 21 14:03:02 CST 2013
All Oracle instances should be shutdown before running this script.
Please log into the Unix system as the Oracle owner for running this scriptDo you want to continue? (y/n) [n] y
LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /software/oracle/proct/10.2.0/db1Oracle version: 10.2.0.5.0
Platform type: x86_64
Linking LIBOBK:
ln -s /usr/openv/netbackup/bin/libobk.so64 /software/oracle/proct/10.2.0/db1/lib/libobk.soDone
Please check the trace file located in /tmp/make_trace.23602to make sure the linking process was successful.
4、編輯初始參數文件
這時候,需要進行修改,比如原來用的什麼盤,現在用什麼盤等編輯後如下:
*._addm_auto_enable=FALSE
*._b_tree_bitmap_plans=FALSE
*._db_block_numa=1
*._enable_NUMA_optimization=FALSE
*._optimizer_cartesian_enabled=FALSE
*._optimizer_skip_scan_enabled=FALSE
*.archive_lag_target=1800
*.audit_file_dest='/software/oracle/admin/ncerp/amp'
*.background_mp_dest='/software/oracle/admin/ncerp/bmp'
*.compatible='10.2.0.5.0'
*.control_files='/u01/ncerp/control/control01.ctl','/u01/ncerp/control/control02.ctl'
*.core_mp_dest='/software/oracle/admin/ncerp/cmp'
*.db_block_size=8192
*.db_cache_size=4294967296
*.db_create_file_dest='/u01/ncerp/flash_recover'
*.db_domain=''
*.db_file_multiblock_read_count=16
*.db_name='ncerp'
*.java_pool_size=33554432
*.job_queue_processes=10
*.large_pool_size=33554432
*.log_archive_dest_1='location=/u01/ncerp/arch'
*.log_archive_format='%s_%t_%r.log'
*.max_mp_file_size='1024'
*.open_cursors=1000
*.optimizer_dynamic_sampling=4
*.optimizer_index_cost_adj=40
*.parallel_max_servers=5
*.pga_aggregate_target=2147483648
*.processes=800
*.recyclebin='OFF'
*.shared_pool_size=838860800
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
5、根據參數文件,建相應的目錄
[oracle@scmtest ~]$ mkdir -p /u01/ncerp/control/[oracle@scmtest u01]$ mkdir -p /app/oracle/admin/ncerp/cmp[oracle@scmtest u01]$ mkdir -p /app/oracle/admin/ncerp/bmp[oracle@scmtest u01]$ mkdir -p /app/oracle/admin/ncerp/amp[oracle@scmtest u01]$ mkdir -p /app/oracle/admin/ncerp/pfile[oracle@scmtest u01]$ mkdir -p /u01/ncerp/flash_recover[oracle@scmtest u01]$ mkdir -p /u01/ncerp/arch[oracle@scmtest ncerp]$ mkdir oradata
注意:這些要與參數文件對應,要不然無法啟動!
6、恢復控制文件
export ORACLE_SID=ncerp
[oracle@scmtest u01]$ rman target /
Recovery Manager: Release 10.2.0.5.0 - Proction on Thu Feb 21 14:17:10 2013Copyright (c) 1982, 2007, Oracle. All rights reserved.
connected to target database (not started)RMAN> startup nomount pfile='/u01/ncpfile.ora';Oracle instance started
Total System Global Area 5217714176 bytesFixed Size 2103536 bytesVariable Size 905971472 bytesDatabase Buffers 4294967296 bytesRedo Buffers 14671872 bytes從nbu的伺服器上查詢要恢復的控制文件
hdnbu1:/tmp # bplist -C RD162 -t 4 -R -b -l / | more-rw-rw---- oracle dba 10747904 Mar 28 11:26 /c-3383507379-20130328-0b-rw-rw---- oracle dba 11010048 Mar 28 11:25 /c-2177845250-20130328-0d-rw-rw---- oracle dba 10747904 Mar 28 11:25 /cntrl_9202_1_811250475-rw-rw---- oracle dba 10747904 Mar 28 11:25 /cntrl_7788_1_811250456-rw-rw---- oracle dba 10747904 Mar 28 11:25 /c-3383507379-20130328-0a-rw-rw---- oracle dba 11010048 Mar 28 11:24 /c-2177845250-20130328-0c-rw-rw---- oracle dba 114032640 Mar 28 11:17 /al_7786_1_811249961-rw-rw---- oracle dba 123207680 Mar 28 11:17 /al_7785_1_811249961-rw-rw---- oracle dba 3670016 Mar 28 11:17 /al_9200_1_811249960-rw-rw---- oracle dba 3932160 Mar 28 11:17 /al_9199_1_811249959-rw-rw---- oracle dba 11010048 Mar 28 09:25 /c-2177845250-20130328-0b-rw-rw---- oracle dba 10747904 Mar 28 09:25 /c-3383507379-20130328-09-rw-rw---- oracle dba 10747904 Mar 28 09:25 /cntrl_9197_1_811243259-rw-rw---- oracle dba 10747904 Mar 28 09:25 /cntrl_7783_1_811243253RMAN> run
2> {
3> allocate channel c1 type 'sbt_tape';
4> send 'NB_ORA_CLIENT=RD162';
5> restore controlfile from '/cntrl_24145_1_828414748';6> release channel c1;
7> }
using target database control file instead of recovery catalogallocated channel: c1
channel c1: sid=874 devtype=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.5 (2012050902)sent command to channel: c1
Starting restore at 2013-03-28 12:41:30
channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:05:16output filename=/u02/ncerp/control/control01.ctloutput filename=/u02/ncerp/control/control02.ctlFinished restore at 2013-03-28 12:46:47
released channel: c1
7、還原資料庫文件
在這里要查一下資料庫是否已經mount
sql> select status from v$instance;
STATUS
------------
MOUNTED
RMAN> run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=RD162';
set newname for datafile '/backup/ncerp/oradata/system01.dbf' to '/u02/ncerp/oradata/system01.dbf' ;set newname for datafile '/backup/ncerp/oradata/system02.dbf' to '/u02/ncerp/oradata/system02.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_index03_1.dbf' to '/u02/ncerp/oradata/nnc_index03_1.dbf';set newname for datafile '/backup/ncerp/oradata/undotbs1.dbf' to '/u02/ncerp/oradata/undotbs1.dbf' ;set newname for datafile '/backup/ncerp/oradata/sysaux01.dbf' to '/u02/ncerp/oradata/sysaux01.dbf' ;set newname for datafile '/backup/ncerp/oradata/users01.dbf' to '/u02/ncerp/oradata/users01.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data01_1.dbf' to '/u02/ncerp/oradata/nnc_data01_1.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data01_2.dbf' to '/u02/ncerp/oradata/nnc_data01_2.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data01_3.dbf' to '/u02/ncerp/oradata/nnc_data01_3.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data01_4.dbf' to '/u02/ncerp/oradata/nnc_data01_4.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data02_1.dbf' to '/u02/ncerp/oradata/nnc_data02_1.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data02_2.dbf' to '/u02/ncerp/oradata/nnc_data02_2.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data03_1.dbf' to '/u02/ncerp/oradata/nnc_data03_1.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data03_2.dbf' to '/u02/ncerp/oradata/nnc_data03_2.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data03_3.dbf' to '/u02/ncerp/oradata/nnc_data03_3.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data03_4.dbf' to '/u02/ncerp/oradata/nnc_data03_4.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_index02_1.dbf' to '/u02/ncerp/oradata/nnc_index02_1.dbf';set newname for datafile '/backup/ncerp/oradata/nnc_index01_1.dbf' to '/u02/ncerp/oradata/nnc_index01_1.dbf';set newname for datafile '/backup/ncerp/oradata/nnc_index01_2.dbf' to '/u02/ncerp/oradata/nnc_index01_2.dbf';set newname for datafile '/backup/ncerp/oradata/nnc_index01_3.dbf' to '/u02/ncerp/oradata/nnc_index01_3.dbf';set newname for datafile '/backup/ncerp/oradata/nnc_index01_4.dbf' to '/u02/ncerp/oradata/nnc_index01_4.dbf';set newname for datafile '/backup/ncerp/oradata/iufo01.dbf' to '/u02/ncerp/oradata/iufo01.dbf' ;set newname for datafile '/backup/ncerp/oradata/iufo02.dbf' to '/u02/ncerp/oradata/iufo02.dbf' ;set newname for datafile '/backup/ncerp/oradata/nnc_data03_5.dbf' to '/u02/ncerp/oradata/nnc_data03_5.dbf' ;Restore database;
Switch datafile all;
}
vi res_test.sh 內容如下:
export ORACLE_SID=ncerp
rman target / < run {
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=RD162';
做一次恢復測試看看
說明需要3556這個歸檔日誌
所以恢復時,從這個日誌進行恢復!
也可以採用後台運行方式
9、資料庫恢復
SQL>
cancel
說明,如果上面日誌可能有點大的時候,我們需要調整,比如說刪除日誌組等,然後還重新添加日誌到新位置10、打開資料庫
SQL> alter database open resetlogs;
Database altered.
11、創建臨時表空間

⑵ nbu client 怎麼配置

  1. 配/etc/hosts把master server和media server的主機名 ip加進去

  2. 配master server和media server的hosts把client的主機名和ip加進去

  3. ./install安裝。安裝過程中輸入master和media的主機名

  4. 安裝完成後到bin目錄下bpclntcmd -pn檢測是否有信息輸出,報錯說明之間埠不通

  5. 以上都成功後到master server的nbu console裡面的host properties 應該能看到client信息

  6. 對應的備份策略有很多,,不知道你要備份哪一種


⑶ 請教,關於NBU media server問題

NBUversion:7.5

MediaServer:WindowsServer 2008R2 hostname:BALY

帶庫: IBM3584

最近在巡視時發現MediaServer備份失敗,打開NBUAdministrotar Console 發現MediaServer上的一個drive出現 pathmissing。

1 TroubleShooting

在命令行執行發現一個MISSING_PATH,如下:

C:\Program Files\Veritas\Volmgr\bin>tpconfig -l

Type Num Index Type DrNum Status Comment Name Path

robot 0 - TLD - - - - bcsyyfx

drive - 9 hcart2 8 DOWN - IBM.ULT3580-TD5.009 MISSING_PATH:{4,0,6,0}:00078AD2A

Robot下一共有12個drive,其中一個出現問題,檢查操作系統設備驅動發現tape驅動都正常運行,這里設置的是NBU通過操作系統驅動來獲得路徑的,所以肯定是NBU出問題了,經過檢查這個設備驅動在操作系統的port=4bus=0 target=5 lun=0 {4,0,5,0},而NBU中設置的卻是4,0,6,0,所以需要重新配置path。

2重新配置path

2.1在MediaServer上,刪除現有路徑

…\Volmgr\bin>tpconfig –delete –drpath –port 4 –bus 0 –target 6 –lun0 –asciiname IBM.ULT3580-TD5.009

2.2重啟nbu進程

…\Netbackup\bin>bpdown –f –v

…\Netbackup\bin>bpup –f -v

2.3查看drive 狀態

…\Volmgr\bin>vmoprcmd

MISS_PATH的drive已經刪除,但是其他dirve狀態由TLD變為restart,文檔上並沒有restart的介紹,上網查了一下,出現restart意思是,當在MediaServer上添加、刪除、修改robot或dirve後,device path需要重新啟動。好吧。不管它。

2.4重新添加path

在MasterServer上使用向導」configureStrage Devices」,勾選選擇MediaserverBALY,報錯」error connecting to oprd>BALY: oprd returned an abnormal status (96)」這樣就無法添加drive path了,只能先解決這個問題先。

從網上搜了一個解決辦法

先在MediaServer上關閉NBU進程bpdown–f –v

修改NBU安裝路徑下Volmgr\misc目錄下的vmd.lock文件名稱

開啟進程bpup –f–v

在MasterServer上執行NBU安裝路徑\NetBackup\bin\admincmd\nbrbutil –resetMediaServer BALY

注意:1先使用nbrbutil -mp 檢查沒有device Allocations 卡在EMM中

2 使用nbrbutil前確保沒有job運行,nbrbutil會關閉所以正常運行的job

重新在MasterServer打開控制台,向導」configureStrage Devices」可以正常使用,選中BALY,下一步,添加設備,下一步,然後OK

在MediaServer上使用vmoprcmd檢查drive的狀態,都是TLD,手工備份測試,可以備份了,OK大功告成。

⑷ NBU故障代碼83:備份走FT的故障處理

備份走FT,報異仔友常狀態碼83,如下圖

1.查詢知道SAN client 主機名與現有的主機名不一致

2.重新添加SAN client 故障恢復

3.SAN client 上面,

一、修改bp.conf文件,注釋#SANCLIENT = 1,之後 bp.kill_all,之後念做槐 bpclntcmd -clear_host_cache,之後 bp.start_all

二、完成在server上刪除後,去注釋#SANCLIENT = 1,之後 bp.kill_all,之後 bp.start_all

4.NBU server上面,

一、nbftconfig -deleteclient  hostname  #刪除主機,若不成功如下,則胡物 nbrbutil -listorphanedpipes && nbrbutil -releaseorphanedpipes

----------------

Run 'nbrbutil -listorphanedpipes' and if the output shows orphaned pipe(s), run 'nbrbutil -releaseorphanedpipes' to release same.

Following that, run 'nbftconfig -deleteserver' command, which should be successful. If not, collect nbdb_unload information and examine output per internal notes below.

Problem

After properly deleting all FT clients associated with an FT server, the following error code may occur when trying to delete the FT server:

# nbftconfig -deleteserver ftserver01

Failed to delete the FT server

EXIT error: unable to process request because the server resources are busy

EXIT status = 134

There are some jobs on this machine

--------------------

二、 nbemmcmd -deletehost -machinename hostname    #刪除主機

三、完成主機上的重新配置後,重新掃描,nbftconfig -rescanallclients

⑸ NBU備份軟體詞彙總結

differetial incremental backup:差異增量備份
cumulative incremental backup:累積增量備份
user backup:用戶備份
user archive:用戶檔案
archived redo log backup:歸檔重做日誌備份
properties:屬性
item:項目
scheles:時間表、調度
frequency:頻率
calendar:日歷
archive files:存檔文件
archive:封存、存檔
keyword phrase:關鍵字片語
task progess:任務進度
manual backup:手動備份
retetion:保留
automatic:自動
application backup:應用程序備份
unknow schele backup:未知時間表備份
no data classification:沒有數據分類
platinum:鉑, 白金
gold:黃金
silver:白銀
bronze:青銅
any available:任何可用
puredisk:純磁碟
advancedisk:高級風險
catalog-backup:目錄備份
limit jobs per policy:限制每個策略的作業數
job priority:工作優先順序
higher number is greater priority:數字越大優先順序越高
go into effect at:生效於,從什麼時間開始生效
disable client-side deplicati:禁用客戶端重復數據刪除
use accelerator:使用加速器
keyword phrase:關鍵字片語
enable indexing for search :為渣寬粗搜索啟用索引
must also be enabled for the schele and client:還必如鎮須為計劃和客戶端啟用
indexing server:索引伺服器
multiple copies:多個副本
override policy storage selection:覆蓋策略存儲選擇
override policy volume pool:覆蓋策略卷池
override media owner:覆巧孝蓋媒體所有者
media multiplexing:媒體多路復用
virtual machine selection:虛擬機選擇
select manually:手動選擇
select automatically through query:通過查詢自動選擇
browse and select virtual machine:瀏覽並選擇虛擬機
enable vcloud director integration:啟用vcloud控制器集成
netbackup host to perform automatic virtual machine selection:netbackup主機執行自動虛擬機選擇
query builder:查詢生成器
field:領域
operator:操作人員
value:值,價值
advanced:高級
test the query to view results. vms selected for backup may vary with any change in the virtual environment:測試查詢以查看結果。 選擇用於備份的虛擬機可能會隨虛擬環境的變化而變化
reuse vm selection query results:重用vm選擇查詢結果
backup selections:備份選擇
optimizations:優化
enable file recovery from vm backup:從vm備份啟用文件恢復
enable block-level incremental backup:啟用塊級增量備份
exclude deleted blocks:排除已刪除的塊
Exclude swap and paging files:排除交換和分頁文件
transport modes:傳輸方式
netbackup tries each selected transport in order from top to bottom:netbackup按從上到下的順序嘗試每個選定的傳輸
san: use san to move virtual disk data:san方式,使用san網路移動虛擬磁碟數據
nbd: do not encrypt the virtual disk data for over-the-network transform :nbd方式,非san方式,不要加密虛擬磁碟數據以進行網路轉換
hotadd: use virtual disk files from netbackup server : hotadd方式,使用netbackup伺服器中的虛擬磁碟文件
encrypt the virtual disk data for over-the-network transform : 加密虛擬磁碟數據以進行網路轉換
primary vm identifier:主虛擬機標識符
orphaned snapshot handling:孤立快照處理
application protection:應用保護
enable exchange recovery:啟用exchange恢復
enable sql server recovery:啟用sql server恢復
print preview:列印預覽
liveupdate:實時更新
undo:取消
edit:編輯
view:視圖、看法、意見
toolbar:工具欄
status bar:狀態欄
previous pane:前窗格
customize:定製
refresh:刷新
large icons:大圖標
columns:列
to new policy:復制到新策略
activate:啟用
deactivate:停用
troubleshooter:疑難解答
storage units:存儲單元
storage lifecycle policies:存儲生命周期策略
catalog:目錄
host properties:主機屬性
indexing servers:索引伺服器
media and device management:媒體和設備管理
volume pools:卷池
datastore:數據存儲
robots:機器人
standalone:獨立的
topology:拓撲結構
credentials:證書
disk array hosts:磁碟陣列主機
access management:訪問管理
bare metal restore management:裸機還原管理
vm conversion clients:虛擬機轉換客戶端
resources:資源
discovered configurations:發現的配置
archived boot floppies:存檔的啟動軟盤
bare metal restore tasks:裸機還原任務
vm conversion tasks:虛擬機轉換任務
logging assistant:

getting started:入門
get step-by-step help setting up netbackup:獲得有關設置netbackup的分步幫助
configure storage devices:配置存儲設備
define robots and drives:定義機器人和驅動器
configure disk storage servers:配置磁碟存儲伺服器
define servers supporting data deplication,openstorage or advanceddisk technology:定義支持重復數據刪除,開放存儲或高級磁碟技術的伺服器
configure cloud storage servers:配置雲存儲伺服器
define disk and media servers to be used in a disk pool:定義要在磁碟池中使用的磁碟和介質伺服器
configure volumes:配置卷
inventory robots and define volumes for use in standalone drives:盤點機器人並定義用於獨立驅動器的卷
configure the catalog backup:配置目錄備份
specify how and when netbackup configuration and catalog information is to be backed up:指定如何以及何時備份「netbackup配置和目錄信息」
create a policy:制定策略
define scheles and setting for backing up one or more clients,snapshots or virtual machines:定義用於備份一個或多個客戶端,快照或虛擬機的計劃和設置
import images:導入圖像
this wizard will assist you in stepping through an import:該向導將幫助您逐步完成導入
recover the catalog:恢復目錄
restore the catalog in a disaster recovery situation from a hot,online catalog backup:通過熱的在線目錄備份在災難恢復情況下還原目錄