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!

Tablespace System is full

user12048358Jan 31 2018 — edited Feb 1 2018

Hi Oracle experts;

I'm working with oracle 11g RAC (2 nodes) with ASM disk group.

My oracle version is 11.2.0.4.0 and OS is CentOS release 6.9 (Final).

My situation is that the tablespace System was 100%, and I decided to add a new datafile. I did the process OK, but I forget to include the path or assign the datafile to the +DATA diskgroup. the data file was created in the filesystem.

So I understand I should move that datafile from filesystem to ASM disk group. Could you give me an advice, pls?

Besides that, the new datafile created does not have autoextend. What happen with this DF once is full?

Shoud I worry about if the TB System continue reaching the 100% of it's size?

I wiil apreciate all your comments and suggestions.

Thanks and regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 1 2018

Added on Jan 31 2018

#performance-availability, #rac-asm-clusterware-installation

6 comments

2,311 views