Hot Backups
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Hot Backups

  1. #1
    Join Date
    May 2001
    Location
    India
    Posts
    55
    Hi,

    I need information about hot backups.
    after I giver alter tablespace tablespacename begin backup

    How it is functioning, If anybody knows

    How i can take hot backups plz tell me the steps and details.

    I am confused with this.

    Thanking You,

    my id is shankar_gk@hotmail.com

    G.Shankar.

  2. #2
    Join Date
    Jun 2001
    Posts
    76
    Following are the minimum steps to a hot backup:

    1) Make sure the database is in ARCHIVELOG mode.

    2) Prepare the database for a hot backup:
    SQL> ALTER TABLESPACE tablespace_name BEGIN BACKUP;

    3) Obtain the oldest online log sequence #:
    SQL> ARCHIVE LOG LIST;

    4) Back up the database using a system command:
    UNIX: obackup, tar, dd, etc...
    NT: backup manager, etc..

    5) Set the tablespace to no hot backup mode:
    SQL> ALTER TABLESPACE tablespace_name END BACKUP;

    6) Obtain the current online log sequence #:
    SQL> ARCHIVE LOG LIST;

    7) Force a log switch:
    SQL> ALTER SYSTEM SWITCH LOGFILE;


    Good luck
    R
    On the other hand, you have different fingers.

  3. #3
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by rlowe
    Following are the minimum steps to a hot backup:
    .....
    A final step is missing from your backup scenario for this backup to be usable:

    8.) Back up all the archived logs that have been created during the backup procedure - all archlogs with sequences between (and including) numbers obtained in steps 3.) and 6.)
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  4. #4
    Join Date
    Jun 2001
    Posts
    76
    details...
    On the other hand, you have different fingers.

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