Show TOC

Function documentationRecreate Database Locate this document in the navigation structure

 

You can recreate the database, that is, set up the SYSTEM tablespace. Logically this means that the SYSTEM tablespace is reorganized. The UNDO and TEMP tablespaces are also recreated. However, SAP data is unaffected. Only the metadata of SAP tablespaces are exported and imported.

You can recreate the database to:

  • Migrate the SYSTEM tablespace from dictionary to locally managed tablespaces (LMTS)

  • Defragment the SYSTEM tablespace

  • Solve the extent problem in the SYSTEM tablespace – for more information, see SAP Note 651796.

    Note Note

    This section describes how to approach recreate database.

    For more information on how to perform recreate database, see Recreating a Database with BR*Tools.

    End of the note.

It is possible to use BRSPACE and BRTOOLS for heterogeneous database copies. For more information, see Enhanced Support for Heterogeneous Database Copies in SAP Note 1003028.

Prerequisites

The prerequisites are described in Recreating a Database with BR*Tools.

Features

The following graphic shows how recreate database works:

This graphic is explained in the accompanying text.

Activities

  1. Specify new database options.

    You define the following database options:

    • Passwords for SYS and SYSTEM users

    • Maximum number of instances

    • Maximum number of datafiles

    • Maximum number of redo log groups

    • Maximum number of redo log members in a group

    • Maximum size of redo log history

    • Attributes for files of SYSTEM, SYSAUX, temporary and undo tablespaces

    • Attributes for files of original and mirror online redo logs

  2. Export user tablespaces phase.

    BRSPACE exports the metadata - that is, database object definitions - of all user tablespaces using the transportable feature of the Oracle EXPDP (Data Pump) tool. This logically detaches the user tablespaces from the original database.

  3. Export global objects phase.

    BRSPACE exports global object definitions - such as users, roles, links, sequences, synonyms, views, procedures, triggers, and so on - using the full export feature of the Oracle EXPDP tool.

  4. Create new database phase.

    BRSPACE drops the old database and recreates a new one based on the options you specified. Oracle catalog views and stored procedures are also recreated, as described in the Oracle documentation.

  5. Import global objects phase.

    BRSPACE imports global object definitions previously exported using the full import feature of the Oracle IMPDP (Data Pump) tool.

  6. Import user tablespaces phase.

    BRSPACE imports the metadata of all user tablespaces exported before using the transportable tablespace feature of the Oracle IMPDP tool. Therefore, the user tablespaces are logically reattached to the new database.