NetWorker:Oracle 備份失敗,並顯示錯誤「ORA 03113 通訊通道上的檔案結束」

摘要: Oracle 備份失敗,並顯示錯誤「ORA-03113:通訊通道上的檔案結束」。

本文章適用於 本文章不適用於 本文無關於任何特定產品。 本文未識別所有產品版本。

症狀

錯誤訊息如下所示:

RMAN> run {
2> allocate channel c1 type 'sbt_tape' format '%d_%U';
3> }

using target database control file instead of recovery catalog
PSDRPC returns significant error 3113.
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of allocate command on c1 channel at 10/27/2023 13:07:49
ORA-03113: end-of-file on communication channel

sbttest was also failed:
[GW-DB:oracle:SJGW80:/]$sbttest /etc/hosts -no_proxy_backup -no_proxy_restore
The sbt function pointers are loaded from libobk.so library.
(pid 3839660): Failed to resolve hostname client1 to an internet address. Please verify a mapping for client1 exists in the /etc/hosts file or DNS.
-- sbtinit succeeded
(pid 3839661): Failed to resolve hostname client1 to an internet address. Please verify a mapping for client1 exists in the /etc/hosts file or DNS.
-- sbtinit (2nd time) succeeded
sbtinit: Media manager supports SBT API version 2.0
sbtinit: vendor description string=NMDA Oracle v19.4.0.6
sbtinit: allocated sbt context area of 2280 bytes
sbtinit: Media manager is version 19.4.0.0
sbtinit: proxy copy is supported
sbtinit: maximum concurrent proxy copy files is 0
(pid 3839659): Failed to resolve hostname client1 to an internet address. Please verify a mapping for client1 exists in the /etc/hosts file or DNS.

原因

這是因為使用者 Oracle 無法存取 /etc/hosts 檔案中所定義。NMDA Oracle 備份是以使用者 Oracle 而非 root 啟動。
[client1:root:/]# ls -arlt /etc/hosts
-rw------- l root root 233 10 20 11:27 /etc/hosts

[client1:oracle:/]$cat /etc/hosts
cat: /etc/hosts: Permmission denied

解析度

授予讀取權限 /etc/hosts 給使用者 Oracle。
文章屬性
文章編號: 000219976
文章類型: Solution
上次修改時間: 08 10月 2025
版本:  3
向其他 Dell 使用者尋求您問題的答案
支援服務
檢查您的裝置是否在支援服務的涵蓋範圍內。