Re: Is it safe to rebuild an index during an RMAN full backup?

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,
> >Bill
>
> 0. Please read the newsgroup charter:
>    http://members.cox.net/oracleunix/ORACLECH.HTM
> 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
>    answer
> 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