Re: Is it safe to rebuild an index during an RMAN full backup?
Date: Thu, 23 Oct 2008 14:44:26 -0700 (PDT)
On Oct 22, 5:01 pm, sybra..._at_hccnet.nl wrote:
> On Wed, 22 Oct 2008 13:22:42 -0700 (PDT), 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,
> 0. Please read the newsgroup charter:
> 1. Please post your full Oracle version (e.g., 10.2.0.4.0) via "select
> banner from v$version"
> 2. Please post your Oracle server's operating system and version
> 3. Please usehttp://google.comto help you find your answer
> 4. Please usehttp://tahiti.oracle.com/to help you find your answer
> 5. Please usehttp://www.psoug.org/library.htmlto help you find your
> 6. Please usehttp://asktom.oracle.comto help you find your answer
> 7. Please specify whether the index tablespace is in nologging, the
> backup is to tape or disk, you are issuing a full or an incremental
> backup, and/or 10g block change tracking.
> Sybrand Bakker
> Senior Oracle DBA
Oracle Server 10.2.0.2
UNIX AIX 5.2
The index tablespace logs changes.
The backup is to disk. It is a full backup. 10g block change tracking is disabled.
Bill Received on Thu Oct 23 2008 - 16:44:26 CDT