RE: DBA probems

Posted in 1999

Sadagopan, Sathish, CFCTR — Wed, 31 Mar 1999 09:06:14 -0500 — source: Informix-list mailing list archive (1991-1998)

You will lose the transactions which occurred after the 'ontape -s -L 0' if you do not back up your logfiles. You will be able to restore only till the point when the level 0 archive started. You might want to back up your logical log files as well using ontape -a or ontape -c (continuous if you have 2 tape drives) to ensure complete recovery.Then you can restore from your level 0 and then replay all the logical logs for complete recovery. HTH Sathish Sadagopan -----Original Message----- From: Mukund Shevkar [mailto:mukundshevkar@hotmail.com] Sent: Tuesday, March 30, 1999 6:45 PM To: informix-list@iiug.org Subject: DBA probems Hi this is mukund ! I am doing backup thru ontape utility as follows ontape -s -L 0 everyday. (logfiles backup thru ontape -a is not done)Is archive level 0 backup without logfile backup thru ontape -a command is sufficient ? If not what is correct method ? Favor me with correct and fast answer on this. I have following software - informix online (IDS) engine ver 7.13. Sql serial no AAB#J516701 Thanks Mukund Get Your Private, Free Email at http://www.hotmail.com