Re: Backing up OE db files
Posted in 1992
In article 3566@infonode.ingr.com, jjolly@jjolly.b24b.ingr.com (Jack G. Jolly) writes: >Is it necessary to back up the physical files associated with an >ONLINE db "outside of the environment"? > >Consider "raw partitions" as well. > >I always thought that backup of physical files was a necessity to >prevent against disk failure - that you would restore your old >files and apply the contents of saved transaction log files against >them to bring them up to date (at least that is how you're supposed >to do it with Oracle). > >Does the "Archive" utility in tbmonitor eliminate the need to make copies >of the physical files?? > >JJ >------------- > > ^^^^^^^^^ Jack Jolly @ jjolly@jjolly.b24b.ingr.com > (| 0 - |) > | * | Intergraph Corporation, Huntsville AL > \\_______/ AEC Project Management Support The entire purpose of the archive system is so that you don't have to make backing up your on-line data part of your regular backups. The on-line archiving system stores all database information needed to restore the database in the event of failure. You still need to backup your regular UNIX system, so that the INFORMIXDIR files (programs and configuration info) are saved. If you are using cooked files, and are properly archiving your on-line system (both data and logs), you can exclude the cooked files from your unix archive. Hope this clears things up some, don simon "I didn't do it. Nobody some me do it. You can't prove a thing."