How to Reset user password using BRtools in oracle SAP database?

 steps to Reset user password  using BRtools in oracle SAP database:

linux_server>:oraoradb1 26> brtools

BR0651I BRTOOLS 7.20 (22)

BR0280I BRTOOLS time stamp: 2021-08-24 12.38.55

BR0656I Choice menu 1 - please make a selection

-------------------------------------------------------------------------------

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:

8

BR0280I BRTOOLS time stamp: 2021-08-24 12.38.59

BR0663I Your choice: '8'

BR0280I BRTOOLS time stamp: 2021-08-24 12.38.59

BR0656I Choice menu 2 - please make a selection

-------------------------------------------------------------------------------

Additional BR*Tools functions

 1 = Show profiles and logs

 2 - Clean up DBA logs and tables

 3 - Adapt NEXT extents

 4 - Change password of database user

 5 - Create/change synonyms for DBA tables

 6 - Reset program status

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

4

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.06

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.06

BR0657I Input menu 59 - please enter/check input values

-------------------------------------------------------------------------------

BRCONNECT options for changing password of database user

 1 - BRCONNECT profile (profile) ............... [initoradb1.sap]

 2 - Database user/password (user) ............. [/]

 3 ~ Database owner to change password (owner) . []

 4 ~ Log file name (log) ....................... []

 5 - Message language (language) ............... [E]

 6 - BRCONNECT command line (command) .......... [-p initoradb1.sap -l E -f chpass]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

3

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.23

BR0663I Your choice: '3'

BR0681I Enter string value for "owner" []:

TEST_USER

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.26

BR0683I New value for "owner": 'TEST_USER'

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.26

BR0657I Input menu 59 - please enter/check input values

-------------------------------------------------------------------------------

BRCONNECT options for changing password of database user

 1 - BRCONNECT profile (profile) ............... [initoradb1.sap]

 2 - Database user/password (user) ............. [/]

 3 ~ Database owner to change password (owner) . [TEST_USER]

 4 ~ Log file name (log) ....................... []

 5 - Message language (language) ............... [E]

 6 - BRCONNECT command line (command) .......... [-p initoradb1.sap -l E -f chpass -o TEST_USER]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.30

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRCONNECT will be started with options '-p initoradb1.sap -l E -f chpass -o TEST_USER'

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.30

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.36

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR0801I BRCONNECT 7.20 (22)

BR0280I BRCONNECT time stamp: 2021-08-24 12.39.37

BR1048I Enter new password for database user 'TEST_USER' (max. 30 characters):

BR0280I BRCONNECT time stamp: 2021-08-24 12.39.54

BR1048I Reenter new password for database user 'TEST_USER' (max. 30 characters):

BR0280I BRCONNECT time stamp: 2021-08-24 12.39.58

BR0829I Password changed successfully in database for user TEST_USER

BR0280I BRCONNECT time stamp: 2021-08-24 12.39.58

BR0802I BRCONNECT completed successfully

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 0

BR0280I BRTOOLS time stamp: 2021-08-24 12.39.58

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:

s

BR0280I BRTOOLS time stamp: 2021-08-24 12.40.06

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

y

BR0280I BRTOOLS time stamp: 2021-08-24 12.40.09

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2021-08-24 12.40.09

BR0654I BRTOOLS terminated with errors

*************************************************************************************

There wont be Brtools entry for password reset in alert log

**************************************************************************************

steps to install oracle 12c client on Linux server using silent method

 steps to install oracle 12c client on Linux server using silent method:

1.down load the client binary and unzip it.

2.modify the below parameter on response file

#-------------------------------------------------------------------------------

# Do not change the following system generated value.

#-------------------------------------------------------------------------------

oracle.install.responseFileVersion=/oracle/install/rspfmt_clientinstall_response_schema_v12.2.0

#-------------------------------------------------------------------------------

# Unix group to be set for the inventory directory.

#-------------------------------------------------------------------------------

UNIX_GROUP_NAME=dba

#-------------------------------------------------------------------------------

# Inventory location.

#-------------------------------------------------------------------------------

INVENTORY_LOCATION=/oracle/oradata/backup/TESTDB/gold/client_122/dmapps/product/oraInventory

#-------------------------------------------------------------------------------

# Complete path of the Oracle Home

#-------------------------------------------------------------------------------

ORACLE_HOME=/oracle/oradata/backup/TESTDB/gold/client_122/dmapps/product/release/oracle/oracle/product/12.1.0/client_1

#-------------------------------------------------------------------------------

# Complete path of the Oracle Base.

#-------------------------------------------------------------------------------

ORACLE_BASE=/oracle/oradata/backup/TESTDB/gold/client_122/dmapps/product/release

#------------------------------------------------------------------------------

#Name       : INSTALL_TYPE

#Datatype   : String

#Description: Installation type of the component.

#

#             The following choices are available. The value should contain

#             only one of these choices.

#               - InstantClient

#               - Administrator

#               - Runtime

#               - Custom

#

#Example    : INSTALL_TYPE = Administrator

#------------------------------------------------------------------------------

oracle.install.client.installType=Administrator

3.run the response file

linux_server1:/oracle/oradata/backup/TESTDB/gold/tmp_client/client# ls -ltr

total 28

-rwxrwxr-x  1 oracle dba  500 Feb  6  2013 welcome.html

-rwxr-xr-x  1 oracle dba 8775 Jan 26  2017 runInstaller

drwxr-xr-x  4 oracle dba 4096 Jan 26  2017 install

drwxrwxr-x  2 oracle dba 4096 Jan 26  2017 response

drwxr-xr-x 14 oracle dba 4096 Jan 26  2017 stage

linux_server1:/oracle/oradata/backup/TESTDB/gold/tmp_client/client# cd response

linux_server1:/oracle/oradata/backup/TESTDB/gold/tmp_client/client/response# ls -ltr

total 32

-rwxrwxr-x 1 oracle dba 6209 Jun 20  2016 netca.rsp

-rwxr-xr-x 1 oracle dba 6209 Jul 13 08:58 netca.rsp_bak_july13

-rw-r--r-- 1 oracle dba 5498 Jul 13 08:58 client_install.rsp_bak_july13_2021

-rw-rw-r-- 1 oracle dba 5767 Jul 13 09:13 client_install.rsp

linux_server1:/oracle/oradata/backup/TESTDB/gold/tmp_client/client/

linux_server1:/oracle/oradata/backup/TESTDB/gold/tmp_client/client# ./runInstaller -ignoreSysPrereqs -showProgress -silent -responseFile /oracle/oradata/backupll.rspADB/gold/tmp_client/client/response/client_insta

Starting Oracle Universal Installer...

Checking Temp space: must be greater than 415 MB.   Actual 4615 MB    Passed

Checking swap space: must be greater than 150 MB.   Actual 17740 MB    Passed

Preparing to launch Oracle Universal Installer from /tmp/OraInstall2021-07-13_09-17-08AM. Please wait ...linux_server1:/oracle/oradata/backup/TESTDB/gold/tmp_client/client# You can find the log of this install session at:

 /oracle/oraInventory_1960/logs/installActions2021-07-13_09-17-08AM.log

Prepare in progress.

..................................................   7% Done.

Prepare successful.

Copy files in progress.

..................................................   14% Done.

..................................................   19% Done.

..................................................   24% Done.

..................................................   29% Done.

..................................................   34% Done.

..................................................   39% Done.

..................................................   45% Done.

..................................................   50% Done.

..................................................   55% Done.

..................................................   60% Done.

..................................................   65% Done.

....................

Copy files successful.

Link binaries in progress.

Link binaries successful.

Setup files in progress.

Setup files successful.

Setup Inventory in progress.

Setup Inventory successful.

Finish Setup in progress.

Finish Setup successful.

The installation of Oracle Client 12c was successful.

Please check '/oracle/oraInventory_1960/logs/silentInstall2021-07-13_09-17-08AM.log' for more details.

Prepare for configuration steps in progress.

Prepare for configuration steps successful.

..................................................   83% Done.

Oracle Client Configuration in progress.

..................................................   100% Done.

Oracle Client Configuration successful.

Successfully Setup Software.

How to search AD group from windows 10?

 How to search AD group from windows 10:

try this on Run command:

windows 7:  C:\Windows\System32\rundll32.exe  dsquery.dll,OpenQueryWindow

Windows 10 :  rundll32 dsquery.dll,OpenQueryWindow

what is the query to list tablespace in PostgreSQL?

 

query to list tablespace in PostgreSQL:

SELECT spcname FROM pg_tablespace;

\db+

                                            List of tablespaces

    Name    |   Owner    |             Location              | Access privileges | Options |  Size  | Description

------------+------------+-----------------------------------+-------------------+---------+--------+-------------

 DB_data  | DB_admin | /opt/pgsql12/tablespace/DBdata |                   |         | 59 GB  |

 pg_default | postgres   |                                   |                   |         | 35 MB  |

 pg_global  | postgres   |                                   |                   |         | 399 kB |

PostgreSQL Database Design and implementation Standard

PostgreSQL Database Design & implementation Standard:

its been a while  that I am working on PostgreSQL and would like to create standard for DB cluster installation.

 Installation:

install the postgres software under the below directory and user postgres:

Postgres Binary tablespace----> /postgres/<App_name>/<postgres/version>

pre-work 

1.we  need to create separate OS user to install & run the PostgrSQL cluster ,e,g postgres OS User.

2.create separate File system for Data,Temp,Postgres Binary and WAL(write Ahead Log),Backup

3.folder sturcture should be like below

Data tablespace----> /postgres/<App_name>/Data/--->used for Data

Temp tablespace---->/postgres/<App_name>/Temp/---->used for sorting, Temp

Postgres Binary tablespace----> /postgres/<App_name>/<postgres/version>

WAL tablespace---->/postgres/<App_name>/WAL/--->To store WAL files

Backup tablespace----> /postgres/<App_name>/Backup/--->to store backup files

3.we can have profile  for Postgres OS user.

we can Have :PG_HOME,PG_DATA,PG_DATABASE,PG_BACKUP,PG_HOSTNAME

4.Port Number ---configure Non-Default port number  5432

Memory configuration 

As per the Industry standard ,Please allocate the Memory for Each Layer in Postgres like below

shared_buffers - Non Prod==>20-30% of total, Non Prod==>RAM 20% of total RAM---->Key Memory component for PostgreSQL cluster

temp_buffers - Non Prod==>10-15% of total RAM,Non Prod==> 10% of total RAM----> Memory component for Temp Buffer

work_mem - Non Prod==>5-10% of total RAM ,5% of total RAM-

maintenance_work_mem - 10-15% of total RAM  10% of total RAM-

