This discussion is archived
8 Replies Latest reply: Nov 18, 2012 4:59 PM by FahdMirza RSS

disk vs tape

864103 Newbie
Currently Being Moderated
hi all ,

oracle 11g.2 rac 2-nodes with asm RHEL 5


which the best backup to disk or tape database size is 126G but the used is 16G???
  • 1. Re: disk vs tape
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Depend on your Cash Flow , Its better to have it on Tape Since If any Disk Failure Happened you still have copy of your backup .
  • 2. Re: disk vs tape
    864103 Newbie
    Currently Being Moderated
    thanks , but i need to make full backup and incremental backup and apply block change tracking all of these not support in TAPE???

    also the /backup is a file system in both node i mean this file system is on storage and 2 nodes is mounting it???
  • 3. Re: disk vs tape
    Girish Sharma Guru
    Currently Being Moderated
    There is nothing "Best" nor "Worst" in the IT. We can not say that tape/disk backup is more good/worst. If you google with "disk vs tape backup oracle" you may find couple of links mentioning pros and cons example : http://www.eversyncsolutions.com/disk-vs-tape.html.

    For greater details you should read :
    RMAN-Based Disk and Tape Backup Strategies: Scenarios
    http://docs.oracle.com/cd/B19306_01/backup.102/b14192/bkscenar.htm

    So, this is answer of your post.

    Now your next post, which is basically not a post; rather a new question, and this type of posts always makes members irritate. Why? Because you could mention all the details of next post in your first post, so that person who is going to help you may judge your question fully; anyway...
    but i need to make full backup and incremental backup and apply block change tracking all of these not support in TAPE???
    And what docs are saying :
    Location of the Block Change Tracking File
    One block change tracking file is created for the whole database. By default, the change tracking file is created as an Oracle managed file in the destination specified by the DB_CREATE_FILE_DEST initialization parameter. You can also place the change tracking file in any location you choose, by specifying its name when enabling block change tracking. Oracle recommends against using a raw device (that is, a disk without a file system) as a change tracking file.
    http://docs.oracle.com/cd/E14072_01/backup.112/e10642/rcmbckba.htm#BRADV89533

    And [url http://sysdba.wordpress.com/2006/05/18/how-to-use-fast-incremental-backups-with-block-change-tracking-with-oracle-10g/]How to use Fast Incremental Backups with Block Change Tracking with Oracle 10g  may also be of your interest.

    Regards
    Girish Sharma
  • 4. Re: disk vs tape
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Another solution you can use in this case :
    -take backup on Disk After that copy it to Tape .

    http://mehrajdba.wordpress.com/2009/03/17/rman-block-change-tracking/
  • 5. Re: disk vs tape
    864103 Newbie
    Currently Being Moderated
    thanks
  • 6. Re: disk vs tape
    Aman.... Oracle ACE
    Currently Being Moderated
    You must remember that its always going to be a slower backup done on tape compared to the disk. So if you are going to take a backup on a RAC cluster, you may want to take the incremental backup on the disk and then push it to the tape , either a single tape or an individual tape per instance.

    Aman....
  • 7. Re: disk vs tape
    864103 Newbie
    Currently Being Moderated
    thanks aman for your reply this is what i need to hear.
  • 8. Re: disk vs tape
    FahdMirza Oracle ACE
    Currently Being Moderated
    Hello,
    Backups are key as you know and for production databases, its always good to have more than one copies of backup stored at different locations, and at may be different media. When disaster hit, you want your backups to be readily available and for that matter, you might consider placing one copy of backup to the storage attached to the production server. But it is very very important to place one copy of backup off-server to any tape or any other disk-based storage.

    regards
    fahdmirza.blogspot.com

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points