DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 14 of 14

Thread: what files need to be included in cold backup?

  1. #11
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    I like to backup redo logs with cold backups because there have been times when I was asked to clone databases on a separate server, mostly for testing purposes. This can be done without interruption to the production system if there is a recent cold backup with all files including redo logs. Usually, data from the last cold backup was good enough, since we do cold backups once a week.

    Just a different angle on cold backups.

  2. #12
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Its the question of what you loose and what you have when you are recovering your database. Bottom line you need to have all the files(data,log,control,parameter) and archivelog files.

    You can't predict your recovery situation while planning for backup plan. Your backup plan should be in such a way, No matter whats the situation, you should bring up your databse with no data loss. Attempt towards that and take backup.

  3. #13
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Amen. You can never have too many options to recover.
    Jeff Hunter

  4. #14
    Join Date
    Jun 2000
    Posts
    55
    You guys answered my questions. Thanks a lot!!!

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