There were no RMAN catalog and all
backups(archive log and DB file) information was not available in current
control file.
Summary of steps performed:
1.
To
check what is needed for restore+recovery. (asked to restored with
8thSep2014 Data until 1am) current date 29thSep.
2.
Restored
the old (backed-up) controlfile.
3.
Mounted
the DB with new controlfile and restored and recovered the DB.
PFB......
Login on the database:
$ export NLS_DATE_FORMAT='dd-mm-yyyy
hh24:mi:ss'
>>>>>>>>>(this
is important to set the time format)
$ rman target
/
>>>>>>>>>>>Connect
to RMAN
Recovery Manager: Release 11.2.0.3.0 -
Production on Mon Sep 29 14:55:56 2014
Copyright (c) 1982, 2011, Oracle and/or its
affiliates. All rights reserved.
connected to target database: CEDEV
(DBID=3677482209)
RMAN> list backup of database
summary;
>>>>>>>>>>>
check the backup summary
using target database control file instead of
recovery catalog
List of Backups
===============
Key TY LV S Device Type
Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------
------- ------- ---------- ---
3 B
0 A SBT_TAPE 22-08-2014 20:10:10
1 1
NO TAG20140822T200954
5 B
0 A SBT_TAPE 22-08-2014 20:10:29
1 1
NO TAG20140822T200954
7 B
0 A SBT_TAPE 22-08-2014 20:10:45
1 1
NO TAG20140822T200954
8 B
0 A SBT_TAPE 22-08-2014 20:11:05
1 1
NO TAG20140822T200954
13 B
0 A SBT_TAPE 23-08-2014 00:30:42 1
1 NO
TAG20140823T003025
15 B
0 A SBT_TAPE 23-08-2014 00:30:58
1 1
NO TAG20140823T003025
17 B
0 A SBT_TAPE 23-08-2014 00:31:10
1 1
NO TAG20140823T003025
18 B
0 A SBT_TAPE 23-08-2014 00:31:29
1 1
NO TAG20140823T003025
24 B
0 A SBT_TAPE 24-08-2014 00:30:49
1 1
NO TAG20140824T003031
26 B
0 A SBT_TAPE 24-08-2014 00:31:06
1 1
NO TAG20140824T003031
28 B
0 A SBT_TAPE 24-08-2014 00:31:13
1 1
NO TAG20140824T003031
29 B
0 A SBT_TAPE 24-08-2014 00:31:31
1 1
NO TAG20140824T003031
37 B
0 A SBT_TAPE 25-08-2014 00:30:41
1 1 NO
TAG20140825T003024
40 B
0 A SBT_TAPE 25-08-2014 00:31:09
1 1
NO TAG20140825T003024
41 B
0 A SBT_TAPE 25-08-2014 00:31:10
1 1
NO TAG20140825T003024
42 B
0 A SBT_TAPE 25-08-2014 00:31:28
1 1
NO
TAG20140825T003024
50 B
0 A SBT_TAPE 26-08-2014 00:30:47
1 1
NO TAG20140826T003027
53 B
0 A SBT_TAPE 26-08-2014 00:31:10
1 1
NO TAG20140826T003027
54 B
0 A SBT_TAPE 26-08-2014 00:31:22
1 1
NO TAG20140826T003027
55 B
0 A SBT_TAPE 26-08-2014 00:31:37
1 1
NO TAG20140826T003027
65 B
0 A SBT_TAPE 27-08-2014 00:30:45
1 1
NO TAG20140827T003027
68 B
0 A SBT_TAPE 27-08-2014 00:31:12
1 1
NO TAG20140827T003027
69 B
0 A SBT_TAPE 27-08-2014 00:31:26
1 1
NO TAG20140827T003027
70 B
0 A SBT_TAPE 27-08-2014 00:31:40
1 1
NO TAG20140827T003027
81 B
0 A SBT_TAPE 28-08-2014 00:30:45
1 1
NO TAG20140828T003027
84 B
0 A SBT_TAPE 28-08-2014 00:31:45
1 1
NO TAG20140828T003027
85 B
0 A SBT_TAPE 28-08-2014 00:31:58
1 1
NO TAG20140828T003027
86 B
0 A SBT_TAPE 28-08-2014 00:32:06
1 1
NO TAG20140828T003027
97 B
0 A SBT_TAPE 29-08-2014 00:30:44
1 1
NO TAG20140829T003028
99 B
0 A SBT_TAPE 29-08-2014 00:31:05
1 1
NO TAG20140829T003028
101 B 0 A
SBT_TAPE 29-08-2014 00:31:18
1 1
NO TAG20140829T003028
102 B 0 A
SBT_TAPE 29-08-2014 00:31:32
1 1
NO TAG20140829T003028
114 B 0 A
SBT_TAPE 30-08-2014 00:30:43
1 1
NO TAG20140830T003026
116 B 0 A
SBT_TAPE 30-08-2014 00:31:01
1 1
NO TAG20140830T003026
118 B 0 A
SBT_TAPE 30-08-2014 00:31:12
1 1
NO TAG20140830T003026
119 B 0 A
SBT_TAPE 30-08-2014 00:31:29
1 1
NO TAG20140830T003026
130 B 0 A
SBT_TAPE 31-08-2014 00:30:50
1 1
NO TAG20140831T003028
133 B 0 A
SBT_TAPE 31-08-2014 00:31:10
1 1
NO TAG20140831T003028
134 B 0 A
SBT_TAPE 31-08-2014 00:31:19
1 1
NO TAG20140831T003028
135 B 0 A
SBT_TAPE 31-08-2014 00:31:38
1 1
NO TAG20140831T003028
146 B 0 A
SBT_TAPE 01-09-2014 00:30:43
1 1
NO TAG20140901T003027
148 B 0 A
SBT_TAPE 01-09-2014 00:31:03
1 1
NO TAG20140901T003027
150 B 0 A
SBT_TAPE 01-09-2014 00:31:16
1 1
NO TAG20140901T003027
151 B 0 A
SBT_TAPE 01-09-2014 00:31:31
1 1
NO TAG20140901T003027
161 B 0 A
SBT_TAPE 02-09-2014 00:30:45
1 1
NO TAG20140902T003029
164 B 0 A
SBT_TAPE 02-09-2014 00:31:11 1
1
NO TAG20140902T003029
165 B 0 A
SBT_TAPE 02-09-2014 00:31:20
1 1
NO TAG20140902T003029
166 B 0 A
SBT_TAPE 02-09-2014 00:31:39
1 1
NO TAG20140902T003029
176 B 0 A
SBT_TAPE 03-09-2014 00:30:44
1 1
NO TAG20140903T003027
179 B 0 A
SBT_TAPE 03-09-2014 00:31:07
1 1
NO TAG20140903T003027
180 B 0 A
SBT_TAPE 03-09-2014 00:31:19
1 1
NO TAG20140903T003027
181 B 0 A
SBT_TAPE 03-09-2014 00:31:33
1 1
NO TAG20140903T003027
191 B 0 A
SBT_TAPE 04-09-2014 00:30:44
1 1
NO TAG20140904T003027
194 B 0 A
SBT_TAPE 04-09-2014 00:31:11 1
1 NO
TAG20140904T003027
195 B 0 A
SBT_TAPE 04-09-2014 00:31:20
1 1
NO TAG20140904T003027
196 B 0 A
SBT_TAPE 04-09-2014 00:31:37
1 1
NO TAG20140904T003027
205 B 0 A
SBT_TAPE 05-09-2014 00:30:45
1 1
NO TAG20140905T003027
208 B 0 A
SBT_TAPE 05-09-2014 00:31:15
1 1
NO TAG20140905T003027
209 B 0 A
SBT_TAPE 05-09-2014 00:31:30
1 1
NO TAG20140905T003027
210 B 0 A
SBT_TAPE 05-09-2014 00:31:44
1 1
NO TAG20140905T003027
219 B 0 A
SBT_TAPE 06-09-2014 00:30:47
1 1
NO TAG20140906T003028
222 B 0 A
SBT_TAPE 06-09-2014 00:31:15
1 1
NO TAG20140906T003028
223 B 0 A
SBT_TAPE 06-09-2014 00:31:27
1 1
NO TAG20140906T003028
224 B 0 A
SBT_TAPE 06-09-2014 00:31:48
1 1
NO TAG20140906T003028
233 B 0 A
SBT_TAPE 07-09-2014 00:30:45
1 1
NO TAG20140907T003026
236 B 0 A
SBT_TAPE 07-09-2014 00:31:12
1 1
NO TAG20140907T003026
237 B 0 A
SBT_TAPE 07-09-2014 00:31:23
1 1
NO TAG20140907T003026
238 B 0 A
SBT_TAPE 07-09-2014 00:31:45
1 1
NO TAG20140907T003026
248
B 0 A SBT_TAPE 08-09-2014 00:30:44
1 1
NO TAG20140908T003026
251
B 0 A SBT_TAPE 08-09-2014 00:31:15
1 1
NO TAG20140908T003026
252
B 0 A SBT_TAPE 08-09-2014 00:31:24
1 1
NO TAG20140908T003026
253
B 0 A SBT_TAPE 08-09-2014 00:31:46
1 1
NO TAG20140908T003026
264 B 0 A
SBT_TAPE 09-09-2014 00:30:51
1 1
NO TAG20140909T003028
267 B 0 A
SBT_TAPE 09-09-2014 00:31:22
1 1
NO TAG20140909T003028
268 B 0 A
SBT_TAPE 09-09-2014 00:31:36
1 1
NO TAG20140909T003028
269 B 0 A
SBT_TAPE 09-09-2014 00:32:00
1 1
NO TAG20140909T003028
280 B 0 A
SBT_TAPE 10-09-2014 00:30:56
1 1
NO TAG20140910T003042
283 B 0 A
SBT_TAPE 10-09-2014 00:31:38
1 1
NO TAG20140910T003042
284 B 0 A
SBT_TAPE 10-09-2014 00:31:55
1 1
NO TAG20140910T003042
285 B 0 A
SBT_TAPE 10-09-2014 00:32:07
1 1
NO TAG20140910T003042
296 B 0 A
SBT_TAPE 11-09-2014 00:30:43
1 1
NO TAG20140911T003030
299 B 0 A
SBT_TAPE 11-09-2014 00:31:16
1 1
NO TAG20140911T003030
300 B 0 A
SBT_TAPE 11-09-2014 00:31:32
1 1
NO TAG20140911T003030
301 B 0 A
SBT_TAPE 11-09-2014 00:31:50 1
1
NO TAG20140911T003030
313 B 0 A
SBT_TAPE 12-09-2014 00:30:45
1 1
NO TAG20140912T003030
316 B 0 A
SBT_TAPE 12-09-2014 00:31:46
1 1
NO TAG20140912T003030
317 B 0 A
SBT_TAPE 12-09-2014 00:32:16
1 1
NO TAG20140912T003030
318 B 0 A
SBT_TAPE 12-09-2014 00:32:31
1 1
NO TAG20140912T003030
328 B 0 A
SBT_TAPE 13-09-2014 00:30:42
1 1
NO TAG20140913T003029
331 B 0 A
SBT_TAPE 13-09-2014 00:31:22
1 1
NO TAG20140913T003029
332 B 0 A
SBT_TAPE 13-09-2014 00:31:41
1 1
NO TAG20140913T003029
333 B 0 A
SBT_TAPE 13-09-2014 00:31:55 1
1 NO
TAG20140913T003029
343 B 0 A
SBT_TAPE 14-09-2014 00:30:42
1 1
NO TAG20140914T003028
346 B 0 A
SBT_TAPE 14-09-2014 00:31:24
1 1
NO TAG20140914T003028
347 B 0 A
SBT_TAPE 14-09-2014 00:31:40
1 1
NO TAG20140914T003028
348 B 0 A
SBT_TAPE 14-09-2014 00:31:58
1 1
NO TAG20140914T003028
358 B 0 A
SBT_TAPE 15-09-2014 00:30:39
1 1
NO TAG20140915T003026
361 B 0 A
SBT_TAPE 15-09-2014 00:31:25
1 1
NO TAG20140915T003026
362 B 0 A
SBT_TAPE 15-09-2014 00:31:48
1 1
NO TAG20140915T003026
363 B 0 A
SBT_TAPE 15-09-2014 00:31:59
1 1 NO
TAG20140915T003026
373 B 0 A
SBT_TAPE 16-09-2014 00:30:44
1 1
NO TAG20140916T003030
376 B 0 A
SBT_TAPE 16-09-2014 00:31:32
1 1
NO TAG20140916T003030
377 B 0 A
SBT_TAPE 16-09-2014 00:32:05
1 1
NO
TAG20140916T003030
378 B 0 A
SBT_TAPE 16-09-2014 00:32:30
1 1
NO TAG20140916T003030
387 B 0 A
SBT_TAPE 17-09-2014 00:30:44
1 1
NO TAG20140917T003030
390 B 0 A
SBT_TAPE 17-09-2014 00:31:24
1 1
NO TAG20140917T003030
391 B 0 A
SBT_TAPE 17-09-2014 00:31:42
1 1
NO TAG20140917T003030
392 B 0 A
SBT_TAPE 17-09-2014 00:31:57
1 1
NO TAG20140917T003030
400 B 0 A
SBT_TAPE 18-09-2014 00:30:43
1 1
NO TAG20140918T003029
403 B 0 A
SBT_TAPE 18-09-2014 00:31:27
1 1
NO TAG20140918T003029
404 B 0 A
SBT_TAPE 18-09-2014 00:31:41
1 1
NO TAG20140918T003029
405 B 0 A
SBT_TAPE 18-09-2014 00:31:57
1 1
NO TAG20140918T003029
414 B 0 A
SBT_TAPE 19-09-2014 00:30:45
1 1
NO TAG20140919T003031
417 B 0 A
SBT_TAPE 19-09-2014 00:31:26 1
1
NO TAG20140919T003031
418 B 0 A
SBT_TAPE 19-09-2014 00:31:41
1 1
NO TAG20140919T003031
419 B 0 A
SBT_TAPE 19-09-2014 00:31:55
1 1
NO TAG20140919T003031
428 B 0 A
SBT_TAPE 20-09-2014 00:30:43
1 1
NO TAG20140920T003029
431 B 0 A
SBT_TAPE 20-09-2014 00:31:20
1 1
NO TAG20140920T003029
432 B 0 A
SBT_TAPE 20-09-2014 00:31:39
1 1
NO TAG20140920T003029
433 B 0 A
SBT_TAPE 20-09-2014 00:31:59
1 1
NO TAG20140920T003029
442 B 0 A
SBT_TAPE 21-09-2014 00:30:44
1 1
NO TAG20140921T003031
445 B 0 A
SBT_TAPE 21-09-2014 00:31:30
1 1 NO
TAG20140921T003031
446 B 0 A
SBT_TAPE 21-09-2014 00:31:52
1 1
NO TAG20140921T003031
447 B 0 A
SBT_TAPE 21-09-2014 00:32:02
1 1
NO TAG20140921T003031
456 B 0 A
SBT_TAPE 22-09-2014 00:30:44
1 1
NO TAG20140922T003030
459 B 0 A
SBT_TAPE 22-09-2014 00:31:40
1 1
NO TAG20140922T003030
460 B 0 A
SBT_TAPE 22-09-2014 00:32:05
1 1
NO TAG20140922T003030
461 B 0 A
SBT_TAPE 22-09-2014 00:32:18
1 1
NO TAG20140922T003030
469 B 0 A
SBT_TAPE 23-09-2014 00:30:43
1 1
NO TAG20140923T003029
472 B 0 A
SBT_TAPE 23-09-2014 00:31:29
1 1
NO TAG20140923T003029
473 B 0 A
SBT_TAPE 23-09-2014 00:31:52
1 1
NO TAG20140923T003029
474 B 0 A
SBT_TAPE 23-09-2014 00:32:04
1 1
NO TAG20140923T003029
483 B 0 A
SBT_TAPE 24-09-2014 00:30:46
1 1
NO TAG20140924T003032
486 B 0 A
SBT_TAPE 24-09-2014 00:31:29
1 1
NO TAG20140924T003032
487 B 0 A
SBT_TAPE 24-09-2014 00:31:57
1 1
NO TAG20140924T003032
488 B 0 A
SBT_TAPE 24-09-2014 00:32:04
1 1
NO TAG20140924T003032
497 B 0 A
SBT_TAPE 25-09-2014 00:30:42
1 1
NO TAG20140925T003028
500 B 0 A
SBT_TAPE 25-09-2014 00:31:28
1 1
NO TAG20140925T003028
501 B 0 A
SBT_TAPE 25-09-2014 00:31:46
1 1
NO TAG20140925T003028
502 B 0 A
SBT_TAPE 25-09-2014 00:32:05
1 1
NO TAG20140925T003028
511 B 0 A
SBT_TAPE 26-09-2014 00:30:44 1
1 NO
TAG20140926T003030
514 B 0 A
SBT_TAPE 26-09-2014 00:31:27
1 1
NO TAG20140926T003030
515 B 0 A
SBT_TAPE 26-09-2014 00:31:48
1 1
NO TAG20140926T003030
516 B 0 A
SBT_TAPE 26-09-2014 00:32:00
1 1
NO TAG20140926T003030
524 B 0 A
SBT_TAPE 29-09-2014 00:30:46
1 1
NO TAG20140929T003032
527 B 0 A
SBT_TAPE 29-09-2014 00:31:25
1 1
NO TAG20140929T003032
528 B 0 A
SBT_TAPE 29-09-2014 00:31:40
1 1
NO TAG20140929T003032
529 B 0 A
SBT_TAPE 29-09-2014 00:32:03
1 1
NO TAG20140929T003032
>>>>>>>>>>>>
We are asked to restore backup of 08-09-2014. We can see 4 pieces of backupsets
under TAG TAG20140908T003026
RMAN> list backup of database tag
TAG20140908T003026;
Listing the Backup of
Database in this TAG TAG20140908T003026
List of Backup Sets
===================
BS Key Type LV Size
Device Type Elapsed Time Completion Time
------- ---- -- ---------- -----------
------------ -------------------
248 Incr 0
276.50M SBT_TAPE
00:00:17 08-09-2014 00:30:44
BP
Key: 248 Status: AVAILABLE Compressed: NO Tag:
TAG20140908T003026
Handle: vvsl60110_CEDEV_online<CEDEV_255:857694627:1>.dbf
Media: 8ad0210a:539bc1d0:4058:0013
List of Datafiles in backup set 248
File LV Type Ckp SCN
Ckp Time Name
---- -- ---- ----------
------------------- ----
1 0 Incr
14208035 08-09-2014 00:30:27 /u03/oradata/CEDEV/system01.dbf
4 0 Incr
14208035 08-09-2014 00:30:27 /u04/oradata/CEDEV/users01.dbf
BS Key Type LV
Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- -----------
------------ -------------------
251 Incr 0
4.63G SBT_TAPE
00:00:48 08-09-2014 00:31:15
BP
Key: 251 Status: AVAILABLE Compressed: NO Tag:
TAG20140908T003026
Handle: vvsl60110_CEDEV_online<CEDEV_254:857694627:1>.dbf
Media: 8ad0210a:539bc0b9:3fc5:0013
List of Datafiles in backup set 251
File LV Type Ckp SCN
Ckp Time Name
---- -- ---- ----------
------------------- ----
2 0 Incr
14208034 08-09-2014 00:30:27 /u03/oradata/CEDEV/sysaux01.dbf
3 0 Incr
14208034 08-09-2014 00:30:27 /u04/oradata/CEDEV/undotbs01.dbf
BS Key Type LV
Size Device Type Elapsed Time Completion
Time
------- ---- -- ---------- -----------
------------ -------------------
252 Incr 0
3.21G SBT_TAPE
00:00:57 08-09-2014 00:31:24
BP
Key: 252 Status: AVAILABLE Compressed: NO Tag:
TAG20140908T003026
Handle: vvsl60110_CEDEV_online<CEDEV_253:857694627:1>.dbf
Media: 8ad0210a:539bc1c2:407d:000d
List of Datafiles in backup set 252
File LV Type Ckp SCN
Ckp Time Name
---- -- ---- ----------
------------------- ----
5 0 Incr
14208033 08-09-2014 00:30:27 /u03/oradata/CEDEV/users_large01.dbf
8 0 Incr 14208033
08-09-2014 00:30:27 /u04/oradata/CEDEV/indx_small01.dbf
BS Key Type LV
Size Device Type Elapsed Time Completion
Time
------- ---- -- ---------- -----------
------------ -------------------
253 Incr 0
13.50G SBT_TAPE
00:01:19 08-09-2014 00:31:46
BP
Key: 253 Status: AVAILABLE Compressed: NO Tag:
TAG20140908T003026
Handle: vvsl60110_CEDEV_online<CEDEV_252:857694627:1>.dbf
Media: 8ad0210a:539bc0b9:4021:0005
List of Datafiles in backup set 253
File LV Type Ckp SCN
Ckp Time Name
---- -- ---- ----------
------------------- ----
6 0 Incr
14208032 08-09-2014 00:30:27 /u03/oradata/CEDEV/users_small01.dbf
7 0 Incr
14208032 08-09-2014 00:30:27 /u04/oradata/CEDEV/indx_large01.dbf
RMAN> list backup of controlfile tag
TAG20140908T003026; >>>>>> Listing the Backup
of control file in this TAG TAG20140908T003026 . Luckily we have controlfile
backup in this Backup.
List of Backup Sets
===================
BS Key Type LV Size
Device Type Elapsed Time Completion Time
------- ---- -- ---------- -----------
------------ -------------------
249 Incr 0
19.25M SBT_TAPE
00:00:09 08-09-2014 00:31:01
BP
Key: 249 Status: AVAILABLE Compressed: NO Tag: TAG20140908T003026
Handle: vvsl60110_CEDEV_online<CEDEV_256:857694652:1>.dbf
Media: 8ad0210a:539bc1d0:4058:0013
Control File Included: Ckp SCN: 14208046
Ckp time: 08-09-2014 00:30:52
RMAN> list backup of archivelog all tag
TAG20140908T003026; >>>>>> Listing the Backup
of archivelog backup in the same TAG. We do not have any archivelog backup
info in this TAG
specification does not match any backup in the
repository
RMAN> list backup of archivelog scn between
14208032 and 14208046;
>>> here we
tried to find minimum archivelog needed for Recover the Database. We took SCN
from last backup file But no information found as we are
connected to current
controlfile and we do not have RMAN catalog
specification does not match any backup in the
repository
RMAN> list backup of archivelog all
summary;
<listing the backup of
archivelog . It shows that the latest backup of Archivelog backup tag is on
TAG20140913T050019 (13thSep)
List of Backups
===============
Key TY LV S Device Type
Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------
------- ------- ---------- ---
339
B A A SBT_TAPE 13-09-2014 05:00:52
1 1
NO TAG20140913T050019
340 B A A
SBT_TAPE 13-09-2014 05:00:52
1 1
NO TAG20140913T050019
341 B A A
SBT_TAPE 13-09-2014 05:00:59
1 1
NO TAG20140913T050019
350 B A A
SBT_TAPE 14-09-2014 05:00:35 1
1
NO TAG20140914T050019
351 B A A
SBT_TAPE 14-09-2014 05:00:37
1 1
NO TAG20140914T050019
352 B A A
SBT_TAPE 14-09-2014 05:00:45
1 1
NO TAG20140914T050019
353 B A A
SBT_TAPE 14-09-2014 05:00:46
1 1
NO TAG20140914T050019
354 B A A
SBT_TAPE 14-09-2014 05:00:53
1 1
NO TAG20140914T050019
355 B A A
SBT_TAPE 14-09-2014 05:00:54
1 1
NO TAG20140914T050019
356 B A A
SBT_TAPE 14-09-2014 05:01:00
1 1
NO TAG20140914T050019
365 B A A
SBT_TAPE 15-09-2014 05:00:33
1 1
NO TAG20140915T050018
366 B A A
SBT_TAPE 15-09-2014 05:00:33
1 1
NO TAG20140915T050018
367 B A A
SBT_TAPE 15-09-2014 05:00:42
1 1
NO TAG20140915T050018
368 B A A
SBT_TAPE 15-09-2014 05:00:43
1 1
NO TAG20140915T050018
369 B A A
SBT_TAPE 15-09-2014 05:00:50
1 1
NO TAG20140915T050018
370 B A A
SBT_TAPE 15-09-2014 05:00:50
1 1
NO TAG20140915T050018
371 B A A
SBT_TAPE 15-09-2014 05:00:57
1 1
NO TAG20140915T050018
380 B A A
SBT_TAPE 16-09-2014 05:00:33
1 1
NO TAG20140916T050018
381 B A A
SBT_TAPE 16-09-2014 05:00:37
1 1
NO TAG20140916T050018
382 B A A
SBT_TAPE 16-09-2014 05:00:42
1 1
NO TAG20140916T050018
383 B A A
SBT_TAPE 16-09-2014 05:00:46
1 1
NO TAG20140916T050018
384 B A A
SBT_TAPE 16-09-2014 05:00:52
1 1
NO TAG20140916T050018
385 B A A
SBT_TAPE 16-09-2014 05:00:54
1 1
NO TAG20140916T050018
394 B A A
SBT_TAPE 17-09-2014 05:00:32
1 1
NO TAG20140917T050017
395 B A A
SBT_TAPE 17-09-2014 05:00:32
1 1
NO TAG20140917T050017
396 B A A
SBT_TAPE 17-09-2014 05:00:42
1 1
NO TAG20140917T050017
397 B A A
SBT_TAPE 17-09-2014 05:00:42
1 1
NO TAG20140917T050017
398 B A A
SBT_TAPE 17-09-2014 05:00:49
1 1
NO TAG20140917T050017
407 B A A
SBT_TAPE 18-09-2014 05:00:30
1 1
NO TAG20140918T050016
408 B A A
SBT_TAPE 18-09-2014 05:00:31 1
1
NO TAG20140918T050016
409 B A A
SBT_TAPE 18-09-2014 05:00:40
1 1
NO TAG20140918T050016
410 B A A
SBT_TAPE 18-09-2014 05:00:40
1 1
NO TAG20140918T050016
411 B A A
SBT_TAPE 18-09-2014 05:00:47
1 1
NO TAG20140918T050016
412 B A A
SBT_TAPE 18-09-2014 05:00:48
1 1
NO TAG20140918T050016
421 B A A
SBT_TAPE 19-09-2014 05:00:30
1 1
NO TAG20140919T050015
422 B A A
SBT_TAPE 19-09-2014 05:00:30
1 1
NO TAG20140919T050015
423 B A A
SBT_TAPE 19-09-2014 05:00:38
1 1
NO TAG20140919T050015
424 B A A
SBT_TAPE 19-09-2014 05:00:39
1 1
NO TAG20140919T050015
425 B A A
SBT_TAPE 19-09-2014 05:00:46
1 1
NO TAG20140919T050015
426 B A A
SBT_TAPE 19-09-2014 05:00:47
1 1
NO TAG20140919T050015
435 B A A
SBT_TAPE 20-09-2014 05:00:34
1 1
NO TAG20140920T050020
436 B A A
SBT_TAPE 20-09-2014 05:00:34
1 1
NO TAG20140920T050020
437 B A A
SBT_TAPE 20-09-2014 05:00:44
1 1
NO TAG20140920T050020
438 B A A
SBT_TAPE 20-09-2014 05:00:44
1 1
NO TAG20140920T050020
439 B A A
SBT_TAPE 20-09-2014 05:00:51
1 1
NO TAG20140920T050020
440 B A A
SBT_TAPE 20-09-2014 05:00:51
1 1
NO TAG20140920T050020
449 B A A
SBT_TAPE 21-09-2014 05:00:31
1 1
NO TAG20140921T050017
450 B A A
SBT_TAPE 21-09-2014 05:00:35
1 1
NO TAG20140921T050017
451 B A A
SBT_TAPE 21-09-2014 05:00:40
1 1
NO
TAG20140921T050017
452 B A A
SBT_TAPE 21-09-2014 05:00:44
1 1
NO TAG20140921T050017
453 B A A
SBT_TAPE 21-09-2014 05:00:46
1 1
NO TAG20140921T050017
454 B A A
SBT_TAPE 21-09-2014 05:00:51
1 1
NO TAG20140921T050017
463 B A A
SBT_TAPE 22-09-2014 05:00:34
1 1
NO TAG20140922T050020
464 B A A
SBT_TAPE 22-09-2014 05:00:35
1 1
NO TAG20140922T050020
465 B A A
SBT_TAPE 22-09-2014 05:00:45
1 1
NO TAG20140922T050020
466 B A A
SBT_TAPE 22-09-2014 05:00:45
1 1
NO TAG20140922T050020
467 B A A
SBT_TAPE 22-09-2014 05:01:01
1 1
NO TAG20140922T050020
476 B A A
SBT_TAPE 23-09-2014 05:00:32
1 1
NO TAG20140923T050018
477 B A A
SBT_TAPE 23-09-2014 05:00:36
1 1
NO TAG20140923T050018
478 B A A
SBT_TAPE 23-09-2014 05:00:41 1
1
NO TAG20140923T050018
479 B A A
SBT_TAPE 23-09-2014 05:00:45 1
1
NO TAG20140923T050018
480 B A A
SBT_TAPE 23-09-2014 05:00:48
1 1
NO TAG20140923T050018
481 B A A
SBT_TAPE 23-09-2014 05:00:57
1 1
NO TAG20140923T050018
490 B A A
SBT_TAPE 24-09-2014 05:00:33
1 1
NO TAG20140924T050019
491 B A A
SBT_TAPE 24-09-2014 05:00:34
1 1
NO TAG20140924T050019
492 B A A
SBT_TAPE 24-09-2014 05:00:43
1 1
NO TAG20140924T050019
493 B A A
SBT_TAPE 24-09-2014 05:00:44
1 1
NO TAG20140924T050019
494 B A A
SBT_TAPE 24-09-2014 05:00:51
1 1 NO
TAG20140924T050019
495 B A A
SBT_TAPE 24-09-2014 05:00:52
1 1 NO
TAG20140924T050019
504 B A A
SBT_TAPE 25-09-2014 05:00:35
1 1
NO TAG20140925T050019
505 B A A
SBT_TAPE 25-09-2014 05:00:35
1 1
NO TAG20140925T050019
506 B A A
SBT_TAPE 25-09-2014 05:00:43
1 1
NO TAG20140925T050019
507 B A A
SBT_TAPE 25-09-2014 05:00:45
1 1
NO TAG20140925T050019
508 B A A
SBT_TAPE 25-09-2014 05:00:51
1 1
NO TAG20140925T050019
509 B A A
SBT_TAPE 25-09-2014 05:00:52
1 1
NO TAG20140925T050019
518 B A A
SBT_TAPE 26-09-2014 05:00:32
1 1
NO TAG20140926T050018
519 B A A
SBT_TAPE 26-09-2014 05:00:33
1 1
NO TAG20140926T050018
520 B A A
SBT_TAPE 26-09-2014 05:00:42
1 1
NO TAG20140926T050018
521 B A A
SBT_TAPE 26-09-2014 05:00:43
1 1
NO TAG20140926T050018
522 B A A
SBT_TAPE 26-09-2014 05:00:50
1 1
NO TAG20140926T050018
531 B A A
SBT_TAPE 29-09-2014 05:00:30
1 1
NO TAG20140929T050016
532 B A A
SBT_TAPE 29-09-2014 05:00:31
1 1
NO TAG20140929T050016
533 B A A
SBT_TAPE 29-09-2014 05:00:40
1 1
NO TAG20140929T050016
534 B A A
SBT_TAPE 29-09-2014 05:00:41
1 1
NO TAG20140929T050016
535 B A A
SBT_TAPE 29-09-2014 05:00:48
1 1
NO TAG20140929T050016
536 B A A
SBT_TAPE 29-09-2014 05:00:48
1 1
NO TAG20140929T050016
537 B A A
SBT_TAPE 29-09-2014 05:00:56
1 1
NO TAG20140929T050016
RMAN> list backup of archivelog sequence
1595;
(From V$archived_log) we
can see the log SEQ of time we need the recovery(until Time)
specification does not match any backup in the
repository
RMAN> list backup of archivelog all tag
TAG20140913T050019;
the backup which happened on 13th, we are looking if its contains
the archivelogs.
List of Backup Sets
===================
BS Key
Size Device Type Elapsed Time Completion
Time
k------- ---------- ----------- ------------
-------------------
339
184.50M SBT_TAPE
00:00:07 13-09-2014 05:00:52
BP
Key: 339 Status: AVAILABLE Compressed: NO Tag:
TAG20140913T050019
Handle:
vvsl60110_CEDEV_arch<CEDEV_343:858142845:1>.dbf Media:
8ad0210a:539bc0b9:3fc5:0013
List of Archived Logs in backup set 339
Thrd Seq Low
SCN Low
Time Next
SCN Next Time
---- ------- ----------
------------------- ---------- ---------
1
1694 14536095 10-09-2014 01:01:47
14536807 10-09-2014
01:31:49
1
1695 14536807 10-09-2014 01:31:49
14537723 10-09-2014 02:01:47
1
1696 14537723 10-09-2014 02:01:47
14538633 10-09-2014 02:31:50
1
1698 14539654 10-09-2014 03:01:49
14540572 10-09-2014 03:31:49
1
1699 14540572 10-09-2014 03:31:49
14541459 10-09-2014 04:01:49
1
1700 14541459 10-09-2014 04:01:49
14542275 10-09-2014 04:31:48
1
1701 14542275 10-09-2014 04:31:48
14542971 10-09-2014 05:00:15
1
1702 14542971 10-09-2014 05:00:15
14542980 10-09-2014 05:00:15
1
1703 14542980 10-09-2014 05:00:15
14544037 10-09-2014 05:30:13
1
1705 14544952 10-09-2014 06:00:15
14545748 10-09-2014 06:30:15
1
1706 14545748 10-09-2014 06:30:15
14546594 10-09-2014 07:00:14
1
1707 14546594 10-09-2014 07:00:14
14547365 10-09-2014 07:30:16
1
1708 14547365 10-09-2014 07:30:16
14548245 10-09-2014 08:00:16
1
1709 14548245 10-09-2014 08:00:16
14549029 10-09-2014 08:30:15
1
1710 14549029 10-09-2014 08:30:15
14549921 10-09-2014 09:00:17
1
1711 14549921 10-09-2014 09:00:17
14550700 10-09-2014 09:30:16
1
1712 14550700 10-09-2014 09:30:16
14551590 10-09-2014 10:00:16
1
1713 14551590 10-09-2014 10:00:16 14552411
10-09-2014 10:30:18
1
1714 14552411 10-09-2014 10:30:18
14553295 10-09-2014 11:00:17
1
1715 14553295 10-09-2014 11:00:17
14554092 10-09-2014 11:30:16
1
1716 14554092 10-09-2014 11:30:16
14554973 10-09-2014 12:00:19
1
1717 14554973 10-09-2014 12:00:19
14555773 10-09-2014 12:30:18
1
1719 14556757 10-09-2014 13:00:17
14557808 10-09-2014 13:30:19
1
1721 14558828 10-09-2014 14:00:18
14559596 10-09-2014 14:30:18
1 1723
14560726 10-09-2014 15:00:20 14561559 10-09-2014
15:30:19
1
1724 14561559 10-09-2014 15:30:19
14562491 10-09-2014 16:00:21
1
1725 14562491 10-09-2014 16:00:21
14563205 10-09-2014 16:30:27
1
1726 14563205 10-09-2014 16:30:27 14564105
10-09-2014 17:00:26
1
1727 14564105 10-09-2014 17:00:26
14564927 10-09-2014 17:30:25
1
1728 14564927 10-09-2014 17:30:25
14565861 10-09-2014 18:00:27
1
1729 14565861 10-09-2014 18:00:27
14566574 10-09-2014 18:30:27
1
1730 14566574 10-09-2014 18:30:27
14567440 10-09-2014 19:00:27
1
1731 14567440 10-09-2014 19:00:27
14568222 10-09-2014 19:30:26
1
1732 14568222 10-09-2014 19:30:26
14569110 10-09-2014 20:00:29
1
1733 14569110 10-09-2014 20:00:29
14569863 10-09-2014 20:30:28
1
1734 14569863 10-09-2014 20:30:28
14570588 10-09-2014 21:00:28
1
1735 14570588 10-09-2014 21:00:28
14571567 10-09-2014 21:30:30
1
1740 14605465 10-09-2014 23:30:30 14606266
11-09-2014 00:00:30
1
1742 14614049 11-09-2014 00:30:30
14614782 11-09-2014 01:00:30
1
1744 14616075 11-09-2014 01:30:33
14616802 11-09-2014 02:00:39
1
1746 14617878 11-09-2014 02:30:37
14618633 11-09-2014 03:00:39
1
1747 14618633 11-09-2014 03:00:39
14619793 11-09-2014 03:30:37
1
1748 14619793 11-09-2014 03:30:37
14620459 11-09-2014 04:00:37
1
1749 14620459 11-09-2014 04:00:37
14621553 11-09-2014 04:30:40
1
1750 14621553 11-09-2014 04:30:40
14622246 11-09-2014 05:00:17
1
1751 14622246 11-09-2014 05:00:17
14622255 11-09-2014 05:00:18
1
1753 14623337 11-09-2014 05:30:15
14624011 11-09-2014 06:00:15
1
1754 14624011 11-09-2014 06:00:15
14625038 11-09-2014 06:30:15
1
1755 14625038 11-09-2014 06:30:15
14625935 11-09-2014 07:00:15
1
1756 14625935 11-09-2014 07:00:15
14626733 11-09-2014 07:30:15
BS Key
Size Device Type Elapsed Time Completion
Time
------- ---------- ----------- ------------
-------------------
340
190.50M SBT_TAPE
00:00:06 13-09-2014 05:00:52
BP
Key: 340 Status: AVAILABLE Compressed: NO Tag:
TAG20140913T050019
Handle: vvsl60110_CEDEV_arch<CEDEV_344:858142846:1>.dbf
Media: 8ad0210a:539bc0b9:4021:0005
List of Archived Logs in backup set 340
Thrd Seq Low
SCN Low
Time Next
SCN Next Time
---- ------- ----------
------------------- ---------- ---------
1
1757 14626733 11-09-2014 07:30:15
14627636 11-09-2014 08:00:15
1
1758 14627636 11-09-2014 08:00:15
14628445 11-09-2014 08:30:18
1
1759 14628445 11-09-2014 08:30:18
14629310 11-09-2014 09:00:19
1
1760 14629310 11-09-2014 09:00:19 14630161
11-09-2014 09:30:19
1
1761 14630161 11-09-2014 09:30:19
14631082 11-09-2014 10:00:19
1
1762 14631082 11-09-2014 10:00:19
14632367 11-09-2014 10:30:18
1
1763 14632367 11-09-2014 10:30:18
14633532 11-09-2014 11:00:18
1
1764 14633532 11-09-2014 11:00:18
14634811 11-09-2014 11:30:18
1
1765 14634811 11-09-2014 11:30:18
14635961 11-09-2014 12:00:19
1
1766 14635961 11-09-2014 12:00:19
14636758 11-09-2014 12:30:19
1
1767 14636758 11-09-2014 12:30:19
14637574 11-09-2014 13:00:19
1 1768
14637574 11-09-2014 13:00:19 14638607 11-09-2014
13:30:19
1
1769 14638607 11-09-2014 13:30:19
14639299 11-09-2014 14:00:21
1
1770 14639299 11-09-2014 14:00:21 14640316
11-09-2014 14:30:21
1
1771 14640316 11-09-2014 14:30:21
14640975 11-09-2014 15:00:21
1
1772 14640975 11-09-2014 15:00:21
14642052 11-09-2014 15:30:21
1
1773 14642052 11-09-2014 15:30:21
14642892 11-09-2014 16:00:21
1
1774 14642892 11-09-2014 16:00:21
14644809 11-09-2014 16:30:21
1
1775 14644809 11-09-2014 16:30:21
14645485 11-09-2014 17:00:21
1
1776 14645485 11-09-2014 17:00:21
14646617 11-09-2014 17:30:21
1
1777 14646617 11-09-2014 17:30:21
14647301 11-09-2014 18:00:22
1
1778 14647301 11-09-2014 18:00:22
14648320 11-09-2014 18:30:22
1
1779 14648320 11-09-2014 18:30:22
14648992 11-09-2014 19:00:22
1
1780 14648992 11-09-2014 19:00:22 14649991
11-09-2014 19:30:23
1
1781 14649991 11-09-2014 19:30:23
14650660 11-09-2014 20:00:23
1
1782 14650660 11-09-2014 20:00:23
14651655 11-09-2014 20:30:23
1
1783 14651655 11-09-2014 20:30:23
14652389 11-09-2014 21:00:24
1
1784 14652389 11-09-2014 21:00:24
14653406 11-09-2014 21:30:24
1
1785 14653406 11-09-2014 21:30:24
14662095 11-09-2014 22:00:27
1
1786 14662095 11-09-2014 22:00:27
14670855 11-09-2014 22:30:24
1
1787 14670855 11-09-2014 22:30:24
14672741 11-09-2014 23:00:24
1
1788 14672741 11-09-2014 23:00:24
14674564 11-09-2014 23:30:24
1
1789 14674564 11-09-2014 23:30:24
14675308 12-09-2014 00:00:24
1
1790 14675308 12-09-2014 00:00:24 14685644
12-09-2014 00:30:27
1
1791 14685644 12-09-2014 00:30:27
14686377 12-09-2014 01:00:26
1
1792 14686377 12-09-2014 01:00:26
14687642 12-09-2014 01:30:26
1
1793 14687642 12-09-2014 01:30:26
14688347 12-09-2014 02:00:26
1
1794 14688347 12-09-2014 02:00:26
14689443 12-09-2014 02:30:27
1
1795 14689443 12-09-2014 02:30:27
14690415 12-09-2014 03:00:27
1
1796 14690415 12-09-2014 03:00:27
14691293 12-09-2014 03:30:26
1
1797 14691293 12-09-2014 03:30:26
14692194 12-09-2014 04:00:28
1
1798 14692194 12-09-2014 04:00:28
14693035 12-09-2014 04:30:28
1
1799 14693035 12-09-2014 04:30:28
14694034 12-09-2014 05:00:17
1
1800 14694034 12-09-2014 05:00:17
14694043 12-09-2014 05:00:17
1
1801 14694043 12-09-2014 05:00:17
14694890 12-09-2014 05:30:15
1
1802 14694890 12-09-2014 05:30:15
14695804 12-09-2014 06:00:16
1
1803 14695804 12-09-2014 06:00:16
14696623 12-09-2014 06:30:16
1
1804 14696623 12-09-2014 06:30:16
14697502 12-09-2014 07:00:19
1
1805 14697502 12-09-2014 07:00:19
14698307 12-09-2014 07:30:19
1
1806 14698307 12-09-2014 07:30:19
14699192 12-09-2014 08:00:19
1 1807
14699192 12-09-2014 08:00:19 14700011 12-09-2014
08:30:19
1
1808 14700011 12-09-2014 08:30:19
14700778 12-09-2014 09:00:19
1 1809
14700778 12-09-2014 09:00:19 14701707
12-09-2014 09:30:19
1
1810 14701707 12-09-2014 09:30:19
14702484 12-09-2014 10:00:19
1
1811 14702484 12-09-2014 10:00:19
14703671 12-09-2014 10:30:19
1
1812 14703671 12-09-2014 10:30:19
14704433 12-09-2014 11:00:19
1
1813 14704433 12-09-2014 11:00:19
14705587 12-09-2014 11:30:19
1
1814 14705587 12-09-2014 11:30:19
14706338 12-09-2014 12:00:19
1
1815 14706338 12-09-2014 12:00:19
14707725 12-09-2014 12:30:19
1 1816
14707725 12-09-2014 12:30:19 14708586 12-09-2014
13:00:19
1 1817
14708586 12-09-2014 13:00:19 14709749 12-09-2014
13:30:22
1
1818 14709749 12-09-2014 13:30:22
14710463 12-09-2014 14:00:29
1 1819
14710463 12-09-2014 14:00:29 14711735
12-09-2014 14:30:29
1
1820 14711735 12-09-2014 14:30:29
14712498 12-09-2014 15:00:29
BS Key
Size Device Type Elapsed Time Completion
Time
------- ---------- ----------- ------------
-------------------
341
154.50M SBT_TAPE
00:00:06 13-09-2014 05:00:59
BP
Key: 341 Status: AVAILABLE Compressed: NO Tag:
TAG20140913T050019
Handle: vvsl60110_CEDEV_arch<CEDEV_345:858142853:1>.dbf
Media: 8ad0210a:539bc0b9:4021:0005
List of Archived Logs in backup set 341
Thrd Seq Low
SCN Low
Time Next SCN
Next Time
---- ------- ----------
------------------- ---------- ---------
1
1821 14712498 12-09-2014 15:00:29
14713850 12-09-2014 15:30:29
1
1822 14713850 12-09-2014 15:30:29
14714740 12-09-2014 16:00:29
1
1823 14714740 12-09-2014 16:00:29
14716417 12-09-2014 16:30:29
1
1824 14716417 12-09-2014 16:30:29
14717408 12-09-2014 17:00:29
1
1825 14717408 12-09-2014 17:00:29
14718570 12-09-2014 17:30:29
1
1826 14718570 12-09-2014 17:30:29 14719236
12-09-2014 18:00:29
1
1827 14719236 12-09-2014 18:00:29
14720273 12-09-2014 18:30:30
1
1828 14720273 12-09-2014 18:30:30
14720944 12-09-2014 19:00:30
1
1829 14720944 12-09-2014 19:00:30
14721952 12-09-2014 19:30:30
1
1830 14721952 12-09-2014 19:30:30
14722613 12-09-2014 20:00:30
1
1831 14722613 12-09-2014 20:00:30
14723629 12-09-2014 20:30:30
1
1832 14723629 12-09-2014 20:30:30
14724322 12-09-2014 21:00:31
1
1833 14724322 12-09-2014 21:00:31
14725355 12-09-2014 21:30:31
1
1834 14725355 12-09-2014 21:30:31
14735755 12-09-2014 22:00:34
1
1835 14735755 12-09-2014 22:00:34
14743204 12-09-2014 22:30:32
1
1836 14743204 12-09-2014 22:30:32
14743918 12-09-2014 23:00:32
1
1837 14743918 12-09-2014 23:00:32
14746262 12-09-2014 23:30:32
1
1838 14746262 12-09-2014 23:30:32
14747206 13-09-2014 00:00:32
1
1839 14747206 13-09-2014 00:00:32
14754906 13-09-2014 00:30:32
1
1840 14754906 13-09-2014 00:30:32
14756053 13-09-2014 01:00:32
1
1841 14756053 13-09-2014 01:00:32
14756881 13-09-2014 01:30:33
1
1842 14756881 13-09-2014 01:30:33
14757833 13-09-2014 02:00:33
1
1843 14757833 13-09-2014 02:00:33
14758782 13-09-2014 02:30:33
1
1844 14758782 13-09-2014 02:30:33
14759747 13-09-2014 03:00:36
1
1845 14759747 13-09-2014 03:00:36
14760701 13-09-2014 03:30:36
1
1846 14760701 13-09-2014 03:30:36
14761669 13-09-2014 04:00:36
1
1847 14761669 13-09-2014 04:00:36
14762468 13-09-2014 04:30:36
1
1848 14762468 13-09-2014 04:30:36
14763451 13-09-2014 05:00:18
1
1849 14763451 13-09-2014 05:00:18 14763460
13-09-2014 05:00:18
RMAN> list backup of archivelog sequence
1596;
from v$archived_log we
check that we need 1596 seq.
List of Backup Sets
===================
BS Key
Size Device Type Elapsed Time Completion
Time
------- ---------- ----------- ------------
-------------------
351
415.75M SBT_TAPE
00:00:16 14-09-2014 05:00:37
BP
Key: 351 Status: AVAILABLE Compressed: NO Tag:
TAG20140914T050019
Handle: vvsl60110_CEDEV_arch<CEDEV_354:858229221:1>.dbf
Media: 8ad0210a:539bc1c2:407d:000d
List of Archived Logs in backup set 351
Thrd Seq Low
SCN Low
Time Next
SCN Next Time
---- ------- ---------- -------------------
---------- ---------
1
1596 14216015 08-09-2014 05:00:18
14216826 08-09-2014 05:30:17
RMAN> list backup of controlfile
summary;
to check backup of controlfile
List of Backups
===============
Key TY LV S Device Type
Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------
------- ------- ---------- ---
1 B
0 A SBT_TAPE 22-08-2014 19:58:45
1 1
NO TAG20140822T195834
4 B 0
A SBT_TAPE 22-08-2014 20:10:26
1 1
NO TAG20140822T200954
9 B
F A SBT_TAPE 22-08-2014 20:11:20
1 1
NO TAG20140822T201114
12 B
F A SBT_TAPE 22-08-2014 20:16:42
1 1
NO TAG20140822T201636
14 B
0 A SBT_TAPE 23-08-2014 00:30:57
1 1
NO TAG20140823T003025
19 B
F A SBT_TAPE 23-08-2014 00:31:40
1 1
NO TAG20140823T003134
23 B
F A SBT_TAPE 23-08-2014 05:00:43
1 1
NO TAG20140823T050037
25 B
0 A SBT_TAPE 24-08-2014 00:31:01
1 1
NO TAG20140824T003031
30 B
F A SBT_TAPE 24-08-2014 00:31:46
1 1
NO TAG20140824T003140
36 B
F A SBT_TAPE 24-08-2014 05:01:22
1 1
NO TAG20140824T050116
38 B
0 A SBT_TAPE 25-08-2014 00:30:55
1 1
NO TAG20140825T003024
43 B
F A SBT_TAPE 25-08-2014 00:31:39
1 1
NO TAG20140825T003133
49 B
F A SBT_TAPE 25-08-2014 05:01:22
1 1
NO TAG20140825T050116
51 B
0 A SBT_TAPE 26-08-2014 00:30:59
1 1
NO
TAG20140826T003027
56 B
F A SBT_TAPE 26-08-2014 00:31:53
1 1
NO TAG20140826T003147
64 B
F A SBT_TAPE 26-08-2014 05:01:30
1 1
NO TAG20140826T050124
66 B
0 A SBT_TAPE 27-08-2014 00:31:00
1 1
NO TAG20140827T003027
71 B
F A SBT_TAPE 27-08-2014 00:31:52
1 1
NO TAG20140827T003147
80 B
F A SBT_TAPE 27-08-2014 05:01:37
1 1
NO TAG20140827T050132
82 B
0 A SBT_TAPE 28-08-2014 00:31:00
1 1
NO TAG20140828T003027
87 B
F A SBT_TAPE 28-08-2014 00:32:13
1 1
NO TAG20140828T003207
96 B
F A SBT_TAPE 28-08-2014 05:01:28
1 1
NO TAG20140828T050124
98 B
0 A SBT_TAPE 29-08-2014 00:30:59
1 1
NO TAG20140829T003028
103 B F A
SBT_TAPE 29-08-2014 00:31:43
1 1
NO TAG20140829T003137
113 B F A
SBT_TAPE 29-08-2014 05:01:46 1
1
NO TAG20140829T050140
115 B 0 A
SBT_TAPE 30-08-2014 00:30:57
1 1
NO TAG20140830T003026
120 B F A
SBT_TAPE 30-08-2014 00:31:40
1 1
NO TAG20140830T003135
129 B F A
SBT_TAPE 30-08-2014 05:01:30
1 1
NO TAG20140830T050124
131 B 0 A
SBT_TAPE 31-08-2014 00:31:00
1 1
NO TAG20140831T003028
136 B F A
SBT_TAPE 31-08-2014 00:31:54
1 1
NO TAG20140831T003147
145 B F A
SBT_TAPE 31-08-2014 05:01:31
1 1
NO TAG20140831T050125
147 B 0 A
SBT_TAPE 01-09-2014 00:30:59
1 1
NO TAG20140901T003027
152 B F A
SBT_TAPE 01-09-2014 00:31:42
1 1
NO TAG20140901T003137
160 B F A
SBT_TAPE 01-09-2014 05:02:02
1 1
NO TAG20140901T050157
162 B 0 A
SBT_TAPE 02-09-2014 00:31:01
1 1
NO TAG20140902T003029
167 B F A
SBT_TAPE 02-09-2014 00:31:55
1 1
NO TAG20140902T003149
175 B F A
SBT_TAPE 02-09-2014 05:01:34
1 1
NO TAG20140902T050127
177 B 0 A
SBT_TAPE 03-09-2014 00:30:59
1 1
NO TAG20140903T003027
182 B F A
SBT_TAPE 03-09-2014 00:31:43
1 1
NO TAG20140903T003137
190 B F A
SBT_TAPE 03-09-2014 05:01:28
1 1
NO TAG20140903T050122
192 B 0 A
SBT_TAPE 04-09-2014 00:30:59
1 1
NO TAG20140904T003027
197 B F A
SBT_TAPE 04-09-2014 00:31:52
1 1
NO TAG20140904T003147
204 B F A
SBT_TAPE 04-09-2014 05:01:24
1 1
NO TAG20140904T050118
206 B 0 A
SBT_TAPE 05-09-2014 00:31:02
1 1
NO
TAG20140905T003027
211 B F A
SBT_TAPE 05-09-2014 00:31:55
1 1
NO TAG20140905T003149
218 B F A
SBT_TAPE 05-09-2014 05:01:25
1 1
NO TAG20140905T050120
220 B 0 A
SBT_TAPE 06-09-2014 00:31:02
1 1
NO TAG20140906T003028
225 B F A
SBT_TAPE 06-09-2014 00:31:56
1 1
NO TAG20140906T003151
232 B F A
SBT_TAPE 06-09-2014 05:01:53
1 1
NO TAG20140906T050147
234 B 0 A
SBT_TAPE 07-09-2014 00:31:01
1 1
NO TAG20140907T003026
239 B F A
SBT_TAPE 07-09-2014 00:31:54
1 1
NO TAG20140907T003148
247 B F A
SBT_TAPE 07-09-2014 05:01:39
1 1
NO TAG20140907T050133
249 B 0 A
SBT_TAPE 08-09-2014 00:31:01
1 1
NO TAG20140908T003026
254 B F A
SBT_TAPE 08-09-2014 00:31:55
1 1
NO TAG20140908T003149
263
B F A SBT_TAPE 08-09-2014 05:01:34
1 1
NO TAG20140908T050128
265 B 0 A
SBT_TAPE 09-09-2014 00:31:07 1
1
NO TAG20140909T003028
270 B F A
SBT_TAPE 09-09-2014 00:32:10
1 1
NO TAG20140909T003205
279 B F A
SBT_TAPE 09-09-2014 05:01:30
1 1
NO TAG20140909T050124
281 B 0 A
SBT_TAPE 10-09-2014 00:31:06
1 1
NO TAG20140910T003042
286 B F A
SBT_TAPE 10-09-2014 00:32:20
1 1
NO TAG20140910T003215
295 B F A
SBT_TAPE 10-09-2014 05:01:38
1 1
NO TAG20140910T050133
297 B 0 A
SBT_TAPE 11-09-2014 00:30:51
1 1
NO TAG20140911T003030
302 B F A
SBT_TAPE 11-09-2014 00:32:07
1 1
NO TAG20140911T003201
312 B F A
SBT_TAPE 11-09-2014 05:01:40
1 1 NO
TAG20140911T050134
314 B 0 A
SBT_TAPE 12-09-2014 00:30:52
1 1
NO TAG20140912T003030
319 B F A
SBT_TAPE 12-09-2014 00:32:47
1 1
NO TAG20140912T003242
327 B F A
SBT_TAPE 12-09-2014 05:01:24
1 1
NO TAG20140912T050118
329 B 0 A
SBT_TAPE 13-09-2014 00:30:51
1 1
NO TAG20140913T003029
334 B F A
SBT_TAPE 13-09-2014 00:32:06
1 1
NO TAG20140913T003200
342 B F A
SBT_TAPE 13-09-2014 05:01:11
1 1
NO TAG20140913T050105
344 B 0 A
SBT_TAPE 14-09-2014 00:30:50
1 1
NO TAG20140914T003028
349 B F A
SBT_TAPE 14-09-2014 00:32:15
1 1
NO TAG20140914T003209
357 B F A
SBT_TAPE 14-09-2014 05:01:10
1 1
NO TAG20140914T050106
359 B 0 A
SBT_TAPE 15-09-2014 00:30:49
1 1
NO TAG20140915T003026
364 B F A
SBT_TAPE 15-09-2014 00:32:14
1 1
NO TAG20140915T003208
372 B F A
SBT_TAPE 15-09-2014 05:01:09
1 1
NO TAG20140915T050103
374 B 0 A
SBT_TAPE 16-09-2014 00:30:52
1 1
NO TAG20140916T003030
379 B F A
SBT_TAPE 16-09-2014 00:32:37
1 1
NO TAG20140916T003232
386 B F A
SBT_TAPE 16-09-2014 05:01:04
1 1
NO TAG20140916T050058
388 B 0 A
SBT_TAPE 17-09-2014 00:30:52
1 1
NO TAG20140917T003030
393 B F A
SBT_TAPE 17-09-2014 00:32:06
1 1
NO TAG20140917T003201
399 B F A
SBT_TAPE 17-09-2014 05:01:00
1 1
NO
TAG20140917T050054
401 B 0 A
SBT_TAPE 18-09-2014 00:30:51
1 1
NO TAG20140918T003029
406 B F A
SBT_TAPE 18-09-2014 00:32:07
1 1
NO TAG20140918T003200
413 B F A
SBT_TAPE 18-09-2014 05:00:59
1 1
NO TAG20140918T050053
415 B 0 A
SBT_TAPE 19-09-2014 00:30:51
1 1
NO TAG20140919T003031
420 B F A
SBT_TAPE 19-09-2014 00:32:08
1 1
NO TAG20140919T003202
427 B F A
SBT_TAPE 19-09-2014 05:00:57
1 1
NO TAG20140919T050052
429 B 0 A
SBT_TAPE 20-09-2014 00:30:51
1 1
NO TAG20140920T003029
434 B F A
SBT_TAPE 20-09-2014 00:32:16
1 1
NO TAG20140920T003210
441 B F A
SBT_TAPE 20-09-2014 05:01:03
1 1
NO TAG20140920T050057
443 B 0 A
SBT_TAPE 21-09-2014 00:30:53
1 1
NO TAG20140921T003031
448 B F A
SBT_TAPE 21-09-2014 00:32:18 1
1
NO TAG20140921T003212
455 B F A
SBT_TAPE 21-09-2014 05:01:00
1 1
NO TAG20140921T050056
457 B 0 A
SBT_TAPE 22-09-2014 00:30:53
1 1
NO TAG20140922T003030
462 B F A
SBT_TAPE 22-09-2014 00:32:27
1 1
NO TAG20140922T003222
468 B F A
SBT_TAPE 22-09-2014 05:01:18
1 1
NO TAG20140922T050113
470 B 0 A
SBT_TAPE 23-09-2014 00:30:51
1 1
NO TAG20140923T003029
475 B F A
SBT_TAPE 23-09-2014 00:32:15
1 1
NO TAG20140923T003210
482 B F A
SBT_TAPE 23-09-2014 05:01:15
1 1
NO TAG20140923T050109
484 B 0 A
SBT_TAPE 24-09-2014 00:30:55
1 1
NO TAG20140924T003032
489 B F A
SBT_TAPE 24-09-2014 00:32:18
1 1
NO TAG20140924T003213
496 B F A
SBT_TAPE 24-09-2014 05:01:10
1 1
NO TAG20140924T050104
498 B 0 A
SBT_TAPE 25-09-2014 00:30:50
1 1
NO TAG20140925T003028
503 B F A
SBT_TAPE 25-09-2014 00:32:14
1 1
NO TAG20140925T003209
510 B F A
SBT_TAPE 25-09-2014 05:01:02
1 1
NO TAG20140925T050057
512 B 0 A
SBT_TAPE 26-09-2014 00:30:53
1 1
NO TAG20140926T003030
517 B F A
SBT_TAPE 26-09-2014 00:32:18
1 1
NO TAG20140926T003212
523 B F A
SBT_TAPE 26-09-2014 05:01:01
1 1
NO TAG20140926T050055
525 B 0 A
SBT_TAPE 29-09-2014 00:30:54
1 1
NO TAG20140929T003032
530 B F A
SBT_TAPE 29-09-2014 00:32:20
1 1
NO TAG20140929T003214
538 B F A
SBT_TAPE 29-09-2014 05:01:10
1 1
NO
TAG20140929T050104
RMAN> list backup of controlfile tag
TAG20140908T050128;
So we have crontrolfile
backup in 8th Sep backup
List of Backup Sets
===================
BS Key Type LV
Size Device Type Elapsed Time Completion
Time
------- ---- -- ---------- -----------
------------ -------------------
263
Full 19.25M
SBT_TAPE 00:00:06 08-09-2014 05:01:34
BP
Key: 263 Status: AVAILABLE Compressed: NO Tag:
TAG20140908T050128
Handle: vvsl60110_CEDEV_arch<CEDEV_267:857710888:1>.dbf
Media: 8ad0210a:539bc1d0:4058:0013
Control File Included: Ckp SCN:
14216065 Ckp time: 08-09-2014 05:01:28
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
The step
is to open the DB with 8th Sep backed –up control file because that
contains the information about the arechivelogs which are required after
restore to recover the database.
1.
So
restore the controle from TAG first,
2.
Put
the DB in mount mode with new control file.(can take backup of old controlfile
). PFA below file.
3.
Open
restore the DB and OPEN database with resetlogs.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
RMAN> shutdown immediate;
database closed
database dismounted
Oracle instance shut down
RMAN>
RMAN> startup nomount
connected to target database (not started)
RMAN-00571:
===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK
FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03002: failure of startup command at
09/29/2014 15:38:27
RMAN-04014: startup failed: ORA-00821:
Specified value of sga_target 2048M is too small, needs to be at least 2160M
RMAN> exit
Recovery Manager complete.
$ rman target /
Recovery Manager: Release 11.2.0.3.0 -
Production on Mon Sep 29 15:50:55 2014
Copyright (c) 1982, 2011, Oracle and/or its
affiliates. All rights reserved.
connected to target database: CEDEV
(DBID=3677482209, not open)
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=CEDEV,OB2BARLIST=vvsl60110_CEDEV_online)';
set PRAM parameters
3> restore controlfile to
'/u00/app/oracle/admin/CEDEV/pfile/control01.ctl' from tag
TAG20140909T003028;
restore the controfile
to an other place
4> }
allocated channel: dev_0
channel dev_0: SID=10 device type=SBT_TAPE
channel dev_0: Data Protector A.08.10/154
Starting restore at 29-09-2014 15:57:58
channel dev_0: starting datafile backup set
restore
channel dev_0: restoring control file
output file
name=/u00/app/oracle/admin/CEDEV/pfile/control01.ctl
channel dev_0: reading from backup piece
vvsl60110_CEDEV_online<CEDEV_272:857781054:1>.dbf
channel dev_0: piece
handle=vvsl60110_CEDEV_online<CEDEV_272:857781054:1>.dbf
tag=TAG20140909T003028
channel dev_0: restored backup piece 1
channel dev_0: restore complete, elapsed time:
00:00:45
Finished restore at 29-09-2014 15:58:45
released channel: dev_0
RMAN> shutdown immediate
database dismounted
Oracle instance shut down
RMAN> exit
Recovery Manager complete.
$ rman target /
Recovery Manager: Release 11.2.0.3.0 -
Production on Mon Sep 29 16:02:48 2014
Copyright (c) 1982, 2011, Oracle and/or its
affiliates. All rights reserved.
connected to target database: CEDEV
(DBID=3677482209, not open)
RMAN> list backup of archivelog sequence
between 1590 and 1596
summary;
new control file
contain info regarding the achivelog which are req for restore/Recover
using target database control file instead of
recovery catalog
List of Backups
===============
Key TY LV S Device Type
Completion Time #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------
------- ------- ---------- ---
261 B A A
SBT_TAPE 08-09-2014 05:01:24
1 1
NO TAG20140908T050018
RMAN> list backup of archivelog sequence
between 1590 and 1596;
List of Backup Sets
===================
BS Key
Size Device Type Elapsed Time Completion
Time
------- ---------- ----------- ------------
-------------------
261
4.50M SBT_TAPE
00:00:05 08-09-2014 05:01:24
BP
Key: 261 Status: AVAILABLE Compressed: NO Tag:
TAG20140908T050018
Handle: vvsl60110_CEDEV_arch<CEDEV_266:857710879:1>.dbf
Media: 8ad0210a:539bc1c2:407d:000d
List of Archived Logs in backup set 261
Thrd Seq Low
SCN Low
Time Next
SCN Next Time
---- ------- ----------
------------------- ---------- ---------
1
1590 14211649 08-09-2014 02:30:28
14212589 08-09-2014 03:00:29
1 1591
14212589 08-09-2014 03:00:29 14213437 08-09-2014
03:30:28
1
1592 14213437 08-09-2014 03:30:28
14214272 08-09-2014 04:00:29
1
1593 14214272 08-09-2014 04:00:29
14215084 08-09-2014 04:30:28
1
1594 14215084 08-09-2014 04:30:28
14216006 08-09-2014 05:00:17
1
1595 14216006 08-09-2014 05:00:17
14216015 08-09-2014 05:00:18
RMAN> list backup of archivelog scn between
14208030 and 14208046;
List of Backup Sets
===================
BS Key
Size Device Type Elapsed Time Completion
Time
------- ---------- ----------- ------------
-------------------
262
245.50M SBT_TAPE
00:00:07 08-09-2014 05:01:25
BP
Key: 262 Status: AVAILABLE Compressed: NO Tag:
TAG20140908T050018
Handle:
vvsl60110_CEDEV_arch<CEDEV_265:857710878:1>.dbf Media:
8ad0210a:539bc1d0:4058:0013
List of Archived Logs in backup set 262
Thrd Seq Low
SCN Low
Time Next
SCN Next Time
---- ------- ----------
------------------- ---------- ---------
1
1585 14199445 08-09-2014 00:00:28
14208039 08-09-2014 00:30:27
1
1586 14208039 08-09-2014 00:30:27
14208780 08-09-2014 01:00:27
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=CEDEV,OB2BARLIST=vvsl60110_CEDEV_online)';
3> restore database from tag
TAG20140908T003026;
> restore database
4> }
allocated channel: dev_0
channel dev_0: SID=10 device type=SBT_TAPE
channel dev_0: Data Protector A.08.10/154
Starting restore at 29-09-2014 16:13:43
Starting implicit crosscheck backup at
29-09-2014 16:13:43
Finished implicit crosscheck backup at
29-09-2014 16:13:44
Starting implicit crosscheck copy at 29-09-2014
16:13:44
Crosschecked 72 objects
Finished implicit crosscheck copy at 29-09-2014
16:13:45
searching for all files in the recovery area
cataloging files...
cataloging done
List of Cataloged Files
=======================
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2472_b27r5n6w_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2453_b26prnz5_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2451_b26m84r3_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2437_b25wfvlb_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2450_b26khwo0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2477_b280yzr0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2464_b27b3jm9_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2447_b26d7499_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2480_b2867nsq_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2454_b26rjzx0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2439_b25zyfsh_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2435_b25rx1wc_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2476_b27z6np9_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2457_b26xsr0g_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2449_b26hqnl5_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2434_b25q4sph_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2478_b282q4pp_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2455_b26t97yf_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2468_b27k4mlm_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2471_b27pfd1s_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2452_b26o0dtd_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2470_b27no3rd_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2461_b274tr5l_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2459_b271b844_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2465_b27cvrnp_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2444_b266yd05_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2446_b26bgw4j_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2469_b27lwvlw_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2458_b26zl01k_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2473_b27sxwh2_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2438_b25y67or_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2442_b265637r_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2462_b276m07b_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2443_b26563gs_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2445_b268pn3c_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2479_b284hdrl_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2474_b27vp4kl_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2436_b25tob39_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2448_b26fzdg8_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2467_b27hdckz_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2441_b263h08q_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2466_b27fn0mk_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2456_b26w1hyp_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2433_b25odk8j_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2440_b261pr7h_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2463_b278c89g_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2475_b27xgdld_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2460_b2732j4p_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_25/o1_mf_1_2432_b25mn95j_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2646_b2k4qxcc_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2648_b2k88jcj_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2635_b2jmt4l4_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2633_b2jj9n9x_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2636_b2jolfos_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2651_b2kfkgwg_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2652_b2kh9q1d_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2644_b2k17fb0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2659_b2kvmhco_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2657_b2kr2z4s_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2658_b2ksv799_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2654_b2klt726_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2631_b2jds4rz_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2656_b2kpbq21_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2655_b2knlh0l_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2640_b2jt6f43_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2638_b2jpozrh_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2639_b2jrg4yl_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2653_b2kk1z1j_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2628_b2j7jbhj_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2647_b2k6j5b3_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2627_b2j5r8go_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2641_b2jvyo8o_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2642_b2jxpxbf_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2650_b2kcs6jy_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2630_b2jc0xnq_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2632_b2jgkcld_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2637_b2jpoznp_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2649_b2kb0ycn_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2643_b2jzh5b2_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2634_b2jl1wrv_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2645_b2k2zoct_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_2629_b2j98lkb_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2577_b2fgzwvf_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2531_b2by42q1_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2538_b2cbfv49_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2530_b2bwctm0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2546_b2crhyp5_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2572_b2f66ng0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2533_b2c1nls7_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2545_b2cpqpmb_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2541_b2chpmc8_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2552_b2d31h6h_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2573_b2f7ywld_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2535_b2c5530g_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2539_b2cd637z_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2540_b2cfyc9q_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2547_b2ct86rs_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2555_b2d8b7dz_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2561_b2dlvv18_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2568_b2dz5n8r_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2543_b2cm73j6_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2537_b2c8om4c_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2570_b2f2p4fl_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2567_b2dxfd40_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2542_b2ckgyfg_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2534_b2c3dty4_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2550_b2czjz38_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2560_b2dk3j0q_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2569_b2f0xw9y_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2566_b2dvo409_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2571_b2f4gdfc_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2544_b2cnzclk_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2556_b2db2hh0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2554_b2d6kz91_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2564_b2dr4mt4_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2532_b2bzwbqh_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2558_b2dflzsk_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2562_b2dnn34b_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2559_b2dhc7x9_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2563_b2dpdcbp_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2565_b2dsww00_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2536_b2c6xc0b_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2553_b2d4sq7x_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2551_b2d19736_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2575_b2fchdog_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2574_b2f9q4mb_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2549_b2cxrpx9_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2548_b2cw0gt0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2576_b2ff7nry_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_27/o1_mf_1_2557_b2dctqnp_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2592_b2g871hk_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2615_b2hjo6jn_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2583_b2frdp9b_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2582_b2fpng79_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2604_b2gxb517_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2612_b2hcdgdg_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2598_b2glrns7_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2586_b2fxokbr_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2580_b2fm3y2y_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2595_b2gfhsm7_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2621_b2hv6r31_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2602_b2gssnwk_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2591_b2g6gsg5_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2625_b2j27rb7_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2624_b2j0hj9b_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2581_b2fnw63d_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2605_b2gz2f2h_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2610_b2h7vrb2_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2619_b2hqp7wm_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2613_b2hf4pf1_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2599_b2gnjwpx_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2626_b2j400cl_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2606_b2h0to42_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2611_b2h9n6df_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2603_b2gvkwxq_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2601_b2gr1dv8_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2579_b2fkcp1x_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2618_b2hoxzqn_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2590_b2g4pkh6_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2584_b2ft4y93_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2596_b2gh81ny_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2587_b2fzfsfm_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2607_b2h2lx65_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2588_b2g161dm_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2578_b2fjr4yj_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2597_b2gk0dpz_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2616_b2hlfgv0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2593_b2g9z9k4_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2594_b2gcqklf_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2622_b2hwz034_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2617_b2hn5q96_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2623_b2hyq86l_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2614_b2hgwydf_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2620_b2hsghwo_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2589_b2g2y9g3_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2600_b2gp94sy_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2585_b2fvx9b6_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2609_b2h63f8n_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_28/o1_mf_1_2608_b2h4c56k_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2492_b28sl1y9_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2528_b2brv984_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2494_b28x2h9k_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2500_b297n2d6_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2490_b28qtm2m_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2486_b28js7b9_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2529_b2btmlb3_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2509_b29qgdsx_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2527_b2bq30nv_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2515_b2b1zwcf_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2510_b29s6nx5_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2507_b29mxv2v_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2484_b28f8plo_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2504_b29go2hs_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2481_b287zwt2_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2502_b29c4lft_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2488_b28nb28x_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2519_b2b90xgh_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2487_b28lkl6z_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2506_b29l5llk_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2516_b2b3r52d_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2497_b292c7d6_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2518_b2b78o9d_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2505_b29jfbkq_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2503_b29dwtg7_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2489_b28p2c76_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2491_b28sl1qn_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2526_b2bobw13_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2524_b2bkt8x3_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2523_b2bj1xsh_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2499_b295vqfd_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2501_b299dbg2_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2512_b29wq4vv_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2517_b2b5jf5k_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2513_b29yhf35_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2522_b2bg9oq0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2521_b2bdkfj4_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2483_b28cjgf8_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2482_b289r671_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2485_b28h0ylo_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2508_b29op3lh_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2493_b28vb7b5_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2495_b28ytq9m_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2498_b2943hf1_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2525_b2bmlk0f_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2511_b29tywwm_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2496_b290lz9p_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2514_b2b07obw_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_26/o1_mf_1_2520_b2bbs5kv_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2404_b242dpb8_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2412_b24jgq52_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2408_b249fpr5_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2418_b24v0825_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2400_b23vclx4_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2416_b24qhr16_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2421_b25093dx_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2430_b25j3rs9_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2426_b2592rqw_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2429_b25gcjpd_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2415_b24oqhvq_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2395_b23llb9y_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2405_b2444ydl_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2403_b240ng8g_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2420_b24yjr6r_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2414_b24mz7l1_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2396_b23nblhk_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2409_b24c5yt6_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2425_b257bfm3_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2419_b24wrj4c_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2401_b23x3v29_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2417_b24s8034_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2411_b24gph14_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2423_b253stdq_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2413_b24l6zgb_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2407_b247ogmw_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2431_b25kw0y9_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2406_b245x6kc_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2424_b255l5k5_.arc
File Name: /u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2427_b25bv0sf_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2410_b24dy6wo_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2428_b25dmcxx_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2402_b23yw3bg_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2398_b23qv2r0_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2397_b23p2tlt_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2422_b2521gsv_.arc
File Name:
/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_24/o1_mf_1_2399_b23smbsg_.arc
channel dev_0: starting datafile backup set
restore
channel dev_0: specifying datafile(s) to
restore from backup set
channel dev_0: restoring datafile 00001 to
/u03/oradata/CEDEV/system01.dbf
channel dev_0: restoring datafile 00004 to
/u04/oradata/CEDEV/users01.dbf
channel dev_0: reading from backup piece
vvsl60110_CEDEV_online<CEDEV_255:857694627:1>.dbf
channel dev_0: piece
handle=vvsl60110_CEDEV_online<CEDEV_255:857694627:1>.dbf
tag=TAG20140908T003026
channel dev_0: restored backup piece 1
channel dev_0: restore complete, elapsed time:
00:00:55
channel dev_0: starting datafile backup set
restore
channel dev_0: specifying datafile(s) to
restore from backup set
channel dev_0: restoring datafile 00002 to
/u03/oradata/CEDEV/sysaux01.dbf
channel dev_0: restoring datafile 00003 to
/u04/oradata/CEDEV/undotbs01.dbf
channel dev_0: reading from backup piece
vvsl60110_CEDEV_online<CEDEV_254:857694627:1>.dbf
channel dev_0: piece
handle=vvsl60110_CEDEV_online<CEDEV_254:857694627:1>.dbf
tag=TAG20140908T003026
channel dev_0: restored backup piece 1
channel dev_0: restore complete, elapsed time:
00:02:05
channel dev_0: starting datafile backup set
restore
channel dev_0: specifying datafile(s) to
restore from backup set
channel dev_0: restoring datafile 00005 to
/u03/oradata/CEDEV/users_large01.dbf
channel dev_0: restoring datafile 00008 to
/u04/oradata/CEDEV/indx_small01.dbf
channel dev_0: reading from backup piece
vvsl60110_CEDEV_online<CEDEV_253:857694627:1>.dbf
channel dev_0: piece
handle=vvsl60110_CEDEV_online<CEDEV_253:857694627:1>.dbf
tag=TAG20140908T003026
channel dev_0: restored backup piece 1
channel dev_0: restore complete, elapsed time:
00:01:55
channel dev_0: starting datafile backup set
restore
channel dev_0: specifying datafile(s) to
restore from backup set
channel dev_0: restoring datafile 00006 to
/u03/oradata/CEDEV/users_small01.dbf
channel dev_0: restoring datafile 00007 to
/u04/oradata/CEDEV/indx_large01.dbf
channel dev_0: reading from backup piece
vvsl60110_CEDEV_online<CEDEV_252:857694627:1>.dbf
channel dev_0: piece
handle=vvsl60110_CEDEV_online<CEDEV_252:857694627:1>.dbf
tag=TAG20140908T003026
channel dev_0: restored backup piece 1
channel dev_0: restore complete, elapsed time:
00:03:55
Finished restore at 29-09-2014 16:22:44
released channel: dev_0
RMAN> list backup of archivelog sequence 1587;
List of Backup Sets
===================
BS Key
Size Device Type Elapsed Time Completion
Time
------- ---------- ----------- ------------
-------------------
262
245.50M SBT_TAPE 00:00:07
08-09-2014 05:01:25
BP
Key: 262 Status: AVAILABLE Compressed: NO Tag:
TAG20140908T050018
Handle: vvsl60110_CEDEV_arch<CEDEV_265:857710878:1>.dbf
Media: 8ad0210a:539bc1d0:4058:0013
List of Archived Logs in backup set 262
Thrd Seq Low
SCN Low
Time Next
SCN Next Time
---- ------- ----------
------------------- ---------- ---------
1
1587 14208780 08-09-2014 01:00:27 14209913
08-09-2014 01:30:27
RMAN> run {
2> allocate channel 'dev_0' type 'sbt_tape'
parms
'ENV=(OB2BARTYPE=Oracle8,OB2APPNAME=CEDEV,OB2BARLIST=vvsl60110_CEDEV_online)';
3> recover database until sequence 1587;
>>>>>>recover
database until 01:00:27(were asked to recover around 1am)
4> }
allocated channel: dev_0
channel dev_0: SID=10 device type=SBT_TAPE
channel dev_0: Data Protector A.08.10/154
Starting recover at 29-09-2014 16:31:49
starting media recovery
channel dev_0: starting archived log restore to
default destination
channel dev_0: restoring archived log
archived log thread=1 sequence=1585
channel dev_0: restoring archived log
archived log thread=1 sequence=1586
channel dev_0: reading from backup piece
vvsl60110_CEDEV_arch<CEDEV_265:857710878:1>.dbf
channel dev_0: piece
handle=vvsl60110_CEDEV_arch<CEDEV_265:857710878:1>.dbf
tag=TAG20140908T050018
channel dev_0: restored backup piece 1
channel dev_0: restore complete, elapsed time:
00:00:45
archived log file
name=/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_1585_b2kz8007_.arc
thread=1 sequence=1585
channel default: deleting archived log(s)
archived log file
name=/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_1585_b2kz8007_.arc
RECID=1373 STAMP=859566752
archived log file
name=/u02/oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_1586_b2kz80hx_.arc
thread=1 sequence=1586
channel default: deleting archived log(s)
archived log file
name=/u02 /oraarch/CEDEV/archive/CEDEV/archivelog/2014_09_29/o1_mf_1_1586_b2kz80hx_.arc
RECID=1372 STAMP=859566752
media recovery complete, elapsed time: 00:00:00
Finished recover at 29-09-2014 16:32:37
released channel: dev_0
RMAN>
alter database open resetlogs;
Open Db
database opened
RMAN> exit
Recovery Manager complete.
$
Please
feel free to ask for any clarification,.,,,,,