3.4. Recovering an Index Tablespace

Recovering the database with a missing index tablespace is another non-critical recovery technique that you need to understand. An index tablespace is a tablespace that should contain only indexes. Indexes are objects that can be created from the underlying database tables. Rebuild index scripts can be rerun to build the indexes in the index tablespace.

Let's walk through the process of recovering an index tablespace:

  1. The first step is to start and mount the database if it is not already running:

    C:\Documents and Settings\dstuns> sqlplus /nolog

SQL*Plus: Release 10.1.0.2.0 - Production on Sat Aug 21 19:08:48 2004

Copyright (c) 1982, 2004, Oracle. All rights reserved.

SQL> connect / as sysdba Connected. SQL> ...

Get OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial