Extented Tablespace thru BRTOOLS

[Former Member]

Dear Experts,

When i am trying to add datafile i am getting the below error now i am unable to use BRtools even to show the tablespaces also. please find the below log and suggest me on how to resolve the issue..

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

-

---

BR0662I Enter your choice:

3

BR0280I BRTOOLS time stamp: 2008-09-22 18.56.09

BR0663I Your choice: '3'

BR0280I BRTOOLS time stamp: 2008-09-22 18.56.09

BR0681I Enter string value for "tablespace" []:

psapsr3

BR0280I BRTOOLS time stamp: 2008-09-22 18.56.20

BR0683I New value for "tablespace": 'psapsr3'

BR0280I BRTOOLS time stamp: 2008-09-22 18.56.20

BR0657I Input menu 81 - please check/enter input values

-

---

BRSPACE options for tablespace extension

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

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

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

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

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

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

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

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

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2008-09-22 18.56.27

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

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

BR0280I BRTOOLS time stamp: 2008-09-22 18.56.27

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

c

BR0280I BRTOOLS time stamp: 2008-09-22 18.56.41

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR1001I BRSPACE 7.00 (11)

BR1002I Start of BRSPACE processing: sdywhtlp.tse 2008-09-22 18.56.41

BR0280I BRSPACE time stamp: 2008-09-22 18.56.42

BR1009I Name of database instance: SRD

BR1010I BRSPACE action ID: sdywhtlp

BR1011I BRSPACE function ID: tse

BR1012I BRSPACE function: tsextend

BR0382E File/directory name '/oracle/SRD/sapdata2/sr3_41/sr3.data41 ' contains white spaces / caret characters - file cannot be processed

BR0273E Determination of file status for /oracle/SRD/sapdata2/sr3_41/sr3.data41 failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2008-09-22 18.56.42

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

Regards,

Laxman

[Former Member]

Hi ,

I know it´s old post , but it will be helpful for others , i have faced same issue able to solve by following below steps .

Reference Note :

868750 - How to relocate/rename a datafile

1. generate trace file using    ( ALTER DATABASE BACKUP CONTROLFILE TO TRACE; )

2. move table to offline ( example SQL> ALTER TABLESPACE PSAPSR3 OFFLINE;)

3. move  corrupted file to new file name

cd /oracle/<SID>/sapdata3/sr3_6

mv sr3_data6* sr3_data6

4. open trace file which is generated in point 1. and adjust the trace file

  --> remove all file containing  with set#2 rest logs , just keep only entries for no reset logs

--> remove space or hidden character in   '/oracle/<SID>/sapdata3/sr3_6/sr3.data6 ', in trace file

5. save file to control.sql

6.shutdown database

7. execute @control.sql

8. bring the tablespace online (SQL> ALTER TABLESPACE PSAPSR3 ONLINE;)

All the best.

Thank you.

Mani Bushan

[Former Member]

Hello,

Looks like your path does not contain any white spaces or ^. I suggest to check file permissions and dba permissions for the user.

Hope this helps.

Regards,

Manoj

[Former Member]

HI,

Have a look at note 898787 - BRBACKUP error message BR0382E

It looks like you have to update your brbackup tools since old versions of brbackup cannot handle white spaces in the directory name. Hope this helps.

[Former Member]

Solution

BRBACKUP 6.40 patch 28 and BRBACKUP 7.00 patch 9 or higher are able to backup directories containing blanks in their names.

BRBACKUP do not support white spaces or caret characters in names of regular files.

NOTE: It is not possible to backup files or directories with blanks in the name using BACKINT (backup_dev_type = util_file|util_file_online).

The BACKINT interface does not support files/directories with blanks in the name.

++++++++++++++++++++++++++

In the case above described, is not possible solve the issue with BRTOOLS?

We must rename datafile with database commands? It's possible do it with SAP running?

[Former Member]

Pedro,

I think you will have to rename your datafile as described in SAP note 868750.

And just curious: How did you manage to create a datafile with a name like this?

Manoj,

I disagree. Just read the error message. There is white space at the end of the file name. It is not '/oracle/PML/sapdata3/sr3_36/sr3.data36', but '/oracle/PML/sapdata3/sr3_36/sr3.data36 '.

regards

[Former Member]

Thanks Joe.

The problem was solved.

in fact, this procedure is explained at detail in Oracle Database Administration Guide.

Regards.

[Former Member]

Hi pedro,

We are facing exactly same issue as part of our upgrade and we are finding difficult to search for the solution.

Can you please tell us how you fixed the problem . It would be of Great help.

Kindly reply

Thanks

GP

[Former Member]

Check the solution.

SQL> DROP TABLESPACE PSAPPRD701 INCLUDING CONTENTS AND DATAFILES;

Tablespace dropped.

It worked perfectly fine for me.

Thanks

GV

[Former Member]

Hello Laxman,

OSS note 898787 may be helpful for you. Please check it,

Regards.

Ruchit.

[Former Member]

The note describe the error, but is related to BRBACKUP, not BRSPACE.

How can be fix the name of datafile to able BRTOOLS add datafiles again?

Regards.

[Former Member]

The problem is the blank character at the end of the new data file:

'/oracle/SRD/sapdata2/sr3_41/sr3.data41 '

I don't know how this blank came in there, just guessing: Maybe someone previously added a datafile with a blank like this?

But anyway, you might try this workaround, using brspace instead of brtools :

brspace -f tsextend

c (continue)

(choose number of tablespace)

3 (new file to be added)

(enter full path of datafile, leave out the blank)

c (continue)

hope this helps

[Former Member]

Does not work the workaround.

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

mxlmnerpdb:orapml 3> brspace -f tsextend

BR1001I BRSPACE 7.00 (31)

BR1002I Start of BRSPACE processing: sdzfuczv.tse 2008-11-11 10.15.51

BR0484I BRSPACE log file: /oracle/PML/sapreorg/sdzfuczv.tse

BR0280I BRSPACE time stamp: 2008-11-11 10.15.51

BR1009I Name of database instance: PML

BR1010I BRSPACE action ID: sdzfuczv

BR1011I BRSPACE function ID: tse

BR1012I BRSPACE function: tsextend

BR0280I BRSPACE time stamp: 2008-11-11 10.15.51

BR0656I Choice menu 301 - please make a selection

-

---

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:

c

BR0280I BRSPACE time stamp: 2008-11-11 10.16.02

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0382E File/directory name '/oracle/PML/sapdata3/sr3_36/sr3.data36 ' contains white spaces / caret characters - file cannot be processed

BR0273E Determination of file status for /oracle/PML/sapdata3/sr3_36/sr3.data36 failed

BR0669I Cannot continue due to previous warnings or errors - you can go back to repeat the last action

BR0280I BRSPACE time stamp: 2008-11-11 10.16.02

BR0671I Enter 'b[ack]' to go back, 's[top]' to abort:

[Former Member]

Maybe I misunderstood your error message; so for clarification:

Does file '/oracle/PML/sapdata3/sr3_36/sr3.data36 ' already exist?

Or would it be the next file to be created?

[Former Member]

yes, already exists.