backing up archives but ignoring logs
Is it possible to use ontape to just backup archives and never use it to
backup logical logs and then restore? In other words, I'm not worried
about keeping track of the latest stuff - its okay to lose a couple
hours work. So, can I just periodically do a "ontape -s -L 0" (maybe do
a levels 1 and 2 in between) to disk files and restore from those disk
files if needed?
I guess the easiest way to do this would be to create the databases with
no logging right? What problems might that cause?
In article <3A64DFB2.4A930ADC@nokia.com>, Allen Wyatt
<Allen.Wyatt@nokia.com> writes
>Is it possible to use ontape to just backup archives and never use it to
>backup logical logs and then restore? In other words, I'm not worried
>about keeping track of the latest stuff - its okay to lose a couple
>hours work. So, can I just periodically do a "ontape -s -L 0" (maybe do
>a levels 1 and 2 in between) to disk files and restore from those disk
>files if needed?
>
>I guess the easiest way to do this would be to create the databases with
>no logging right? What problems might that cause?
>
You can do this. The databases do not have to be with no logging, just
set LTAPEDEV in $ONCONFIG to /dev/null.
--
David Williams
This is my experience...I restored to a test system from a system where
logical logging is turned on. I, too, did not care about restoring up to
date information, just wanted a recent db to play with on my test server.
What I discovered... After doing the restore, my chunks were in an
inconsistent state. I researched this error (I think it was in the manual
but it could have been a previous c.d.i message)...If your backed up system
does have logical logging turned on, you must restore at least one log,
following the level 0 restore or your chunks will remain in an inconsistant
state (unuseable).
HTH,
Wynne
"Allen Wyatt" <Allen.Wyatt@nokia.com> wrote in message
news:3A64DFB2.4A930ADC@nokia.com...
> Is it possible to use ontape to just backup archives and never use it to
> backup logical logs and then restore? In other words, I'm not worried
> about keeping track of the latest stuff - its okay to lose a couple
> hours work. So, can I just periodically do a "ontape -s -L 0" (maybe do
> a levels 1 and 2 in between) to disk files and restore from those disk
> files if needed?
>
> I guess the easiest way to do this would be to create the databases with
> no logging right? What problems might that cause?
>
Naw, you just have to bring the engine to FULL OnLine mode (ie onmode -m)
and wait for physical and logical recovery to complete BEFORE shutting
down and restarting the engine. Otherwise you have to start the restore
all over again (or call tech support to mark your chunks/dbspaces up).
Art S. Kagel
Impy wrote:
>
> This is my experience...I restored to a test system from a system where
> logical logging is turned on. I, too, did not care about restoring up to
> date information, just wanted a recent db to play with on my test server.
> What I discovered... After doing the restore, my chunks were in an
> inconsistent state. I researched this error (I think it was in the manual
> but it could have been a previous c.d.i message)...If your backed up system
> does have logical logging turned on, you must restore at least one log,
> following the level 0 restore or your chunks will remain in an inconsistant
> state (unuseable).
> HTH,
> Wynne
>
> "Allen Wyatt" <Allen.Wyatt@nokia.com> wrote in message
> news:3A64DFB2.4A930ADC@nokia.com...
> > Is it possible to use ontape to just backup archives and never use it to
> > backup logical logs and then restore? In other words, I'm not worried
> > about keeping track of the latest stuff - its okay to lose a couple
> > hours work. So, can I just periodically do a "ontape -s -L 0" (maybe do
> > a levels 1 and 2 in between) to disk files and restore from those disk
> > files if needed?
> >
> > I guess the easiest way to do this would be to create the databases with
> > no logging right? What problems might that cause?
> >