Search This Blog

Sunday, June 22, 2008

Strange but Interesting problem

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.

2 comments:

mczim said...

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.

mczim said...
This comment has been removed by the author.