- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: backup ORACLE
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
тАО09-12-2000 07:28 PM
тАО09-12-2000 07:28 PM
backup ORACLE
Our Server machine is L2000.
We want to backup following filesystems during Oracle shutdown.(Cold Backup)
/PRODUCTS 5GB
/ORA_LOG 10GB
/ORA_CONTROL 4GB
/INDEX 20GB
/DBS/sys 15GB
/DBS/TBL 75GB
Total Size: 129GB
To backup above files, it will spend 6.5hours. and while to restore above,it will spend 8hours to 10hours.
In case of system failure, it is mean we should spend 10hours to recover the system.
Can someone advise me how to backup(restore) above files speedy?
Thank you and best regards.
Chen Yingjie
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-12-2000 11:29 PM
тАО09-12-2000 11:29 PM
Re: backup ORACLE
129GB to backup to a DLT8000, you should be able to get the DLT drive working at almost 30GB/hour if its on its own dedicated SCSI bus (with no disks on the same bus). That means your backup should take around 4.5 hours - if you back it up raw using Omniback (raw backup much faster than non-raw). The only other way to increase your backup and restore times is to use an additional DTL8000, that will halve your backup time to <3 hours and restore time to not much more. On some of our large servers here we have 8xDLT8000 drives, we can backup and restore a couple of hundred GB in around 2 hours!
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-13-2000 04:15 AM
тАО09-13-2000 04:15 AM
Re: backup ORACLE
I may be reading your objective differently, but I'm wondering if the following might make backup time more bearable:
If you define "cold" backup as a period in which only the ORACLE export is run, then if you split your export into multiple streams fed to multiple filesystems, then you could return ORACLE to your users; do your backups to tape; and "gain" a reduction in overall downtime.
There is a formum post which discusses the use of exporting through pipes over multiple filesystems and references Oracle Note 30528.1.
This link is:
http://forums.itrc.hp.com/cm/QuestionAnswer/1,1150,0xcc4668c57f64d4118fee0090279cd0f9,00.html
Perhaps all this helps.
...JRF...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2000 01:34 AM
тАО09-27-2000 01:34 AM
Re: backup ORACLE
With regards,
Dieter Degrendele
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2000 04:52 AM
тАО09-27-2000 04:52 AM
Re: backup ORACLE
To reduce recovery time without additional drives, you could backup to another disk, or get a faster tape drive. The option of backing to another disk is different to mirroring cos only the backup operation updates it. If the users corrupt the data in a mirrored environment both copies are damaged.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2000 05:26 AM
тАО09-27-2000 05:26 AM
Re: backup ORACLE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2000 05:26 AM
тАО09-27-2000 05:26 AM
Re: backup ORACLE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-27-2000 07:49 AM
тАО09-27-2000 07:49 AM
Re: backup ORACLE
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО09-29-2000 01:45 AM
тАО09-29-2000 01:45 AM
Re: backup ORACLE
if you have Mirror-UX you can make an mirror and for backup use lvsplit.
Another idea is an snapshot- filesystem, but i have no experience with snapshots on tablespaces.....
regards
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-13-2000 01:26 AM
тАО10-13-2000 01:26 AM
Re: backup ORACLE
there are different ways to reduce backup time. on possible way is to online backup your database. refer to the according oracle manuals.
i decided to "business copy" all database files :
1. shutdown the database
2. copy all files to another filesystem
3. startup the database
4. now you have lot's of time to backup the copy.
Depending on your disk subsystem you can minimize the downtime of your database. we currently backup a 500gb database this way. the downtime is 25 minutes.... all you need is lots of fast disks....
have fun