Re: Is it safe to rebuild an index during an RMAN full backup?
Date: Wed, 22 Oct 2008 15:45:25 -0700 (PDT)
On Oct 22, 1:22 pm, bfoga..._at_gaports.com wrote:
> My database is used most heavily between 06:00 and 20:00.
> An RMAN full backup runs nightly from 20:00 to 23:00.
> If I execute command "alter index <name> rebuild online;" during the
> backup will that cause a problem?
> Thank you,
RMAN is smart enough to check if Oracle blocks are fracturing during the copy, so no.
Rebuilding indices and reading data blocks/writing backups tend to be I/O intensive operations, so maybe yes.
I've seen RMAN alone push a fragmented unix I/O buffer over the edge, YMMV. jg
-- @home.com is bogus. Friendly helpful google. http://catless.ncl.ac.uk/Risks/25.40.html#subj2Received on Wed Oct 22 2008 - 17:45:25 CDT