cancel
Showing results for 
Search instead for 
Did you mean: 

Extending Tablespaces while SAP Instance is running

former_member215439
Participant
0 Kudos

Hi Experts,

     I would like to inquire if it is safe to extend tablespaces using Oracle BRTOOLS while SAP Instance is running?

     One of our tablespace going to reach its limit soon (98.84%) and I can't afford to shutdown the SAP Instance.

      

     OS: WS2012R2 Std

     DB: Oracle 12c

     System: SAP ECC 6.0

     Brtools version: 7.20

   

Best Regards,

Jehizon

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi James,

Unless you have basic problems with your storage, which is a different issue altogether, it is perfectly safe to extend tablespaces online.Even in the old days, with less efficient storage, I have never known this to cause any performance problem.

Regards,

Mark

0 Kudos

You can even resize tablespaces online, BRTOOLS (brspace) or just the oracle commands like

ALTER DATABASE DATAFILE '<path/datafile>' RESIZE 10000M;

(You have to check filesystem space of course, and you can easily find the path and size information about the datafile through DB02)

Its a good idea however, to use brspace command:

"Since creating a tablespace is a structural change to the database, BRSPACE Creates a control file backup in the directory $SAPDATA_HOME/sapreorg/<encoded timestamp> before and after the procedure."

If you are running an online backup (while extending), I suggest using the BRSPACE way.

Answers (1)

Answers (1)

former_member182967
Active Contributor
0 Kudos

Hi James,

It is safe to extend tablespace by adding more datafiles while SAP is online.

Regards,

Ning

former_member215439
Participant
0 Kudos

Hi Ning,

        Thanks for your answer. Is there any effect to users(eg. lagging or slow in performance) while Im extending the tablespaces?

Thanks,

Jehizon

former_member182967
Active Contributor
0 Kudos

Hi James,

During tablespace extention, maybe there is some performance impact. So you can extent it out of busy hours or just give some initial size then autoextend to maxsize if needed.

Regards,

Ning