Re: 7x24 database backup - unix

karlene audd (audd_at_nmti.com) wrote:

: Our production data base is a 7x24 system that can never be shutdown
: (on purpose). In order to back it up I know that a cold backup is
: needed. From then on a hot backup will need to be done at some
: regular interval. My question is do we need to keep all these
: backups in order to restore the data base? Over time (months, years)
: this could really add up. I hope I am missing something very basic!
: Any light you can shed on this subject will be greatly appreciated.

nope...unless you have a need to restore to a particular point in time in the past. If all you want is to be able to recover up to the point of the db crash and media failure, all you need is the latest hot backups of your database (or just of the data file that was trashed if you are that's the only file you lost) and the archive logs needed to roll forward to the present.

Johnny Chan
Independent Oracle Specialist Received on Tue Aug 22 1995 - 00:00:00 CEST