Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unable to resize asm datafile even though I resized the (logical) datafile

Daryl E.Dec 14 2012 — edited Jan 8 2013

I have a bigfile that went above 16tb - this is causing me grief in a restore to a netapp filer that has a 16tb limit.

So we went thru the hassles of moving data around. I issued the

Mon Dec 10 21:15:06 2012
alter database datafile '+DATA/pcinf/datafile/users1.303.777062961' resize 15900000000000
Completed: alter database datafile '+DATA/pcinf/datafile/users1.303.777062961' resize 15900000000000
Mon Dec 10 21:40:10 2012

The datafile itself from v$datafile shows 15tb - BUT the asm file is still 18tb in size.

Should it not be the same - is this something others have faced where the asm file doesnt match?

Name USERS1.303.777062961
Type DATAFILE
Redundancy MIRROR
Block Size (Bytes) 8192
Blocks 2281701377
Logical Size (KB) 18253611016

Linux, Exadata, 11.2.0.2 + psu

SR Created but not getting anywhere - Why such a large file, are you sure its really not 18tb, etc .etc

Daryl

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2013

Added on Dec 14 2012

#automatic-storage-management, #performance-availability

14 comments

2,237 views