Hot Backup questions
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Hot Backup questions

  1. #1
    Join Date
    Jan 2002
    Posts
    58

    Hot Backup questions

    I just have a few questions about Hot backups. Ok Here goes.

    1. How does a DBA backup or deal with Online redologs in a Hot backup scheme.

    2. Do I need to ever incorporate a Cold backup during the weekend and Hot backups during the week. Deleteing arch logs after each successfull cold backup.

    3. If I have a complete Hot backup of the database, can I restore that HOT backup to a different machine using "backup controlfile to trace" procedure. If not then how do I do so.

    4. Here is my tentative plan for backups
    Monday: Hot backup of DDrive TS
    Tuesday: Hot backup of EDrive TS
    Wednesday: Hot backup of FDrive TS
    Thursday: Hot backup of GDrive TS
    Friday: Hot backup of HDrive TS
    Saturday: Logical export of database during the day
    Sunday: Full Cold backup

    thanks

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Re: Hot Backup questions

    Originally posted by antilles
    I just have a few questions about Hot backups. Ok Here goes.

    1. How does a DBA backup or deal with Online redologs in a Hot backup scheme.
    http://www.dbasupport.com/oracle/scr...ckup_Recovery/

    2. Do I need to ever incorporate a Cold backup during the weekend and Hot backups during the week. Deleteing arch logs after each successfull cold backup.
    IMHO, there's no need to do a cold backup when you have a hot backup in place. Why empty out your cache when you don't have to? Delete the n+1 archived logs after your backup is complete.

    3. If I have a complete Hot backup of the database, can I restore that HOT backup to a different machine using "backup controlfile to trace" procedure. If not then how do I do so.
    sure.


    4. Here is my tentative plan for backups
    Monday: Hot backup of DDrive TS
    Tuesday: Hot backup of EDrive TS
    Wednesday: Hot backup of FDrive TS
    Thursday: Hot backup of GDrive TS
    Friday: Hot backup of HDrive TS
    Saturday: Logical export of database during the day
    Sunday: Full Cold backup

    thanks
    Why not backup everything with a hot backup on Saturday/Sunday and do incrementals on M-F?

    IMHO, a logical backup once a week is worthless. What do you hope to gain with an export only once a week?

    If you are looking at a complex backup schedule with multi-level backups and partial backups, I would look into using RMAN. It will simplify your tasks many-fold. You can also automate the cleaning of your log_archive_dest with RMAN.
    Last edited by marist89; 11-08-2002 at 11:45 AM.
    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
    Jan 2002
    Posts
    58
    So what you are saying is that if I have a full HOT backup I can use the create controlfile process on a new machine to restore the database, then rollfoward as far as my arch logs go ??

  4. #4
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    yes, you can restore to a new server, re-create control file, and apply as many archived redo logs as you wish.

    http://metalink.oracle.com/metalink/...T&p_id=69468.1
    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 2002
    Posts
    376
    Hi jeff could u pls explain what this command does....

    SVRMGR> alter database recover continue default;

  6. #6
    Join Date
    Sep 2002
    Posts
    376
    Hi jeff could u pls explain what this command does....

    SVRMGR> alter database recover continue default;

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