All very interesting responses. Thanks! Yes, indeed, it could have been
the fact that we were not
running a level 0 that was causing this mischief, but I read somewhere
that if you run
a level 1 cumulative , and it does not have a level 0 to build on then
it will force one, which I would
think would then allow any subsequent level 1 backups to run as normal,
but maybe not?
In other words, maybe unless you overtly run a level 0 then any
following level 1 cumulative incremental
will not run as expected?
We, too, have noticed that these incrementals take as long to run as
level 0 backups, but they
are very fast to recover from. I notice, for example, that when
recovering from a full
(level 0) backup of say 4 save sets that NetWorker will recover the
first one,
and then there will be a time lapse (maybe 20-30 min) before it will
recover the second one.
It does this for each one recovered. I suspect that Oracle is doing
something with the
recovered data during this time or reorganizing the closet or whatever.
However, when
recovering the subsequent incremental, it only takes minutes to run, and
there is virtually
no lag time between the recovered save sets.
I will ask our DBA about the block change tracking, but I thought ORacle
10g used this
by default? Must it be overtly turned on?
George
Uwe Weber wrote:
Preston de Guise schrieb:
I always followed their instructions, and always got proper
full+"incremental" backups. One thing of course is that while the
"incremental" is usually much smaller than the full, many of my
customers have found that it takes almost as long as the full, and is
more intensive on database processing than the full, due to the
tablespace scans that have to be done.
If you are backing up Oracle 10, you could ask your
DBA to enable Block Change tracking. This will
speed up incrementals a lot.
Regards,
uwe
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to networker-request
AT listserv.temple DOT edu if you have any problems with this list. You can access the
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
--
George Sinclair - NOAA/NESDIS/National Oceanographic Data Center
SSMC3 4th Floor Rm 4145 | Voice: (301) 713-3284 x210
1315 East West Highway | Fax: (301) 713-3301
Silver Spring, MD 20910-3282 | Web Site: http://www.nodc.noaa.gov/
- Any opinions expressed in this message are NOT those of the US Govt. -
To sign off this list, send email to listserv AT listserv.temple DOT edu and type
"signoff networker" in the body of the email. Please write to networker-request
AT listserv.temple DOT edu if you have any problems with this list. You can access the
archives at http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER
|