DB creation

1.create separate tablespace for each DB and park the DB data on that tablespace,it will be easy to recover during server crash.

2.Add the DB parameter accoridng to  below for Prod & Non Prod systems

max_connections - For Dev systems, 100-200. For Production, 500-1000 (Depending on application requirements)

Authentication/Security

Do not leave the defult setting and change all connection thru encrypted and password session on hba file

pg_hba.conf entries (Allow specific IP)

host     all             all            172.17.0.0/32           md5

Monitoring Tools:

I believe Community version needs to buy separate license for the below PostgreSQL monitoring tools,But Enterprise DB license must include PEM monitoring license.

PEM(Postgres Enterprise Manager) just we need to install the agent on the DB server and GUI based tool to monitor Postgres service.

ZABBIX

NAGIOS

PEM

Backup Policy:

Prod we can enable the WAL  to have get the Point in time recovery ,for Non Prod ,No need  to enable the WAL

backup types :

we use the pg_dump backup utility for Community version and Enterprise DB we can use BART tools.

we can schedule the backup backup jobs under cron

1.pg_dump

2.BART tool(EDB)

Maintenance Jobs needed:

1.Vacuum job 

2.Backup Job

3.stats gathering

How to recreate undo tablespace in oracle SAP database using BRtools?

 SQL> select tablespace_name, status, count(*) from dba_rollback_segs group by tablespace_name, status;

TABLESPACE_NAME                STATUS             COUNT(*)

------------------------------ ---------------- ----------

PSAPUNDO                       OFFLINE                 321

SYSTEM                         ONLINE                    1

PSAPUNDO2                      ONLINE                  321

SYSTEM                         OFFLINE                   1

 

alter system set undo_tablespace = PSAPUNDO scope=spfile;

SQL> select tablespace_name, status, count(*) from dba_rollback_segs group by tablespace_name, status;

TABLESPACE_NAME                STATUS             COUNT(*)

------------------------------ ---------------- ----------

PSAPUNDO2                      OFFLINE                 321

SYSTEM                         ONLINE                    1

PSAPUNDO                       ONLINE                  321

SYSTEM                         OFFLINE                   1

 

Drop tablespace PSAPUNDO2 including contents and datafiles;

SQL> select file_name from dba_data_files where tablespace_name='PSAPUNDO2';

FILE_NAME

--------------------------------------------------------------------------------

/oracle/ORA_DB/sapdata888/undo_11/undo.data12

 

SQL> Drop tablespace PSAPUNDO2 including contents and datafiles;

 

Tablespace dropped.

 

SQL> !ls -ltr /oracle/ORA_DB/sapdata888/undo_11/undo.data12

/oracle/ORA_DB/sapdata888/undo_11/undo.data12 not found

 

Linux_server>:oraORA_DB 37> brtools

BR0651I BRTOOLS 7.20 (42)

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.02

BR0656I Choice menu 1 - please make a selection

-------------------------------------------------------------------------------

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

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.04

BR0663I Your choice: '2'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.04

BR0656I Choice menu 5 - please make a selection

-------------------------------------------------------------------------------

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:

4

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.10

BR0663I Your choice: '4'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.10

BR0657I Input menu 84 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for alter tablespace

 

1 - BRSPACE profile (profile) ........ [initORA_DB.sap]

2 - Database user/password (user) .... [/]

3 ~ Alter tablespace action (action) . []

4 ~ Tablespace names (tablespace) .... []

5 - Confirmation mode (confirm) ...... [yes]

6 - Scrolling line count (scroll) .... [20]

7 - Message language (language) ...... [E]

8 - BRSPACE command line (command) ... [-p initORA_DB.sap -s 20 -l E -f tsalter]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

4

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.19

BR0663I Your choice: '4'

BR0681I Enter string value for "tablespace" []:

PSAPUNDO

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.25

BR0683I New value for "tablespace": 'PSAPUNDO'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.25

BR0657I Input menu 84 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for alter tablespace

 

1 - BRSPACE profile (profile) ........ [initORA_DB.sap]

2 - Database user/password (user) .... [/]

3 ~ Alter tablespace action (action) . []

4 ~ Tablespace names (tablespace) .... [PSAPUNDO]

5 - Confirmation mode (confirm) ...... [yes]

6 - Scrolling line count (scroll) .... [20]

7 - Message language (language) ...... [E]

8 - BRSPACE command line (command) ... [-p initORA_DB.sap -s 20 -l E -f tsalter -t PSAPUNDO]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.41

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0291I BRSPACE will be started with options '-p initORA_DB.sap -s 20 -l E -f tsalter -t PSAPUNDO'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.41

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2021-07-30 10.39.44

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

###############################################################################

 

BR1001I BRSPACE 7.20 (42)

BR1002I Start of BRSPACE processing: sfgzuylt.tsa 2021-07-30 10.39.45

BR0484I BRSPACE log file: /oracle/ORA_DB/sapreorg/sfgzuylt.tsa

 

BR0280I BRSPACE time stamp: 2021-07-30 10.39.54

BR1009I Name of database instance: ORA_DB

BR1010I BRSPACE action ID: sfgzuylt

BR1011I BRSPACE function ID: tsa

BR1012I BRSPACE function: tsalter

 

BR0280I BRSPACE time stamp: 2021-07-30 10.39.54

BR0656I Choice menu 311 - please make a selection

-------------------------------------------------------------------------------

