powered by simpleCommunicator - 2.0.61     © 2026 Programmizd 02
Целевая тема:
Создать новую тему:
Автор:
Закрыть
Цитировать
Форумы / Oracle [игнор отключен] [закрыт для гостей] / RMAN требует неизвестные backup piece
25 сообщений из 25, страница 1 из 1
RMAN требует неизвестные backup piece
    #38322368
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Здравствуйте.
Встретился со следующей проблемой:
1. Делаю rman backup:
run {
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup01/RMAN/back%U';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK CLEAR;
BACKUP DATABASE INCLUDE CURRENT CONTROLFILE;
}
Получаю 5 backup piece :
>/backup01/RMAN
ls -al
total 1363999668
drwxrwxrwx 2 oracle dba 1024 Jul 5 00:36 .
drwxr-xr-x 7 110 dba 1024 Jul 5 16:28 ..
-rw-r--r-- 1 oracle dba 164282834944 Jul 5 00:46 backbcodubao_1_1
-rw-r--r-- 1 oracle dba 192142024704 Jul 5 00:55 backbdodubat_1_1
-rw-r--r-- 1 oracle dba 191940526080 Jul 5 00:54 backbeodubb4_1_1
-rw-r--r-- 1 oracle dba 149980872704 Jul 5 00:36 backbfodubba_1_1
-rw-r--r-- 1 oracle dba 16973824 Jul 5 00:36 backbgodugs1_1_1
LOG=
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
Recovery Manager: Release 11.2.0.1.0 - Production on Thu Jul 4 23:00:16 2013

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

connected to target database: AISTPS (DBID=90882830)
using target database control file instead of recovery catalog

RMAN> run { 
2> CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
3> CONFIGURE BACKUP OPTIMIZATION ON; # default
4> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
5> CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
6> CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
7> CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
8> CONFIGURE CONTROLFILE AUTOBACKUP ON;
9> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup01/RMAN/back%U';
10> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;
11> CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR;
12> CONFIGURE CHANNEL 3 DEVICE TYPE DISK CLEAR;
13> CONFIGURE CHANNEL 4 DEVICE TYPE DISK CLEAR;
14> BACKUP DATABASE INCLUDE CURRENT CONTROLFILE; 
15> }
16> 
old RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
new RMAN configuration parameters:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters:
CONFIGURE DEVICE TYPE DISK PARALLELISM 4 BACKUP TYPE TO BACKUPSET;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters:
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters:
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP ON;
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup01/RMAN/back%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup01/RMAN/back%U';
new RMAN configuration parameters are successfully stored

old RMAN configuration parameters are successfully deleted

old RMAN configuration parameters are successfully deleted

old RMAN configuration parameters are successfully deleted

old RMAN configuration parameters are successfully deleted

Starting backup at 04-JUL-13
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=249 device type=DISK
allocated channel: ORA_DISK_2
channel ORA_DISK_2: SID=315 device type=DISK
allocated channel: ORA_DISK_3
channel ORA_DISK_3: SID=335 device type=DISK
allocated channel: ORA_DISK_4
channel ORA_DISK_4: SID=369 device type=DISK
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00008 name=+AISTPSDATA/aistps/datafile/users_04.dba
input datafile file number=00015 name=+AISTPSDATA/aistps/datafile/indx4m_02.dba
input datafile file number=00020 name=+AISTPSDATA/aistps/datafile/indx_03.dba
input datafile file number=00025 name=+AISTPSDATA/aistps/datafile/users_4m_01.dba
input datafile file number=00029 name=+AISTPSDATA/aistps/datafile/users4m_05.dba
input datafile file number=00034 name=+AISTPSDATA/aistps/datafile/users_4m_06.dba
input datafile file number=00003 name=+AISTPSDATA/aistps/datafile/undotbs1.276.809630909
input datafile file number=00031 name=+AISTPSDATA/aistps/datafile/repl_03.dba
input datafile file number=00024 name=+AISTPSDATA/aistps/datafile/tools_01.dba
channel ORA_DISK_1: starting piece 1 at 04-JUL-13
channel ORA_DISK_2: starting full datafile backup set
channel ORA_DISK_2: specifying datafile(s) in backup set
input datafile file number=00005 name=+AISTPSDATA/aistps/datafile/users_01.dba
input datafile file number=00009 name=+AISTPSDATA/aistps/datafile/users_05.dba
input datafile file number=00018 name=+AISTPSDATA/aistps/datafile/indx_02.dba
input datafile file number=00022 name=+AISTPSDATA/aistps/datafile/indx_04.dba
input datafile file number=00027 name=+AISTPSDATA/aistps/datafile/users_4m_03.dba
input datafile file number=00032 name=+AISTPSDATA/aistps/datafile/indx_05.dba
input datafile file number=00036 name=+AISTPSDATA/aistps/datafile/indx_06.dba
input datafile file number=00001 name=+AISTPSDATA/aistps/datafile/system.282.809630937
input datafile file number=00002 name=+AISTPSDATA/aistps/datafile/sysaux.281.809630933
channel ORA_DISK_2: starting piece 1 at 04-JUL-13
channel ORA_DISK_3: starting full datafile backup set
channel ORA_DISK_3: specifying datafile(s) in backup set
input datafile file number=00004 name=+AISTPSDATA/aistps/datafile/users.257.809630783
input datafile file number=00016 name=+AISTPSDATA/aistps/datafile/indx4m_03.dba
input datafile file number=00021 name=+AISTPSDATA/aistps/datafile/indx4m_05.dba
input datafile file number=00026 name=+AISTPSDATA/aistps/datafile/users_4m_02.dba
input datafile file number=00030 name=+AISTPSDATA/aistps/datafile/indx_01.dba
input datafile file number=00035 name=+AISTPSDATA/aistps/datafile/indx_07.dba
input datafile file number=00013 name=+AISTPSDATA/aistps/datafile/repl_02.dba
input datafile file number=00006 name=+AISTPSDATA/aistps/datafile/users_02.dba
input datafile file number=00017 name=+AISTPSDATA/aistps/datafile/system02
channel ORA_DISK_3: starting piece 1 at 04-JUL-13
channel ORA_DISK_4: starting full datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
input datafile file number=00007 name=+AISTPSDATA/aistps/datafile/users_03.dba
input datafile file number=00014 name=+AISTPSDATA/aistps/datafile/indx4m_01.dba
input datafile file number=00019 name=+AISTPSDATA/aistps/datafile/indx4m_04.dba
input datafile file number=00023 name=+AISTPSDATA/aistps/datafile/indx4m_06.dba
input datafile file number=00028 name=+AISTPSDATA/aistps/datafile/users_4m_04.dba
input datafile file number=00033 name=+AISTPSDATA/aistps/datafile/users_4m_07.dba
input datafile file number=00037 name=+AISTPSDATA/aistps/datafile/indx4m_07.dba
input datafile file number=00010 name=+AISTPSDATA/aistps/datafile/users_06.dba
input datafile file number=00011 name=+AISTPSDATA/aistps/datafile/users_07.dba
input datafile file number=00012 name=+AISTPSDATA/aistps/datafile/users_08.dba
channel ORA_DISK_4: starting piece 1 at 04-JUL-13
channel ORA_DISK_4: finished piece 1 at 05-JUL-13
piece handle=/backup01/RMAN/backbfodubba_1_1 tag=TAG20130704T230140 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 01:34:13
channel ORA_DISK_4: starting full datafile backup set
channel ORA_DISK_4: specifying datafile(s) in backup set
including current control file in backup set
channel ORA_DISK_4: starting piece 1 at 05-JUL-13
channel ORA_DISK_4: finished piece 1 at 05-JUL-13
piece handle=/backup01/RMAN/backbgodugs1_1_1 tag=TAG20130704T230140 comment=NONE
channel ORA_DISK_4: backup set complete, elapsed time: 00:00:07
channel ORA_DISK_1: finished piece 1 at 05-JUL-13
piece handle=/backup01/RMAN/backbcodubao_1_1 tag=TAG20130704T230140 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 01:44:43
channel ORA_DISK_3: finished piece 1 at 05-JUL-13
piece handle=/backup01/RMAN/backbeodubb4_1_1 tag=TAG20130704T230140 comment=NONE
channel ORA_DISK_3: backup set complete, elapsed time: 01:53:12
channel ORA_DISK_2: finished piece 1 at 05-JUL-13
piece handle=/backup01/RMAN/backbdodubat_1_1 tag=TAG20130704T230140 comment=NONE
channel ORA_DISK_2: backup set complete, elapsed time: 01:53:39
Finished backup at 05-JUL-13

