File create failed, file size limit reached.

[Gerald Deinzer]

I need to understand the file size limit better, how large a file does RMS allow to be created. We are trying to implement RMAN backup for the Oracle databases and it fails when it trys to create a very large files. I am about to increase the extend quantity on the volume but am unsure if it will be enough, we want to try for 50Gb file if possible. The volume is a bound set of two
raidsets served from the SAN and are 1.7 Tb total. Also, what size is the default file size limit and what determine it?

[Steven Schweda]

The RMS limit is 1TB (2^31-1 blocks).

If Oracle is complaining about less than that,
I doubt that RMS is the problem.

[Jim_McKinney]

See the "FILE6" label at http://www.faqs.org/faqs/dec-faq/vms/part3/ which states

"the volume size and the RMS maximum file size limit is 2**31 * 512 bytes -- one terabyte (1 TB)."

The value is static and can't be changed.

[Steven Schweda]

Oops. 2^31 blocks. The largest block _number_
is 2^31-1.

Bigger than 50GB, anyway.

[Gerald Deinzer]

Thank you, I still would like to know what the file size limit is by default without, setting the extend quantity on the volume or elswhere. Also, are the 'file high-water marking' or disk quota related to the file size.

[Steven Schweda]

The only RMS limit is 1TB.

Normally you can't make a file bigger than
your disk quota. (Otherwise, what good
would a disk quota be?) There is no default
value for disk quota, only what you set.

The extend quantity determines how much a
file may grow in one jump, but it has no
effect on the maximum file size.

Highwater marking also has no effect on the
maximum file size. (It can make the
_creation_ of a large file slower, however.)

[Gerald Deinzer]

If that is the case, why would the file creation fail with a file size limit reached? I doubt the file is greater than 1Tb. Any ideas? I will look at the proceedure the DBA is using but not sure what to look for.

[Steven Schweda]

> why would the file creation fail with a file size limit reached?

Ask the people who wrote the program which
complained. Oracle?

What _is_ your disk quota, by the way? Is it
big enough? (Who owns the new file? What's
_his_ disk quota?)

SHOW QUOTA

[Gerald Deinzer]

Show quota stated that 'disk quotas not enabled on this volume' for system and oracle. System owns all of the directories on the drive in question.

[Duncan Morris]

Gerald, what version of Oracle are you using?

Also, please get the dba to do

RMAN> SHOW ALL;