cancel
Showing results for 
Search instead for 
Did you mean: 

File system full

Former Member
0 Kudos

Hi,

oracle/sid/sapdata1 file system is full........

4.6c, hp-ux, oracle 9i

Please suggest me what and how to do?

thanks in advance

P G

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

When your file system is full, you will need to extend the file system provided you have free extends. The files in that file system are all oracle database datafiles, redo logs, and control files which are all required for the proper functioning of the database, and you cannot delete any one of them.

To extend the file system, you will have to unmount, extend and then mount (if you do not have on-line JFS). For this reason you will have to shutdown the database and see no user is accessng any files from the file system (stop the listener as well) and extend the file system.

Afterwards if you feel like cleaning up your database or archiving the data (older records, then you can export the data, and save the dump file on to a tape if you need them later on. Then delete the data that you do not want, and reorg the data (by export and import) to gain the free space back. Just deleting the records does not release free space.

The other option fi you cannot extent that file system and have free space else where then shutdown the database, copy the datafiles and redologs to the new location and re-create the control files and startup the database.

regards,

Wojtek

Former Member
0 Kudos

Hi Wojtek,

Thank you very much for immediate reply...