Skip to Content

Extending Tablespaces while SAP Instance is running

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jun 02, 2016 at 11:34 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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.

  • Jun 02, 2016 at 02:18 AM

    Hi James,

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

    Regards,

    Ning

    Add comment
    10|10000 characters needed characters exceeded

    • 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