Wednesday, 23 December 2015

Install oracle restart.( 1 node RAC without SCAN and Voting disk)

check that asmdba, asmoper and asmadmin groups exist and assigned to oracle
sudo groupadd -g 1004 asmoper
sudo groupadd -g 1004 asmoper
sudo groupadd -g 1005 asmadmin
sudo usermod -G asmdba,asmoper,asmoper -a oracle

sudo mkdir /u00/11.2.0 /u00/app
sudo chown oracle:oinstall /u00/11.2.0 /u00/app
mkdir /u00/11.2.0/grid
mkdir /u00/app/software

====== Clone Softaree from tar files you can use normal install====
Copy the following archives to /u00/app/software:
  restart-11.2.0.3.15-rhel-6.6-x_64-1.0.tgz
  database-sa-11.2.0.3.15-rhel-6.6-x_64-1.0.tgz
  soe-standalone-asm.dbt

cd /u00/11.2.0/grid
tar zxpf /u00/app/software/restart-11.2.0.3.15-rhel-6.6-x_64-1.0.tgz
cd /u00/11.2.0/grid/clone/bin
perl clone.pl ORACLE_HOME=/u00/11.2.0/grid ORACLE_BASE=/u00/app/oracle INVENTORY_LOCATION=/u00/app/oraInventory CRS=TRUE
sudo /u00/app/oraInventory/orainstRoot.sh
sudo /u00/11.2.0/grid/root.sh
cat logfile

sudo /u00/11.2.0/grid/perl/bin/perl -I/u00/11.2.0/grid/perl/lib -I/u00/11.2.0/grid/crs/install /u00/11.2.0/grid/crs/install/roothas.pl

if it fails, decofigure HAS, fix the problem and re-run
  /u00/11.2.0/grid/crs/install/roothas.pl -deconfig -force

set environment to ASM

crsctl modify resource ora.cssd -attr "AUTO_START=1"
srvctl add listener -p 2521
srvctl start listener
crsctl stop has
crsctl start has
res

create $ORACLE_HOME/dbs/init+ASM.ora

*._shared_pool_reserved_pct=10
*.asm_diskstring='/etc/asmdisk/data','/etc/asmdisk/fra','/etc/asmdisk/redo1','/etc/asmdisk/redo2'
*.asm_power_limit=1
*.diagnostic_dest='/u00/app/oracle'
*.instance_type='asm'
*.large_pool_size=12M
*.processes=300
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_max_size=2147483648
*.sga_target=1572864000
*.shared_pool_size=1073741824

srvctl add asm
crsctl modify resource ora.asm -attr "AUTO_START=1"

sqlplus / as sysasm
  startup pfile=/u00/11.2.0/grid/dbs/init+ASM.ora
  create spfile from pfile;

srvctl modify asm -p /u00/11.2.0/grid/dbs/spfile+ASM.ora
srvctl modify asm -l LISTENER

rm init+ASM.ora
crsctl stop has
crsctl start has
res

create diskgroups (AU=4M, Database Compatibility=11.2.0.0.0)

mkdir -p /u00/app/oracle/product/11.2.0/db_1
cd /u00/app/oracle/product/11.2.0/db_1
tar zxpf /u00/app/software/database-sa-11.2.0.3.15-rhel-6.6-x_64-1.0.tgz
cd clone/bin
perl clone.pl ORACLE_HOME=/u00/app/oracle/product/11.2.0/db_1 ORACLE_BASE=/u00/app/oracle
sudo /u00/app/oracle/product/11.2.0/db_1/root.sh




mv /u00/app/software/soe-standalone-asm.dbt /u00/app/oracle/product/11.2.0/db_1/assistants/dbca/templates

create database using soe-standalone-asm template and changing all environment-specific parameters, names etc
  note SYS/SYSTEM password

run postinstall for patch 21068553; details are in $ORACLE_HOME/README.txt
 
create tnsnames.ora sqlnet.ora

configure backups
  create rman user
  configure rman
  note RMAN password

put in place .profile, ~/techm and crontab

prepare for database monitoring
  alter user DBSNMP identified by <password> account unlock;

prepare for ASM monitoring
  orapwd file='orapw+ASM'  entries=5 password=<password>
  sqlplus / as sysasm
    create user ASMSNMP identified by <password>;
    grant sysdba to ASMSNMP;
 
reboot host and check that everything starts up correctly

configure OEM monitoring

Saturday, 14 November 2015

RMAN restore when there is no backup information in current controlfile

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,.,,,,,