Starting Control File Autobackup at 05-JUL-13
piece handle=/backup01/CTRL/contc-90882830-20130705-00 comment=NONE
Finished Control File Autobackup at 05-JUL-13

Recovery Manager complete.



Controlfile сохраняю
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
run { 
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION ON; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/backup01/CTRL/cont%F';
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/backup01/CTRL/snapcf_AISTPS.f';
BACKUP AS COPY
  CURRENT CONTROLFILE FORMAT '/backup01/CTRL/control01.ctl';
}




2. Пытаюсь восстановить на аналогичном сервере(тестовом), подмонтировав диск backup01/:
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
run {
SET DBID = 90882830;
RESTORE CONTROLFILE FROM '/backup01/CTRL/contc-90882830-20130705-01';
ALTER DATABASE MOUNT;
CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   '/backup01/RMAN/back%U';
CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 3 DEVICE TYPE DISK CLEAR;
CONFIGURE CHANNEL 4 DEVICE TYPE DISK CLEAR;
SET ARCHIVELOG DESTINATION TO '/backup01/ARCH';
SET UNTIL SCN=22040698009;
RESTORE DATABASE;
RECOVER DATABASE;
}



Получаю ошибку :
RA-19870: error while restoring backup piece /backup01/RMAN/backavodp2lh_1_1
ORA-19505: failed to identify file "/backup01/RMAN/backavodp2lh_1_1"
ORA-27037: unable to obtain file status
HPUX-ia64 Error: 2: No such file or directory
Additional information: 3

LOG - в файле .

Не понимаю, откуда берется инфа по кускам :
backup01/RMAN/backb7odrn1m_1_1
backup01/RMAN/backb4odrn0r_1_1
...
Пытался control заменять просто руками - то же самое..
прошу помощи...
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322382
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Oracle 11g, HPUX..
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322394
optimizationon
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Read-only ts?
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322405
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
optimizationonRead-only ts?
нет
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322408
Фотография DВА
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
это откуда взялось?
SCN=22040698009
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322425
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
DВАэто откуда взялось?
SCN=22040698009

recid,stamp,thread#,sequence#,first_change#,first_time,next_change#,resetlogs_change#,resetlogs_time
86779,819933653,1,11300,22040698009,04-Jul-13 11:10:05 PM,22040781388,20787025276,09-Mar-13 7:24:10 PM
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322426
Фотография DВА
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Георгий7DВАэто откуда взялось?
SCN=22040698009

recid,stamp,thread#,sequence#,first_change#,first_time,next_change#,resetlogs_change#,resetlogs_time
86779,819933653,1,11300,22040698009,04-Jul-13 11:10:05 PM,22040781388,20787025276,09-Mar-13 7:24:10 PM


