Re: Online Backups

In article <3qvqj1$9g5_at_news.informix.com>, Mark Sigler <msigler_at_informix.com> wrote:
>Bruce Boike (bboike_at_baynetworks.com) wrote:
>: I would like to hear from others on their experiences with doing backups
>: online. Has anyone had problems doing this with Oracle7?
 

>: --
>: Bruce Boike
>: Bay Networks, Inc.
>
>This is called 'archivelog' mode and covered extensively in the
>Oracle DBA Handbook from Oracle Press. It includes a lengthy script
>showing the procedures to alter the tables and logs prior to the archive
>and restoration of same after. It appears to be a cumbersome method
>and I have found it rarely used in practice. There are also some caveats
>about block sizes in the instance corresponding to the Unix filesystem.
>--
>
>//////////////// Mark Sigler, Systems Engineer
>////////// // Informix Software, Inc.
>////// / /// 1000 West McNab Road
>///// // //// Fort Lauderdale, Florida 33069
>//// // ///// Voice: (305) 781-2646
>/// // ////// Fax: (305) 781-2029
>// // /////// Voicemail: (800) 688-4217 x 2147
>/ /////////// Email: MSigler_at_Informix.Com
>//////////////// WWWeb: HTTP://WWW.Informix.Com/
>
>--

Hey Mark. Rarely used in practice? I beg to differ. Online backups are an excellent form of backups for 24x7 shops who don't have the luxury to shut down the database to do offline backups. Looking at your "signature", it sounds like you may have a bias. Received on Tue Jun 06 1995 - 00:00:00 CEST