如何免安裝異機恢復sap bi系統及資料庫
前言，我們在做sap basis時，總是對檔案進行了備份，包括sap的安裝檔案、資料庫安裝檔案。現在我們透過以上備份，對系統進行異機恢復測試。本次測試，其實非常有意義的，sap的安裝會耗費大量的時間，如果透過免安裝恢復，可以節約大量的時間。在我們進行同構硬體升級時，這個意義比較大，可以直接透過tar包進行操作，再把資料庫恢復到最新，可以大大的提高速度
一、作業系統準備
1.1安裝作業系統並安裝相應的包
在伺服器上安裝作業系統這一步比較簡單
補丁包的安裝也比較簡單，對於其它unix或者linux系統來說，其步驟基本上是差不多的
# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWpool SUNWpoolr SUNWsprot SUNWtoo SUNWuiu8 SUNWfont-xorg-core SUNWfont-xorg-iso8859-1 SUNWmfrun SUNWxorg-client-programs SUNWxorg-clientlibs SUNWxwfsw SUNWxwplt
system SUNWarc Lint Libraries (usr)
system SUNWbtool CCS tools bundled with SunOS
system SUNWfont-xorg-core X.Org Foundation X11 core fonts
system SUNWfont-xorg-iso8859-1 X.Org Foundation X11 iso8859-1 fonts
system SUNWhea SunOS Header Files
system SUNWlibm Math & Microtasking Library Headers & Lint Files (Usr)
system SUNWlibms Math & Microtasking Libraries (Usr)
system SUNWmfrun Motif RunTime Kit
system SUNWpool Resource Pools
system SUNWpoolr Resource Pools (Root)
system SUNWsprot Solaris Bundled tools
system SUNWtoo Programming Tools
system SUNWuiu8 Iconv modules for UTF-8 Locale
system SUNWxorg-client-programs X.Org Foundation X Client Programs
system SUNWxorg-clientlibs X.Org Foundation X Client Libraries
system SUNWxwfsw X Window System platform required font software
system SUNWxwplt X Window System platform software
以上包存在，就沒有問題了！我們採用的用恢復檔案的方式進行的，所以我們可以不安裝圖形介面，需要補安裝的是字符集
# pkg install pkg:/text/locale@0.5.11-0.175.1.0.0.24.2
Packages to install: 1
Create boot environment: No
Create backup boot environment: No
DOWNLOAD PKGS FILES XFER (MB) SPEED
Completed 1/1 42/42 0.2/0.2 0B/s
PHASE ITEMS
Installing new actions 69/69
Updating package state database Done
Updating image state Done
Creating fast lookup database Done
:~# pkg install pkg:/system/locale/extra@0.5.11-0.175.1.0.0.23.1134
Packages to install: 3
Create boot environment: No
Create backup boot environment: Yes
Services to change: 1
DOWNLOAD PKGS FILES XFER (MB) SPEED
Completed 3/3 5382/5382 82.9/82.9 0B/s
PHASE ITEMS
Installing new actions 6132/6132
Updating package state database Done
Updating image state Done
Creating fast lookup database Done
最後用locale -a來檢查就行了
1.2建立檔案目錄或者掛載點
事先準備好儲存，建好pool池，我這裡建了三個掛載點，如下：
:~# zpool create -f datapool /dev/dsk/c8t2d0
:~# zpool add -f datapool /dev/dsk/c8t3d0
:~# zpool add -f datapool /dev/dsk/c8t4d0
:~# zpool add -f datapool /dev/dsk/c8t5d0
:~# zpool add -f datapool /dev/dsk/c8t6d0
# zfs create -o mountpoint=/usr/sap datapool/usrsap
# zfs create -o mountpoint=/sapmnt datapool/sapmnt
# zfs create -o mountpoint=/oracle datapool/oracle
# mkdir -p /oracle/BIP
1.3 建立使用者組及使用者
這一步，儘量使我們本機上的使用者名稱與id與源環境的相同。
透過/etc/passwd及group檔案來檢視，在備份的時候，我們也將這兩個檔案一同備份
--建立使用者組
# groupadd -g 100 sapinst
# groupadd -g 101 sapsys
# groupadd -g 102 dba
# groupadd -g 103 oper
# usermod -G +sapinst root
--建立使用者
# useradd -u 100 -b /export/home bipadm
# useradd -u 101 -b /export/home sapadm
# useradd -u 102 -b /oracle/BIP orabip
# useradd -u 103 -b /export/home daaadm
--把使用者新增到組裡
新增主組
# usermod -g sapsys sapadm --新增主組
# usermod -g sapsys bipadm
# usermod -g dba orabip
# usermod -g sapsys daaadm
新增輔組
# usermod -G +sapinst bipadm --新增輔組
# usermod -G +sapinst sapadm
# usermod -G +sapinst orabip
# usermod -G +sapinst daaadm
# usermod -G +dba bipadm
# usermod -G +oper bipadm
# usermod -G +oper orabip
1.4建立資源使用
solaris是建立project，aix及linux也是透過編輯系統引數來實現
# projadd -p 200 -c "SAP System BIP" -U bipadm,orabip \-K "process.max-file-descriptor=(basic,65536,deny)" \-K "process.max-sem-nsems=(priv,2048,deny)" \-K "project.max-sem-ids=(priv,1024,deny)" \-K "project.max-shm-ids=(priv,256,deny)" \-K "project.max-shm-memory=(priv,18446744073709551615,deny)" \BIP
如果沒有這一步，後面的資料庫及sap程式會報錯
oracle資料庫會報：
ORA-27102 out of memory
sap在啟動的時候會報：
rdisp/http_min_wait_dia_wp : 1 -> 1
***LOG CPS=> DpLoopInit, ICU ( 4.0.1 4.0.1 5.1) [dpxxdisp.c 1702]
***LOG Q0I=> NiPConnect2: 192.168.91.133:3900: connect (146: Connection refused) [nixxi.cpp 3285]
*** ERROR => NiPConnect2: SiPeekPendConn failed for hdl 17/sock 12
(SI_ECONN_REFUSE/146; I4; ST; 10.10.1.133:3900) [nixxi.cpp 3285]
*** ERROR => MsIAttachEx: NiBufConnect to MYRESTBI/3900 failed (rc=NIECONN_REFUSED) [msxxi.c 713]
***LOG Q0L=> DpLoopInit, nomscon () [dpxxdisp.c 1804]
CCMS: SemInMgt: Semaphore Management initialized by AlAttachShm_Doublestack.
CCMS: SemInit: Semaphore 38 initialized by AlAttachShm_Doublestack.
CCMS: start to initalize 3.X shared alert area (first segment).
上面的好些東西就說明是與記憶體、訊號等相關的
我也編輯了/etc/system中的一些引數，如下：
set zfs:zfs_arc_max = 2147483648
set shmsys:shminfo_shmmax = 38654705664
set semsys:seminfo_semmni = 1000
set semsys:seminfo_semmns = 50000
set pg_contig_disable = 1
具體的錯誤，大家可以透過/usr/sap/BIP/DVEBMGS01/work/dev_disp及dev_w0來檢視報錯，然後具體處理
1.5編輯hosts
MYRESTBI:orabip> cat /etc/hosts
#
# Copyright 2009 Sun Microsystems, Inc. All rights reserved.
# Use is subject to license terms.
#
# Internet host table
#
::1 localhost
127.0.0.1 localhost loghost
10.10.1.133 MYRESTBI
透過以上步驟後，作業系統方面的準備已經就緒，可以進行恢復了
二、sap軟體、資料庫軟體的恢復
1、sap軟體、資料庫軟體物理恢復
開啟nbu，透過呼叫備份進行恢復
export Fri Apr 18 11:45:56 CST 2014
oracle Fri Apr 18 11:45:55 CST 2014
sapmnt Fri Apr 18 11:45:53 CST 2014
usr Fri Apr 18 11:45:54 CST 2014
可以看到所要備份的目錄，選擇目錄進行還原，具體過程就不在多說。如果透過tar包的方式，也是沒問題的，目的就把源機目錄還原到目標端去
2、恢復還原資料庫
2.1對還原後的資料庫安裝軟體進行處理
relink all
writing relink log to: /oracle/BIP/112_64/install/relink.log
relink all
writing relink log to: /oracle/BIP/112_64/install/relink.log
relink all
writing relink log to: /oracle/BIP/112_64/install/relink.log
relink all
writing relink log to: /oracle/BIP/112_64/install/relink.log
relink all
writing relink log to: /oracle/BIP/112_64/install/relink.log
cd $ORACLE_HOME
cat oraInst.loc
inventory_loc=/oracle/oraInventory
inst_group=dba
cat oraInst.loc
inventory_loc=/oracle/oraInventory
inst_group=dba
cat oraInst.loc
inventory_loc=/oracle/oraInventory
inst_group=dba
cat oraInst.loc
inventory_loc=/oracle/oraInventory
inst_group=dba
cat oraInst.loc
inventory_loc=/oracle/oraInventory
inst_group=dba
cd /oracle/BIP/112_64/clone/config
vi cs.properties
# Copyright (c) 2005, Oracle. All rights reserved.
# clone command line
clone_command_line= -silent -noConfig -nowait -invPtrLoc
vi cs.properties
# Copyright (c) 2005, Oracle. All rights reserved.
# clone command line
clone_command_line= -silent -noConfig -nowait -invPtrLoc
vi cs.properties
# Copyright (c) 2005, Oracle. All rights reserved.
# clone command line
clone_command_line= -silent -noConfig -nowait -invPtrLoc
vi cs.properties
# Copyright (c) 2005, Oracle. All rights reserved.
# clone command line
clone_command_line= -silent -noConfig -nowait -invPtrLoc
vi cs.properties
# Copyright (c) 2005, Oracle. All rights reserved.
# clone command line
clone_command_line= -silent -noConfig -nowait -invPtrLoc
./clone.pl \
> ORACLE_HOME="/oracle/BIP/11203"
./runInstaller -clone -waitForCompletion "ORACLE_HOME=/oracle/BIP/112_64" -defaultHomeName -silent -noConfig -nowait -invPtrLoc
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 39290 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2014-01-16_10-18-36AM. Please wait ...Oracle Universal Installer, Version 11.2.0.3.0 Production
Copyright (C) 1999, 2011, Oracle. All rights reserved.
You can find the log of this install session at:
/oracle/oraInventory/logs/cloneActions2014-01-16_10-18-36AM.log
OUI-10197:Unable to create a new Oracle Home at /oracle/BIP/112_64. Oracle Home already exists at this location. Select another location.
SEVERE:OUI-10197:Unable to create a new Oracle Home at /oracle/BIP/112_64. Oracle Home already exists at this location. Select another location.
:~# cd /oracle/BIP/112_64
# ./root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= orabip
ORACLE_HOME= /oracle/BIP/11203
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The contents of "oraenv" have not changed. No need to overwrite.
The contents of "coraenv" have not changed. No need to overwrite.
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
./oracle_link
Thursday, January 16, 2014 10:23:27 AM CST
All Oracle instances should be shutdown before running this script.
Please log into the Unix system as the Oracle owner for running this script
Do you want to continue? (y/n) [n] y
LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /oracle/BIP/112_64
Oracle version: 11.2.0.3.0
Platform type: sparc
Linking LIBOBK:
Moving 64-bit libobk.so to libobk.so.back
ln -s /usr/openv/netbackup/bin/libobk.so64.1 /oracle/BIP/112_64/lib/libobk.so
Done
Please check the trace file located in /tmp/make_trace.4612
to make sure the linking process was successful.
透過以上處理步驟，資料庫軟體基本上沒什麼問題了。
2.2恢復還原資料庫
--建立資料目錄，這個與原檔案相同即可
./oracle_link
Thursday, January 16, 2014 10:23:27 AM CST
All Oracle instances should be shutdown before running this script.
Please log into the Unix system as the Oracle owner for running this script
Do you want to continue? (y/n) [n] y
LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /oracle/BIP/112_64
Oracle version: 11.2.0.3.0
Platform type: sparc
Linking LIBOBK:
Moving 64-bit libobk.so to libobk.so.back
ln -s /usr/openv/netbackup/bin/libobk.so64.1 /oracle/BIP/112_64/lib/libobk.so
Done
Please check the trace file located in /tmp/make_trace.4612
to make sure the linking process was successful.
透過以上處理步驟，資料庫軟體基本上沒什麼問題了。
2.2恢復還原資料庫
--建立資料目錄，這個與原檔案相同即可
./oracle_link
Thursday, January 16, 2014 10:23:27 AM CST
All Oracle instances should be shutdown before running this script.
Please log into the Unix system as the Oracle owner for running this script
Do you want to continue? (y/n) [n] y
LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /oracle/BIP/112_64
Oracle version: 11.2.0.3.0
Platform type: sparc
Linking LIBOBK:
Moving 64-bit libobk.so to libobk.so.back
ln -s /usr/openv/netbackup/bin/libobk.so64.1 /oracle/BIP/112_64/lib/libobk.so
Done
Please check the trace file located in /tmp/make_trace.4612
to make sure the linking process was successful.
透過以上處理步驟，資料庫軟體基本上沒什麼問題了。
2.2恢復還原資料庫
--建立資料目錄，這個與原檔案相同即可
./oracle_link
Thursday, January 16, 2014 10:23:27 AM CST
All Oracle instances should be shutdown before running this script.
Please log into the Unix system as the Oracle owner for running this script
Do you want to continue? (y/n) [n] y
LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /oracle/BIP/112_64
Oracle version: 11.2.0.3.0
Platform type: sparc
Linking LIBOBK:
Moving 64-bit libobk.so to libobk.so.back
ln -s /usr/openv/netbackup/bin/libobk.so64.1 /oracle/BIP/112_64/lib/libobk.so
Done
Please check the trace file located in /tmp/make_trace.4612
to make sure the linking process was successful.
透過以上處理步驟，資料庫軟體基本上沒什麼問題了。
2.2恢復還原資料庫
--建立資料目錄，這個與原檔案相同即可
./oracle_link
Thursday, January 16, 2014 10:23:27 AM CST
All Oracle instances should be shutdown before running this script.
Please log into the Unix system as the Oracle owner for running this script
Do you want to continue? (y/n) [n] y
LIBOBK path: /usr/openv/netbackup/bin
ORACLE_HOME: /oracle/BIP/112_64
Oracle version: 11.2.0.3.0
Platform type: sparc
Linking LIBOBK:
Moving 64-bit libobk.so to libobk.so.back
ln -s /usr/openv/netbackup/bin/libobk.so64.1 /oracle/BIP/112_64/lib/libobk.so
Done
Please check the trace file located in /tmp/make_trace.4612
to make sure the linking process was successful.
透過以上處理步驟，資料庫軟體基本上沒什麼問題了。
2.2恢復還原資料庫
--建立資料目錄，這個與原檔案相同即可
mkdir origlogA
mkdir origlogB
mkdir origlogB
mkdir origlogB
mkdir origlogB
mkdir origlogB
mkdir mirrlogA
mkdir mirrlogB
mkdir mirrlogB
mkdir mirrlogB
mkdir mirrlogB
mkdir mirrlogB
mkdir -p /oracle/BIP/origlogA/cntrl
mkdir -p /oracle/BIP/origlogB/cntrl
mkdir -p /oracle/BIP/origlogB/cntrl
mkdir -p /oracle/BIP/origlogB/cntrl
mkdir -p /oracle/BIP/origlogB/cntrl
mkdir -p /oracle/BIP/origlogB/cntrl
mkdir -p /oracle/BIP/sapdata1/cntrl
mkdir -p /oracle/BIP/oraarch/BIParch
mkdir -p /oracle/BIP/oraarch/BIParch
mkdir -p /oracle/BIP/oraarch/BIParch
mkdir -p /oracle/BIP/oraarch/BIParch
mkdir -p /oracle/BIP/oraarch/BIParch
mkdir -p /oracle/BIP/sapdata1/system_1
mkdir -p /oracle/BIP/sapdata1/sysaux_1
mkdir -p /oracle/BIP/sapdata1/sysaux_1
mkdir -p /oracle/BIP/sapdata1/sysaux_1
mkdir -p /oracle/BIP/sapdata1/sysaux_1
mkdir -p /oracle/BIP/sapdata1/sysaux_1
mkdir -p /oracle/BIP/sapdata1/undo_1
mkdir -p /oracle/BIP/sapdata2/sr3_1
mkdir -p /oracle/BIP/sapdata2/sr3_1
mkdir -p /oracle/BIP/sapdata2/sr3_1
mkdir -p /oracle/BIP/sapdata2/sr3_1
mkdir -p /oracle/BIP/sapdata2/sr3_1
mkdir -p /oracle/BIP/sapdata2/sr3_2
mkdir -p /oracle/BIP/sapdata2/sr3_3
mkdir -p /oracle/BIP/sapdata2/sr3_3
mkdir -p /oracle/BIP/sapdata2/sr3_3
mkdir -p /oracle/BIP/sapdata2/sr3_3
mkdir -p /oracle/BIP/sapdata2/sr3_3
mkdir -p /oracle/BIP/sapdata2/sr3_4
mkdir -p /oracle/BIP/sapdata2/sr3_5
mkdir -p /oracle/BIP/sapdata2/sr3_5
mkdir -p /oracle/BIP/sapdata2/sr3_5
mkdir -p /oracle/BIP/sapdata2/sr3_5
mkdir -p /oracle/BIP/sapdata2/sr3_5
mkdir -p /oracle/BIP/sapdata2/sr3_6
mkdir -p /oracle/BIP/sapdata2/sr3_7
mkdir -p /oracle/BIP/sapdata2/sr3_7
mkdir -p /oracle/BIP/sapdata2/sr3_7
mkdir -p /oracle/BIP/sapdata2/sr3_7
mkdir -p /oracle/BIP/sapdata2/sr3_7
mkdir -p /oracle/BIP/sapdata2/sr3_8
mkdir -p /oracle/BIP/sapdata2/sr3_9
mkdir -p /oracle/BIP/sapdata2/sr3_9
mkdir -p /oracle/BIP/sapdata2/sr3_9
mkdir -p /oracle/BIP/sapdata2/sr3_9
mkdir -p /oracle/BIP/sapdata2/sr3_9
mkdir -p /oracle/BIP/sapdata3/sr3730_1
mkdir -p /oracle/BIP/sapdata3/sr3730_2
mkdir -p /oracle/BIP/sapdata3/sr3730_2
mkdir -p /oracle/BIP/sapdata3/sr3730_2
mkdir -p /oracle/BIP/sapdata3/sr3730_2
mkdir -p /oracle/BIP/sapdata3/sr3730_2
mkdir -p /oracle/BIP/sapdata3/sr3730_3
mkdir -p /oracle/BIP/sapdata3/sr3730_4
mkdir -p /oracle/BIP/sapdata3/sr3730_4
mkdir -p /oracle/BIP/sapdata3/sr3730_4
mkdir -p /oracle/BIP/sapdata3/sr3730_4
mkdir -p /oracle/BIP/sapdata3/sr3730_4
mkdir -p /oracle/BIP/sapdata3/sr3730_5
mkdir -p /oracle/BIP/sapdata3/sr3730_6
mkdir -p /oracle/BIP/sapdata3/sr3730_6
mkdir -p /oracle/BIP/sapdata3/sr3730_6
mkdir -p /oracle/BIP/sapdata3/sr3730_6
mkdir -p /oracle/BIP/sapdata3/sr3730_6
mkdir -p /oracle/BIP/sapdata4/sr3usr_1
mkdir -p /oracle/BIP/sapdata4/sr3730x_1
mkdir -p /oracle/BIP/sapdata4/sr3730x_1
mkdir -p /oracle/BIP/sapdata4/sr3730x_1
mkdir -p /oracle/BIP/sapdata4/sr3730x_1
mkdir -p /oracle/BIP/sapdata4/sr3730x_1
mkdir -p /oracle/BIP/sapdata4/sr3730x_2
mkdir -p /oracle/BIP/sapdata4/sr3730x_3
mkdir -p /oracle/BIP/sapdata4/sr3730x_3
mkdir -p /oracle/BIP/sapdata4/sr3730x_3
mkdir -p /oracle/BIP/sapdata4/sr3730x_3
mkdir -p /oracle/BIP/sapdata4/sr3730x_3
mkdir -p /oracle/BIP/sapdata4/sr3730x_4
mkdir -p /oracle/BIP/sapdata4/sr3730x_5
mkdir -p /oracle/BIP/sapdata4/sr3730x_5
mkdir -p /oracle/BIP/sapdata4/sr3730x_5
mkdir -p /oracle/BIP/sapdata4/sr3730x_5
mkdir -p /oracle/BIP/sapdata4/sr3730x_5
mkdir -p /oracle/BIP/sapdata4/sr3730x_6
mkdir -p /oracle/BIP/sapdata4/sr3730x_7
mkdir -p /oracle/BIP/sapdata4/sr3730x_7
mkdir -p /oracle/BIP/sapdata4/sr3730x_7
mkdir -p /oracle/BIP/sapdata4/sr3730x_7
mkdir -p /oracle/BIP/sapdata4/sr3730x_7
mkdir -p /oracle/BIP/sapdata4/sr3730x_8
mkdir -p /oracle/BIP/sapdata4/sr3730x_9
mkdir -p /oracle/BIP/sapdata4/sr3730x_9
mkdir -p /oracle/BIP/sapdata4/sr3730x_9
mkdir -p /oracle/BIP/sapdata4/sr3730x_9
mkdir -p /oracle/BIP/sapdata4/sr3730x_9
mkdir -p /oracle/BIP/sapdata4/sr3730x_10
mkdir -p /oracle/BIP/sapdata4/sr3730x_11
mkdir -p /oracle/BIP/sapdata4/sr3730x_11
mkdir -p /oracle/BIP/sapdata4/sr3730x_11
mkdir -p /oracle/BIP/sapdata4/sr3730x_11
mkdir -p /oracle/BIP/sapdata4/sr3730x_11
mkdir -p /oracle/BIP/sapdata4/sr3730x_12
mkdir -p /oracle/BIP/sapdata4/sr3730x_13
mkdir -p /oracle/BIP/sapdata4/sr3730x_13
mkdir -p /oracle/BIP/sapdata4/sr3730x_13
mkdir -p /oracle/BIP/sapdata4/sr3730x_13
mkdir -p /oracle/BIP/sapdata4/sr3730x_13
mkdir -p /oracle/BIP/sapdata1/system_2
mkdir -p /oracle/BIP/sapdata4/sr3730x_14
mkdir -p /oracle/BIP/sapdata4/sr3730x_14
mkdir -p /oracle/BIP/sapdata4/sr3730x_14
mkdir -p /oracle/BIP/sapdata4/sr3730x_14
mkdir -p /oracle/BIP/sapdata4/sr3730x_14
mkdir -p /oracle/BIP/sapdata1/sysaux_2
mkdir -p /oracle/BIP/sapdata4/sr3730x_15
--編輯引數檔案
mkdir -p /oracle/BIP/sapdata4/sr3730x_15
--編輯引數檔案
mkdir -p /oracle/BIP/sapdata4/sr3730x_15
--編輯引數檔案
mkdir -p /oracle/BIP/sapdata4/sr3730x_15
--編輯引數檔案
mkdir -p /oracle/BIP/sapdata4/sr3730x_15
--編輯引數檔案
vi BIPfile.ora
注意，以下的編輯，根據需要進行修改
BIP.__oracle_base='/oracle'#ORACLE_BASE set from environment
*._B_TREE_BITMAP_PLANS=FALSE
*._IN_MEMORY_UNDO=FALSE
*._INDEX_JOIN_ENABLED=FALSE
*._OPTIM_PEEK_USER_BINDS=FALSE
*._OPTIMIZER_MJC_ENABLED=FALSE
*._SORT_ELIMINATION_COST_RATIO=10
*._TABLE_LOOKUP_PREFETCH_SIZE=0
*.audit_file_dest='/oracle/BIP/saptrace/audit'
*.compatible='11.2.0'
*.control_file_record_keep_time=30
*.control_files='/oracle/BIP/origlogA/cntrlBIP.dbf','/oracle/BIP/origlogB/cntrlBIP.dbf'
*.db_block_size=8192
*.db_cache_size=9277129359
*.db_name='BIP'
*.db_recovery_file_dest='/oracle/BIP/oraflash'
*.db_recovery_file_dest_size=30000M
*.diagnostic_dest='/oracle/BIP/saptrace'
*.FILESYSTEMIO_OPTIONS='setall'
*.log_archive_dest_1='LOCATION=/oracle/BIP/oraarch/BIParch'
*.log_archive_format='%t_%s_%r.dbf'
*.log_checkpoints_to_alert=true
*.max_dump_file_size='20000'
*.open_cursors=2000
*.parallel_execution_message_size=16384
*.parallel_threads_per_cpu=1
*.pga_aggregate_target=12369505812
*.processes=750
*.query_rewrite_enabled='false'
*.recyclebin='off'
*.remote_login_passwordfile='exclusive'
*.remote_os_authent=true
*.replication_dependency_tracking=false
*.sessions=1500
*.shared_pool_size=9277129359
*.star_transformation_enabled='true'
*.undo_tablespace='PSAPUNDO'
--啟動資料庫到nomount狀態
SQL> startup pfile='/oracle/BIP/orapfile.ora';
啟動後，就可以透過rman進入恢復介面
--檢查nbu裡面的恢復檔案
hdnbu1:/usr/openv/netbackup/db # mkdir altnames
hdnbu1:/usr/openv/netbackup/db # cd altnames/
hdnbu1:/usr/openv/netbackup/db/altnames # touch No.Restrictions
注意，如果在nbu上面首次執行恢復操作的話，以上三步不能少。
以下顯示的是要恢復的控制檔案，我們選擇其一進行恢復
mynbu2:~ # bplist -C tarbidb -t 4 -R -b -l / | more
-rw-rw---- orabip dba 26476544 Jan 16 09:11 /c-749400663-20140116-07
-rw-rw---- orabip dba 26476544 Jan 16 09:11 /cntrl_4870_1_836989680
-rw-rw---- orabip dba 26476544 Jan 16 09:10 /c-749400663-20140116-06
-rw-rw---- orabip dba 32243712 Jan 16 09:00 /al_4868_1_836989017
-rw-rw---- orabip dba 26476544 Jan 16 07:17 /c-749400663-20140116-05
-rw-rw---- orabip dba 26476544 Jan 16 07:14 /cntrl_4866_1_836982673
-rw-rw---- orabip dba 26476544 Jan 16 07:12 /c-749400663-20140116-04
--恢復資料庫控制檔案
cd /oracle/BIP
cd /oracle/BIP
cd /oracle/BIP
cd /oracle/BIP
cd /oracle/BIP
export ORACLE_SID=BIP
rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 16 11:06:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount pfile='/oracle/BIP/BIPfile.ora';
Oracle instance started
Total System Global Area 19113713664 bytes
Fixed Size 2167280 bytes
Variable Size 9730788880 bytes
Database Buffers 9328132096 bytes
Redo Buffers 52625408 bytes
RMAN> run
{
allocate channel c1 type 'sbt_tape';
send 'NB_ORA_CLIENT=HDBIOPDB';
restore controlfile from '/cntrl_4243_1_845075914';
release channel c1;
}
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1324 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.5 (2012050823)
sent command to channel: c1
Starting restore at 16-JAN-14
channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:02:05
output file name=/oracle/BIP/origlogA/cntrlBIP.dbf
output file name=/oracle/BIP/origlogB/cntrlBIP.dbf
Finished restore at 16-JAN-14
released channel: c1
--恢復資料庫檔案
rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 16 11:06:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount pfile='/oracle/BIP/BIPfile.ora';
Oracle instance started
Total System Global Area 19113713664 bytes
Fixed Size 2167280 bytes
Variable Size 9730788880 bytes
Database Buffers 9328132096 bytes
Redo Buffers 52625408 bytes
RMAN> run
{
allocate channel c1 type 'sbt_tape';
send 'NB_ORA_CLIENT=HDBIOPDB';
restore controlfile from '/cntrl_4243_1_845075914';
release channel c1;
}
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1324 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.5 (2012050823)
sent command to channel: c1
Starting restore at 16-JAN-14
channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:02:05
output file name=/oracle/BIP/origlogA/cntrlBIP.dbf
output file name=/oracle/BIP/origlogB/cntrlBIP.dbf
Finished restore at 16-JAN-14
released channel: c1
--恢復資料庫檔案
rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 16 11:06:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount pfile='/oracle/BIP/BIPfile.ora';
Oracle instance started
Total System Global Area 19113713664 bytes
Fixed Size 2167280 bytes
Variable Size 9730788880 bytes
Database Buffers 9328132096 bytes
Redo Buffers 52625408 bytes
RMAN> run
{
allocate channel c1 type 'sbt_tape';
send 'NB_ORA_CLIENT=HDBIOPDB';
restore controlfile from '/cntrl_4243_1_845075914';
release channel c1;
}
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1324 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.5 (2012050823)
sent command to channel: c1
Starting restore at 16-JAN-14
channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:02:05
output file name=/oracle/BIP/origlogA/cntrlBIP.dbf
output file name=/oracle/BIP/origlogB/cntrlBIP.dbf
Finished restore at 16-JAN-14
released channel: c1
--恢復資料庫檔案
rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 16 11:06:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount pfile='/oracle/BIP/BIPfile.ora';
Oracle instance started
Total System Global Area 19113713664 bytes
Fixed Size 2167280 bytes
Variable Size 9730788880 bytes
Database Buffers 9328132096 bytes
Redo Buffers 52625408 bytes
RMAN> run
{
allocate channel c1 type 'sbt_tape';
send 'NB_ORA_CLIENT=HDBIOPDB';
restore controlfile from '/cntrl_4243_1_845075914';
release channel c1;
}
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1324 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.5 (2012050823)
sent command to channel: c1
Starting restore at 16-JAN-14
channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:02:05
output file name=/oracle/BIP/origlogA/cntrlBIP.dbf
output file name=/oracle/BIP/origlogB/cntrlBIP.dbf
Finished restore at 16-JAN-14
released channel: c1
--恢復資料庫檔案
rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 16 11:06:31 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database (not started)
RMAN> startup nomount pfile='/oracle/BIP/BIPfile.ora';
Oracle instance started
Total System Global Area 19113713664 bytes
Fixed Size 2167280 bytes
Variable Size 9730788880 bytes
Database Buffers 9328132096 bytes
Redo Buffers 52625408 bytes
RMAN> run
{
allocate channel c1 type 'sbt_tape';
send 'NB_ORA_CLIENT=HDBIOPDB';
restore controlfile from '/cntrl_4243_1_845075914';
release channel c1;
}
using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=1324 device type=SBT_TAPE
channel c1: Veritas NetBackup for Oracle - Release 7.5 (2012050823)
sent command to channel: c1
Starting restore at 16-JAN-14
channel c1: restoring control file
channel c1: restore complete, elapsed time: 00:02:05
output file name=/oracle/BIP/origlogA/cntrlBIP.dbf
output file name=/oracle/BIP/origlogB/cntrlBIP.dbf
Finished restore at 16-JAN-14
released channel: c1
--恢復資料庫檔案
sqlplus "/as sysdba"
SQL*Plus: Release 11.2.0.3.0 Production on Thu Jan 16 11:24:26 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> alter database mount;
Database altered.
vi BIPrestore.sh
export ORACLE_SID=BIP
rman target / <
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=tarbidb';
Restore database;
Switch datafile all;
}
這個需要的時間比較長，可以做些其它的準備
--恢復歸檔日誌
SQL> select max(SEQUENCE#),min(SEQUENCE#) from v$archived_log where COMPLETION_TIME >= to_date('20140416 17:00:01','yyyymmdd hh24:mi:ss');
MAX(SEQUENCE#) MIN(SEQUENCE#)
-------------- --------------
5611 5331
vi BIPrestore.sh
export ORACLE_SID=BIP
rman target / <
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=tarbidb';
Restore database;
Switch datafile all;
}
這個需要的時間比較長，可以做些其它的準備
--恢復歸檔日誌
SQL> select max(SEQUENCE#),min(SEQUENCE#) from v$archived_log where COMPLETION_TIME >= to_date('20140416 17:00:01','yyyymmdd hh24:mi:ss');
MAX(SEQUENCE#) MIN(SEQUENCE#)
-------------- --------------
5611 5331
vi BIPrestore.sh
export ORACLE_SID=BIP
rman target / <
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=tarbidb';
Restore database;
Switch datafile all;
}
這個需要的時間比較長，可以做些其它的準備
--恢復歸檔日誌
SQL> select max(SEQUENCE#),min(SEQUENCE#) from v$archived_log where COMPLETION_TIME >= to_date('20140416 17:00:01','yyyymmdd hh24:mi:ss');
MAX(SEQUENCE#) MIN(SEQUENCE#)
-------------- --------------
5611 5331
vi BIPrestore.sh
export ORACLE_SID=BIP
rman target / <
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=tarbidb';
Restore database;
Switch datafile all;
}
這個需要的時間比較長，可以做些其它的準備
--恢復歸檔日誌
SQL> select max(SEQUENCE#),min(SEQUENCE#) from v$archived_log where COMPLETION_TIME >= to_date('20140416 17:00:01','yyyymmdd hh24:mi:ss');
MAX(SEQUENCE#) MIN(SEQUENCE#)
-------------- --------------
5611 5331
vi BIPrestore.sh
export ORACLE_SID=BIP
rman target / <
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=tarbidb';
Restore database;
Switch datafile all;
}
這個需要的時間比較長，可以做些其它的準備
--恢復歸檔日誌
SQL> select max(SEQUENCE#),min(SEQUENCE#) from v$archived_log where COMPLETION_TIME >= to_date('20140416 17:00:01','yyyymmdd hh24:mi:ss');
MAX(SEQUENCE#) MIN(SEQUENCE#)
-------------- --------------
5611 5331
rman target /
Recovery Manager: Release 11.2.0.3.0 - Production on Thu Jan 16 11:57:27 2014
Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.
connected to target database: BIP (DBID=749400663, not open)
run
{
set archivelog destination to '/oracle/BIP/oraarch';
ALLOCATE CHANNEL ch00 TYPE 'SBT_TAPE';
send 'NB_ORA_CLIENT=tarbidb';
restore archivelog sequence between 2024 and 2027;
RELEASE CHANNEL ch00;
}
--還原資料庫
sqlplus " a="" sysdba"SQL> recover database using backup controlfile until cancel;
第一次選擇auto，然後會自動運用歸檔日誌
SQL> recover database using backup controlfile until cancel;
sqlplus " p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba"Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
sqlplus " p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " ORA-00279: change 47293818 generated at 01/16/2014 03:56:44 needed for thread 1
ORA-00289: suggestion : /oracle/BIP/oraarch/BIParch1_5608_825957847.dbf
ORA-00280: change 47293818 for thread 1 is in sequence #5608
Specify log: {
auto
sqlplus " p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " until="" controlfile="" backup="" using="" database="" recover="" cancel; ORA-00279: change 47308405 generated at 01/16/2014 08:56:57 needed for thread 1
ORA-00289: suggestion : /oracle/BIP/oraarch/BIParch1_5612_825957847.dbf
ORA-00280: change 47308405 for thread 1 is in sequence #5612
sqlplus " p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba" Specify log: {
cancel
Media recovery cancelled.
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " database="" sysdba"sql>="" resetlogs; --開啟資料庫
SQL> alter database open resetlogs;Database altered.
--建立臨時表空間
sqlplus " p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba"--建立臨時表空間SQL> create temporary tablespace saptemp tempfile '/oracle/BIP/sapdata2/saptemp01.dbf' size 8192m;
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " created.
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " database="" sysdba"sql> ="" alter="" saptemp;
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " altered.
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba"--修改監聽、tnsnames
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba"主要是將裡面的tarbidb替換成myrestbi
sqlplus " p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba"修改後，可以重新啟監聽，註冊資料庫
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba"到此資料庫的恢復工作已經完成，下面開始sap軟體的處理
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba"3、sap軟體還原後的處理
sqlplus " a="" p="" data-ke-src="mailto:orabip@MYRESTBI:~$2>orabip@MYRESTBI:~$ sqlplus " sysdba"3.1資料夾授權
# chown -R bipadm:sapsys *
# chown -R orabip:sapsys brarchive
# chown -R orabip:sapsys brbackup
# chown -R orabip:sapsys brconnect
3.2修改系統使用者bipadm使用者的檔案
--修改系統使用者檔案
具體修改辦法
透過編輯進入後,輸入冒號(:)
然後鍵入 g/tarbidb/s//MYRESTBI/g
/export/home/bipadm
這個是根據建使用者裡的設定做的
.dbenv_tarbidb.1.csh
.dbenv_tarbidb.1.sh
.dbenv.sh
.dbenv.csh
這些檔案裡面涉及到tarbidb的部份，分部修改為MYRESTBI，我是把檔案也進行了修改
如下：
MYRESTBI:bipadm> mv .dbenv_tarbidb.1.csh .dbenv_MYRESTBI.1.csh
其它的也這樣進行修改。
--修改ERS10裡的引數
MYRESTBI:bipadm> cd /usr/sap/BIP/ERS10/profile
MYRESTBI:bipadm> ls -lrt
total 29
-rw-r--r-- 1 bipadm sapsys 2193 Apr 18 16:10 DEFAULT.PFL
-rw-r--r-- 1 bipadm sapsys 48 Apr 18 16:44 BIP_ERS10_tarbidb.lst
-rw-r--r-- 1 bipadm sapsys 2258 Apr 18 16:48 BIP_ERS10_tarbidb
-rw-r--r-- 1 bipadm sapsys 1216 Apr 21 11:41 dev_icm.old
-rw-r--r-- 1 bipadm sapsys 1192 Apr 21 11:42 dev_icm_sec
-rw-r--r-- 1 bipadm sapsys 1218 Apr 21 11:42 dev_icm
-rw-r--r-- 1 bipadm sapsys 876 Apr 21 14:09 dev_sapstart
主要對最上面的三個檔案進行修改，把檔案裡的內容hostname進行替換，也就是把tarbidb替換成MYRESTBI
然後把檔名進行更名如BIP_ERS10_tarbidb.lst更換成BIP_ERS10_MYRESTBI.lst
--修改SYS裡面的引數檔案
MYRESTBI:bipadm> cd /usr/sap/BIP/SYS/profile
drwxr-xr-x 2 bipadm sapsys 4 Apr 18 15:23 oracle
-rw-r--r-- 1 bipadm sapsys 2193 Apr 18 16:10 DEFAULT.PFL
-rw-r--r-- 1 bipadm sapsys 160 Apr 18 16:21 dev_sapstart
-rw-r--r-- 1 bipadm sapsys 92 Apr 18 16:21 sapstart.log
-rw-r--r-- 1 bipadm sapsys 71 Apr 18 16:21 INSTSTAT
-rw-r--r-- 1 bipadm sapsys 48 Apr 18 16:44 BIP_ERS10_tarbidb.lst
-rw-r--r-- 1 bipadm sapsys 2064 Apr 18 16:46 DEFAULT.1.PFL
-rw-r--r-- 1 bipadm sapsys 593 Apr 18 16:46 DEFAULT.2.PFL
-rw-r--r-- 1 bipadm sapsys 708 Apr 18 16:47 DEFAULT.3.PFL
-rw-r--r-- 1 bipadm sapsys 742 Apr 18 16:47 DEFAULT.4.PFL
-rw-r--r-- 1 bipadm sapsys 826 Apr 18 16:47 DEFAULT.5.PFL
-rw-r--r-- 1 bipadm sapsys 2258 Apr 18 16:48 BIP_ERS10_tarbidb
-rw-r--r-- 1 bipadm sapsys 12180 Apr 18 16:49 BIP_DVEBMGS01_tarbidb
-rw-r--r-- 1 bipadm sapsys 2506 Apr 18 16:50 BIP_ASCS00_tarbidb
-rw-r--r-- 1 bipadm sapsys 2438 Apr 18 16:50 BIP_ASCS00_tarbidb.1
-rw-r--r-- 1 bipadm sapsys 12468 Apr 18 16:51 BIP_DVEBMGS01_tarbidb.1
-rw-rw---- 1 bipadm sapsys 4254 Apr 18 16:51 BIP_DVEBMGS01_tarbidb.2
修改方法與上面類似，為了徹底，我對所的檔名及內容都進行了修改
--修改sap裡面的tnsnames.ora
MYRESTBI:bipadm> cd /usr/sap/BIP/SYS/profile/oracle
-rw-r--r-- 1 bipadm sapsys 500 Nov 9 22:52 sqlnet.ora
-rw-r--r-- 1 bipadm sapsys 492 Apr 18 15:23 tnsnames.ora
將配置檔案中的tarbidb替換成MYRESTBI
3.3修改daaadm使用者相關檔案
MYRESTBI:daaadm> cd /usr/sap/DAA/SYS/profile/
MYRESTBI:daaadm> ls -lrt
total 17
-rw-r--r-- 1 daaadm sapsys 449 Nov 10 06:50 DEFAULT.PFL
-rw-r--r-- 1 daaadm sapsys 1782 Apr 21 10:44 DAA_SMDA98_tarbidb
-rw-r--r-- 1 daaadm sapsys 1669 Apr 21 10:45 DAA_SMDA98_tarbidb.1
-rw-r--r-- 1 daaadm sapsys 1742 Apr 21 10:46 DAA_SMDA98_tarbidb.2
其修改方法同上面所述，完全一樣，檔案裡的內容及檔名均進行替換
透過以上的修改，那麼基本上我們sap軟體的配置修改工作已經結束，也就是說，相當於我們安裝好了sap軟體，資料庫也完成了
三、啟動sap軟體
檢查資料庫連線是否正常
MYRESTBI:bipadm> R3trans -d
This is R3trans version 6.24 (release 720 - 08.07.13 - 20:13:05 ).
unicode enabled version
R3trans finished (0000).
說明資料庫已經正常
啟動sap軟體
MYRESTBI:bipadm> startsap
Checking BIP Database
Database is not available via R3trans
-------------------------------------------
Trying to start BIP database ...
Log file: /export/home/bipadm/startdb.log
BIP database started
Starting Startup Agent sapstartsrv
OK
Instance Service on host MYRESTBI started
-------------------------------------------
starting SAP Instance ERS10
Startup-Log is written to /export/home/bipadm/startsap_ERS10.log
-------------------------------------------
/usr/sap/BIP/ERS10/exe/sapcontrol -prot NI_HTTP -nr 10 -function Start
Instance on host MYRESTBI started
Starting Startup Agent sapstartsrv
OK
Instance Service on host MYRESTBI started
-------------------------------------------
starting SAP Instance ASCS00
Startup-Log is written to /export/home/bipadm/startsap_ASCS00.log
-------------------------------------------
/usr/sap/BIP/ASCS00/exe/sapcontrol -prot NI_HTTP -nr 00 -function Start
Instance on host MYRESTBI started
Starting Startup Agent sapstartsrv
OK
Instance Service on host MYRESTBI started
-------------------------------------------
starting SAP Instance DVEBMGS01
Startup-Log is written to /export/home/bipadm/startsap_DVEBMGS01.log
-------------------------------------------
/usr/sap/BIP/DVEBMGS01/exe/sapcontrol -prot NI_HTTP -nr 01 -function Start
Instance on host MYRESTBI started
然後透過gui登入恢復環境，圖形介面出來了
透過ps -ef | grep -i sap ，一切正常！
四、問題處理與排查
問題1：
啟動sap的時候，發現啟動的資料庫，也被關閉掉，後來排查是因為記憶體設定不合理所致
問題2.
開始的時候，始終無法啟動BIP_DVEBMGS01，後來透過排查目錄下面的
/usr/sap/BIP/DVEBMGS01/work dev_disp, dev_w0兩個檔案，找到問題把在，仍然是記憶體設定不合理。
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29371470/viewspace-1147135/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- ClickHouse資料庫單機安裝及備份恢復資料庫
- 資料庫異機冷備恢復資料庫
- 【資料庫資料恢復】SAP資料庫資料恢復案例資料庫資料恢復
- 【資料庫資料恢復】linux系統下MYSQL資料庫資料恢復案例資料庫資料恢復LinuxMySql
- Oracle異地資料庫恢復Oracle資料庫
- SQL Server 系統資料庫恢復SQLServer資料庫
- oracle 9I 資料庫異機恢復( Catalog 庫 )Oracle資料庫
- 【資料庫資料恢復】EXT3檔案系統下MYSQL資料庫恢復案例資料庫資料恢復MySql
- 【資料庫資料恢復】如何恢復Oracle資料庫truncate表的資料資料庫資料恢復Oracle
- SQL Server2000 如何恢復系統資料庫？SQLServer資料庫
- Oracle資料庫故障恢復資料庫系統故障恢復效能優化指南大全Oracle資料庫優化
- 【資料庫資料恢復】HP-UX系統ORACLE資料庫被誤刪除的資料恢復資料庫資料恢復UXOracle
- 資料庫備份與異機恢復——熱備份方式資料庫
- 資料庫異機恢復開啟報錯ORA-36961資料庫
- Oracle備份恢復之熱備份恢復及異機恢復Oracle
- RAC資料庫的RMAN備份異機恢復到單節點資料庫資料庫
- 生產系統恢復到異機測試
- vivo 資料庫備份恢復系統演化資料庫
- 資料庫資料恢復—NTFS分割槽損壞如何恢復SqlServer資料庫資料資料庫資料恢復SQLServer
- 【資料庫資料恢復】Oracle資料庫ASM磁碟組掉線如何恢復資料？資料庫資料恢復OracleASM
- RMAN異機恢復異作業系統（Linux到Windows）作業系統LinuxWindows
- 【資料庫資料恢復】SQL server資料庫被加密怎麼辦？如何恢復？資料庫資料恢復SQLServer加密
- 同事拿錯作業系統安裝盤，導致資料庫安裝異常作業系統資料庫
- NAS升級如何恢復系統資料夾？
- SCN, checkpoint 及資料庫的恢復資料庫
- 寶塔資料庫恢復 mysql資料庫丟失恢復 mysql資料庫刪除庫恢復 寶塔mysql資料庫恢復資料庫MySql
- 資料庫資料恢復-oracle資料庫報錯無法開啟的如何恢復資料？資料庫資料恢復Oracle
- 資料庫資料恢復-SQL SERVER資料庫MDF (NDF)或LDF損壞如何恢復資料？資料庫資料恢復SQLServer
- 【資料庫資料恢復】Sql Server資料庫資料恢復案例資料庫資料恢復SQLServer
- 【kingsql分享】將RAC資料庫異機恢復到單例項（Ⅰ）SQL資料庫單例
- 伺服器資料恢復-ext3檔案系統下oracle資料庫資料恢復案例伺服器資料恢復Oracle資料庫
- Oracle資料庫的冷備份及冷備份異地恢復方法Oracle資料庫
- 戴爾一鍵恢復出廠自帶系統 戴爾如何恢復原裝系統
- Oracle資料庫冷備份的異地恢復Oracle資料庫
- oracle 異機恢復Oracle
- 恢復資料庫資料庫
- 【資料庫資料恢復】透過恢復NDF檔案修復資料庫的資料恢復過程資料庫資料恢復
- 自研資料庫CynosDB儲存系統如何實現即時恢復資料庫