- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Tar: database file not > 2GB Not dumped
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
тАО02-05-2002 11:55 AM
тАО02-05-2002 11:55 AM
Tar: database file not > 2GB Not dumped
I am getting the following error, while taking the hotbackup of Oracle database 7.3.4 using tar command on HP-UX 11.0
tar: Size of the /db19/oradata/xxx/dataxx.dbf > 2GB. Not dumped
Except the above file, remaining data files have been copied on tape on DDS-3.
How over come the above problem?
Thanks in advance
Rao
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2002 11:59 AM
тАО02-05-2002 11:59 AM
Re: Tar: database file not > 2GB Not dumped
A couple of options:
1) Use fbackup instead of tar. fbackup can easily handle large files.
2) Get the gnu version of tar which can handle large files. Gnu tar is available here:
http://hpux.cs.utah.edu/hppd/hpux/Gnu/tar-1.13.25/
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2002 12:00 PM
тАО02-05-2002 12:00 PM
Re: Tar: database file not > 2GB Not dumped
Regards, Clay
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2002 12:02 PM
тАО02-05-2002 12:02 PM
Re: Tar: database file not > 2GB Not dumped
http://hpux.cs.utah.edu/hppd/hpux/Gnu/tar-1.13.25/
Also, you said "you are doing a hot-backup". I take it that you are moving the tablespaces to backup mode before using tar on the files?
Ron
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2002 02:41 PM
тАО02-05-2002 02:41 PM
Re: Tar: database file not > 2GB Not dumped
Tar and cpio will not support backup of files larger than 2GB. So if you want to still use the hp-ux native commands to backup the file, use fbackup.
Hope this helps.
Regds
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2002 06:01 PM
тАО02-05-2002 06:01 PM
Re: Tar: database file not > 2GB Not dumped
The classic tools lack a large number of safety and reliability features that should be carefully weighed when looking for a backup solution. The primary reason to perform a backup is to protect from data loss, but often overlooked is the need to protect the backup, things like the ability to test the backup, to restore data rapidly, to recover from a bad spot on the tape, to seamlessly handle multiple tapes, etc.
Bill Hassell, sysadmin
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО02-05-2002 11:55 PM
тАО02-05-2002 11:55 PM
Re: Tar: database file not > 2GB Not dumped
I have always been unhappy with oracle datafiles which are bigger than two GB for various reasons.
If possible, I would favor to reduce the size of the datafile, and add a new datafile to the tablespace.
ALTER DATABASE DATAFILE '/db19/oradata/xxx/dataxx.dbf' resize 2000M;
ALTER TABLESPACE ts_name ADD DATAFILE '/db19/oradata/xxx/dataxx+1.dbf' size 500M
I know I am old fashioned, but before any protest, I recommend to check oracle patchnotes on various errors concerning datafiles bigger that 2 GB (in various releases).
If your database is only some 100GB big, I would always go for datafiles with a max size of 2000M (not 2GB)!
Just my 0.02???
Volker