Recreating a Database with BR*Tools

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.

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.

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

BRGUI or BRTOOLS

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.
Choose Specify new database options.
BRSPACE displays the menu Main options for recreate of database.

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

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

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

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

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

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

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

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

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.

Choose Continue.
BRSPACE returns to the menu Recreate database main menu.
Choose Export user tablespaces.
BRSPACE exports the user tablespaces and returns to the menu Recreate database main menu.
Choose Export global objects.
BRSPACE exports the global objects and returns to the menu Recreate database main menu.
Choose Create new database.
BRSPACE creates a new empty database and returns to the menu Recreate database main menu.
Choose Import global objects.
BRSPACE imports the global objects and returns to the menu Recreate database main menu.
Choose Import user tablespaces.
BRSPACE imports user tablespaces and returns to the menu Recreate database main menu.

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.
For more information on how to view the logs with BR*Tools, see .