Re: DB recovery using ontape
On Wed, 20 Aug 1997, Kenji Hino wrote:
} I did say "No" to that but I still didn't get the update. Do I need to
} do something else ?
}
} Kenji
}
} Mark D. Stock wrote:
}
} > Kenji Hino wrote:
} > >
} > > I am new to the utility "ontape". I hope somebody can explain to me
} >
} > > what's going on.
} > > To get familiar with the tool, I created a dataspace and put data in
} >
} > > it
} > > and created a level-0 archive using "ontape -s". Then, I updated one
} >
} > > of
} > > the record and created a logical log archive using "ontape -a". For
ontape -a is a backup of logical logs available to be backed up. If you haddid not have enough activity to fill a logical log your backup would
have no data on it. onlog will let you know what if anything is on
your logical log backup. I would also try backing these up
to tape since that is what ontape supports.
Good luck
--
Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; Ft. Collins CO 80523,
USofA; 970-491-1244 FAX 970-491-4100 cwoodall@vth1.vth.colostate.edu
"There is no 'maybe' in Boolean algebra."
--
} > > the
} > > testing purpose, I used UNIX files (not devices) to specify the
} > > destination for both system and logincal archive tape devices.
} > > When I try to do full recovery using those two files, I get the
} > system
} > > archive recovered fine but I can't get the logical log to
} > rollforward
} > > which means that I can't get any update after I created the system
} > > archive. Does anybody know what I am doing wrong ? During the
} > > recovery,
} >
} > During the restore it asks if you want to backup the current logs. You
} >
} > MUST say NO. Otherwise you will overwrite your previous backup, and
} > have no logs to restore.
} >
} > Hope that helps,
} > --
} > Mark.
} >
} > +----
} > -----------------------------------------------------+-----------+
} > |Mark D. Stock - Informix SA http://www.informix.com |////////
} > /|
} > |mailto:mdstock@informix.com FAQ http://www.iiug.org |///// /
} > //|
} > | +-----------------------------------+//// /
} > ///|
} > | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// /
} > ////|
} > | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// /
} > /////|
} > |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/
} > ////////|
} > +--------
} > -------------+-----------------------------------+-----------+
}
}
}
}