News By Tag
News By Location
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.
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: http://www.dbametrix.com