oracle rman備份時出現ORA-19502錯誤解決案例
系統平臺:HP-UX 11.23
資料庫版本:oracle 10g 10.2.0.1
何時出錯:使用rman將資料庫備份至磁碟陣列中時
錯誤記錄:RMAN> run {
2> allocate channel t1 type disk;
3> backup
4> incremental level=0
5> format '/u02/oradata/db_bak/%d_full_%t_%s_%p'
6> tag='Whole_incr0'
7> database;
8> release channel t1;
9> # Backup Archived Logs
10> allocate channel t1 type disk;
11> sql 'alter system archive log current';
12> backup
13> format '/u02/oradata/db_bak/arch-s%s-p%p-t%t'
14> archivelog
15> all
16> delete input;
17> release channel t1;
18> # Control file backup
19> allocate channel t1 type disk;
20> backup
21> format '/u02/oradata/db_bak/bk_u%u_s%s_p%p_t%t'
22> current controlfile;
23> release channel t1;
24> }
allocated channel: t1
channel t1: sid=138 devtype=DISK
Starting backup at 04-SEP-06
channel t1: starting incremental level 0 datafile backupset
channel t1: specifying datafile(s) in backupset
input datafile fno=00005 name=/u02/oradata/orcl/shzhdb.dbF
input datafile fno=00010 name=/u02/oradata/orcl/DOCdb.dbF
input datafile fno=00014 name=/u02/oradata/orcl/digitialscandb.dbF
input datafile fno=00022 name=/u02/oradata/orcl/digitalscandata.dat
input datafile fno=00026 name=/u02/oradata/orcl/digitalscandata1.dbf
input datafile fno=00027 name=/u02/oradata/orcl/digitalscandata2.dbf
input datafile fno=00028 name=/u02/oradata/orcl/digitalscandata3.dbf
input datafile fno=00029 name=/u02/oradata/orcl/digitalscandata4.dbf
input datafile fno=00030 name=/u02/oradata/orcl/digitalscandata5.dbf
input datafile fno=00001 name=/u02/oradata/orcl/system01.dbf
input datafile fno=00003 name=/u02/oradata/orcl/sysaux01.dbf
input datafile fno=00008 name=/u02/oradata/orcl/TRADEdb.dbF
input datafile fno=00007 name=/u02/oradata/orcl/STANDARDdb.dbF
input datafile fno=00015 name=/u02/oradata/orcl/DOCMANAGEDB.dbf
input datafile fno=00025 name=/u02/oradata/orcl/archivets.dbF
input datafile fno=00017 name=/u02/oradata/orcl/MDAts.dbf
input datafile fno=00006 name=/u02/oradata/orcl/REPAIDdb.dbF
input datafile fno=00009 name=/u02/oradata/orcl/DOCREPdb.dbF
input datafile fno=00021 name=/u02/oradata/orcl/webissuets.dbf
input datafile fno=00012 name=/u02/oradata/orcl/registeronlinedb.dbF
input datafile fno=00024 name=/u02/oradata/orcl/digitalscanidx.dat
input datafile fno=00031 name=/u01/app/oracle/product/10.1.0/db_1/dbs/owblogts.dbf
input datafile fno=00002 name=/u02/oradata/orcl/undotbs01.dbf
input datafile fno=00023 name=/u02/oradata/orcl/digitalscandb.dat
input datafile fno=00011 name=/u02/oradata/orcl/restrictdb.dbF
input datafile fno=00013 name=/u02/oradata/orcl/gis.dbF
input datafile fno=00016 name=/u02/oradata/orcl/kmdocts.dbf
input datafile fno=00018 name=/u02/oradata/orcl/SCREENDB.dbf
input datafile fno=00019 name=/u02/oradata/orcl/TOUCHDB.dbf
input datafile fno=00020 name=/u02/oradata/orcl/twboxdb.dbf
input datafile fno=00004 name=/u02/oradata/orcl/users01.dbf
channel t1: starting piece 1 at 04-SEP-06
released channel: t1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on t1 channel at 09/04/2006 17:13:34
ORA-19502: write error on file "/u02/oradata/db_bak/ORCL_full_600282318_1_1", blockno 262017 (blocksize=8192)
ORA-27072: File I/O error
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3
Additional information: 262017
解決辦法:原因是生成的備份集檔案超過了作業系統的2GB限制,通過限制備份集檔案大小來避免錯誤的發生
修改備份指令碼為:
run {
allocate channel t1 type disk;
set limit channel t1 kbytes 1800000;
backup
incremental level=0
format '/u02/oradata/db_bak/%d_full_%t_%s_%p'
tag='Whole_incr0'
database;
release channel t1;
# Backup Archived Logs
allocate channel t1 type disk;
sql 'alter system archive log current';
backup
format '/u02/oradata/db_bak/arch-s%s-p%p-t%t'
archivelog
all
delete input;
release channel t1;
# Control file backup
allocate channel t1 type disk;
backup
format '/u02/oradata/db_bak/bk_u%u_s%s_p%p_t%t'
current controlfile;
release channel t1;
}
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/13024285/viewspace-628967/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- RMAN備份時出現RMAN-06056: could not access datafile 6 錯誤,解決方法!!
- 【RMAN】Oracle12c之後,rman備份Dataguard備端恢復可能出現邏輯錯誤Oracle
- 一個RMAN備份時導致系統慢解決的案例
- 執行impdp時出現ORA-39154錯誤的解決案例
- ORACLE tsm 備份錯誤Oracle
- ant構建時出現錯誤解決方案
- rman duplicate出現PLS-00201錯誤解決
- Oracle備份時出現AIX系統的3D32B80D錯誤OracleAI3D
- oracle rman 定時備份指令碼Oracle指令碼
- SqlServer NBU備份出現錯誤程式碼2SQLServer
- JDBC 連oracle 時出現錯誤,,求助???JDBCOracle
- RMAN備份恢復典型案例——RMAN備份&系統變慢
- rman映象備份全庫的時候報ora-00600錯誤。
- 案例: 解決ORACLE ORA-27211的錯誤Oracle
- oracle之rman備份Oracle
- Oracle RMAN 增量備份Oracle
- oracle rman備份命令Oracle
- 【轉】Oracle rman備份Oracle
- 工程make時出現"時鐘錯誤的問題"的解決方案
- 手動刪除了歸檔日誌後,rman備份出現問題解決
- TSM備份ANS0326E錯誤及解決
- Rman增量壓縮備份來解決備份空間不足
- Oracle RMAN 備份控制檔案報錯問題Oracle
- Oracle rman 備份與恢復 臨時表空間的檔案問題解決Oracle
- Rman 定時備份crontab
- RMAN 備份詳解
- RMAN備份詳解
- -- RMAN備份詳解
- AIX上oracle匯出備份EXP-00056: 遇到 ORACLE 錯誤 600AIOracle
- RMAN備份時出現ORA-19809: limit exceeded for recovery filesMIT
- scp出現錯誤的解決辦法
- 編譯EJB出現錯誤的解決編譯
- ontape出現段錯誤(未解決篇)
- Oracle 11g RMAN備份-增量備份Oracle
- Rman-ORACLE資料庫RMAN實現自動備份Oracle資料庫
- Oracle RMAN備份實戰Oracle
- Oracle OCP(60):RMAN 備份Oracle
- oracle RMAN備份指令碼Oracle指令碼