• 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