Sometimes Tape Backup is faster than Disk Backup

Oracle Backup tuning is most important for large OLTP database. Due to this reason, some Oracle DBA configure disk backup but every time it is not faster than tape backup. Here are some reasons.
Spread the Word
Listed Under

Oracle backup
Oracle Backup Recovery
Database Backup


Skokie - Illinois - US

July 2, 2012 - PRLog -- It’s important to take every step possible to assist in arriving coming returning ups in order to reduce the effect on performance. From this viewpoint, with regards to the back-up elements or software being used, assistance up to complicated produce may be faster or assistance up immediately to other media such as history or writeable recognizable pushes may be faster. It’s a common misconception that assistance up to complicated produce is always faster. With history engineering getting better and better, it’s not uncommon to see large online internet directories of several hundred gb in element getting increased up in identical applications known as multi-streaming to several history pushes in just few hours. Actually, some history improvements can provide a throughput of higher in handled circumstances.

If that throughput can be equaled in real-world circumstances, assistance up immediately to history may validate much faster that assistance up to complicated produce. Actually, arriving coming returning ups to history are often restricted by disk-drive throughput, which hardly ever improves above 8-10 MB/sec for most details resource action since details to history produce can only be launched as fast as details is study from complicated produce. Again, I have observed this 8-10 MB/sec in circumstances where the complicated produce sub-system uses more newest engineering for example, roughage applications appropriate with fastSCSI remotes and this is set out incredibly well. Quite a few OLTP circumstances, where I/O applications are difficult to find that is, arriving coming returning ups have to deal with regular details resource features and reads/writes are really unique, are restricted to disk-drive throughput of merely 3-5 MB/sec.

However, this might not be real for every atmosphere. Based on various aspects such as the type of off-line back-up media you are using, whether such gadgets are in the area related or a little bit appropriate with it, the number of identical arriving coming returning ups applications they can manage, each stream’s throughput, the complicated produce generate throughput, whether you have dedicated I/O changes for back-up, and so on, arriving coming returning ups either to complicated produce or arriving coming returning ups immediately to history may validate faster for you. If you are writing in a single action to a networked history program, possibilities are, arriving coming returning ups to complicated produce may provide much higher throughput. In any case not discounting the value of fast arriving coming returning ups, back-up amount is not the objective for this tip. Rather, recovery amount is.

Once details information are available on complicated produce, in the occurrence of a details resource occurrence, they do not have to be restored off off-line storage space space media, thus reducing mean time recovery. Most of the delay during recovery happens not during the real act itself, but during restore of the necessary details information from the off-line back-up media. If details information are associated with the most present back-up are already on complicated produce, such ranking out due to high restore time can be avoided. This is a very effective objective for any 24/7 handling site to sustain the most new online back-up.

Dbametrix is expert remote dba team to provide excellent database services in affordable remote dba plans. For more details kindly contact us or check more information from our website:
Posted By:*** Email Verified
Phone:91 9429389363
Tags:Oracle backup, Oracle Backup Recovery, Database Backup
Industry:Business, Software
Location:Skokie - Illinois - United States
Account Email Address Verified     Account Phone Number Verified     Disclaimer     Report Abuse
Dbametrix Solutions PRs
Trending News
Top Daily News
Top Weekly News

Like PRLog?
Click to Share