Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    ORACLE SID's and database files

    • Article Type: General
    • Product: Aleph
    • Product Version: 18.01

    Description:
    We want to make sure our backup process is correct.

    Currently we have 2 database SID aleph0 and aleph1 on our production system. aleph0 is for version16 which is no use anymore. aleph1 is version18 for our current use. We think we need backup aleph1 only. By using util o/13/1 to check the database file list we got following:
    The Database aleph1 Contains the Following Files:
    ======================================================

    T NAME SIZE K F
    ---------- -------------------------------------------------- ---------- ---
    DRSYS /exlibris/oradata/aleph1/aleph1_drsys_01.dbf 86016 39
    SYSAUX /exlibris/oradata/aleph1/aleph1_sysaux01.dbf 524288 59
    SYSTEM /exlibris/oradata/aleph1/aleph1_system_01.dbf 368640 1
    TOOLS /exlibris/oradata/aleph1/aleph1_tools_01.dbf 524288 3
    TS0 /exlibris/oradata/aleph1/aleph1_ts0_01.dbf 2096128 4
    TS0 /exlibris/oradata/aleph1/aleph1_ts0_02.dbf 2096128 5
    TS0 /exlibris/oradata/aleph1/aleph1_ts0_03.dbf 2048000 58
    TS1 /exlibris1/oradata/aleph1/aleph1_ts1_01.dbf 2096128 6
    TS1 /exlibris1/oradata/aleph1/aleph1_ts1_02.dbf 2096128 7
    TS1D /exlibris/oradata/aleph1/aleph1_ts1d_01.dbf 2096128 8
    TS1D /exlibris/oradata/aleph1/aleph1_ts1d_02.dbf 4096000 50
    TS1D /exlibris/oradata/aleph1/aleph1_ts1d_03.dbf 4096000 51
    TS1D /exlibris/oradata/aleph1/aleph1_ts1d_04.dbf 4096000 52
    TS1D /exlibris/oradata/aleph1/aleph1_ts1d_05.dbf 4096000 53
    TS1X /exlibris1/oradata/aleph1/aleph1_ts1x_01.dbf 2096128 23
    TS1X /exlibris1/oradata/aleph1/aleph1_ts1x_02.dbf 4096000 54
    TS2D /exlibris/oradata/aleph1/aleph1_ts2d_01.dbf 2096128 9
    TS2D /exlibris/oradata/aleph1/aleph1_ts2d_02.dbf 2096128 10
    TS2X /exlibris/oradata/aleph1/aleph1_ts2x_01.dbf 2096128 24
    TS2X /exlibris/oradata/aleph1/aleph1_ts2x_02.dbf 2096128 25
    TS3D /exlibris/oradata/aleph1/aleph1_ts3d_05.dbf 2048000 2
    TS3D /exlibris/oradata/aleph1/aleph1_ts3d_01.dbf 2096128 11
    TS3D /exlibris/oradata/aleph1/aleph1_ts3d_02.dbf 2096128 12
    TS3D /exlibris/oradata/aleph1/aleph1_ts3d_03.dbf 2096128 13
    TS3D /exlibris/oradata/aleph1/aleph1_ts3d_04.dbf 2096128 14
    TS3D /exlibris1/oradata/aleph1/aleph1_ts3d_06.dbf 2096128 61
    TS3X /exlibris1/oradata/aleph1/aleph1_ts3x_01.dbf 2096128 26
    TS3X /exlibris1/oradata/aleph1/aleph1_ts3x_02.dbf 2096128 27
    TS3X /exlibris1/oradata/aleph1/aleph1_ts3x_03.dbf 2096128 28
    TS3X /exlibris1/oradata/aleph1/aleph1_ts3x_04.dbf 2096128 29
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_01.dbf 2096128 15
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_02.dbf 2096128 16
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_03.dbf 2096128 17
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_04.dbf 2096128 18
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_05.dbf 2096128 19
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_06.dbf 2096128 20
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_07.dbf 2096128 21
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_08.dbf 2096128 22
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_09.dbf 2096128 40
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_10.dbf 2096128 41
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_11.dbf 4096000 42
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_12.dbf 4096000 43
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_13.dbf 4096000 44
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_14.dbf 4096000 46
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_15.dbf 4096000 47
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_16.dbf 4096000 48
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_17.dbf 4096000 55
    TS4D /exlibris/oradata/aleph1/aleph1_ts4d_18.dbf 4096000 56
    TS4D /exlibris1/oradata/aleph0/aleph0_ts4d_19.dbf 2096128 62
    TS4D /exlibris1/oradata/aleph0/aleph0_ts4d_20.dbf 2096128 63
    TS4X /exlibris1/oradata/aleph1/aleph1_ts4x_01.dbf 2096128 30
    TS4X /exlibris1/oradata/aleph1/aleph1_ts4x_02.dbf 2096128 31
    TS4X /exlibris1/oradata/aleph1/aleph1_ts4x_03.dbf 2096128 32
    TS4X /exlibris1/oradata/aleph1/aleph1_ts4x_04.dbf 2096128 33
    TS4X /exlibris1/oradata/aleph1/aleph1_ts4x_05.dbf 2096128 34
    TS4X /exlibris1/oradata/aleph1/aleph1_ts4x_06.dbf 20

    Resolution:
    When you are connected to a particular instance, you can do "echo $ORACLE_SID":

    abc-a18(1)>>echo $ORACLE_SID
    aleph0

    This comes from this line in the $alephe_root/aleph_start:

    setenv ORACLE_SID aleph0

    And the /exlibris/oradata/aleph0/ directory contains the dbf files for this instance.


    This is what we see for v18:

    abc-a18(1) >>echo $ORACLE_SID
    aleph1

    setenv ORACLE_SID aleph1

    And the /exlibris/oradata/aleph1/ directory contains its dbf files.


    So, yes, the aleph0 datafiles are for v16.


    • Article last edited: 10/8/2013