Adding SAP Datafile using BRTools

Hi All,

In this blog I will tell you how to add a new SAP datafile using BRTools:

In Windows login as SIDADM.

Start --> run --> cmd --> brtools

For Linux and Solaris login as root, then follow these commands:

> su - oraSID > sqlplus /nolog > conn sys as sysdba
Enter password: (Press enter)
Connected.
sql>brtools
---------------------------------------------------
Steps are common once brtools starts:
Step1:
------------------------------------------------------------------------------
BR*Tools main menu

1 = Instance management
2 - Space management
3 - Segment management
4 - Backup and database copy
5 - Restore and recovery
6 - Check and verification
7 - Database statistics
8 - Additional functions
9 - Exit program

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
2 ----------------> Enter 2

-------------------------------------------------------------------------------
Database space management

1 = Extend tablespace
2 - Create tablespace
3 - Drop tablespace
4 - Alter tablespace
5 - Alter data file
6 - Move data file
7 - Additional space functions
8 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1 -------------> Enter 1

And then enter c two times.


Step2:
-------------------------------------------------------------------------------
Tablespace extension main menu

1 = Extend tablespace
2 - Show tablespaces
3 - Show data files
4 - Show disk volumes
5 * Exit program
6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
1 ---------------> Select

After this all the table space will be displayed
Select the tablespace for which you want to add a new datafile.

For example we are trying to add datafile to tablespace "PSAPSR3".

As an example we have selected
-------------------------------------------------------------------------------
Options for extension of tablespace PSAPSR3 (1. file)

1 * Last added file name (lastfile) ....... [[Drive]:\ORACLE\SID\SAPDATA2\SR3_4\SR3.D
ATA4]
2 * Last added file size in MB (lastsize) . [2000]
3 - New file to be added (file) ........... [[Drive]:\oracle\SID\sapdata2\sr3_5\sr3.d
ata5]
4 # Raw disk / link target (rawlink) ...... []
5 - Size of the new file in MB (size) ..... [2000]
6 - File autoextend mode (autoextend) ..... [yes]
7 - Maximum file size in MB (maxsize) ..... [10000]
8 - File increment size in MB (incrsize) .. [20]
9 - SQL command (command) ................. [alter tablespace PSAPSR3 add dataf
ile 'D:\oracle\SID\sapdata2\sr3_5\sr3.data5' size 2000M autoextend on next 20M m
axsize 10000M]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c ---------------> Enter c to continue and create datafiles.
----After that enter n --------------------
BR0675I Do you want to perform this action?
BR0676I Enter 'y[es]' to perform the action, 'n[o]/c[ont]' to skip it, 's[top]'
to abort:
n --------------> Enter n to stop creating another datafile.

It will add a new datafile to it.

Hurray !!!!!!!! You have added a new datafile.



Note: Please refer to the SAP/Oracle note for exact procedure for adding datafile, the blogger is not responsible for any issue arising by using the above blog.