Re: RMAN backup failed and ORA-07445

Yes, there was such a hint; the SIGXFSZ error is thrown when that error message is reported:

"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] []"

I have seen this before when the filesystem is configured for a 2 GB file size maximum; I reported it here:


Cut 'em off at the pass! Or, why is my piped export file truncated?

 
   Cut 'em off at the pass! Or, why is my piped export file...
Sometimes you need to conserve space on a file system, and using exp with a named pipe to the compress utility is a nice way to export large databases and consume t...  
View on dfitzjarrell.wordpres... Preview by Yahoo  
  as a cause for piped export file truncation when using the older exp utility.

 
David Fitzjarrell
Principal author, "Oracle Exadata Survival Guide"



On Thursday, June 26, 2014 11:28 AM, NISHANT CHAWRE <nishant.chawre_at_gmail.com> wrote:
 


Hello sir,
I would like to understand how you figured it out that the above errors were due to "max file size exceeded". 
I mean no such hint was there in error logs but u catch the problem so precisely.
Any clues how you figured it out.
Thanks n Regards, 
Nishant Chawre
Sent from mobile.
On 26 Jun 2014 07:41, "sumit Tyagi" <dba.tyagisumit_at_gmail.com> wrote:

Thanks all , yes this issue was due to maxfilesize supported by the OS  and now it is resolved.
>On Jun 26, 2014 2:34 AM, "David Fitzjarrell" <oratune_at_yahoo.com> wrote:
>
>I suspect this is an error for "max file size exceeded", meaning RMAN it trying to write a file larger than the filesystem will allow.  In older releases f Unix/Linux this was 2 GB (and some  newer systems may still be configured this way).  You may need to change your RMAN script to write smaller pieces.
>>
>> 
>>David Fitzjarrell
>>Principal author, "Oracle Exadata Survival Guide"
>>
>>
>>
>>
>>On Friday, June 13, 2014 9:38 PM, 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-l