Как вы предлагаете ораклу воссстановить базу по состоянию на 04-Jul-13 из бэкапа, сделанного 05-Jul-13 ?
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322429
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
наверное вы правы, с SCN ошибся, но роли это тут не сыграет, если я убираб SET UNTIL, ла и если просто руками захожу и говорю restore database - появляются "левые" backup piece...
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322430
Фотография DВА
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
ну так продемонстрируйте
с предварительным выводом list backup после restore controlfile
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322434
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Код: plsql
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
24.
25.
26.
27.
28.
29.
30.
31.
32.
33.
34.
35.
36.
37.
38.
39.
40.
41.
42.
43.
44.
45.
46.
47.
48.
49.
50.
51.
52.
53.
54.
55.
56.
57.
58.
59.
60.
61.
62.
63.
64.
65.
66.
67.
68.
69.
70.
71.
72.
73.
74.
75.
76.
77.
78.
79.
80.
81.
82.
83.
84.
85.
86.
87.
88.
89.
90.
91.
92.
93.
94.
95.
96.
97.
98.
99.
100.
101.
102.
103.
104.
105.
106.
107.
108.
109.
110.
111.
112.
113.
114.
115.
116.
117.
118.
119.
120.
121.
122.
123.
124.
125.
126.
127.
128.
129.
130.
131.
132.
133.
134.
135.
136.
137.
138.
139.
140.
141.
142.
143.
144.
145.
146.
147.
148.
149.
150.
151.
152.
153.
154.
155.
156.
157.
158.
159.
160.
161.
162.
163.
164.
165.
166.
167.
168.
169.
170.
171.
172.
173.
174.
175.
176.
177.
178.
179.
180.
181.
182.
183.
184.
185.
186.
187.
188.
189.
190.
191.
192.
193.
194.
195.
196.
197.
198.
199.
200.
201.
202.
203.
204.
205.
206.
207.
208.
209.
210.
211.
212.
213.
214.
215.
216.
217.
218.
219.
220.
221.
222.
223.
224.
225.
226.
227.
228.
229.
230.
231.
232.
233.
234.
235.
236.
237.
238.
239.
240.
241.
242.
243.
244.
245.
246.
247.
248.
249.
250.
251.
252.
253.
254.
255.
256.
257.
258.
259.
260.
261.
262.
263.
264.
265.
266.
267.
268.
269.
270.
271.
272.
273.
274.
275.
276.
277.
278.
279.
280.
281.
282.
283.
284.
285.
286.
287.
288.
289.
290.
291.
292.
293.
294.
295.
296.
297.
298.
299.
300.
301.
302.
303.
304.
305.
306.
307.
308.
309.
310.
311.
312.
313.
314.
315.
316.
317.
318.
319.
320.
321.
322.
323.
324.
325.
326.
327.
328.
329.
330.
331.
332.
333.
334.
335.
336.
337.
338.
339.
340.
341.
342.
343.
344.
345.
346.
347.
348.
349.
350.
351.
352.
353.
354.
355.
356.
357.
358.
359.
360.
361.
362.
363.
364.
365.
366.
367.
368.
369.
370.
371.
372.
373.
374.
375.
376.
377.
378.
379.
380.
381.
382.
383.
384.
385.
386.
387.
388.
389.
390.
391.
392.
393.
394.
395.
396.
397.
398.
399.
400.
401.
402.
403.
404.
405.
406.
407.
408.
409.
410.
411.
412.
413.
414.
415.
416.
417.
418.
419.
420.
421.
422.
423.
424.
425.
426.
427.
428.
429.
430.
431.
432.
433.
434.
435.
436.
437.
438.
439.
440.
441.
442.
443.
444.
445.
446.
447.
448.
449.
450.
451.
452.
453.
454.
455.
456.
457.
458.
459.
460.
461.
462.
463.
464.
465.
466.
467.
468.
469.
470.
471.
472.
473.
474.
475.
476.
477.
478.
479.
480.
481.
482.
483.
484.
485.
486.
487.
488.
489.
490.
491.
492.
493.
494.
495.
496.
497.
498.
499.
500.
501.
502.
503.
504.
505.
506.
507.
508.
509.
510.
511.
512.
513.
514.
515.
516.
517.
518.
519.
520.
521.
522.
523.
524.
525.
526.
527.
528.
529.
530.
531.
532.
533.
534.
535.
536.
537.
538.
539.
540.
541.
542.
543.
544.
545.
546.
547.
548.
549.
550.
551.
552.
553.
554.
555.
556.
557.
558.
559.
560.
561.
562.
563.
564.
565.
566.
567.
568.
569.
570.
571.
572.
573.
574.
575.
576.
577.
578.
579.
580.
581.
582.
583.
584.
585.
586.
587.
588.
589.
590.
591.
592.
593.
594.
595.
596.
597.
598.
599.
600.
601.
602.
603.
604.
605.
606.
607.
608.
609.
610.
611.
612.
613.
614.
615.
616.
617.
618.
619.
620.
621.
622.
623.
624.
625.
626.
627.
628.
629.
630.
631.
632.
633.
634.
635.
636.
637.
638.
639.
640.
641.
642.
643.
644.
645.
646.
647.
648.
649.
650.
651.
652.
653.
654.
655.
656.
657.
658.
659.
660.
661.
662.
663.
664.
665.
666.
667.
668.
669.
670.
671.
672.
673.
674.
675.
676.
677.
678.
679.
680.
681.
682.
683.
684.
685.
686.
687.
688.
689.
690.
691.
692.
693.
694.
695.
696.
697.
698.
699.
700.
701.
702.
703.
704.
705.
706.
707.
708.
709.
710.
711.
712.
713.
714.
715.
716.
717.
718.
719.
720.
721.
722.
723.
724.
725.
726.
727.
728.
729.
730.
731.
732.
733.
734.
735.
736.
737.
738.
739.
740.
741.
742.
743.
744.
745.
746.
747.
748.
749.
750.
751.
752.
753.
754.
755.
756.
757.
758.
759.
760.
761.
762.
763.
764.
765.
766.
767.
768.
769.
770.
771.
772.
773.
774.
775.
776.
777.
778.
779.
780.
781.
782.
783.
784.
785.
786.
787.
788.
789.
790.
791.
792.
793.
794.
795.
796.
797.
798.
799.
800.
801.
802.
803.
804.
805.
806.
807.
808.
809.
810.
811.
812.
813.
814.
815.
816.
817.
818.
819.
820.
821.
822.
823.
824.
825.
826.
827.
828.
829.
830.
831.
832.
833.
834.
835.
836.
837.
838.
839.
840.
841.
842.
843.
844.
845.
846.
847.
848.
849.
850.
851.
852.
853.
854.
855.
856.
857.
858.
859.
860.
861.
862.
863.
864.
865.
866.
867.
868.
869.
870.
871.
872.
873.
874.
875.
876.
877.
878.
879.
880.
881.
882.
883.
884.
885.
886.
887.
888.
889.
890.
891.
892.
893.
894.
895.
896.
897.
898.
899.
900.
901.
902.
903.
904.
905.
906.
907.
908.
909.
910.
911.
912.
913.
914.
915.
916.
917.
918.
919.
920.
921.
922.
923.
924.
925.
926.
927.
928.
929.
930.
931.
932.
933.
934.
935.
936.
937.
938.
939.
940.
941.
942.
943.
944.
945.
946.
947.
948.
949.
950.
951.
952.
953.
954.
955.
956.
957.
958.
959.
960.
961.
962.
963.
964.
965.
966.
967.
968.
969.
970.
971.
972.
973.
974.
975.
976.
977.
978.
979.
980.
981.
982.
983.
984.
985.
986.
987.
988.
989.
990.
991.
992.
993.
994.
995.
996.
997.
998.
999.
1000.
1001.
1002.
1003.
1004.
1005.
1006.
1007.
1008.
1009.
1010.
1011.
1012.
1013.
1014.
1015.
1016.
1017.
1018.
1019.
1020.
1021.
1022.
1023.
1024.
1025.
1026.
1027.
1028.
1029.
1030.
1031.
1032.
1033.
1034.
1035.
1036.
1037.
1038.
1039.
1040.
1041.
1042.
1043.
1044.
1045.
1046.
1047.
1048.
1049.
1050.
1051.
1052.
1053.
1054.
1055.
1056.
1057.
1058.
1059.
1060.
1061.
1062.
1063.
1064.
1065.
1066.
1067.
1068.
1069.
1070.
1071.
1072.
1073.
1074.
1075.
1076.
1077.
1078.
1079.
1080.
1081.
1082.
1083.
1084.
1085.
1086.
1087.
1088.
1089.
1090.
1091.
1092.
1093.
1094.
1095.
1096.
1097.
1098.
1099.
1100.
1101.
1102.
1103.
1104.
1105.
1106.
1107.
1108.
1109.
1110.
1111.
1112.
1113.
1114.
1115.
1116.
1117.
1118.
1119.
1120.
1121.
1122.
1123.
1124.
1125.
1126.
1127.
1128.
1129.
1130.
1131.
1132.
1133.
1134.
1135.
1136.
1137.
1138.
1139.
1140.
1141.
1142.
1143.
1144.
1145.
1146.
1147.
1148.
1149.
1150.
1151.
1152.
1153.
1154.
1155.
1156.
1157.
1158.
1159.
1160.
1161.
1162.
1163.
1164.
1165.
1166.
1167.
RMAN> list backup;
2> 

List of Backup Sets
===================


BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2885    Full    176.61G    DISK        01:56:34     21-JUN-13      
        BP Key: 2885   Status: AVAILABLE  Compressed: NO  Tag: TAG20130620T230246
        Piece Name: /backup01/RMAN/back8bocmpp1_1_1
  List of Datafiles in backup set 2885
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21883193377 20-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21883193377 20-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  9       Full 21883193377 20-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21883193377 20-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21883193377 20-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21883193377 20-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21883193377 20-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21883193377 20-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2886    Full    16.17M     DISK        00:00:11     21-JUN-13      
        BP Key: 2886   Status: AVAILABLE  Compressed: NO  Tag: TAG20130621T005948
        Piece Name: /backup01/CTRL/contc-90882830-20130621-00
  Control File Included: Ckp SCN: 21884610149   Ckp time: 21-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2887    Full    16.17M     DISK        00:00:17     21-JUN-13      
        BP Key: 2887   Status: AVAILABLE  Compressed: NO  Tag: TAG20130621T010321
        Piece Name: /backup01/CTRL/contc-90882830-20130621-01
  Control File Included: Ckp SCN: 21884678224   Ckp time: 21-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2888    Full    138.27G    DISK        01:27:12     22-JUN-13      
        BP Key: 2888   Status: AVAILABLE  Compressed: NO  Tag: TAG20130621T230122
        Piece Name: /backup01/RMAN/back8locpe27_1_1
  List of Datafiles in backup set 2888
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 21894309038 21-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2889    Full    16.17M     DISK        00:00:17     22-JUN-13      
        BP Key: 2889   Status: AVAILABLE  Compressed: NO  Tag: TAG20130621T230122
        Piece Name: /backup01/RMAN/back8mocpj5s_1_1
  Control File Included: Ckp SCN: 21894929542   Ckp time: 22-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2890    Full    157.52G    DISK        01:41:04     22-JUN-13      
        BP Key: 2890   Status: AVAILABLE  Compressed: NO  Tag: TAG20130621T230122
        Piece Name: /backup01/RMAN/back8iocpe24_1_1
  List of Datafiles in backup set 2890
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 21894308864 21-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2891    Full    177.35G    DISK        01:46:18     22-JUN-13      
        BP Key: 2891   Status: AVAILABLE  Compressed: NO  Tag: TAG20130621T230122
        Piece Name: /backup01/RMAN/back8kocpe27_1_1
  List of Datafiles in backup set 2891
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 21894308984 21-JUN-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2892    Full    176.90G    DISK        01:46:37     22-JUN-13      
        BP Key: 2892   Status: AVAILABLE  Compressed: NO  Tag: TAG20130621T230122
        Piece Name: /backup01/RMAN/back8jocpe26_1_1
  List of Datafiles in backup set 2892
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21894308975 21-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2893    Full    16.17M     DISK        00:00:20     22-JUN-13      
        BP Key: 2893   Status: AVAILABLE  Compressed: NO  Tag: TAG20130622T004819
        Piece Name: /backup01/CTRL/contc-90882830-20130622-00
  Control File Included: Ckp SCN: 21895120805   Ckp time: 22-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2894    Full    16.17M     DISK        00:00:11     22-JUN-13      
        BP Key: 2894   Status: AVAILABLE  Compressed: NO  Tag: TAG20130622T005119
        Piece Name: /backup01/CTRL/contc-90882830-20130622-01
  Control File Included: Ckp SCN: 21895137585   Ckp time: 22-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2895    Full    138.30G    DISK        01:27:56     23-JUN-13      
        BP Key: 2895   Status: AVAILABLE  Compressed: NO  Tag: TAG20130622T230134
        Piece Name: /backup01/RMAN/back8tocs2er_1_1
  List of Datafiles in backup set 2895
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 21900089603 22-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2896    Full    16.17M     DISK        00:00:17     23-JUN-13      
        BP Key: 2896   Status: AVAILABLE  Compressed: NO  Tag: TAG20130622T230134
        Piece Name: /backup01/RMAN/back8uocs7k0_1_1
  Control File Included: Ckp SCN: 21900457240   Ckp time: 23-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2897    Full    152.07G    DISK        01:38:01     23-JUN-13      
        BP Key: 2897   Status: AVAILABLE  Compressed: NO  Tag: TAG20130622T230134
        Piece Name: /backup01/RMAN/back8qocs2eg_1_1
  List of Datafiles in backup set 2897
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 21900089585 22-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2898    Full    177.11G    DISK        01:47:13     23-JUN-13      
        BP Key: 2898   Status: AVAILABLE  Compressed: NO  Tag: TAG20130622T230134
        Piece Name: /backup01/RMAN/back8rocs2ei_1_1
  List of Datafiles in backup set 2898
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21900089600 22-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2899    Full    177.40G    DISK        01:47:17     23-JUN-13      
        BP Key: 2899   Status: AVAILABLE  Compressed: NO  Tag: TAG20130622T230134
        Piece Name: /backup01/RMAN/back8socs2ek_1_1
  List of Datafiles in backup set 2899
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 21900089602 22-JUN-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2900    Full    16.17M     DISK        00:00:17     23-JUN-13      
        BP Key: 2900   Status: AVAILABLE  Compressed: NO  Tag: TAG20130623T004918
        Piece Name: /backup01/CTRL/contc-90882830-20130623-00
  Control File Included: Ckp SCN: 21900492890   Ckp time: 23-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2901    Full    16.17M     DISK        00:00:07     23-JUN-13      
        BP Key: 2901   Status: AVAILABLE  Compressed: NO  Tag: TAG20130623T005304
        Piece Name: /backup01/CTRL/contc-90882830-20130623-01
  Control File Included: Ckp SCN: 21900506706   Ckp time: 23-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2902    Full    138.45G    DISK        01:33:25     25-JUN-13      
        BP Key: 2902   Status: AVAILABLE  Compressed: NO  Tag: TAG20130624T230247
        Piece Name: /backup01/RMAN/back95od1b91_1_1
  List of Datafiles in backup set 2902
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 21920621683 24-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2903    Full    16.17M     DISK        00:00:09     25-JUN-13      
        BP Key: 2903   Status: AVAILABLE  Compressed: NO  Tag: TAG20130624T230247
        Piece Name: /backup01/RMAN/back96od1goi_1_1
  Control File Included: Ckp SCN: 21921336554   Ckp time: 25-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2904    Full    157.95G    DISK        01:47:01     25-JUN-13      
        BP Key: 2904   Status: AVAILABLE  Compressed: NO  Tag: TAG20130624T230247
        Piece Name: /backup01/RMAN/back92od1b8r_1_1
  List of Datafiles in backup set 2904
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 21920619343 24-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2905    Full    177.66G    DISK        01:59:04     25-JUN-13      
        BP Key: 2905   Status: AVAILABLE  Compressed: NO  Tag: TAG20130624T230247
        Piece Name: /backup01/RMAN/back94od1b8t_1_1
  List of Datafiles in backup set 2905
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 21920619772 24-JUN-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2906    Full    177.55G    DISK        02:00:14     25-JUN-13      
        BP Key: 2906   Status: AVAILABLE  Compressed: NO  Tag: TAG20130624T230247
        Piece Name: /backup01/RMAN/back93od1b8t_1_1
  List of Datafiles in backup set 2906
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21920619456 24-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2907    Full    16.17M     DISK        00:00:18     25-JUN-13      
        BP Key: 2907   Status: AVAILABLE  Compressed: NO  Tag: TAG20130625T010322
        Piece Name: /backup01/CTRL/contc-90882830-20130625-00
  Control File Included: Ckp SCN: 21921563180   Ckp time: 25-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2908    Full    16.17M     DISK        00:00:17     25-JUN-13      
        BP Key: 2908   Status: AVAILABLE  Compressed: NO  Tag: TAG20130625T010701
        Piece Name: /backup01/CTRL/contc-90882830-20130625-01
  Control File Included: Ckp SCN: 21921619845   Ckp time: 25-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2909    Full    138.56G    DISK        01:37:26     26-JUN-13      
        BP Key: 2909   Status: AVAILABLE  Compressed: NO  Tag: TAG20130625T230510
        Piece Name: /backup01/RMAN/back9dod3vq7_1_1
  List of Datafiles in backup set 2909
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 21931223180 25-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2910    Full    16.17M     DISK        00:00:17     26-JUN-13      
        BP Key: 2910   Status: AVAILABLE  Compressed: NO  Tag: TAG20130625T230510
        Piece Name: /backup01/RMAN/back9eod45h8_1_1
  Control File Included: Ckp SCN: 21931969904   Ckp time: 26-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2911    Full    147.43G    DISK        01:48:52     26-JUN-13      
        BP Key: 2911   Status: AVAILABLE  Compressed: NO  Tag: TAG20130625T230510
        Piece Name: /backup01/RMAN/back9aod3vpb_1_1
  List of Datafiles in backup set 2911
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 21931222255 25-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2912    Full    177.81G    DISK        01:58:03     26-JUN-13      
        BP Key: 2912   Status: AVAILABLE  Compressed: NO  Tag: TAG20130625T230510
        Piece Name: /backup01/RMAN/back9cod3vq2_1_1
  List of Datafiles in backup set 2912
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 21931223158 25-JUN-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2913    Full    177.71G    DISK        01:58:27     26-JUN-13      
        BP Key: 2913   Status: AVAILABLE  Compressed: NO  Tag: TAG20130625T230510
        Piece Name: /backup01/RMAN/back9bod3vpu_1_1
  List of Datafiles in backup set 2913
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21931222591 25-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2914    Full    16.17M     DISK        00:00:19     26-JUN-13      
        BP Key: 2914   Status: AVAILABLE  Compressed: NO  Tag: TAG20130626T010416
        Piece Name: /backup01/CTRL/contc-90882830-20130626-00
  Control File Included: Ckp SCN: 21932133633   Ckp time: 26-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2915    Full    16.17M     DISK        00:00:29     26-JUN-13      
        BP Key: 2915   Status: AVAILABLE  Compressed: NO  Tag: TAG20130626T010718
        Piece Name: /backup01/CTRL/contc-90882830-20130626-01
  Control File Included: Ckp SCN: 21932147878   Ckp time: 26-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2916    Full    138.64G    DISK        01:32:08     27-JUN-13      
        BP Key: 2916   Status: AVAILABLE  Compressed: NO  Tag: TAG20130626T230335
        Piece Name: /backup01/RMAN/back9lod6k31_1_1
  List of Datafiles in backup set 2916
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 21945416051 26-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2917    Full    16.17M     DISK        00:00:18     27-JUN-13      
        BP Key: 2917   Status: AVAILABLE  Compressed: NO  Tag: TAG20130626T230335
        Piece Name: /backup01/RMAN/back9mod6pg0_1_1
  Control File Included: Ckp SCN: 21946085703   Ckp time: 27-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2918    Full    150.21G    DISK        01:43:49     27-JUN-13      
        BP Key: 2918   Status: AVAILABLE  Compressed: NO  Tag: TAG20130626T230335
        Piece Name: /backup01/RMAN/back9iod6k2c_1_1
  List of Datafiles in backup set 2918
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 21945415408 26-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2919    Full    177.97G    DISK        01:51:11     27-JUN-13      
        BP Key: 2919   Status: AVAILABLE  Compressed: NO  Tag: TAG20130626T230335
        Piece Name: /backup01/RMAN/back9kod6k2u_1_1
  List of Datafiles in backup set 2919
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 21945416016 26-JUN-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2920    Full    178.04G    DISK        01:51:57     27-JUN-13      
        BP Key: 2920   Status: AVAILABLE  Compressed: NO  Tag: TAG20130626T230335
        Piece Name: /backup01/RMAN/back9jod6k2i_1_1
  List of Datafiles in backup set 2920
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21945415991 26-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2921    Full    16.17M     DISK        00:00:18     27-JUN-13      
        BP Key: 2921   Status: AVAILABLE  Compressed: NO  Tag: TAG20130627T005602
        Piece Name: /backup01/CTRL/contc-90882830-20130627-00
  Control File Included: Ckp SCN: 21946152136   Ckp time: 27-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2922    Full    16.17M     DISK        00:00:06     27-JUN-13      
        BP Key: 2922   Status: AVAILABLE  Compressed: NO  Tag: TAG20130627T005850
        Piece Name: /backup01/CTRL/contc-90882830-20130627-01
  Control File Included: Ckp SCN: 21946157509   Ckp time: 27-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2923    Full    138.79G    DISK        01:31:22     28-JUN-13      
        BP Key: 2923   Status: AVAILABLE  Compressed: NO  Tag: TAG20130627T230142
        Piece Name: /backup01/RMAN/back9tod98bb_1_1
  List of Datafiles in backup set 2923
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 21959264916 27-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2924    Full    16.17M     DISK        00:00:17     28-JUN-13      
        BP Key: 2924   Status: AVAILABLE  Compressed: NO  Tag: TAG20130627T230142
        Piece Name: /backup01/RMAN/back9uod9dn4_1_1
  Control File Included: Ckp SCN: 21960200457   Ckp time: 28-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2925    Full    159.62G    DISK        01:44:59     28-JUN-13      
        BP Key: 2925   Status: AVAILABLE  Compressed: NO  Tag: TAG20130627T230142
        Piece Name: /backup01/RMAN/back9qod98at_1_1
  List of Datafiles in backup set 2925
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 21959263552 27-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2926    Full    178.13G    DISK        01:49:48     28-JUN-13      
        BP Key: 2926   Status: AVAILABLE  Compressed: NO  Tag: TAG20130627T230142
        Piece Name: /backup01/RMAN/back9sod98b5_1_1
  List of Datafiles in backup set 2926
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 21959264818 27-JUN-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2927    Full    178.27G    DISK        01:50:10     28-JUN-13      
        BP Key: 2927   Status: AVAILABLE  Compressed: NO  Tag: TAG20130627T230142
        Piece Name: /backup01/RMAN/back9rod98b2_1_1
  List of Datafiles in backup set 2927
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21959264133 27-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2928    Full    16.17M     DISK        00:00:09     28-JUN-13      
        BP Key: 2928   Status: AVAILABLE  Compressed: NO  Tag: TAG20130628T005215
        Piece Name: /backup01/CTRL/contc-90882830-20130628-00
  Control File Included: Ckp SCN: 21960361578   Ckp time: 28-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2929    Full    16.17M     DISK        00:00:05     28-JUN-13      
        BP Key: 2929   Status: AVAILABLE  Compressed: NO  Tag: TAG20130628T005500
        Piece Name: /backup01/CTRL/contc-90882830-20130628-01
  Control File Included: Ckp SCN: 21960383941   Ckp time: 28-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2930    Full    138.93G    DISK        01:28:59     29-JUN-13      
        BP Key: 2930   Status: AVAILABLE  Compressed: NO  Tag: TAG20130628T230211
        Piece Name: /backup01/RMAN/backa5odbsnq_1_1
  List of Datafiles in backup set 2930
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 21971094645 28-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2931    Full    16.17M     DISK        00:00:17     29-JUN-13      
        BP Key: 2931   Status: AVAILABLE  Compressed: NO  Tag: TAG20130628T230211
        Piece Name: /backup01/RMAN/backa6odc1uq_1_1
  Control File Included: Ckp SCN: 21971530433   Ckp time: 29-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2932    Full    147.71G    DISK        01:39:23     29-JUN-13      
        BP Key: 2932   Status: AVAILABLE  Compressed: NO  Tag: TAG20130628T230211
        Piece Name: /backup01/RMAN/backa2odbsnn_1_1
  List of Datafiles in backup set 2932
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 21971094270 28-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2933    Full    178.24G    DISK        01:46:48     29-JUN-13      
        BP Key: 2933   Status: AVAILABLE  Compressed: NO  Tag: TAG20130628T230211
        Piece Name: /backup01/RMAN/backa4odbsnq_1_1
  List of Datafiles in backup set 2933
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 21971094601 28-JUN-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2934    Full    178.35G    DISK        01:47:12     29-JUN-13      
        BP Key: 2934   Status: AVAILABLE  Compressed: NO  Tag: TAG20130628T230211
        Piece Name: /backup01/RMAN/backa3odbsnp_1_1
  List of Datafiles in backup set 2934
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21971094499 28-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2935    Full    16.17M     DISK        00:00:17     29-JUN-13      
        BP Key: 2935   Status: AVAILABLE  Compressed: NO  Tag: TAG20130629T004940
        Piece Name: /backup01/CTRL/contc-90882830-20130629-00
  Control File Included: Ckp SCN: 21971571812   Ckp time: 29-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2936    Full    16.17M     DISK        00:00:15     29-JUN-13      
        BP Key: 2936   Status: AVAILABLE  Compressed: NO  Tag: TAG20130629T005247
        Piece Name: /backup01/CTRL/contc-90882830-20130629-01
  Control File Included: Ckp SCN: 21971583920   Ckp time: 29-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2937    Full    138.97G    DISK        01:26:34     30-JUN-13      
        BP Key: 2937   Status: AVAILABLE  Compressed: NO  Tag: TAG20130629T230304
        Piece Name: /backup01/RMAN/backadodeh64_1_1
  List of Datafiles in backup set 2937
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 21978070778 29-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2938    Full    16.17M     DISK        00:00:10     30-JUN-13      
        BP Key: 2938   Status: AVAILABLE  Compressed: NO  Tag: TAG20130629T230304
        Piece Name: /backup01/RMAN/backaeodem8p_1_1
  Control File Included: Ckp SCN: 21978634743   Ckp time: 30-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2939    Full    153.55G    DISK        01:41:02     30-JUN-13      
        BP Key: 2939   Status: AVAILABLE  Compressed: NO  Tag: TAG20130629T230304
        Piece Name: /backup01/RMAN/backaaodeh5g_1_1
  List of Datafiles in backup set 2939
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 21978069702 29-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2940    Full    178.29G    DISK        01:46:47     30-JUN-13      
        BP Key: 2940   Status: AVAILABLE  Compressed: NO  Tag: TAG20130629T230304
        Piece Name: /backup01/RMAN/backacodeh5t_1_1
  List of Datafiles in backup set 2940
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 21978070345 29-JUN-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2941    Full    178.41G    DISK        01:47:21     30-JUN-13      
        BP Key: 2941   Status: AVAILABLE  Compressed: NO  Tag: TAG20130629T230304
        Piece Name: /backup01/RMAN/backabodeh5m_1_1
  List of Datafiles in backup set 2941
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 21978070113 29-JUN-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2942    Full    16.17M     DISK        00:00:19     30-JUN-13      
        BP Key: 2942   Status: AVAILABLE  Compressed: NO  Tag: TAG20130630T005100
        Piece Name: /backup01/CTRL/contc-90882830-20130630-00
  Control File Included: Ckp SCN: 21978806500   Ckp time: 30-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2943    Full    16.17M     DISK        00:00:12     30-JUN-13      
        BP Key: 2943   Status: AVAILABLE  Compressed: NO  Tag: TAG20130630T005530
        Piece Name: /backup01/CTRL/contc-90882830-20130630-01
  Control File Included: Ckp SCN: 21978881025   Ckp time: 30-JUN-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2944    Full    139.20G    DISK        01:29:30     02-JUL-13      
        BP Key: 2944   Status: AVAILABLE  Compressed: NO  Tag: TAG20130701T230228
        Piece Name: /backup01/RMAN/backalodme8u_1_1
  List of Datafiles in backup set 2944
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 22001757978 01-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2945    Full    16.17M     DISK        00:00:08     02-JUL-13      
        BP Key: 2945   Status: AVAILABLE  Compressed: NO  Tag: TAG20130701T230228
        Piece Name: /backup01/RMAN/backamodmjh3_1_1
  Control File Included: Ckp SCN: 22002358964   Ckp time: 02-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2946    Full    157.37G    DISK        01:43:34     02-JUL-13      
        BP Key: 2946   Status: AVAILABLE  Compressed: NO  Tag: TAG20130701T230228
        Piece Name: /backup01/RMAN/backaiodme8a_1_1
  List of Datafiles in backup set 2946
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 22001754281 01-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2947    Full    178.46G    DISK        01:15:49     02-JUL-13      
        BP Key: 2947   Status: AVAILABLE  Compressed: NO  Tag: TAG20130701T230228
        Piece Name: /backup01/RMAN/backaoodmkjr_1_1
  List of Datafiles in backup set 2947
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 22002567484 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2948    Full    178.62G    DISK        01:16:13     02-JUL-13      
        BP Key: 2948   Status: AVAILABLE  Compressed: NO  Tag: TAG20130701T230228
        Piece Name: /backup01/RMAN/backanodmkjn_1_1
  List of Datafiles in backup set 2948
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 22002563632 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2949    Full    16.17M     DISK        00:00:14     02-JUL-13      
        BP Key: 2949   Status: AVAILABLE  Compressed: NO  Tag: TAG20130702T020729
        Piece Name: /backup01/CTRL/contc-90882830-20130702-00
  Control File Included: Ckp SCN: 22003035862   Ckp time: 02-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2950    Full    16.17M     DISK        00:00:11     02-JUL-13      
        BP Key: 2950   Status: AVAILABLE  Compressed: NO  Tag: TAG20130702T021028
        Piece Name: /backup01/CTRL/contc-90882830-20130702-01
  Control File Included: Ckp SCN: 22003048603   Ckp time: 02-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2951    Full    139.32G    DISK        01:33:22     03-JUL-13      
        BP Key: 2951   Status: AVAILABLE  Compressed: NO  Tag: TAG20130702T230245
        Piece Name: /backup01/RMAN/backavodp2lh_1_1
  List of Datafiles in backup set 2951
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 22016056267 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2952    Full    16.17M     DISK        00:00:17     03-JUL-13      
        BP Key: 2952   Status: AVAILABLE  Compressed: NO  Tag: TAG20130702T230245
        Piece Name: /backup01/RMAN/backb0odp84t_1_1
  Control File Included: Ckp SCN: 22017034229   Ckp time: 03-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2953    Full    162.20G    DISK        01:50:30     03-JUL-13      
        BP Key: 2953   Status: AVAILABLE  Compressed: NO  Tag: TAG20130702T230245
        Piece Name: /backup01/RMAN/backasodp2kv_1_1
  List of Datafiles in backup set 2953
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 22016054119 02-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2954    Full    178.58G    DISK        01:54:21     03-JUL-13      
        BP Key: 2954   Status: AVAILABLE  Compressed: NO  Tag: TAG20130702T230245
        Piece Name: /backup01/RMAN/backauodp2lf_1_1
  List of Datafiles in backup set 2954
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 22016054876 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2955    Full    178.72G    DISK        01:54:37     03-JUL-13      
        BP Key: 2955   Status: AVAILABLE  Compressed: NO  Tag: TAG20130702T230245
        Piece Name: /backup01/RMAN/backatodp2l7_1_1
  List of Datafiles in backup set 2955
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 22016054861 02-JUL-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2956    Full    16.17M     DISK        00:00:11     03-JUL-13      
        BP Key: 2956   Status: AVAILABLE  Compressed: NO  Tag: TAG20130703T005753
        Piece Name: /backup01/CTRL/contc-90882830-20130703-00
  Control File Included: Ckp SCN: 22017228426   Ckp time: 03-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2957    Full    16.17M     DISK        00:00:12     03-JUL-13      
        BP Key: 2957   Status: AVAILABLE  Compressed: NO  Tag: TAG20130703T010109
        Piece Name: /backup01/CTRL/contc-90882830-20130703-01
  Control File Included: Ckp SCN: 22017272972   Ckp time: 03-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2958    Full    139.53G    DISK        01:39:00     04-JUL-13      
        BP Key: 2958   Status: AVAILABLE  Compressed: NO  Tag: TAG20130703T230244
        Piece Name: /backup01/RMAN/backb7odrn1m_1_1
  List of Datafiles in backup set 2958
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 22026904625 03-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2959    Full    16.17M     DISK        00:00:16     04-JUL-13      
        BP Key: 2959   Status: AVAILABLE  Compressed: NO  Tag: TAG20130703T230244
        Piece Name: /backup01/RMAN/backb8odrsrq_1_1
  Control File Included: Ckp SCN: 22027555571   Ckp time: 04-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2960    Full    159.37G    DISK        01:54:32     04-JUL-13      
        BP Key: 2960   Status: AVAILABLE  Compressed: NO  Tag: TAG20130703T230244
        Piece Name: /backup01/RMAN/backb4odrn0r_1_1
  List of Datafiles in backup set 2960
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 22026897930 03-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2961    Full    178.69G    DISK        02:00:10     04-JUL-13      
        BP Key: 2961   Status: AVAILABLE  Compressed: NO  Tag: TAG20130703T230244
        Piece Name: /backup01/RMAN/backb6odrn1i_1_1
  List of Datafiles in backup set 2961
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 22026902908 03-JUL-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2962    Full    178.81G    DISK        02:00:31     04-JUL-13      
        BP Key: 2962   Status: AVAILABLE  Compressed: NO  Tag: TAG20130703T230244
        Piece Name: /backup01/RMAN/backb5odrn1e_1_1
  List of Datafiles in backup set 2962
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 22026902666 03-JUL-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2963    Full    16.17M     DISK        00:00:14     04-JUL-13      
        BP Key: 2963   Status: AVAILABLE  Compressed: NO  Tag: TAG20130704T010349
        Piece Name: /backup01/CTRL/contc-90882830-20130704-00
  Control File Included: Ckp SCN: 22027746071   Ckp time: 04-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2964    Full    16.17M     DISK        00:00:18     04-JUL-13      
        BP Key: 2964   Status: AVAILABLE  Compressed: NO  Tag: TAG20130704T010738
        Piece Name: /backup01/CTRL/contc-90882830-20130704-01
  Control File Included: Ckp SCN: 22027794824   Ckp time: 04-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2965    Full    139.68G    DISK        01:34:08     05-JUL-13      
        BP Key: 2965   Status: AVAILABLE  Compressed: NO  Tag: TAG20130704T230140
        Piece Name: /backup01/RMAN/backbfodubba_1_1
  List of Datafiles in backup set 2965
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  7       Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/users_03.dba
  10      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/users_06.dba
  11      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/users_07.dba
  12      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/users_08.dba
  14      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_01.dba
  19      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_04.dba
  23      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_06.dba
  28      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_04.dba
  33      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_07.dba
  37      Full 22040662651 04-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2966    Full    16.17M     DISK        00:00:08     05-JUL-13      
        BP Key: 2966   Status: AVAILABLE  Compressed: NO  Tag: TAG20130704T230140
        Piece Name: /backup01/RMAN/backbgodugs1_1_1
  Control File Included: Ckp SCN: 22041060620   Ckp time: 05-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2967    Full    153.00G    DISK        01:44:34     05-JUL-13      
        BP Key: 2967   Status: AVAILABLE  Compressed: NO  Tag: TAG20130704T230140
        Piece Name: /backup01/RMAN/backbcodubao_1_1
  List of Datafiles in backup set 2967
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/undotbs1.276.809630909
  8       Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/users_04.dba
  15      Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_02.dba
  20      Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/indx_03.dba
  24      Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/tools_01.dba
  25      Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_01.dba
  29      Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/users4m_05.dba
  31      Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/repl_03.dba
  34      Full 22040662009 04-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2968    Full    178.76G    DISK        01:53:03     05-JUL-13      
        BP Key: 2968   Status: AVAILABLE  Compressed: NO  Tag: TAG20130704T230140
        Piece Name: /backup01/RMAN/backbeodubb4_1_1
  List of Datafiles in backup set 2968
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  4       Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/users.257.809630783
  6       Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/users_02.dba
  13      Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/repl_02.dba
  16      Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_03.dba
  17      Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/system02
  21      Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/indx4m_05.dba
  26      Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_02.dba
  30      Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/indx_01.dba
  35      Full 22040662629 04-JUL-13 +AISTPSDATA/aistps/datafile/indx_07.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2969    Full    178.95G    DISK        01:53:31     05-JUL-13      
        BP Key: 2969   Status: AVAILABLE  Compressed: NO  Tag: TAG20130704T230140
        Piece Name: /backup01/RMAN/backbdodubat_1_1
  List of Datafiles in backup set 2969
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/system.282.809630937
  2       Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/sysaux.302.820008055
  5       Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/users_01.dba
  9       Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/users_05.dba
  18      Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/indx_02.dba
  22      Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/indx_04.dba
  27      Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/users_4m_03.dba
  32      Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/indx_05.dba
  36      Full 22040662328 04-JUL-13 +AISTPSDATA/aistps/datafile/indx_06.dba

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2970    Full    16.17M     DISK        00:00:17     05-JUL-13      
        BP Key: 2970   Status: AVAILABLE  Compressed: NO  Tag: TAG20130705T005533
        Piece Name: /backup01/CTRL/contc-90882830-20130705-00
  Control File Included: Ckp SCN: 22041087839   Ckp time: 05-JUL-13

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
2971    Full    16.17M     DISK        00:00:08     05-JUL-13      
        BP Key: 2971   Status: AVAILABLE  Compressed: NO  Tag: TAG20130705T005829
        Piece Name: /backup01/CTRL/contc-90882830-20130705-01
  Control File Included: Ckp SCN: 22041094148   Ckp time: 05-JUL-13

