Recreating a Database with BR*Tools

Use

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

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

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

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 reset the 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

                                                  i.       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.

                                                ii.       Choose Specify new database options.

BRSPACE displays the menu Main options for recreate of database.

                                               iii.       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

                                               iv.       Choose Continue.

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

                                                 v.       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

                                               vi.       Choose Continue.

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

                                              vii.       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

                                            viii.       Choose Continue.

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

                                              ix.       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

                                                x.       Choose Continue.

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

                                              xi.       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.

                                             xii.       Choose Continue.

BRSPACE returns to the menu Recreate database main menu.

                                           xiii.       Choose Export user tablespaces.

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

                                            xiv.       Choose Export global objects.

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

                                             xv.       Choose Create new database.

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

                                            xvi.       Choose Import global objects.

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

                                          xvii.       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>.logdisplays the return code.

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