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

Thread: Backup

  1. #1
    Join Date
    Feb 2001
    Posts
    17

    Question

    How should I take a Hot Backup on NT server? HOw do I schedule backups and maintenance jobs on NT server?

  2. #2
    Join Date
    Aug 2000
    Posts
    236
    Hot backups are taken on the tablespace level.

    At SQL plus or Server manager prompt: issue the command:

    ALTER TABLESPACE ts_name start backup;

    Now assuming you are not using RMAN, use the OS utilities to copy all the datafiles belonging to that particular tablespace. Once you do that issue the command:

    ALTER TABLESPACE ts_name END backup;

    Nizar


  3. #3
    Join Date
    Sep 2000
    Location
    Calcutta / Ahmedabad, India
    Posts
    137
    The Command is

    Alter Tablespace <TABLESPACE NAME> Begin backup;

    Alter Tablespace <TABLESPACE NAME> End Backup;
    Suvashish

  4. #4
    Join Date
    Aug 2000
    Posts
    236
    I am sorry about that mistake. Meant BEGIN.

    Nizar

  5. #5
    Join Date
    Feb 2001
    Posts
    13
    As mentioned above , hot backup is taken tablespace by tablespace:

    steps:

    1. take a list of tablespaces and corresponding datafiles you want to take backup.

    2. Issue the command ALTER TABLESPACE tablespace name BEGIN BACKUP;

    3. Copy all the datafiles corresponding to this tablespace to the backup drive.

    4. Issue the command ALTER TABLESPACE tablespace name END BACKUP;

    Repeat the above for all the tablespaces. It's advisable to take backup at the time of low db activity..

    Pands

  6. #6
    Join Date
    Nov 2000
    Posts
    205
    Just a not that this can only be performed on databases in archivelog mode.

    Nirasha

  7. #7
    Join Date
    Feb 2001
    Posts
    17
    hi all,

    thanks for the info.

    thanks mr.pandian for for giving a detailed note. really helpful.

    regards
    ravi 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