Re: RMAN backup failed and ORA-07445
From: Capitanu Ionut <capitanu.ionut_at_yahoo.com>
Date: Wed, 25 Jun 2014 12:29:07 -0700
Message-ID: <1403724547.52822.YahooMailNeo_at_web120702.mail.ne1.yahoo.com>
Date: Wed, 25 Jun 2014 12:29:07 -0700
Message-ID: <1403724547.52822.YahooMailNeo_at_web120702.mail.ne1.yahoo.com>
Hi there, I'd say that you need to log an SR with the Oracle support on the ORA-07445 error. This error is signaled usually by the OS because of some lack of resources of some kind. The lack itself can be because of oracle itself or other reasons. Also, it would be usefull to look at the trace file under the process state and see what was the session waiting for. If you things like MML initializaion, MML write (these are tape events), then you should log an SR with MML provider also, or check disks if disks are used. Regards, Ionut On Saturday, June 14, 2014 6:38 AM, sumit Tyagi <dba.tyagisumit_at_gmail.com> wrote: Hi all, Can anyone help on the below. RMAN backup failed with the below error msg on both primary and physical standby server: At the same time alert log has captured an error message RMAN Error log: channel ch02: starting piece 1 at 13-JUN-14 RMAN-03009: failure of backup command on ch00 channel at 06/13/2014 02:31:00 RMAN-10038: database session for channel ch00 terminated unexpectedly channel ch00 disabled, job failed on it will be run on another channel RMAN-03009: failure of backup command on ch01 channel at 06/13/2014 02:31:00 RMAN-10038: database session for channel ch01 terminated unexpectedly channel ch01 disabled, job failed on it will be run on another channel RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ch02 channel at 06/13/2014 02:31:00 RMAN-10038: database session for channel ch02 terminated unexpectedly Recovery Manager complete. Alert log : ORA-07445: exception encountered: core dump [pwrite64()+19] [SIGXFSZ] [ADDR:0x1F6000004D6] [PC:0x322B40E613] [unknown code] [] ORA-07445: exception encountered: core dump [pwrite64()+19] [SIGXFSZ] [ADDR:0x1F6000004D6] [PC:0x322B40E613] [unknown code] []
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jun 25 2014 - 21:29:07 CEST