- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- long and huge backup
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
тАО03-29-2004 01:18 PM
тАО03-29-2004 01:18 PM
we then deleted some records, reducing the database size to 50% of the original size. after then, we tried the backup and to our surprise, the backup time is still 2hours and still consumes 2 tapes.
why is this so? what should we do to reduce the backup time and database size
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2004 01:22 PM
тАО03-29-2004 01:22 PM
Solution- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2004 01:25 PM
тАО03-29-2004 01:25 PM
Re: long and huge backup
You would have to go through a compression procedure to reduce the amount of space the data takes up.
This varies from database to database.
You might also need to defragement your data unless you are at one of the newer database releases that automatically defragments its data.
You might also want to consider what is called a OnlineJFS snapshot to get a quick copy of your database while its down bring it up and then let your backup run at a liesurely pace on the snapshot.
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-29-2004 01:58 PM
тАО03-29-2004 01:58 PM
Re: long and huge backup
1) Shutdown database.
2) Using OnlineJFS snapof= mount option, make a snapshot mount of all your database filesystems --- takes only a few seconds
3) Restart the database
4) Backup the snapshots
5) Unmount the snapshots
Now for almost all the uptime of a "hot" backup, you have the safety of a "cold" backup --- and speed no longer matters because the database is running.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2004 03:05 AM
тАО03-31-2004 03:05 AM
Re: long and huge backup
Say you have Tablespace A that is 10Gb in size, but only 10% used and you don't expect a lot of growth.Create a 1.5Gb temoorary tablespace, move the tables contained in Tablespace A into the temp tablespace, then delete Tablespace A and re-create it large enough to hold your data plus the growth buffer you need. THen move the tables back and delete the temporary tablespace.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО03-31-2004 10:46 AM
тАО03-31-2004 10:46 AM