Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Error when running RMAN duplicate

RE: Error when running RMAN duplicate

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Fri, 2 Dec 2005 14:33:51 -0500
Message-ID: <6591F529444E9748A546718B3D1A6701019B8554@xcgv2605.northgrum.com>


Don,

Do you have your AIZ file systems configured for "large files". If not your file sizes are limited about 2 gb.

HTH,
Peter Schauss

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Don Morse Sent: Thursday, December 01, 2005 8:05 PM To: oracle-l_at_freelists.org
Subject: Error when running RMAN duplicate

Hello,

We're moving our database server platform from Solaris to AIX.
I'm configuring RMAN to duplicate a 9.2.0.6 database from a
production server to a remote development server (both servers on AIX 5L v5.3 64bit AIX, 64bit Oracle). The RMAN duplicate command is failing on error ORA-27039 (create file failed, file size limit reached).
I had this same RMAN script running in cron on Solaris for the past year, so I know the RMAN syntax is correct.
I'm using TDP for Oracle to interface RMAN to Tivoli backup system for backups/restores.
The ORA-27039 error appears to indicate insufficient AIX privileges in /etc/security/limits for the AIX user to
create a file, but file size is set to unlimited (-1) for AIX user running the script.
To test this is not a problem with AIX user file size limitation, I ran create database using 5GB system tablespace
without error, then backed up and restored (same server) with RMAN. For some reason, I can't restore from production server
to remote test server using RMAN duplicate without hitting this error.
I also tried setting max piece size to 1GB when creating backup on the production server, but same error.

Does anyone have any idea why I can't get this to work in AIX?

Thanks!

Here is the error message received when the RMAN "duplicate database" command fails:
RMAN-00571:



RMAN-00569: = ERROR MESSAGE STACK FOLLOWS

RMAN-00571:

RMAN-03002: failure of Duplicate Db command at 10/06/2005 16:30:46
RMAN-03015: error occurred in stored script Memory Script
ORA-19504: failed to create file
"/u01/oradata/BRY/devl_PROD_01.dbf"
ORA-27039: create file failed, file size limit reached                          

Start your day with Yahoo! - Make it your home page! http://www.yahoo.com/r/hs
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 02 2005 - 13:36:30 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US