Re: Stupid mistake :-)

Peter Eckhardt wrote: > > Hello, > > i did a stupid mistake and am looking if there is a way to recover. We > had > to quickly change the logging mode of a database. First I performed a > level 0 backup, then i performed a level 0 backup to /dev/null when > doing ontape -s -A db_name. Then i forgot an additional level 0 > backup. The logical logs were automatically backed up to tape. > > Before the next level 0 backup occured the server crashed with a > complete > data loss. Now there is a problem in restoring this database. The level > 0 backup goes > in without problems but the logical logs aren't restored because the > database is > still in an unlogged state. OUCH! Makes one appreciate all those precaution we take just in case the "it can't happen scenario" happens, eh? > Is there a way to > > 1. restore the level 0 backup > 2. change the logging state to Ansi > 3. Restore the logs ? No way that I know of. Perhaps tech support can muck things up so this will work. Art S. Kagel