- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: ORACLE - File System Full
Operating System - HP-UX
1752677
Members
5485
Online
108789
Solutions
Forums
Categories
Company
Local Language
back
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Discussions
back
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Blogs
Information
Community
Resources
Community Language
Language
Forums
Blogs
Go to solution
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
02-08-2005 03:33 AM
02-08-2005 03:33 AM
Re: ORACLE - File System Full
Make sure auto extend is turned off on all of your dbf files.
I would make another logical volume filesystem and move your application dbf files to the new location. With 9i, I have successfully on a live production database during low activity, taken dbf files offline, copied to new filesystem. renamed them and put them back on line and removed the old dbf file. (I used fuser to make sure the old one was no longer being used by oracle)
My recommendation for you is to take the system down and use the documented methods
If you are able to take the system down. You should be able to extend the logical volume. and not do any oracle stuff.
Your note suggests that you have old data. After you get past your space crisis. Have your application people look at the database schemas and purge old records. Also look for tables that are not being used and have them dropped. I have a App owner who copies large tables to a backup name and forgets about them. Do Not drop the dbf files they are your file cabinets not your data.
Sound like you have lots of maintaince to do.
After you get your data purged. I would schedule downtime and export your data. delete your table spaces and recreate it with better sized dbfs. I also would set the datafiles to not extend past a particular size. In the future, I would manually add dbf files as table space gets low. That way I could put the files in filesystem with free space. This also might allow time to consider balancing I/O by putting certian files on a particular disks.
Good Luck
There are a 100 ways to do things and 97 of them are right
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
06-28-2006 09:25 PM
06-28-2006 09:25 PM
Re: ORACLE - File System Full
first, the archive logs have to go.
if still not enough space, transfer to a more abundant storage space.
if still not enough space, transfer to a more abundant storage space.
- « Previous
-
- 1
- 2
- Next »
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.
News and Events
Support
© Copyright 2024 Hewlett Packard Enterprise Development LP