onbar -r -t "..." -p -w, recovery not successful
James Zheng reported that a point-in-time onbar restore (onbar -r -t ... -p -w) between two full backups restored only rootdbs, with no logs or other dbspaces, so onmode -m failed. Neil Truby asked about LTAPEDEV, which was /opt/informix/logdev. Brice Avila asked for BAR_ACT_LOG and online.log messages, versions and storage manager errors. Unresolved.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
Database was backup in "onbar -b -w", but when perform point in time
restore, say if pick a time in between two full backups, only rootdbs
restored, no logs and other dbs restored, so after restore done,
onmode -m failed to recovery database to online status.
any suggestion where may went wrong?
Appreciate your respond.
Thanks,
James
what is LTAPEDEV set to?
"James Zheng" <james.zheng@gmail.com> wrote in message
news:7d321437.0409011012.5f59cb7a@posting.google.com...
> Database was backup in "onbar -b -w", but when perform point in time
> restore, say if pick a time in between two full backups, only rootdbs
> restored, no logs and other dbs restored, so after restore done,
> onmode -m failed to recovery database to online status.>
> any suggestion where may went wrong?
>
> Appreciate your respond.
>
> Thanks,
> James
"Neil Truby" <neil.truby@ardenta.com> wrote in message news:<2pmuteFm9a0fU1@uni-berlin.de>...
> what is LTAPEDEV set to?
>
> "James Zheng" <james.zheng@gmail.com> wrote in message
> news:7d321437.0409011012.5f59cb7a@posting.google.com...
> > Database was backup in "onbar -b -w", but when perform point in time
> > restore, say if pick a time in between two full backups, only rootdbs
> > restored, no logs and other dbs restored, so after restore done,
> > onmode -m failed to recovery database to online status.> >
> > any suggestion where may went wrong?
> >
> > Appreciate your respond.
> >
> > Thanks,
> > James
/opt/informix/logdev
James,
I'm sorry, but you'll need to give us more information on this
problem:
1. What are the BAR_ACT_LOG errors/warnings?
2. What are the corresponding online.log errors/warnings?
3. What type and version of:
3a. Operating system
3b. Informix
3c. Storage manager
4. What are the corresponding storage manager errors/warnings?
5. Any unusual behavior/conditions to note?
We'll probably ask more questions as we go on, but this is a good
place to start. Hope this helps.
Brice Avila
Minneapolis, Minnesota
james.zheng@gmail.com (James Zheng) wrote in message news:<7d321437.0409011012.5f59cb7a@posting.google.com>...
> Database was backup in "onbar -b -w", but when perform point in time
> restore, say if pick a time in between two full backups, only rootdbs
> restored, no logs and other dbs restored, so after restore done,
> onmode -m failed to recovery database to online status.>
> any suggestion where may went wrong?
>
> Appreciate your respond.
>
> Thanks,
> James