xtts filename

classic Classic list List threaded Threaded
5 messages Options
Reply | Threaded
Open this post in threaded view
|

xtts filename

Roshan
Hi Erman,

I noticed the filename gets changed after L0 backup

::T24SEYPRODINDEX
10,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_10.dbf
81,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_81.dbf
82,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_82.dbf
83,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_83.dbf
84,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_84.dbf
85,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_85.dbf
86,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_86.dbf
87,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_87.dbf
88,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_88.dbf
89,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_89.dbf
90,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODINDEX_90.dbf
::T24SEYPRODDATA
9,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_9.dbf
11,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_11.dbf
12,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_12.dbf
13,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_13.dbf
14,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_14.dbf
15,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_15.dbf
16,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_16.dbf
17,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_17.dbf
18,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_18.dbf
19,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_19.dbf
20,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_20.dbf
21,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_21.dbf
22,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_22.dbf
23,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_23.dbf
24,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_24.dbf
25,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_25.dbf
26,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_26.dbf
27,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_27.dbf
28,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_28.dbf
29,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_29.dbf
30,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_30.dbf
31,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_31.dbf
32,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_32.dbf
33,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_33.dbf
34,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_34.dbf
35,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_35.dbf
36,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_36.dbf
37,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_37.dbf
38,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_38.dbf
39,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_39.dbf
40,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_40.dbf
41,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_41.dbf
42,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_42.dbf
43,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_43.dbf
44,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_44.dbf
45,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_45.dbf
46,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_46.dbf
47,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_47.dbf
48,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_48.dbf
49,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_49.dbf
50,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_50.dbf
51,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_51.dbf
52,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_52.dbf
53,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_53.dbf
54,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_54.dbf
55,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_55.dbf
56,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_56.dbf
57,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_57.dbf
58,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_58.dbf
59,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_59.dbf
60,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_60.dbf
61,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_61.dbf
62,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_62.dbf
63,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_63.dbf
64,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_64.dbf
65,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_65.dbf
66,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_66.dbf
67,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_67.dbf
68,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_68.dbf
69,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_69.dbf
70,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_70.dbf
71,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_71.dbf
72,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_72.dbf
73,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_73.dbf
74,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_74.dbf
75,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_75.dbf
76,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_76.dbf
77,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_77.dbf
78,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_78.dbf
79,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_79.dbf
80,+DATAC1/SEYDRPD/DATAFILE/T24SEYPRODDATA_80.dbf

They are different from the actual ones
SQL> select file_name from dba_data_files;

FILE_NAME
--------------------------------------------------------------------------------
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-system_fno-1
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-sysaux_fno-3
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-undotbs1_fno-4
+T24SEYDATADG/SEYDR/DATAFILE/undotbs1.456.1117200179
+T24SEYDATADG/SEYDR/DATAFILE/undotbs1.457.1117200323
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-users_fno-7
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-undotbs2_fno-5
+T24SEYDATADG/SEYDR/DATAFILE/undotbs2.458.1117200493
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-ggtbs_fno-2
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-ggtbs_fno-8
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-9

FILE_NAME
--------------------------------------------------------------------------------
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-11
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-12
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-13
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-14
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-15
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-16
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-17
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-18
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-19
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-20
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-21

FILE_NAME
--------------------------------------------------------------------------------
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-22
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-23
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-24
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-25
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-26
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-27
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-28
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-29
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-30
+T24SEYDATADG/SEYDR/DATAFILE/data_d-seyprod_ts-t24seyproddata_fno-31

Kindly advise why the names are not same

Regards,
Roshan
Reply | Threaded
Open this post in threaded view
|

Re: xtts filename

ErmanArslansOracleBlog
Administrator
1)What is the backup command that you use for getting this database backup?

2)What is the command that you use for listing the backup filenames?
Reply | Threaded
Open this post in threaded view
|

Re: xtts filename

Roshan
export TMPDIR=/backupexadr/schema/seydr/SOURCE/TMP
$ORACLE_HOME/perl/bin/perl xttdriver.pl --backup
Reply | Threaded
Open this post in threaded view
|

Re: xtts filename

ErmanArslansOracleBlog
Administrator
This is not a standard backup, it is related with XTTS. It is a script. So that might be normal, expected.
Reply | Threaded
Open this post in threaded view
|

Re: xtts filename

ErmanArslansOracleBlog
Administrator
Bytheway you can't control the level 0 backup filenames that much in RMAN.