| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: AIX(VERSION 4) /Oracle8172
Seema,
This looks to me like your archive destination is full. I'd check that first.
In answer to your other question. Don't know what exact version of AIX you're on, but 4.3.3 handles files over 2 GB with no problems. It's possible that you make have to set the limit up based on the user. I think the default is 1 GB.
Metalink note 62427.1
Be careful when allowing files to automatically resize. It is sensible to always limit the MAXSIZE for AUTOEXTEND files to less than 2Gb if not using 'large files', and to a sensible limit otherwise. Note that due to [BUG:568232] it is possible to specify an value of MAXSIZE larger than Oracle can cope with which may result in internal errors after the resize occurs. (Errors typically include ORA-600 [3292]) On many platforms Oracle datafiles have an additional header block at the start of the file so creating a file of 2Gb actually requires slightly more than 2Gb of disk space. On Unix platforms the additional header for datafiles is usually DB_BLOCK_SIZE bytes but may belarger when creating datafiles on raw devices.
Durinda
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Seema Singh
Sent: Monday, June 14, 2004 10:03 AM
To: oracle-l_at_freelists.org
Subject: AIX(VERSION 4) /Oracle8172
Hi,
I have one instance on AIX version 4 .This instance is crashing on regular basis.I have been noticing following problem.
ORA-16038: log 3 sequence# 723 cannot be archived ORA-19502: write error on file "", blockno (blocksize=) ORA-00312: online log 3 thread 1: '/u02/oradata/DSS/redo3a.log' ORA-00312: online log 3 thread 1: '/u04/oradata/DSS/redo3b.log'ARCH: Connecting to console port...
These all errors are coming since we created maxsize 2048m of datafiles in
autoextend mode.
AIX version is 4.I'm assuming AIX 4 doesn't handle 2GB files.Metalink say
it's due to file size.Doesn any one have such situation in past? If yes how
did fixed pl? ANy suggestions are welcome.
thx
-seema
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |