Our database backup through RMAN was terminated with below error message
In RMAN log file
RMAN-03009: failure of backup command on C1 channel at 06/20/2008 10:04:34
RMAN-10038: database session for channel C1 terminated unexpectedly
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup command at 06/20/2008 10:06:03
RMAN-00600: internal error, arguments [8039] [sqlrcn failed] [-1075] [] []
In alertsid.log file
Sat Jun 21 17:11:56 2008
Errors in file e:\oracle\product\10.1.0\admin\udump\ora_3856.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x114B926] [] [] [] []After that I start my searhing in metalink for ORA-07445 but didn't get any useful.
then search for RMAN-00600 error and get hint through increase SWAP space will solve the issue but it is not solve the problem
then after I search for RMAN-10038 error and get metalink note: 337894.1 which refer to check RMAN configuration, and this is the actual problem when I reset all RMAN configuration then RMAN backup is work smootly.
In RMAN configuration below parameter is set wrongly.
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'G:\ORA_BACKUP\%d_S_%s_P_%p_T_%t' MAXPIECESIZE 1024 M;
Actually I set above parameter for the backup location and format and also mention FORMAT cluase in BACKUP SCRIPT with "BACKUP DATABASE ... FORMAT ...". but when I clear this configuration parameter RMAN backup is work.
CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;
After that RMAN backup work properly and problem solved.
Sunday, June 22, 2008
Strange but Interesting problem
Subscribe to:
Post Comments (Atom)
2 comments:
Hello, i have the same problem, but i'm not use any specific parameters in format string.
My script:
run {
allocate channel t1 type disk;
backup
incremental level 0
skip inaccessible
filesperset 1000
format 'D:\backup\bk_%d_%s_%p_%t' database;
sql 'alter system switch logfile';
sql 'alter system switch logfile';
backup
filesperset 1000
format 'D:\backup\arc_%d_%s_%p_%t'
archivelog all delete input;
backup
format 'D:\backup\cntrl_%d_%s_%p_%t'
current controlfile;
release channel t1;
}
OS: Windows 2003 Server SP1
Oralce: 10.1.0.2.0
and i have error in alert log:
Errors in file c:\oracle\product\10.1.0\admin\iwnm\udump\iwnm_ora_5640.trc:
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x77BD8FA7] [] [] [] []
and trace file:
*** ACTION NAME:(0000091 STARTED16) 2009-10-28 19:14:28.219
*** 2009-10-28 19:14:28.219
ksedmp: internal or fatal error
ORA-07445: exception encountered: core dump [ACCESS_VIOLATION] [0x77BD8FA7] [] [] [] []
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
_InitIsGroup_scls+2 CALL??? 00000000 5FB978C 0 2A
82
_scls_iddb_has_priv CALLrel _InitIsGroup_scls+0 5E14C20 63A91F8 5FB6C90
grp_by_name+1 5FA9CA8 15E
...
...
...
more info...
So, what my problem? Thnx.
Post a Comment