what backup solution do you use? - Page 3
DBAsupport.com Forums - Powered by vBulletin
Page 3 of 5 FirstFirst 12345 LastLast
Results 21 to 30 of 43

Thread: what backup solution do you use?

  1. #21
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by TheSlob

    Jeff, do you use a shell script to do hot backups of datafiles and archived redo logs or do you use veritas?
    I use RMAN to backup the database and archived logs. That way I don't have to worry about which media manager (Veritas, Brightstor) I am using.
    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."

  2. #22
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    We have a 1/2 TB Datawarehouse in which we Hot backup daily and Cold Backup on Sundays. Also run exports on a number of schemas.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #23
    Join Date
    May 2000
    Location
    fremont ca
    Posts
    182
    1. Hot backup full every day
    2. Archive log transfer to standby database every two hrs.
    3. ORACLE HOME backup every day

  4. #24
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by marist89

    If you lose the filesystem that contains the Oracle software, your choices are:
    1. restore the previous working software from tape.
    2. re-install oracle

    I prefer to restore the working software so I don't have to remember what options I had installed for this instance.
    Is backing up only the oracle Home sufficient for this.

    Dont we have to backup the registry (in case of windows) also because it has all the parameters.

    Just restoring the software from the backup wont be enough.

    Correct me if I am wrong.

    Thanks


    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  5. #25
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by ronnie
    Dont we have to backup the registry (in case of windows) also because it has all the parameters.
    I don't know. I don't do Windoz.
    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."

  6. #26
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by marist89
    Originally posted by ronnie
    Dont we have to backup the registry (in case of windows) also because it has all the parameters.
    I don't know. I don't do Windoz.
    I am sure that there must be something like the registry in unix also where information regarding oracle homes created on the server is stored along with lots of other info on the installed Home.

    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  7. #27
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    there is no registry in unix, install linux in your PC and you will see

  8. #28
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    Full Export every night
    Hotbackup every night
    Cold backup 15 days
    Archivelog backup every 1 hour
    Thanks
    Kishore Kumar

  9. #29
    Join Date
    Mar 2001
    Location
    New York , New York
    Posts
    577
    Originally posted by Kishore
    Full Export every night
    Hotbackup every night
    Cold backup 15 days
    Archivelog backup every 1 hour

    Any advantage of taking a cold backup everyday when you take a Kot Backup everyday.

    Originally posted by marist89
    [Yes, Full Hot backup every day. In my environment, my Mean Time To Recovery (MTTR) is so short it doesn't make sense to use Incrementals.
    How do you determine what your MTTR is and at what MTTR does a incemental backup makes sense.



    [Edited by ronnie on 05-08-2002 at 12:55 PM]
    Ronnie
    ronnie_yours@yahoo.com

    You can if you think you can.

  10. #30
    Join Date
    Mar 2000
    Location
    CA
    Posts
    317
    I mentioned that I am taking cold backup every 15 days not every day
    Thanks
    Kishore Kumar

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