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

From: <sybrandb_at_hccnet.nl>
Date: Wed, 22 Oct 2008 23:01:14 +0200
Message-ID: <q15vf49r6jc1bj72eo48tj4445kf1125g3@4ax.com>


On Wed, 22 Oct 2008 13:22:42 -0700 (PDT), bfogarty_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 use http://google.com to help you find your answer
4. Please use http://tahiti.oracle.com/ to help you find your answer
5. Please use http://www.psoug.org/library.html to help you find your

   answer
6. Please use http://asktom.oracle.com to 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
Received on Wed Oct 22 2008 - 16:01:14 CDT

Original text of this message