Recovery Manager complete.
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322437
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
... мда, многовато получилось...
впредь только в файле ..
вот лог после изменения scn
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322445
Фотография DВА
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Георгий7наверное вы правы, с SCN ошибся, но роли это тут не сыграет, если я убираб SET UNTIL, ла и если просто руками захожу и говорю restore database - появляются "левые" backup piece...


и где там "если я убираб SET UNTIL" ?
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322448
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
и где там "если я убираб SET UNTIL" ?

ё... виноват .... выкладываю
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322449
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
вот -без until
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322450
Фотография DВА
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
авторRMAN> run {
2> SET DBID = 90882830;
3> ALTER DATABASE MOUNT;
4> CONFIGURE DEVICE TYPE DISK PARALLELISM 4;
5> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup01/RMAN/back%U';
6> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;
7> CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR;
8> CONFIGURE CHANNEL 3 DEVICE TYPE DISK CLEAR;
9> CONFIGURE CHANNEL 4 DEVICE TYPE DISK CLEAR;
10> SET ARCHIVELOG DESTINATION TO '/backup01/ARCH';
11> SET UNTIL SCN=22041341609;
12> RESTORE DATABASE;
13> RECOVER DATABASE;
14> }
15>

попытайтесь еще раз ))))
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322455
Фотография DВА
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
channel ORA_DISK_4: reading from backup piece /backup01/RMAN/backbdodubat_1_1
channel ORA_DISK_1: ORA-19870: error while restoring backup piece /backup01/RMAN/backbfodubba_1_1
ORA-19504: failed to create file "+AISTPSDATA/aistps/datafile/users_4m_07.dba"
ORA-17502: ksfdcre:4 Failed to create file +AISTPSDATA/aistps/datafile/users_4m_07.dba
ORA-15041: diskgroup "AISTPSDATA" space exhausted

