backup strategy
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: backup strategy

  1. #1
    Join Date
    Oct 2000
    Posts
    20
    Hello,everyone,
    My Databse is running with 24x7 mode.But it's impossiple to require production stop for doing a DB cold backup fequently. So I think my backup strategy will only depent on onling backup every day and expoting data every week,won't it? And any other suggestion will be appreciated.
    Thanks!

  2. #2
    Join Date
    Feb 2000
    Location
    Munich/Germany
    Posts
    5
    yeah, that's the way it's done. You should have one "master" cold backup to start with though...

    Monika

  3. #3
    Join Date
    Nov 2000
    Posts
    212

    standby DB is good option

    We have 24x7 quite critical system (kind of US911 but for Iceland ) and standby DB is a nice solution. It can be created w/o stopping main db from hot backup (if interested, I have intructions for WinNT but generally the only difference from normal db is that you have to use "alter database mount standby database" instead of just "startup mount" before restoring DB from hot backup) and then you can make backups of standby db instead. If you have to recover activating standby is much faster than recovering main db.

  4. #4
    Join Date
    Oct 2000
    Posts
    20
    Hi,LND,
    Please give me detail information about setting up standby DB. Thanks in advance.

  5. #5
    Join Date
    Oct 2000
    Posts
    33
    Consider RMAN, space consuming but very nice and follows the "standby db theory"

  6. #6

    ???

    Impliment a hot backup stratagy, using RMAN. Or the conventional, by puttin g the tablespaces in hot backup mode.
    Copy the Datafiles and then pu the tablespaces of the hot backup mode.

    Do a log switch and then copy the archivelogs files.
    The brain is a wonderful organ; it starts working the moment you get up in the morning and does not stop until you get into the office.

  7. #7
    Join Date
    Nov 2000
    Posts
    212
    sorry for late answer, but I check this site only time from time. If still interested in standby DB for NT and 816, give me your mail (mine is lnd@hnit.is), I will send back MS Word doc.

    Is it possible to get the messages to forum by e-mail or news reader - e-mail is something that runs on my workstation constantly.

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