Restore certain Logical Logs
Markus Bschorer asked whether ontape could restore a level-0 archive and then only some logical logs, such as 145 to 156 rather than to 250. itsme suggested onbar -r -n 156, then conceded ontape differs. Art Kagel said ontape restores every log in a given file or tape, so it only works if logs are in separate files; onbar can do point-in-time restore, ontape cannot.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Hi guys,
restoring a Level-0-archive using ontape -r and after that restoring
logical logs using ontape -l works without any problem.
Now, I have to restore a database-state, given after certain logical log.
Is it possible, to restore a Level-0-archive (which includes the logical log
144) and after that restore the logical logs 145 thru 156 (e.g.) , but not
145 thru 250 ?
Thanks for your answers!
Greetings
Markus
Try onbar -r -n 156
"Markus Bschorer" <mb@worxbox.com> wrote in message
news:bme2kg$2ke$04$1@news.t-online.com...
> Hi guys,
>
> restoring a Level-0-archive using ontape -r and after that restoring
> logical logs using ontape -l works without any problem.
>
> Now, I have to restore a database-state, given after certain logical log.
>
> Is it possible, to restore a Level-0-archive (which includes the logical
log
> 144) and after that restore the logical logs 145 thru 156 (e.g.) , but
not
> 145 thru 250 ?
>
> Thanks for your answers!
>
> Greetings
> Markus
>
>
>
>
>
>
On Mon, 13 Oct 2003 07:36:54 -0400, Markus Bschorer wrote:
Using ontape? Only if the logical logs are on/in separate tapes/files. The
logical log restore phase will restore any and all log files it finds in a log
archive file/tape. So if you have a file with logs 145-156 and another with
logs 157-250 or individual log backup files containing one log each then the
answer is yes, otherwise no.
Onbar can perform a point-in-time restore, ie restore to 2003-10-07 12:45:56,
but ontape cannot.
Art S. Kagel
> Hi guys,
>
> restoring a Level-0-archive using ontape -r and after that restoring logical
> logs using ontape -l works without any problem.
>
> Now, I have to restore a database-state, given after certain logical log.
>
> Is it possible, to restore a Level-0-archive (which includes the logical log
> 144) and after that restore the logical logs 145 thru 156 (e.g.) , but not
> 145 thru 250 ?
>
> Thanks for your answers!
>
> Greetings
> Markus
Sorry, I thought you were using onbar. Art is right about ontape.
"itsme" <please.no.spam@no-spam.net.org.com> wrote in message
news:bmede7$peg$1@reader08.wxs.nl...
> Try onbar -r -n 156
>
> "Markus Bschorer" <mb@worxbox.com> wrote in message
> news:bme2kg$2ke$04$1@news.t-online.com...
> > Hi guys,
> >
> > restoring a Level-0-archive using ontape -r and after that restoring
> > logical logs using ontape -l works without any problem.
> >
> > Now, I have to restore a database-state, given after certain logical
log.
> >
> > Is it possible, to restore a Level-0-archive (which includes the logical
> log
> > 144) and after that restore the logical logs 145 thru 156 (e.g.) , but
> not
> > 145 thru 250 ?
> >
> > Thanks for your answers!
> >
> > Greetings
> > Markus
> >
> >
> >
> >
> >
> >
>
>