Re: Is it safe to rebuild an index during an RMAN full backup?
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 DBAReceived on Wed Oct 22 2008 - 16:01:14 CDT