You can use BR*Tools for Oracle to recreate a database.
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.
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.
Start the procedure using BRGUI or BRTOOLS, or from the command line:
BRGUI or BRTOOLS
Choose
.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) |
|
Password for SYSTEM user (pass_syst) |
|
Max. number of instances (max_inst) |
|
Max. number of data files (max_data) |
|
Max. number of log groups (max_log) |
|
Max. number of log members (max_memb) |
|
Max. size of log history (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) |
|
Raw disk / link target (syst_rawlink) |
|
Size of the file in MB (syst_size) |
|
File autoextend mode (syst_autoext) |
|
Maximum file size in MB (syst_maxsize) |
|
File increment size in MB (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) |
|
Raw disk / link target (aux_rawlink) |
|
Size of the file in MB (aux_size) |
|
File autoextend mode (aux_autoext) |
|
Maximum file size in MB (aux_maxsize) |
|
File increment size in MB (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) |
|
Temp tablespace file (temp_file) |
|
Raw disk / link target (temp_rawlink) |
|
Size of the file in MB (temp_size) |
|
Undo tablespace name (undo_tsp) |
|
Undo tablespace file (undo_file) |
|
Raw disk / link target (undo_rawlink) |
|
Size of the file in MB (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) |
|
Original redo log file (orig_file) |
|
Raw disk / link target (orig_rawlink) |
|
Mirror redo log file (mirr_file) |
|
Raw disk / link target (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.
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.
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.