Oninit cdi / Archive
Talk to an expert →

Informix OnBar Restore

Posted in 2007

Topics: Backup & Restore, Logging & Checkpoints

Wayward — — source: Usenet: comp.databases.informix

Hello all, after an Infomix level 0 restore with onbar 'r 'p the db is at Fast Recovery state ... do I have to restore the logical logs before I bring it online? My aim is to just check that the level 0 backup is recoverable not to bring the db at its latest condition. Or in other words, how can bring the db from Fast Recovery state to Quiescent or Online state? Thank you... :) -- Wayward ------------------------------------------------------------------------ Wayward's Profile: http://unixadmintalk.com/968 View this thread: http://unixadmintalk.com/showthread.php?t=261425

↪ replying to Wayward
Superboer — — source: Usenet: comp.databases.informix

Hello Wayward , is the backup taken paralel onbar -b -L 0 or serial: onbar -b -w -L 0 it it is done using the -w option then you can bring the engine online w.o. applying logs. if it is paralel, you HAVE TO apply the logs. command to bring the engine online would be onmode -m. the engine will then clear the logs (logical and physical ) before it goes to online mode Superboer. On 31 jan, 09:57, Wayward <victor.bec...@vodafone.com> wrote: > Hello all, > > after an Infomix level 0 restore with onbar -r -p > the db is at Fast Recovery state ... > > do I have to restore the logical logs before I bring it online? > > My aim is to just check that the level 0 backup is recoverable > not to bring the db at its latest condition. > > Or in other words, how can bring the db from Fast Recovery state > to Quiescent or Online state? > > Thank you... :) > > -- > Wayward > ------------------------------------------------------------------------ > Wayward's Profile:http://unixadmintalk.com/968 > View this thread:http://unixadmintalk.com/showthread.php?t=261425

↪ replying to Wayward
malc_p@btinternet.com — — source: Usenet: comp.databases.informix

On 31 Jan, 08:57, Wayward <victor.bec...@vodafone.com> wrote: > Hello all, > > after an Infomix level 0 restore with onbar -r -p > the db is at Fast Recovery state ... > > do I have to restore the logical logs before I bring it online? > > My aim is to just check that the level 0 backup is recoverable > not to bring the db at its latest condition. > > Or in other words, how can bring the db from Fast Recovery state > to Quiescent or Online state? > > Thank you... :) > > -- > Wayward Try onmode -m (bring it to multi-user mode). We do this when restoring our physical-only backups (-b -L 0 -w -p)

Glossary