Alter tablespace main menu

 

1 - Set tablespace online

2 - Set tablespace offline

3 - Set backup status

4 - Reset backup status

5 - Coalesce free extents

6 - Rename tablespace

7 - Show tablespaces

8 - Show data files

9 * Exit program

10 - Reset program status

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

s

BR0280I BRSPACE time stamp: 2021-07-30 10.40.12

BR0663I Your choice: 's'

BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.40.15

BR0257I Your reply: 'y'

BR0260E BRSPACE cancelled by user

 

BR1008I End of BRSPACE processing: sfgzuylt.tsa 2021-07-30 10.40.15

BR0280I BRSPACE time stamp: 2021-07-30 10.40.15

BR1007I BRSPACE terminated with errors

 

###############################################################################

 

BR0292I Execution of BRSPACE finished with return code 2

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.15

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

s

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.17

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

y

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.19

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.19

BR0654I BRTOOLS terminated with errors

Linux_server>:oraORA_DB 38> brtools

BR0651I BRTOOLS 7.20 (42)

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.22

BR0656I Choice menu 1 - please make a selection

-------------------------------------------------------------------------------

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

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.33

BR0663I Your choice: '2'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.33

BR0656I Choice menu 5 - please make a selection

-------------------------------------------------------------------------------

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

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.37

BR0663I Your choice: '1'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.37

BR0657I Input menu 81 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for tablespace extension

 

1 - BRSPACE profile (profile) ...... [initORA_DB.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... []

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initORA_DB.sap -s 20 -l E -f tsextend]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

3

BR0280I BRTOOLS time stamp: 2021-07-30 10.40.55

BR0663I Your choice: '3'

BR0681I Enter string value for "tablespace" []:

PSAPUNDO

BR0280I BRTOOLS time stamp: 2021-07-30 10.41.00

BR0683I New value for "tablespace": 'PSAPUNDO'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.41.00

BR0657I Input menu 81 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for tablespace extension

 

1 - BRSPACE profile (profile) ...... [initORA_DB.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPUNDO]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initORA_DB.sap -s 20 -l E -f tsextend -t PSAPUNDO]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2021-07-30 10.41.21

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0291I BRSPACE will be started with options '-p initORA_DB.sap -s 20 -l E -f tsextend -t PSAPUNDO'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.41.21

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2021-07-30 10.41.23

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

###############################################################################

 

BR1001I BRSPACE 7.20 (42)

BR1002I Start of BRSPACE processing: sfgzuypo.tse 2021-07-30 10.41.24

BR0484I BRSPACE log file: /oracle/ORA_DB/sapreorg/sfgzuypo.tse

 

BR0280I BRSPACE time stamp: 2021-07-30 10.41.27

BR1009I Name of database instance: ORA_DB

BR1010I BRSPACE action ID: sfgzuypo

BR1011I BRSPACE function ID: tse

BR1012I BRSPACE function: tsextend

 

BR0280I BRSPACE time stamp: 2021-07-30 10.41.53

BR0657I Input menu 303 - please enter/check input values

-------------------------------------------------------------------------------

Options for extension of tablespace PSAPUNDO (1. file)

 

1 * Last added file name (lastfile) ....... [/oracle/ORA_DB/sapdata888/undo_3/undo.data3]

2 * Last added file size in MB (lastsize) . [11000]

