Erman Arslan's Oracle Forum › Database
Login  Register

xtts filename

classic Classic list List threaded Threaded
♦
♦
 5 messages Options Options
 
Embed post
Permalink
Roshan
Reply | Threaded
Open this post in threaded view
♦
♦
| More
Print post
Permalink
Mar 13, 2024; 7:05pm

xtts filename

Roshan
1294 posts
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
ErmanArslansOracleBlog
Reply | Threaded
Open this post in threaded view
♦
♦
| More
Print post
Permalink
Mar 20, 2024; 8:18am

Re: xtts filename

ErmanArslansOracleBlog
Administrator
5727 posts
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?
Roshan
Reply | Threaded
Open this post in threaded view
♦
♦
| More
Print post
Permalink
Mar 25, 2024; 10:34am

Re: xtts filename

Roshan
1294 posts
export TMPDIR=/backupexadr/schema/seydr/SOURCE/TMP
$ORACLE_HOME/perl/bin/perl xttdriver.pl --backup
ErmanArslansOracleBlog
Reply | Threaded
Open this post in threaded view
♦
♦
| More
Print post
Permalink
Mar 25, 2024; 10:53am

Re: xtts filename

ErmanArslansOracleBlog
Administrator
5727 posts
This is not a standard backup, it is related with XTTS. It is a script. So that might be normal, expected.
ErmanArslansOracleBlog
Reply | Threaded
Open this post in threaded view
♦
♦
| More
Print post
Permalink
Mar 25, 2024; 11:03am

Re: xtts filename

ErmanArslansOracleBlog
Administrator
5727 posts
Bytheway you can't control the level 0 backup filenames that much in RMAN.
Free forum by Nabble Edit this page