Object documentationBRSPACE Structure Change Log

 

The structure change log contains a history of all database structure changes that you perform with BRSPACE. Structure changes consist of the following functions:

  • Recreate database

  • Extend tablespace

  • Create tablespace

  • Drop tablespace

  • Alter tablespace (rename)

  • Alter datafile (rename, drop, change file size attributes)

  • Rename tablespace

  • Move datafile

 

The file helps you to keep track of database structure changes.

Structure

The file is called struc<DBSID>.log and is located in the $SAPDATA_HOME/sapreorg directory.

The first line is standard but the following lines vary according to the function.

  • Standard first line

    Line

    Entry

    Example

    #BRSRUN

    Timestamp (date, time) for when you start BRSPACE for the structure change

    2011-08-01 14.47.18

    BRSPACE action id (encoded timespace)

    swhfavte

    BRSPACE function ID

    tse

    Function name

    tsextend

    Effective and real user name

    user=oragc2/oragc2

    Note Note

    The combination of action id and function id – in the above example, sehfavte.tse – represents the name of the BRSPACE detail log.

    End of the note.

  • Extend tablespace

    Line

    Entry

    Example

    #TSPEXT

    Timestamp (date, time) for when the structure change finished

    2011-08-01 14.47.27

    Tablespace name

    PSAP2222

    #FILEADD

    New datafile name

    /oracle/GC2/sapdata4/2222_6/2222.data6

    Parameters for new datafile

    size=1M autoext=yes maxsize=10M incrsize=1M

  • Create tablespace

    Line

    Entry

    Example

    #TSPCRT

    Timestamp (date, time) for when the structure change finished

    2011-08-01 14.50.35

    Tablespace name

    PSAP3333D

    Parameters for new tablespace

    conts=data assm=auto data=table

    #FILEADD

    New datafile name

    /oracle/GC2/sapdata4/3333d/3333d.data1

    Parameters for new datafile

    size=1M autoext=yes maxsize=10M incrsize=1M

  • Drop tablespace

    #TSPDROP

    Timestamp (date, time) for when the structure change finished

    2011-08-01 14.52.41

    Tablespace name

    PSAP4444I

    Attributes of deleted tablespace

    files=2 size=2M

    #FILEDEL

    Deleted datafile name

    /oracle/GC2/sapdata4/4444i_1/4444i.data1

    Datafile parameters

    size=1M

  • Rename tablespace

    #TSPREN

    Timestamp (date, time) for when the structure change finished

    2011-08-01 14.52.41

    Old tablespace name

    PSAP4444I

    New tablespace name

    newname=PSAP5555I

  • Alter datafile

    • Switch on autoextend

      #FILEAUTO

      Datafile name

      /oracle/GC2/sapdata4/2222_1/2222.data1

      Datafile parameters

      size=1M autoext=yes maxsize=22M incrsize=2M

    • Switch off autoextend

      #FILEFIX

      Datafile name

      /oracle/GC2/sapdata1/testd_5/ttttd.data5

      Parameters to specify the affected datafile

      size=2M autoext=no

    • Resize datafile

      #FILESIZE

      Datafile name

      /oracle/GC2/sapdata6/testd_1/testd.data1

      Parameters for new and old size of datafile

      size=8M oldsize=4M

  • Move datafile

    #TSP

    Timestamp (date, time) for the move

    2011-08-01 17.55.14

    Tablespace

    PSAP1111D

    #FILEMOVE

    New datafile name

    /oracle/GC2/sapdata5/1111d_2/1111d.data2

    Old datafile name

    oldfile=/oracle/GC2/sapdata2/1111d_3/1111d.data3

    Datafile size

    size=3M