3 - New file to be added (file) ........... [/oracle/ORA_DB/sapdata888/undo_4/undo.data4]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [11000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... []

8 # File increment size in MB (incrsize) .. []

9 - SQL command (command) ................. [alter tablespace PSAPUNDO add datafile '/oracle/ORA_DB/sapdata888/undo_4/undo.data4' size 11000M autoextend off]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.42.04

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR1091I Next data file can be specified now

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.04

BR0675I This is a optional action - do you want to execute it now?

BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.42.08

BR0257I Your reply: 'y'

BR0677I The action will be executed...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.08

BR0657I Input menu 303 - please enter/check input values

-------------------------------------------------------------------------------

Options for extension of tablespace PSAPUNDO (2. file)

 

1 * Last added file name (lastfile) ....... [/oracle/ORA_DB/sapdata888/undo_3/undo.data3]

2 * Last added file size in MB (lastsize) . [11000]

3 - New file to be added (file) ........... [/oracle/ORA_DB/sapdata888/undo_5/undo.data5]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [11000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... []

8 # File increment size in MB (incrsize) .. []

9 - SQL command (command) ................. [alter tablespace PSAPUNDO add datafile '/oracle/ORA_DB/sapdata888/undo_4/undo.data4' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_5/undo.data5' size 11000M autoextend off]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.42.12

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR1091I Next data file can be specified now

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.12

BR0675I This is a optional action - do you want to execute it now?

BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.42.15

BR0257I Your reply: 'y'

BR0677I The action will be executed...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.15

BR0657I Input menu 303 - please enter/check input values

-------------------------------------------------------------------------------

Options for extension of tablespace PSAPUNDO (3. file)

 

1 * Last added file name (lastfile) ....... [/oracle/ORA_DB/sapdata888/undo_3/undo.data3]

2 * Last added file size in MB (lastsize) . [11000]

3 - New file to be added (file) ........... [/oracle/ORA_DB/sapdata888/undo_6/undo.data6]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [11000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... []

8 # File increment size in MB (incrsize) .. []

9 - SQL command (command) ................. [alter tablespace PSAPUNDO add datafile '/oracle/ORA_DB/sapdata888/undo_4/undo.data4' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_5/undo.data5' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_6/undo.data6' size 11000M autoextend off]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.42.25

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR1091I Next data file can be specified now

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.25

BR0675I This is a optional action - do you want to execute it now?

BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.42.28

BR0257I Your reply: 'y'

BR0677I The action will be executed...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.28

BR0657I Input menu 303 - please enter/check input values

-------------------------------------------------------------------------------

Options for extension of tablespace PSAPUNDO (4. file)

 

1 * Last added file name (lastfile) ....... [/oracle/ORA_DB/sapdata888/undo_3/undo.data3]

2 * Last added file size in MB (lastsize) . [11000]

3 - New file to be added (file) ........... [/oracle/ORA_DB/sapdata888/undo_7/undo.data7]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [11000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... []

8 # File increment size in MB (incrsize) .. []

9 - SQL command (command) ................. [alter tablespace PSAPUNDO add datafile '/oracle/ORA_DB/sapdata888/undo_4/undo.data4' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_5/undo.data5' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_6/undo.data6' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_7/undo.data7' size 11000M autoextend off]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.42.32

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR1091I Next data file can be specified now

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.32

BR0675I This is a optional action - do you want to execute it now?

BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.42.34

BR0257I Your reply: 'y'

BR0677I The action will be executed...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.34

BR0657I Input menu 303 - please enter/check input values

-------------------------------------------------------------------------------

Options for extension of tablespace PSAPUNDO (5. file)

 

1 * Last added file name (lastfile) ....... [/oracle/ORA_DB/sapdata888/undo_3/undo.data3]

2 * Last added file size in MB (lastsize) . [11000]

3 - New file to be added (file) ........... [/oracle/ORA_DB/sapdata888/undo_8/undo.data8]

4 ~ Raw disk / link target (rawlink) ...... []

5 - Size of the new file in MB (size) ..... [11000]

6 - File autoextend mode (autoextend) ..... [no]

7 # Maximum file size in MB (maxsize) ..... []

8 # File increment size in MB (incrsize) .. []

9 - SQL command (command) ................. [alter tablespace PSAPUNDO add datafile '/oracle/ORA_DB/sapdata888/undo_4/undo.data4' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_5/undo.data5' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_6/undo.data6' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_7/undo.data7' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_8/undo.data8' size 11000M autoextend off]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.42.42

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0370I Directory /oracle/ORA_DB/sapreorg/sfgzuypo created

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.48

BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuypo/cntrlORA_DB.old 133906432

 

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_4 created

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_5 created

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_6 created

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_7 created

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_8 created

 

BR0280I BRSPACE time stamp: 2021-07-30 10.42.48

BR1088I Extending tablespace PSAPUNDO ...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.49.25

BR1016I SQL statement 'alter tablespace PSAPUNDO add datafile '/oracle/ORA_DB/sapdata888/undo_4/undo.data4' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_5/undo.data5' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_6/undo.data6' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_7/undo.data7' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_8/undo.data8' size 11000M autoextend off' executed successfully

 

BR1051I Tablespace PSAPUNDO extended successfully with files:

/oracle/ORA_DB/sapdata888/undo_4/undo.data4 11000M,

/oracle/ORA_DB/sapdata888/undo_5/undo.data5 11000M,

/oracle/ORA_DB/sapdata888/undo_6/undo.data6 11000M,

/oracle/ORA_DB/sapdata888/undo_7/undo.data7 11000M,

/oracle/ORA_DB/sapdata888/undo_8/undo.data8 11000M

 

BR0280I BRSPACE time stamp: 2021-07-30 10.49.26

BR0340I Switching to the next online redolog file for database instance ORA_DB ...

BR0321I Switch to the next online redolog file for database instance ORA_DB successful

 

BR0280I BRSPACE time stamp: 2021-07-30 10.49.32

BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuypo/cntrlORA_DB.new 133906432

 

BR0280I BRSPACE time stamp: 2021-07-30 10.49.32

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

s

BR0280I BRSPACE time stamp: 2021-07-30 10.50.21

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.50.24

BR0257I Your reply: 'y'

BR0260E BRSPACE cancelled by user

 

BR1008I End of BRSPACE processing: sfgzuypo.tse 2021-07-30 10.50.24

BR0280I BRSPACE time stamp: 2021-07-30 10.50.24

BR1007I BRSPACE terminated with errors

 

###############################################################################

 

BR0292I Execution of BRSPACE finished with return code 4

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.50.24

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

s

BR0280I BRTOOLS time stamp: 2021-07-30 10.50.26

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

y

BR0280I BRTOOLS time stamp: 2021-07-30 10.50.28

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.50.28

BR0654I BRTOOLS terminated with errors

How to create new UNDO tablespace in oracle SAP database using brtools?

 Linux_server>:oraORA_DB 27>brtools

-------------------------------------------------------------------------------

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

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.19

BR0663I Your choice: '2'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.19

BR0656I Choice menu 5 - please make a selection

-------------------------------------------------------------------------------

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:

2

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.21

BR0663I Your choice: '2'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.21

BR0657I Input menu 82 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for create tablespace

 

1 - BRSPACE profile (profile) ...... [initORA_DB.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... []

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initORA_DB.sap -s 20 -l E -f tscreate]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

3

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.28

BR0663I Your choice: '3'

BR0681I Enter string value for "tablespace" []:

PSAPUNDO

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.38

BR0683I New value for "tablespace": 'PSAPUNDO'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.38

BR0657I Input menu 82 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for create tablespace

 

1 - BRSPACE profile (profile) ...... [initORA_DB.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPUNDO]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initORA_DB.sap -s 20 -l E -f tscreate -t PSAPUNDO]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.46

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0291I BRSPACE will be started with options '-p initORA_DB.sap -s 20 -l E -f tscreate -t PSAPUNDO'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.46

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2021-07-30 10.19.50

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

###############################################################################

 

BR1001I BRSPACE 7.20 (42)

BR1002I Start of BRSPACE processing: sfgzuwru.tsc 2021-07-30 10.19.50

BR0484I BRSPACE log file: /oracle/ORA_DB/sapreorg/sfgzuwru.tsc

 

BR0280I BRSPACE time stamp: 2021-07-30 10.19.56

BR1009I Name of database instance: ORA_DB

BR1010I BRSPACE action ID: sfgzuwru

BR1011I BRSPACE function ID: tsc

BR1012I BRSPACE function: tscreate

 

BR0280I BRSPACE time stamp: 2021-07-30 10.20.02

BR0657I Input menu 305 - please enter/check input values

-------------------------------------------------------------------------------

Main options for creation of tablespace in database ORA_DB

 

1 - Tablespace name (tablespace) ......... [PSAPUNDO]

2 - Tablespace contents (contents) ....... [data]

3 - Segment space management (space) ..... [auto]

4 ? Database owner of tablespace (owner) . []

5 ~ Table data class / tabart (class) .... []

6 - Data type in tablespace (data) ....... [both]

7 # Joined index/table tablespace (join) . []

8 ~ Uniform size in MB (uniform) ......... []

9 - Bigfile tablespace (bigfile) ......... [no]

10 - Tablespace compression (compress) .... [no]

11 - Tablespace encryption (encryption) ... [no]

12 # Encryption algorithm (algorithm) ..... []

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

2

BR0280I BRSPACE time stamp: 2021-07-30 10.20.17

BR0663I Your choice: '2'

BR0681I Enter string value for "contents" (data|temp|undo) [data]:

undo

BR0280I BRSPACE time stamp: 2021-07-30 10.20.36

BR0683I New value for "contents": 'undo'

 

BR0280I BRSPACE time stamp: 2021-07-30 10.20.36

BR0657I Input menu 305 - please enter/check input values

-------------------------------------------------------------------------------

Main options for creation of tablespace in database ORA_DB

 

1 - Tablespace name (tablespace) ......... [PSAPUNDO]

2 - Tablespace contents (contents) ....... [undo]

3 # Segment space management (space) ..... [auto]

4 # Database owner of tablespace (owner) . []

5 # Table data class / tabart (class) .... []

6 # Data type in tablespace (data) ....... [both]

7 # Joined index/table tablespace (join) . []

8 # Uniform size in MB (uniform) ......... []

9 - Bigfile tablespace (bigfile) ......... [no]

10 # Tablespace compression (compress) .... [no]

11 # Tablespace encryption (encryption) ... [no]

12 # Encryption algorithm (algorithm) ..... []

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.20.54

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.20.54

BR0657I Input menu 306 - please enter/check input values

-------------------------------------------------------------------------------

Space options for creation of tablespace PSAPUNDO (1. file)

 

1 - Tablespace file name (file) .......... [/oracle/ORA_DB/sapdata888/undo_1/undo.data1]

2 ~ Raw disk / link target (rawlink) ..... []

3 - File size in MB (size) ............... [11000]

4 # File autoextend mode (autoextend) .... [no]

5 # Maximum file size in MB (maxsize) .... []

6 # File increment size in MB (incrsize) . []

7 - SQL command (command) ................ [create undo tablespace PSAPUNDO datafile '/oracle/ORA_DB/sapdata888/undo_1/undo.data1' size 11000M autoextend off]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.22.58

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR1091I Next data file can be specified now

 

BR0280I BRSPACE time stamp: 2021-07-30 10.22.58

BR0675I This is a optional action - do you want to execute it now?

BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.23.04

BR0257I Your reply: 'y'

BR0677I The action will be executed...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.23.04

BR0657I Input menu 306 - please enter/check input values

-------------------------------------------------------------------------------

Space options for creation of tablespace PSAPUNDO (2. file)

 

1 - Tablespace file name (file) .......... [/oracle/ORA_DB/sapdata888/undo_2/undo.data2]

2 ~ Raw disk / link target (rawlink) ..... []

3 - File size in MB (size) ............... [11000]

4 # File autoextend mode (autoextend) .... [no]

5 # Maximum file size in MB (maxsize) .... []

6 # File increment size in MB (incrsize) . []

7 - SQL command (command) ................ [create undo tablespace PSAPUNDO datafile '/oracle/ORA_DB/sapdata888/undo_1/undo.data1' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_2/undo.data2' size 11000M autoextend off]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.23.27

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR1091I Next data file can be specified now

 

BR0280I BRSPACE time stamp: 2021-07-30 10.23.27

BR0675I This is a optional action - do you want to execute it now?

BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.23.31

BR0257I Your reply: 'y'

BR0677I The action will be executed...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.23.31

BR0657I Input menu 306 - please enter/check input values

-------------------------------------------------------------------------------

Space options for creation of tablespace PSAPUNDO (3. file)

 

1 - Tablespace file name (file) .......... [/oracle/ORA_DB/sapdata888/undo_3/undo.data3]

2 ~ Raw disk / link target (rawlink) ..... []

3 - File size in MB (size) ............... [11000]

4 # File autoextend mode (autoextend) .... [no]

5 # Maximum file size in MB (maxsize) .... []

6 # File increment size in MB (incrsize) . []

7 - SQL command (command) ................ [create undo tablespace PSAPUNDO datafile '/oracle/ORA_DB/sapdata888/undo_1/undo.data1' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_2/undo.data2' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_3/undo.data3' size 11000M autoextend off]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

n

BR0280I BRSPACE time stamp: 2021-07-30 10.24.07

BR0664W Invalid choice: 'n'

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.24.46

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR1091I Next data file can be specified now

 

BR0280I BRSPACE time stamp: 2021-07-30 10.24.46

BR0675I This is a optional action - do you want to execute it now?

BR0676I Enter 'y[es]' to execute the action, 'n[o]/c[ont]' to skip it, 's[top]' to abort:

n

BR0280I BRSPACE time stamp: 2021-07-30 10.24.50

BR0257I Your reply: 'n'

BR0678I The action will be skipped...

 

BR0370I Directory /oracle/ORA_DB/sapreorg/sfgzuwru created

 

BR0280I BRSPACE time stamp: 2021-07-30 10.24.54

BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuwru/cntrlORA_DB.old 133906432

 

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_1 created

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_2 created

BR0370I Directory /oracle/ORA_DB/sapdata888/undo_3 created

 

BR0280I BRSPACE time stamp: 2021-07-30 10.24.54

BR1089I Creating tablespace PSAPUNDO ...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.28.07

BR1016I SQL statement 'create undo tablespace PSAPUNDO datafile '/oracle/ORA_DB/sapdata888/undo_1/undo.data1' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_2/undo.data2' size 11000M autoextend off, '/oracle/ORA_DB/sapdata888/undo_3/undo.data3' size 11000M autoextend off' executed successfully

 

BR1060I Tablespace PSAPUNDO created successfully with files:

/oracle/ORA_DB/sapdata888/undo_1/undo.data1 11000M,

/oracle/ORA_DB/sapdata888/undo_2/undo.data2 11000M,

/oracle/ORA_DB/sapdata888/undo_3/undo.data3 11000M

 

BR0280I BRSPACE time stamp: 2021-07-30 10.28.07

BR0340I Switching to the next online redolog file for database instance ORA_DB ...

BR0321I Switch to the next online redolog file for database instance ORA_DB successful

 

BR0280I BRSPACE time stamp: 2021-07-30 10.28.12

BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuwru/cntrlORA_DB.new 133906432

 

BR0280I BRSPACE time stamp: 2021-07-30 10.28.12

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

s

BR0280I BRSPACE time stamp: 2021-07-30 10.28.26

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRSPACE? Enter y[es]/n[o]:

y

BR0280I BRSPACE time stamp: 2021-07-30 10.28.32

BR0257I Your reply: 'y'

BR0260E BRSPACE cancelled by user

 

BR1008I End of BRSPACE processing: sfgzuwru.tsc 2021-07-30 10.28.32

BR0280I BRSPACE time stamp: 2021-07-30 10.28.32

BR1007I BRSPACE terminated with errors

 

###############################################################################

 

BR0292I Execution of BRSPACE finished with return code 4

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.28.32

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

s

BR0280I BRTOOLS time stamp: 2021-07-30 10.28.35

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

y

BR0280I BRTOOLS time stamp: 2021-07-30 10.28.38

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.28.38

BR0654I BRTOOLS terminated with errors

Linux_server>:oraORA_DB 30>

How to DROP undo tablespace in oracle SAP database using brtools?

 

SQL> select tablespace_name, status, count(*) from dba_rollback_segs group by tablespace_name, status;

 

TABLESPACE_NAME                STATUS             COUNT(*)

------------------------------ ---------------- ----------

PSAPUNDO                       OFFLINE                 406

SYSTEM                         ONLINE                    1

PSAPUNDO2                      ONLINE                  321

SYSTEM                         OFFLINE                   1

 

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

Linux_server>:oraORA_DB 25> ps -ef |grep tns

  oraORA_DB 14773 11460  1 10:02:36 pts/1     0:00 grep tns

Linux_server>:oraORA_DB 26> brtools

BR0651I BRTOOLS 7.20 (42)

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.00

BR0656I Choice menu 1 - please make a selection

-------------------------------------------------------------------------------

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

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.14

BR0663I Your choice: '2'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.14

BR0656I Choice menu 5 - please make a selection

-------------------------------------------------------------------------------

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:

3

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.27

BR0663I Your choice: '3'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.27

BR0657I Input menu 83 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for drop tablespace

 

1 - BRSPACE profile (profile) ...... [initORA_DB.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... []

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initORA_DB.sap -s 20 -l E -f tsdrop]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

PSAPUNDO

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.49

BR0664W Invalid choice: 'PSAPUNDO'

BR0662I Enter your choice:

3

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.56

BR0663I Your choice: '3'

BR0681I Enter string value for "tablespace" []:

PSAPUNDO

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.59

BR0683I New value for "tablespace": 'PSAPUNDO'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.03.59

BR0657I Input menu 83 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for drop tablespace

 

1 - BRSPACE profile (profile) ...... [initORA_DB.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPUNDO]

4 - Confirmation mode (confirm) .... [yes]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initORA_DB.sap -s 20 -l E -f tsdrop -t PSAPUNDO]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

4

BR0280I BRTOOLS time stamp: 2021-07-30 10.04.30

BR0663I Your choice: '4'

BR0681I Enter string value for "confirm" (yes|no|force) [yes]:

no

BR0280I BRTOOLS time stamp: 2021-07-30 10.05.54

BR0683I New value for "confirm": 'no'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.05.54

BR0657I Input menu 83 - please enter/check input values

-------------------------------------------------------------------------------

BRSPACE options for drop tablespace

 

1 - BRSPACE profile (profile) ...... [initORA_DB.sap]

2 - Database user/password (user) .. [/]

3 ~ Tablespace name (tablespace) ... [PSAPUNDO]

4 - Confirmation mode (confirm) .... [no]

5 - Scrolling line count (scroll) .. [20]

6 - Message language (language) .... [E]

7 - BRSPACE command line (command) . [-p initORA_DB.sap -c -s 20 -l E -f tsdrop -t PSAPUNDO]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2021-07-30 10.05.59

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0291I BRSPACE will be started with options '-p initORA_DB.sap -c -s 20 -l E -f tsdrop -t PSAPUNDO'

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.05.59

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2021-07-30 10.06.02

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

 

###############################################################################

 

BR1001I BRSPACE 7.20 (42)

BR1002I Start of BRSPACE processing: sfgzuvlz.tsd 2021-07-30 10.06.03

BR0484I BRSPACE log file: /oracle/ORA_DB/sapreorg/sfgzuvlz.tsd

 

BR0280I BRSPACE time stamp: 2021-07-30 10.06.13

BR1009I Name of database instance: ORA_DB

BR1010I BRSPACE action ID: sfgzuvlz

BR1011I BRSPACE function ID: tsd

BR1012I BRSPACE function: tsdrop

BR0126I Unattended mode active - no operator confirmation required

 

BR0280I BRSPACE time stamp: 2021-07-30 10.06.51

BR0657I Input menu 310 - please enter/check input values

-------------------------------------------------------------------------------

Options for dropping of tablespace PSAPUNDO

 

1 * Number of files in tablespace (files) . [12]

2 * Total tablespace size in MB (size) .... [266480]

3 - Force tablespace drop (force) ......... [no]

4 - SQL command (command) ................. [drop tablespace PSAPUNDO]

 

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-------------------------------------------------------------------------------

BR0662I Enter your choice:

c

BR0280I BRSPACE time stamp: 2021-07-30 10.07.49

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

 

BR0370I Directory /oracle/ORA_DB/sapreorg/sfgzuvlz created

 

BR0280I BRSPACE time stamp: 2021-07-30 10.07.58

BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuvlz/cntrlORA_DB.old 133906432

 

BR0280I BRSPACE time stamp: 2021-07-30 10.08.11

BR0768I Tablespace PSAPUNDO set OFFLINE

 

BR0280I BRSPACE time stamp: 2021-07-30 10.08.11

BR1090I Dropping tablespace PSAPUNDO ...

 

BR0280I BRSPACE time stamp: 2021-07-30 10.08.28

BR1016I SQL statement 'drop tablespace PSAPUNDO' executed successfully

 

BR1069I Tablespace PSAPUNDO dropped successfully

 

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_1/undo.data1 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_1 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_2/undo.data2 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_2 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_3/undo.data3 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_3 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_4/undo.data4 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_4 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_5/undo.data5 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_5 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_6/undo.data6 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_6 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_7/undo.data7 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_7 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_8/undo.data8 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_8 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_9/undo.data9 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_9 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_10/undo.data10 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_10 deleted

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_11/undo.data11 deleted

BR0252W Function rmdir() failed for '/oracle/ORA_DB/sapdata888/undo_11' at location BrDirDelete-5

BR0253W errno 17: File exists

BR0794I Database file /oracle/ORA_DB/sapdata888/undo_12/undo.data12 deleted

BR0480I Directory /oracle/ORA_DB/sapdata888/undo_12 deleted

 

BR0280I BRSPACE time stamp: 2021-07-30 10.08.28

BR0340I Switching to the next online redolog file for database instance ORA_DB ...

BR0321I Switch to the next online redolog file for database instance ORA_DB successful

 

BR0280I BRSPACE time stamp: 2021-07-30 10.08.36

BR0319I Control file copy created: /oracle/ORA_DB/sapreorg/sfgzuvlz/cntrlORA_DB.new 133906432

 

BR0280I BRSPACE time stamp: 2021-07-30 10.08.36

BR1020I Number of tablespaces processed: 1

BR1003I BRSPACE function 'tsdrop' completed

 

BR1008I End of BRSPACE processing: sfgzuvlz.tsd 2021-07-30 10.08.36

BR0280I BRSPACE time stamp: 2021-07-30 10.08.37

BR1006I BRSPACE completed successfully with warnings

 

###############################################################################

 

BR0292I Execution of BRSPACE finished with return code 1

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.08.37

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

s

BR0280I BRTOOLS time stamp: 2021-07-30 10.08.53

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

y

BR0280I BRTOOLS time stamp: 2021-07-30 10.08.55

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

 

BR0280I BRTOOLS time stamp: 2021-07-30 10.08.55

BR0654I BRTOOLS terminated with errors