это не о чем не говорит?
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322456
Фотография DВА
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
failover to previous backup
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322460
irbis_al
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
RMAN> run {

2> SET DBID = 90882830;

3> ALTER DATABASE MOUNT;

4> CONFIGURE DEVICE TYPE DISK PARALLELISM 4;

5> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup01/RMAN/back%U';

6> CONFIGURE CHANNEL 1 DEVICE TYPE DISK CLEAR;

7> CONFIGURE CHANNEL 2 DEVICE TYPE DISK CLEAR;

8> CONFIGURE CHANNEL 3 DEVICE TYPE DISK CLEAR;

9> CONFIGURE CHANNEL 4 DEVICE TYPE DISK CLEAR;

10> SET ARCHIVELOG DESTINATION TO '/backup01/ARCH';

SWITCH DATAFILE ALL;
11> RESTORE DATABASE;

12> RECOVER DATABASE;

13> }

А добавьте вот это
SWITCH DATAFILE ALL;
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322461
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
теперь понял...
1.валится из-за места, понимает что не восстановила и обращается к предыдущему,
2. а уже там показывает "левые" куски ...

DBA - спасибо, очень выручил.
Надеюсь что ночевать не придется на работе ...
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38322462
Георгий7
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
SWITCH DATAFILE ALL;

