Windows rman backup to shared drive failed

環境

Windows 2003
Oracle 10.2.0.4 EE

異常  

rman backup to shared drive failed

細節

中午接到南部業務轉來園區客戶的 mail , 附件有 rman backup log 如下


Recovery Manager: Release 10.2.0.4.0 - Production on Fri May 25 11:16:59 2018

 Copyright (c) 1982, 2007, Oracle.  All rights reserved.

 connected to target database: ExxxDB (DBID=19xxx06)
using target database control file instead of recovery catalog

 RMAN> run{
2> backup format 'Y:\oracle\backup\df_full_%U%T.dmp' as compressed backupset database;
3> sql 'alter system archive log current';
4> backup format 'Y:\oracle\backup\ar_full_%U%T.dmp' as compressed backupset archivelog all not backed up delete all input;
5> backup format 'Y:\oracle\backup\my_ControlSpfile_%U%T.dmp' current controlfile spfile;
6> }
7> 
Starting backup at 25-MAY-18
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=24 devtype=DISK
channel ORA_DISK_1: starting compressed full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
.....
<中略>
channel ORA_DISK_1: starting piece 1 at 25-MAY-18
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 05/25/2018 11:17:11
ORA-19504: failed to create file "Y:\ORACLE\BACKUP\DF_FULL_6RT3P85F_1_120180525.DMP"
ORA-27040: file create error, unable to create file
OSD-04002: unable to open file
O/S-Error: (OS 3) ?t??????w????C

 Recovery Manager complete.


Workaround 

RMAN 備份時出現無法建立檔案 (backupset), 不外乎下三種原因
1. 磁碟空間滿了
2. 目錄名稱不對
3. 網路磁碟機

實際連線至客戶端檢測, Y: disk 果然是網路磁碟機, 而服務裡的 oracle service 是由 Localsystem 啟動
參考 Doc ID 145843.1 , How to Configure RMAN to Write to Shared Drives on Windows NT/2000/2003
需將服務啟動帳號改為 administrator (或 domain admin, 如果有 domain)
修改完成後需重啟服務


留言

張貼留言

這個網誌中的熱門文章

12c RAC, OS log 出現 WARNING: couldn't allocate FBT table for module oracleacfs

環境 Solaris 11 SPARC (LDOM) Oracle 12.2.0.1 EE RAC  異常   OS log 出現  WARNING: couldn't allocate FBT table for module oracleacfs 細節 root@HISRAC1:~# dmesg |grep acfs Apr 27 01:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 02:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 03:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 04:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 05:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 06:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracleacfs Apr 27 07:08:03 HISRAC1 fbt: [ID 795213 kern.warning] WARNING: couldn't allocate FBT table for module oracl...
閱讀完整內容

11g client 連上 12c server, 出現 ora-28040

圖片
環境 Solaris 11 Oracle 12.2.0.1 EE 異常   開發人員使用 11g tools 連至 12c DB 時出現 ora-28040 細節 User 轉寄以下圖片 Workaround  這個很好查, 馬上就找到  12c: ORA-28040 After Upgrade: No Matching Authentication Protocol (Doc ID 1957995.1)  在 sqlnet.ora 加入以下字串 SQLNET.ALLOWED_LOGON_VERSION_SERVER=10 SQLNET.ALLOWED_LOGON_VERSION_CLIENT=10 有幾點要注意 1. 將數值設成低於 11, 也不代表一定支援那個版本的 client  2. 在RAC環境下, 有時必需重開 cluster service 3. 在 12cR1 預設值是 11, 在 12cR2 預設值是 12 4. 在 12c 已廢棄   SQLNET.ALLOWED_LOGON_VERSION
閱讀完整內容

12cRAC, 災演後, cluster 服務無法啟動

環境 Solaris 11 SPARC (LDOM) Oracle 12.2.0.1 EE RAC  異常   OS 重開後, GI 無法啟動,   osysmond.bin 也沒有啟動 細節 EMRRAC1 root@EMRRAC1:~# /oracle/app/grid/bin/crsctl start cluster CRS-2672: Attempting to start 'ora.crf' on 'emrrac1' CRS-2672: Attempting to start 'ora.cssd' on 'emrrac1' CRS-2672: Attempting to start 'ora.diskmon' on 'emrrac1' CRS-2676: Start of 'ora.diskmon' on 'emrrac1' succeeded CRS-2676: Start of 'ora.crf' on 'emrrac1' succeeded CRS-2674: Start of 'ora.cssd' on 'emrrac1' failed CRS-2679: Attempting to clean 'ora.cssd' on 'emrrac1' CRS-2681: Clean of 'ora.cssd' on 'emrrac1' succeeded CRS-2673: Attempting to stop 'ora.crf' on 'emrrac1' CRS-2677: Stop of 'ora.crf' on 'emrrac1' succeeded CRS-4000: Command Start failed, or completed with errors . EMRRAC2 root@EMRRAC2:~# /oracle/app/grid/bin/crsctl start ...
閱讀完整內容