Oracle Database Discussions

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!

ORA-01653 unable to increase tablespace size

Zeeshan ShaikhDec 19 2010 — edited Dec 20 2010

We have Oracle 11gR2 RAC with ASM installed on Redhat Linux

I am not able to extend tablespace it gives error ORA-01653

I checked ASM views

GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE STATE TYPE TOTAL_MB FREE_MB
1 DWH_OCR 512 4096 1048576 MOUNTED NORMAL 3057 2131
2 DATABASE 512 4096 1048576 CONNECTED NORMAL 204798 1536

Above view shows we have 1536 Mb free in our Database ASM disk group. And when i checked tablespaces used space so i found its not exceeding 70 GB.

Please suggest/advice what can be ocuppying space in ASM? and how to free it?

Also note archiving is also disabled. I tried to empty recycle bin also. Still same issue.

Thanks in advance

Zeeshan Sheikh

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 17 2011

Added on Dec 19 2010

#general-database-discussions

7 comments

801 views