- нет, это не помогает.., пойду искать место .
Спасибо DBA.
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #38323845
Фотография Aliona
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Участник
Кто вас такие скрипты научил писать?!

Зачем вы вкаждом скрипте переконфигурируете rman?
Почему не выполняете dalete obsolete?
В скрипте бэкапирования вы сконфигурировали автобэкап контрольник, но восстанавливаете его не из автобэкапа?

Написали сложные-непонятные скрипты и сами в них запутались.
...
Рейтинг: 0 / 0
Период между сообщениями больше года.
RMAN требует неизвестные backup piece
    #39412213
kabanasy
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
Здравствуйте. Есть проблема. Был когда-то сервер с оракловой базой, развернутый на обычном ПЭВМ, в один прекрасный момент полетел жесткий и случилось несчастье. К этому времени появилась возможность развернуть эту базу на вирталке на нормальном сервере. Базу восстановил, поднял, все работает, но существует проблема, при выполении резервного копирования по расписанию запуском батника rman ищет неизвестный ему backup piece по адресу E:\oracle\backup, хотя диска E на этой виртуалке уже нет давно, он был на старом ПЭВМ. В конфиге rman настроена уже другая директория куда складываются архивлоги и резервные копии. При всем этом, если подключиться rmanом и выполнить резервное копирование командой backup database, то оно выполняется без проблем. Ниже прилагаю результат выполнения резервного копирования.
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #39412219
kabanasy
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #39412254
Kumotori
Скрыть профиль Поместить в игнор-лист Сообщения автора в теме
Гость
kabanasy при выполении резервного копирования по расписанию запуском батника rman ищет неизвестный ему backup piece по адресу E:\oracle\backup,

Ты же рековер делаешь, а до бэкапа у тебя дело не доходит.
Сделай бэкап.
...
Рейтинг: 0 / 0
RMAN требует неизвестные backup piece
    #39412256
kabanasy,

копи-паст, конечно же, не работает? нужно было обязательно порвать монитор огромной картинкой?
...
Рейтинг: 0 / 0
25 сообщений из 25, страница 1 из 1
Форумы / Oracle [игнор отключен] [закрыт для гостей] / RMAN требует неизвестные backup piece
Найденые пользователи ...
Разблокировать пользователей ...
Читали форум (0):
Пользователи онлайн (0):
x
x
Закрыть


Просмотр
0 / 0
Close
Debug Console [Select Text]