Unix vol group backup
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

Thread: Unix vol group backup

Hybrid View

  1. #1
    Join Date
    Feb 2001
    Posts
    32

    Question

    I'm a bit unclear on UNIX VOLUME GROUP BACKUP.

    QUES: During a Unix voulme group backup on AIX,
    would the database still be opened for normal activities? Or should the database be opened for normal activities?

    [Edited by Tee on 08-27-2001 at 11:24 AM]

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    The database should not be backed up using a regular OS backup. Sure, the database can be up during a backup, but you must use a hot-backup mehtodology. See http://dbasupport.com/oracle/scripts...ry/Hot_Backup/ for various examples.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Feb 2001
    Posts
    32

    Question

    Thanks. In a nutshell, can you briefly explain what constitute a unix VOLUME GROUP BACKUP?

    I think I'm confusing my self.

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    I would guess that a VOLUME GROUP BACKUP is an OS level backup of the volume or filesystem.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  5. #5
    Join Date
    Sep 2000
    Posts
    64
    Hello,

    If you will backup a VG in which you have Oracle data file, you have to shutdown you DB (in order to have a clean Backup file).

    Sofiane
    Sofiane

  6. #6
    Join Date
    Jan 2001
    Posts
    157
    I think I would agree more with Sofiane. What do you think marist89?

  7. #7
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Not necessarily. You can perform a hot backup with a combination of OS and Oracle commands. Sure, the safest way is with the database shut down, but who can shutdown their server for an hour?
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #8
    Join Date
    Jun 2001
    Posts
    87

    At work (when I had a job) we had ScoUnix Servers running 8i using BackUPEdge backup software, and NT4 Servers running 8i and using Veritas Backup Exec. We did a hotbackup on the Unix servers every night. The Backup edge software would lock the database during backup preventing other clients from getting access. In the end we had to shutdown the database during hotbackup.

    Hotbackup is good if you run a 24/7 operation and cant afford to take the database offline.

    But its good to periodically take a cold backup.

  9. #9
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by drain surgeon

    But its good to periodically take a cold backup.
    I haven't taken a cold backup on a production server in over three years. But then again, my databases only come less than once a year.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width