- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: big full backup problem
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
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
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- 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
тАО08-01-2003 05:16 AM
тАО08-01-2003 05:16 AM
I have a backup problem with Oracle: to make a full database backup I put the database in backup mode and backup de tablespaces with cpio and gzip. In time this backup was getting bigger and bigger so that a time ago I cleared some very big tables. Now is the data 1/10th from the data before but the backup size keeps the same (I also make an exp. witch is 1/10 of the original size). I think I understand why: I cleared the table but the tablespaces are as patitions on a OS, clearing a file only clears the pointer to this file, the file contains remains on the harddisk.
Does anybody knows how to really clear a tablespace so that my full backup is smaller again or is the only way to delete the tablesspaces, make them again and do an import?
I use Oracle 7.3.3
Thanks,
Robert Verhagen.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2003 05:51 AM
тАО08-01-2003 05:51 AM
Re: big full backup problem
There is a chance you can shrink some of the datafiles. We can only shrink files back to their high water mark -- if there is an extent way out at the end of a file -- we'll not be able to shrink it.
If not, the only thing that will undo this is to recreate the database (exp, imp).
hope this helps!
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2003 05:53 AM
тАО08-01-2003 05:53 AM
SolutionScript to guide you on which datafiles can be shrinked is attached!
CAUTION: Adjust the values accordingly otherwise you may run into space problems.
regards
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-01-2003 11:18 AM
тАО08-01-2003 11:18 AM
Re: big full backup problem
I don't know how many tables and tablespaces you're talking about here, but if it's not too many, you could try this:
1) Create a new tablespace large enough to hold what's in the one you want to shrink
2) Find all tables in the tablespace you want to shrink and move them to the new tablespace using
SQL> alter table
move tablespace
If you're going to leave them there, recreate your indexes in the new tablespace too.
3) When they're all moved, drop the original tablespace
4) Now, if you want, you can re-create the original tablespace with a smaller size
5) Reverse the procedure in step 2 to move the tables back to the original tablespace (if desired) and re-build the indexes.
This should work in the higher 8i versions and above.
-greg
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2003 08:09 AM
тАО08-02-2003 08:09 AM
Re: big full backup problem
You may want to do a dbexport of the data. This will only backup the actual table entries, not the entire tablespace. You can dump it to a flat file in another filesystem, compress it and use regular backups on it.
You will need to do the dbexport for each table in the database. This gives you a 2 tiered backup scheme, with the most current on disk, and +1 on tape.
Hope this helps..
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО08-02-2003 08:34 AM
тАО08-02-2003 08:34 AM
Re: big full backup problem
If the oracle file system was 85% full then you could use online JFS's defrag. utility.
You're other alternative is to dbstop and copy the data in and out from the O/S instead of using Oracle.
cp -p -r /dir/* /temp/*
rm /dir/*
cp -p -r /temp/* /dir/*
Data is not fragmented when loaded for the first time or copied back in after deletion.