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

Thread: Hot Backup

  1. #1
    Join Date
    Sep 2000
    Posts
    305
    What is the best way to take hot backup? I also wanted to know that If I took backup of each tablespace seperatly then will I face the problem of inconsistancy because I do not want to lose the single data.

    suppose my data are in tablespace tbs1 and indexes are in ind_tbs1.

    Please I need you suggestions
    Thanks in Advance

    Shailendra

  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530
    Hi,
    When you take HOT backups ,the backups are not consistent as these backups are taken when the database is open.You have to apply the redolog files in order to recover the database and make it consistent.You can take the hot backup by putting the tablespace in backup mode,backing up the datafiles and then putting the tablespace in end backup mode.Also you can take the HOT backup by implementing RMAN(Recovery Manager) as it provides with a lot of options and makes your backup and recovery very easy.When you want to take a HOT backup take the backup of all the datafiles,controlfiles and the archived-log files of the database.

    Regards,
    Rohit Nirkhe,Oracle/Apps DBA,OCP 8i
    oracle-support@indiatimes.com
    Thanks and Regards
    Rohit S Nirkhe
    rohitsnirkhe@rediffmail.com

  3. #3
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    Do not afraid to do it, it is better to put tablespces in recovery mode one by one. I always do it and did not meet any problems.

    Originally posted by shailendra
    ... If I took backup of each tablespace seperatly then will I face the problem of inconsistancy ...
    Best wishes!
    Dmitri

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