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

Thread: backup strategy

  1. 11-23-2000, 02:17 AM #1
    terrykingfa
    terrykingfa is offline Junior Member
    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!
    Reply With Quote Reply With Quote
  2. 11-23-2000, 07:16 AM #2
    Monika
    Monika is offline Junior Member
    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
    Reply With Quote Reply With Quote
  3. 11-23-2000, 08:20 AM #3
    LND
    LND is offline Member
    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.
    Reply With Quote Reply With Quote
  4. 11-23-2000, 09:38 AM #4
    terrykingfa
    terrykingfa is offline Junior Member
    Join Date
    Oct 2000
    Posts
    20
    Hi,LND,
    Please give me detail information about setting up standby DB. Thanks in advance.
    Reply With Quote Reply With Quote
  5. 11-23-2000, 01:56 PM #5
    rschulze
    rschulze is offline Junior Member
    Join Date
    Oct 2000
    Posts
    33
    Consider RMAN, space consuming but very nice and follows the "standby db theory"
    Reply With Quote Reply With Quote
  6. 11-23-2000, 03:42 PM #6
    birdax1
    birdax1 is offline Member
    Join Date
    Sep 2000
    Posts
    100

    ???

    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.
    Reply With Quote Reply With Quote
  7. 11-28-2000, 12:08 PM #7
    LND
    LND is offline Member
    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.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width