Show TOC

Procedure documentationRecreating a Database with BR*Tools Locate this document in the navigation structure

 

You can use BR*Tools for Oracle to recreate a database.

Note Note

This section describes how you recreate a database with BR*Tools.

For more information on the approach to recreating a database, see Recreate Database.

End of the note.

Prerequisites

  • The Oracle database must be Version 9.2 or higher.

  • All user tablespaces (that is, tablespaces other than the SYSTEM tablespace) must be locally managed.

  • The automatic UNDO management must be active with the Oracle parameter undo_management = auto.

  • The database must contain a default temporary tablespace.

  • Perform a complete database backup before you start the database recreate, offline if possible. If BRSPACE fails, you cannot restart the process and you must therefore resetthe entire database (for example, with the BRRECOVER “reset” function)

For more information, see SAP Note 748434.

Procedure

  1. Start the procedure using BRGUI or BRTOOLS, or from the command line:

    • BRGUI or BRTOOLS

      1. Choose   Instance   Management   Recreate database  .

        BRGUI or BRTOOLS displays the menu Recreate database main menu, where you specify the options with which you call BRSPACE.

        BRTOOLS now calls the BRSPACE function recreate database.

      2. Choose Specify new database options.

        BRSPACE displays the menu Main options for recreate of database.

      3. Set the required options:

        Menu Entry

        Equivalent BRSPACE Command Option

        Password for SYS user (pass_sys)

        -f dbcreate -pass_sys

        Password for SYSTEM user (pass_syst)

        -f dbcreate -pass_syst

        Max. number of instances (max_inst)

        -f dbcreate -max_inst

        Max. number of data files (max_data)

        -f dbcreate -max_data

        Max. number of log groups (max_log)

        -f dbcreate -max_log

        Max. number of log members (max_memb)

        -f dbcreate -max_memb

        Max. size of log history (max_hist)

        -f dbcreate -max_hist

      4. Choose Continue.

        BRSPACE displays the menu SYSTEM tablespace options for recreate of database.

      5. Set the required options:

        Menu Entry

        Equivalent BRSPACE Command Option

        SYSTEM tablespace file (syst_file)

        -f dbcreate -syst_file

        Raw disk / link target (syst_rawlink)

        -f dbcreate -syst_rawlink

        Size of the file in MB (syst_size)

        -f dbcreate -syst_size

        File autoextend mode (syst_autoext)

        -f dbcreate -syst_autoext

        Maximum file size in MB (syst_maxsize)

        -f dbcreate -syst_maxsize

        File increment size in MB (syst_incrsize)

        -f dbcreate -syst_incrsize

      6. Choose Continue.

        BRSPACE displays the menu SYSAUX tablespace options for recreate of database.

      7. Set the required options:

        Menu Entry

        Equivalent BRSPACE Command Option

        SYSAUX tablespace file (aux_file)

        -f dbcreate -aux_file

        Raw disk / link target (aux_rawlink)

        -f dbcreate -aux_rawlink

        Size of the file in MB (aux_size)

        -f dbcreate -aux_size

        File autoextend mode (aux_autoext)

        -f dbcreate -aux_autoext

        Maximum file size in MB (aux_maxsize)

        -f dbcreate -aux_maxsize

        File increment size in MB (aux_incrsize)

        -f dbcreate -aux_incrsize

      8. Choose Continue.

        BRSPACE displays the menu Temp and undo tablespace options for recreate of database.

      9. Set the required options:

        Menu Entry

        Equivalent BRSPACE Command Option

        Temp tablespace name (temp_tsp)

        -f dbcreate -temp_tsp

        Temp tablespace file (temp_file)

        -f dbcreate -temp_file

        Raw disk / link target (temp_rawlink)

        -f dbcreate -temp_rawlink

        Size of the file in MB (temp_size)

        -f dbcreate -temp_size

        Undo tablespace name (undo_tsp)

        -f dbcreate -undo_tsp

        Undo tablespace file (undo_file)

        -f dbcreate -undo_file

        Raw disk / link target (undo_rawlink)

        -f dbcreate -undo_rawlink

        Size of the file in MB (undo_size)

        -f dbcreate -undo_size

      10. Choose Continue.

        BRSPACE displays the menu Online redo log options for log group.

      11. Set the required options:

        Menu Entry

        Equivalent BRSPACE Command Option

        Redo log file size in MB (log_size)

        -f dbcreate -log_size

        Original redo log file (orig_file)

        -f dbcreate -orig_file

        Raw disk / link target (orig_rawlink)

        -f dbcreate -orig_rawlink

        Mirror redo log file (mirr_file)

        -f dbcreate -mirr_file

        Raw disk / link target (mirr_rawlink)

        -f dbcreate -mirr_rawlink

        The above menu appears again for subsequent log groups.

      12. Choose Continue.

        BRSPACE returns to the menu Recreate database main menu.

      13. Choose Export user tablespaces.

        BRSPACE exports the user tablespaces and returns to the menu Recreate database main menu.

      14. Choose Export global objects.

        BRSPACE exports the global objects and returns to the menu Recreate database main menu.

      15. Choose Create new database.

        BRSPACE creates a new empty database and returns to the menu Recreate database main menu.

      16. Choose Import global objects.

        BRSPACE imports the global objects and returns to the menu Recreate database main menu.

      17. Choose Import user tablespaces.

        BRSPACE imports user tablespaces and returns to the menu Recreate database main menu.

    • Command line:

      Enter at least the following command:

      brspace -f dbcreate

      You can enter more parameters if required. For more information, see BRSPACE -f dbcreate.

Result

The new database instance is now recreated and opened.

Check the results in the BRSPACE logs:

  • The summary log space<DBSID>.log displays the return code.

  • The detail log s<encoded timestamp>.dbc displays the details.