ORA-00376: file 92 cannot be read at this time

http://www.oravn.com/qu-n-tr-v-n-hanh-oracle-f6/undotbs-problem-and-how-to-recreate-undo-tablespace-t1369.html?sid=792ed7eca493b2eb5d2861372ce59baa#p7437

http://www.oracleflash.com/32/Change-or-switch-undo-tablespace-in-Oracle-database.html

http://oracledbahub.com/2012/06/ora-01595-ora-00607-ora-00600/

https://community.oracle.com/message/1571060

ORA-01248: file 11 was created in the future of incomplete recovery

Environment: 2 Node GRID(RAC/ASM) Oracle Database v11.2.0.3.0 on RHEL 6.4

At our client setup, faced some issues with SAN storage. So DB got down as there was communication issue between DB server and SAN storage.

After SAN storage restart by H/w team,
– First we not able to open DB because of inconsistent files error might be due to “Storage” issue.
· To resolve issue we have tried to recover from previous success RMAN DB backup(27th Nov14) but we are not able to up the DB.

Commands to analysis the Database Health:-

ERROR at line 1: ORA-01248: file 11 was created in the future of incomplete recovery

select '#' || ts.name || '#' as tablespace_name, ts.ts#,
      '#' || dh.name || '#' as filename, dh.file#, dh.status, dh.error, dh.
fuzzy, dh.creation_change#,
      to_char(dh.creation_time, 'DD-MON-YYYY HH24:MI:SS') as creation_time,
      to_char(dh.checkpoint_change#, '999999999999999') as checkpoint_change#,
      to_char(dh.checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
      to_char(dh.resetlogs_change#, '999999999999999') as resetlogs_change#,
      to_char(dh.resetlogs_time, 'DD-MON-YYYY HH24:MI:SS') as resetlogs_time,
      to_char(dh.bytes, '9,999,999,999,990') as bytes
from v$datafile_header dh, v$tablespace ts
where ts.ts# = dh.ts#
and ( dh.status <> 'ONLINE'
or    dh.checkpoint_change# <> (select checkpoint_change# from v$database) );

TABLESPACE_NAME                            TS#       FILENAME                                       FILE# STATUS       ERROR    FUZ  CREATION_CHANGE# CREATION_TIME                 CHECKPOINT_CHANG      CHECKPOINT_TIME                    RESETLOGS_CHANGE RESETLOGS_TIME                   BYTES
#SYSTEM#                                     0       #+DATA/orcldb/datafile/system.262.821898691#   	1 ONLINE           NO          7 17-SEP-2011      09:46:08                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             8,954,839,040
#SYSAUX#                                     1       #+DATA/orcldb/datafile/sysaux.260.821898691#   	2 ONLINE           NO       2188 17-SEP-2011      09:46:16                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             786,432,000
#UNDOTBS1#                                   2       #+DATA/orcldb/datafile/undotbs1.261.821898691# 	3 ONLINE                  992580 17-SEP-2011      10:22:44                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             2,820,669,440
#USERS#                                      4       #+DATA/orcldb/datafile/users.259.821898691#    	4 ONLINE           NO      18919 17-SEP-2011      09:46:40                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             5,242,880
#UNDOTBS2#                                   5       #+DATA/orcldb/datafile/undotbs2.257.821898845# 	5 ONLINE           NO    1040830 27-JUL-2013      17:14:04                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             104,857,600
#TBSORCL21#                                 6       #+DATA/orcldb/datafile/TBSORCL21.268.865415781#   11 ONLINE           NO  483159051 04-DEC-2014      09:16:22                       483159051             04-DEC-2014 09:16:22                    995548 27-JUL-2013 17:12:39             104,857,600
#TBSORCL21#                                 6       #+DATA/orcldb/datafile/TBSORCL21.dbf#              6 ONLINE           NO    1357459 29-JUL-2013      11:23:18                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             34,357,706,752
#TBSORCL4#                                  7       #+DATA/orcldb/datafile/TBSORCL4.dbf#               7 ONLINE           NO    1358352 29-JUL-2013      11:29:47                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             104,857,600
#TBSORCL#                                   8       #+DATA/orcldb/datafile/TBSORCL.dbf#                8 ONLINE           NO    1359063 29-JUL-2013      11:31:14                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             104,857,600
#SPRELITAAAITISALUNA#                        9       #+DATA/orcldb/datafile/sprelitaaaitisaluna.dbf#     9 ONLINE           NO    1359528 29-JUL-2013      11:32:10                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             171,966,464
#TESTSPR#                                   10       #+DATA/orcldb/datafile/testspr.dbf#                10 ONLINE           NO    1360064 29-JUL-2013      11:33:11                       282258621             29-NOV-2014 19:09:17                    995548 27-JUL-2013 17:12:39             137,232,384
column error format a15
select error, fuzzy, status, checkpoint_change#,
      to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
      count(*)
from v$datafile_header
group by error, fuzzy, status, checkpoint_change#, checkpoint_time
order by checkpoint_change#, checkpoint_time;

ERROR   FUZ STATUS  CHECKPOINT_CHANGE# CHECKPOINT_TIME                       COUNT(*)
        NO  ONLINE      282258621          29-NOV-2014 19:09:17                        10
        NO  ONLINE      483159051          04-DEC-2014 09:16:22                        1
select *
from X$KCCLH, (select min(checkpoint_change#) df_min_scn,
min(checkpoint_change#) df_max_scn
              from v$datafile_header
              where status='ONLINE') df
where LHLOS in (select first_change# from v$log)
or df.df_min_scn between LHLOS and LHNXS
or df.df_max_scn between LHLOS and LHNXS;

ADDR                      INDX       INST_ID         LHRID LHTSM               LHSTM                     LHTHP         LHTNP         LHSEQ LHLOS                    LHLOT                LHNXS            LHNAM          LHRLS                            LHRLC                         LHIC    DF_MIN_SCN    DF_MAX_SCN
---------------- -------------------- ------------- -------------              -------------
00002ABB0A844EB8           147             2           673 11/29/2014 19:09:17      864932957             1           671            401   280405574               11/29/2014 17:52:06  282258621        995548           07/27/2013 17:12:39              2                                    282258621     282258621
00002ABB0A844EB8           148             2           674 11/29/2014 20:16:31      864936991             1           673            402   282258621               11/29/2014 19:09:17  284112603        995548           07/27/2013 17:12:39              2                                    282258621     282258621
00002ABB0A844EB8           150             2           676 11/29/2014 21:20:18      864940818             2           672            273   280405964               11/29/2014 17:52:08  285970919        995548           07/27/2013 17:12:39              2                                    282258621     282258621
00002ABB0A844EB8           289             2           815 12/04/2014 05:45:29      865403129             2           811            309   474881799               12/04/2014 02:05:02  478657004        995548           07/27/2013 17:12:39              2                                    282258621     282258621
00002ABB0A844EB8           291             2           817 12/04/2014 08:50:16      865414216             1           816            508   480525399               12/04/2014 07:28:32  482400653        995548           07/27/2013 17:12:39              2                                    282258621     282258621
select AL.*,
      DF.min_checkpoint_change#, DF.min_checkpoint_time
from v$archived_log AL,
    (select min(checkpoint_change#) min_checkpoint_change#,
            min(checkpoint_time) min_checkpoint_time
     from v$datafile_header
     where status='ONLINE') DF
where DF.min_checkpoint_change# between AL.first_change# and AL.next_change#
order by AL.first_change#;

        RECID         STAMP                NAME                                                               DEST_ID       THREAD#     SEQUENCE# RESETLOGS_CHANGE# RESETLOGS_TIME       RESETLOGS_ID FIRST_CHANGE# FIRST_TIME            NEXT_CHANGE#            NEXT_TIME                   BLOCKS    BLOCK_SIZE CREATOR REGISTR STA ARC        APPLIED   DEL STATUS       COMPLETION_TIME      DIC DIC END  BACKUP_COUNT       ARCHIVAL_THREAD#   ACTIVATION# IS_ COM FAL END_OF_RED BAC MIN_CHECKPOINT_CHANGE#  MIN_CHECKPOINT_TIME
          829     870401153                +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_401.270.870386333        1             1           401            995548 27-JUL-2013 17:12:39   821898759     280405574 29-NOV-2014 17:52:06     282258621               29-NOV-2014 19:09:17       1879169           512 RMAN    RMAN    NO  YES        NO        NO  A            31-JAN-2015 02:05:53 NO  NO  NO              0                      0             0 NO  NO  NO             NO               282258621  29-NOV-2014 19:09:17
          846     870401153                +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_273.398.870386455        1             2           273            995548 27-JUL-2013 17:12:39   821898759     280405964 29-NOV-2014 17:52:08     285970919               29-NOV-2014 21:20:18          7331           512 RMAN    RMAN    NO  YES        NO        NO  A            31-JAN-2015 02:05:53 NO  NO  NO              0                      0             0 NO  NO  NO             NO               282258621  29-NOV-2014 19:09:17
          828     870401153                +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_402.265.870386333        1             1           402            995548 27-JUL-2013 17:12:39   821898759     282258621 29-NOV-2014 19:09:17     284112603               29-NOV-2014 20:16:31       1879536           512 RMAN    RMAN    NO  YES        NO        NO  A            31-JAN-2015 02:05:53 NO  NO  NO              0                      0             0 NO  NO  NO             NO               282258621  29-NOV-2014 19:09:17

Note: There are various other commands as well but above one are related to rca.

Recommendation-1

1/ According to the results of the query on V$DATAFILE_HEADER in above,
all of the 10 datafiles have CHECKPOINT_TIME='29-NOV-2014 19:09:17', while
the datafile# 11, '+DATA/orcldb/datafile/TBSORCL21.268.865415781' has
CHECKPOINT_TIME='04-DEC-2014 09:16:22'.

2/ Before you can normally open the database, all of the datafiles must not be
fuzzy and have similar CHECKPOINT_CHANGE#/TIME.
If you want to recover the database before '04-DEC-2014 09:16:22',
then you need to restore the datafile# 11 from a backup taken before the
said date. However, if you want to recover the database beyond ''04-DEC-2014 09:16:22',
then recover the database by applying the archivelogs generated since '29-NOV-2014 19:09:17'.

Action-1

spool log to rman_df11_restore01.log
set echo on
show all;
report schema;
list incarnation;
list backup summary;
list backup;
list copy;
list backup of datafile 11;
list copy of datafile 11;
run {
set until time "to_date('29-NOV-2014 19:09:17','DD-MON-RRRR HH24:MI:SS')";
restore datafile 11;
}
spool log off

Important Note: Before running the RMAN commands posted above, please
issue the following OS command to set the NLS_DATE_FORMAT, as shown below.
This will allow to display the date, as well as, the time information,
which will help us in our analysis.

NLS_DATE_FORMAT="DD-MON-RRRR HH24:MI:SS"
export NLS_DATE_FORMAT
Spooling started in log file: /home/oracle/rman_df11_restore01.log

Recovery Manager11.2.0.3.0

RMAN> set echo on

echo set on

RMAN> show all;
RMAN configuration parameters for database with db_unique_name orcldb are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '+FRA/orcldb/snapshot/snapcf_orcldb.f';

RMAN> report schema;
RMAN-06139: WARNING: control file is not current for REPORT SCHEMA
Report of database schema for database with db_unique_name orcldb

List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    8540     SYSTEM               ***     +DATA/orcldb/datafile/system.262.821898691
2    750      SYSAUX               ***     +DATA/orcldb/datafile/sysaux.260.821898691
3    5040     UNDOTBS1             ***     +DATA/orcldb/datafile/undotbs1.261.821898691
4    5        USERS                ***     +DATA/orcldb/datafile/users.259.821898691
5    100      UNDOTBS2             ***     +DATA/orcldb/datafile/undotbs2.257.821898845
6    32766    TBSORCL21           ***     +DATA/orcldb/datafile/TBSORCL21.dbf
7    100      TBSORCL4            ***     +DATA/orcldb/datafile/TBSORCL4.dbf
8    100      TBSORCL             ***     +DATA/orcldb/datafile/TBSORCL.dbf
9    164      SPRELITAAAITISALUNA  ***     +DATA/orcldb/datafile/sprelitaaaitisaluna.dbf
10   130      TESTSPR              ***     +DATA/orcldb/datafile/testspr.dbf
11   100      TBSORCL21           ***     +DATA/orcldb/datafile/TBSORCL21.268.865415781

List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    65       TEMP                 32767       +DATA/orcldb/tempfile/temp.258.821898785

RMAN> list incarnation;

List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       orcldb    489766533        PARENT  1          17-SEP-2011 09:46:04
2       2       orcldb    489766533        CURRENT 995548     27-JUL-2013 17:12:39

RMAN> list backup summary;

List of Backups
===============
Key     TY LV S Device Type Completion Time      #Pieces #Copies Compressed Tag
------- -- -- - ----------- -------------------- ------- ------- ---------- ---
528     B  F  A DISK        27-NOV-2014 02:15:31 41      1       NO         TAG20141127T020531
530     B  A  A DISK        27-NOV-2014 02:15:37 1       1       NO         TAG20141127T021536
531     B  F  A DISK        27-NOV-2014 02:15:38 1       1       NO         TAG20141127T021538
532     B  A  A DISK        30-NOV-2014 02:08:33 14      1       NO         TAG20141130T020512
533     B  A  A DISK        04-DEC-2014 02:12:17 30      1       NO         TAG20141204T020512
534     B  A  A DISK        04-DEC-2014 02:19:48 30      1       NO         TAG20141204T020512

RMAN> list backup;

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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
528     Full    40.59G     DISK        00:09:59     27-NOV-2014 02:15:31
  List of Datafiles in backup set 528
  File LV Type Ckp SCN    Ckp Time             Name
  ---- -- ---- ---------- -------------------- ----
  1       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/system.262.821898691
  2       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/sysaux.260.821898691
  3       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/undotbs1.261.821898691
  4       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/users.259.821898691
  5       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/undotbs2.257.821898845
  6       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/TBSORCL21.dbf
  7       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/TBSORCL4.dbf
  8       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/TBSORCL.dbf
  9       Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/sprelitaaaitisaluna.dbf
  10      Full 266654965  27-NOV-2014 02:05:32 +DATA/orcldb/datafile/testspr.dbf

  Backup Set Copy #1 of backup set 528
  Device Type Elapsed Time Completion Time      Compressed Tag
  ----------- ------------ -------------------- ---------- ---
  DISK        00:09:59     27-NOV-2014 02:15:31 NO         TAG20141127T020531

    List of Backup Pieces for backup set 528 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    2250    1   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_1_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2251    2   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_2_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2252    3   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_3_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2253    4   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_4_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2254    5   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_5_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2255    6   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_6_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2256    7   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_7_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2257    8   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_8_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2258    9   AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_9_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2259    10  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_10_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2260    11  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_11_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2261    12  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_12_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2262    13  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_13_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2263    14  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_14_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2264    15  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_15_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2265    16  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_16_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2266    17  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_17_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2267    18  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_18_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2268    19  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_19_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2269    20  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_20_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2270    21  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_21_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2271    22  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_22_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2272    23  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_23_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2273    24  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_24_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2274    25  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_25_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2275    26  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_26_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2276    27  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_27_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2277    28  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_28_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2278    29  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_29_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2279    30  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_30_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2280    31  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_31_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2281    32  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_32_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2282    33  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_33_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2283    34  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_34_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2284    35  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_35_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2285    36  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_36_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2286    37  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_37_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2287    38  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_38_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2288    39  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_39_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2289    40  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_40_1_orcldb_20141127_DATAFILE_FULL_27_11_2014
    2290    41  AVAILABLE   /backup/rmanbackup/rman_bkp_hrpokgbc_41_1_orcldb_20141127_DATAFILE_FULL_27_11_2014

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
530     2.72M      DISK        00:00:00     27-NOV-2014 02:15:37
        BP Key: 2292   Status: AVAILABLE  Compressed: NO  Tag: TAG20141127T021536
        Piece Name: /backup/rmanbackup/rman_bkp_htpokgu9_1_1_orcldb_20141127_ARCHIVELOG_27_11_2014

  List of Archived Logs in backup set 530
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    392     266654808  27-NOV-2014 02:05:02 266659229  27-NOV-2014 02:15:34
  2    269     266654803  27-NOV-2014 02:05:02 266659220  27-NOV-2014 02:15:33

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ --------------------
531     Full    17.70M     DISK        00:00:00     27-NOV-2014 02:15:38
        BP Key: 2293   Status: AVAILABLE  Compressed: NO  Tag: TAG20141127T021538
        Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/c-489766533-20141127-00
  SPFILE Included: Modification time: 05-OCT-2014 10:01:39
  SPFILE db_unique_name: orcldb
  Control File Included: Ckp SCN: 266659252    Ckp time: 27-NOV-2014 02:15:38

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
532     13.56G     DISK        00:03:20     30-NOV-2014 02:08:33

  List of Archived Logs in backup set 532
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    393     266659229  27-NOV-2014 02:15:34 267703333  28-NOV-2014 18:10:36
  1    394     267703333  28-NOV-2014 18:10:36 269280814  29-NOV-2014 08:49:28
  1    395     269280814  29-NOV-2014 08:49:28 271140117  29-NOV-2014 10:42:31
  1    396     271140117  29-NOV-2014 10:42:31 272990133  29-NOV-2014 12:16:31
  1    397     272990133  29-NOV-2014 12:16:31 274841558  29-NOV-2014 13:42:54
  1    398     274841558  29-NOV-2014 13:42:54 276695763  29-NOV-2014 15:04:47
  1    399     276695763  29-NOV-2014 15:04:47 278550497  29-NOV-2014 16:26:34
  1    400     278550497  29-NOV-2014 16:26:34 280405574  29-NOV-2014 17:52:06
  1    401     280405574  29-NOV-2014 17:52:06 282258621  29-NOV-2014 19:09:17
  1    402     282258621  29-NOV-2014 19:09:17 284112603  29-NOV-2014 20:16:31
  1    403     284112603  29-NOV-2014 20:16:31 285970693  29-NOV-2014 21:20:17
  1    404     285970693  29-NOV-2014 21:20:17 287825008  29-NOV-2014 22:21:37
  1    405     287825008  29-NOV-2014 22:21:37 289679608  29-NOV-2014 23:24:06
  1    406     289679608  29-NOV-2014 23:24:06 291531088  30-NOV-2014 00:32:49
  1    407     291531088  30-NOV-2014 00:32:49 293381547  30-NOV-2014 02:05:04
  2    270     266659220  27-NOV-2014 02:15:33 269280971  29-NOV-2014 08:49:29
  2    271     269280971  29-NOV-2014 08:49:29 274842253  29-NOV-2014 13:42:56
  2    272     274842253  29-NOV-2014 13:42:56 280405964  29-NOV-2014 17:52:08
  2    273     280405964  29-NOV-2014 17:52:08 285970919  29-NOV-2014 21:20:18
  2    274     285970919  29-NOV-2014 21:20:18 291532108  30-NOV-2014 00:32:52
  2    275     291532108  30-NOV-2014 00:32:52 293381201  30-NOV-2014 02:05:02

  Backup Set Copy #1 of backup set 532
  Device Type Elapsed Time Completion Time      Compressed Tag
  ----------- ------------ -------------------- ---------- ---
  DISK        00:03:20     30-NOV-2014 02:08:32 NO         TAG20141130T020512

    List of Backup Pieces for backup set 532 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    2294    1   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_1_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2295    2   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_2_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2296    3   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_3_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2297    4   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_4_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2298    5   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_5_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2299    6   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_6_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2300    7   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_7_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2301    8   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_8_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2302    9   AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_9_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2303    10  AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_10_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2304    11  AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_11_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2305    12  AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_12_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2306    13  AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_13_1_orcldb_20141130_ARCHIVELOG_30_11_2014
    2307    14  AVAILABLE   /backup/rmanbackup/rman_bkp_hvposdep_14_1_orcldb_20141130_ARCHIVELOG_30_11_2014

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
533     29.63G     DISK        00:07:04     04-DEC-2014 02:12:17

  List of Archived Logs in backup set 533
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    408     293381547  30-NOV-2014 02:05:04 295175276  30-NOV-2014 04:17:26
  1    409     295175276  30-NOV-2014 04:17:26 297016933  30-NOV-2014 07:00:54
  1    410     297016933  30-NOV-2014 07:00:54 298864673  30-NOV-2014 09:19:21
  1    411     298864673  30-NOV-2014 09:19:21 300707705  30-NOV-2014 11:03:06
  1    412     300707705  30-NOV-2014 11:03:06 302554351  30-NOV-2014 12:39:02
  1    413     302554351  30-NOV-2014 12:39:02 304413355  30-NOV-2014 14:01:22
  1    414     304413355  30-NOV-2014 14:01:22 306305119  30-NOV-2014 14:56:00
  1    415     306305119  30-NOV-2014 14:56:00 308195481  30-NOV-2014 15:48:49
  1    416     308195481  30-NOV-2014 15:48:49 310084603  30-NOV-2014 16:40:47
  1    417     310084603  30-NOV-2014 16:40:47 311973986  30-NOV-2014 17:31:36
  1    418     311973986  30-NOV-2014 17:31:36 313857575  30-NOV-2014 18:20:34
  1    419     313857575  30-NOV-2014 18:20:34 315750179  30-NOV-2014 19:07:45
  1    420     315750179  30-NOV-2014 19:07:45 317646575  30-NOV-2014 19:51:40
  1    421     317646575  30-NOV-2014 19:51:40 319546900  30-NOV-2014 20:31:05
  1    422     319546900  30-NOV-2014 20:31:05 321449269  30-NOV-2014 21:08:00
  1    423     321449269  30-NOV-2014 21:08:00 323352618  30-NOV-2014 21:44:16
  1    424     323352618  30-NOV-2014 21:44:16 325253052  30-NOV-2014 22:22:08
  1    425     325253052  30-NOV-2014 22:22:08 327149419  30-NOV-2014 23:03:09
  1    426     327149419  30-NOV-2014 23:03:09 329043209  30-NOV-2014 23:49:08
  1    427     329043209  30-NOV-2014 23:49:08 330930031  01-DEC-2014 00:42:54
  1    428     330930031  01-DEC-2014 00:42:54 332813156  01-DEC-2014 01:39:53
  1    429     332813156  01-DEC-2014 01:39:53 334686832  01-DEC-2014 03:09:16
  1    430     334686832  01-DEC-2014 03:09:16 336479909  01-DEC-2014 05:06:37
  1    431     336479909  01-DEC-2014 05:06:37 338351182  01-DEC-2014 07:09:34
  1    432     338351182  01-DEC-2014 07:09:34 340226062  01-DEC-2014 08:45:18
  1    433     340226062  01-DEC-2014 08:45:18 342106822  01-DEC-2014 09:54:59
  1    434     342106822  01-DEC-2014 09:54:59 343990168  01-DEC-2014 10:54:41
  1    435     343990168  01-DEC-2014 10:54:41 345878328  01-DEC-2014 11:50:51
  1    436     345878328  01-DEC-2014 11:50:51 347770928  01-DEC-2014 12:40:44
  1    437     347770928  01-DEC-2014 12:40:44 349661540  01-DEC-2014 13:34:24
  1    438     349661540  01-DEC-2014 13:34:24 351551690  01-DEC-2014 14:28:20
  1    439     351551690  01-DEC-2014 14:28:20 353440861  01-DEC-2014 15:19:58
  1    440     353440861  01-DEC-2014 15:19:58 355331208  01-DEC-2014 16:10:08
  2    276     293381201  30-NOV-2014 02:05:02 297017049  30-NOV-2014 07:00:55
  2    277     297017049  30-NOV-2014 07:00:55 302554994  30-NOV-2014 12:39:05
  2    278     302554994  30-NOV-2014 12:39:05 308196833  30-NOV-2014 15:48:52
  2    279     308196833  30-NOV-2014 15:48:52 313858712  30-NOV-2014 18:20:37
  2    280     313858712  30-NOV-2014 18:20:37 319547815  30-NOV-2014 20:31:07
  2    281     319547815  30-NOV-2014 20:31:07 325253833  30-NOV-2014 22:22:09
  2    282     325253833  30-NOV-2014 22:22:09 330930209  01-DEC-2014 00:42:55
  2    283     330930209  01-DEC-2014 00:42:55 336480530  01-DEC-2014 05:06:40
  2    284     336480530  01-DEC-2014 05:06:40 342107564  01-DEC-2014 09:55:01
  2    285     342107564  01-DEC-2014 09:55:01 347772319  01-DEC-2014 12:40:46
  2    286     347772319  01-DEC-2014 12:40:46 353441416  01-DEC-2014 15:19:59

  Backup Set Copy #1 of backup set 533
  Device Type Elapsed Time Completion Time      Compressed Tag
  ----------- ------------ -------------------- ---------- ---
  DISK        00:07:04     04-DEC-2014 02:12:17 NO         TAG20141204T020512

    List of Backup Pieces for backup set 533 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    2308    1   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_1_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2309    2   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_2_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2310    3   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_3_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2311    4   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_4_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2312    5   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_5_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2313    6   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_6_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2314    7   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_7_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2315    8   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_8_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2316    9   AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_9_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2317    10  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_10_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2318    11  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_11_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2319    12  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_12_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2320    13  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_13_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2321    14  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_14_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2322    15  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_15_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2323    16  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_16_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2324    17  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_17_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2325    18  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_18_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2326    19  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_19_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2327    20  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_20_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2328    21  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_21_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2329    22  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_22_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2330    23  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_23_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2331    24  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_24_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2332    25  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_25_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2333    26  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_26_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2334    27  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_27_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2335    28  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_28_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2336    29  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_29_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2337    30  AVAILABLE   /backup/rmanbackup/rman_bkp_i1pp9jap_30_1_orcldb_20141204_ARCHIVELOG_04_12_2014

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ --------------------
534     29.63G     DISK        00:07:22     04-DEC-2014 02:19:48

  List of Archived Logs in backup set 534
  Thrd Seq     Low SCN    Low Time             Next SCN   Next Time
  ---- ------- ---------- -------------------- ---------- ---------
  1    441     355331208  01-DEC-2014 16:10:08 357219056  01-DEC-2014 17:03:46
  1    442     357219056  01-DEC-2014 17:03:46 359108215  01-DEC-2014 17:58:06
  1    443     359108215  01-DEC-2014 17:58:06 360997732  01-DEC-2014 18:49:25
  1    444     360997732  01-DEC-2014 18:49:25 362891438  01-DEC-2014 19:34:38
  1    445     362891438  01-DEC-2014 19:34:38 364792369  01-DEC-2014 20:14:13
  1    446     364792369  01-DEC-2014 20:14:13 366694378  01-DEC-2014 20:54:30
  1    447     366694378  01-DEC-2014 20:54:30 368595352  01-DEC-2014 21:34:44
  1    448     368595352  01-DEC-2014 21:34:44 370499421  01-DEC-2014 22:16:09
  1    449     370499421  01-DEC-2014 22:16:09 372404109  01-DEC-2014 22:53:28
  1    450     372404109  01-DEC-2014 22:53:28 374300198  01-DEC-2014 23:35:54
  1    451     374300198  01-DEC-2014 23:35:54 376192607  02-DEC-2014 00:21:01
  1    452     376192607  02-DEC-2014 00:21:01 378077691  02-DEC-2014 01:16:21
  1    453     378077691  02-DEC-2014 01:16:21 379954440  02-DEC-2014 02:29:38
  1    454     379954440  02-DEC-2014 02:29:38 381753810  02-DEC-2014 04:02:31
  1    455     381753810  02-DEC-2014 04:02:31 383625520  02-DEC-2014 05:54:26
  1    456     383625520  02-DEC-2014 05:54:26 385497446  02-DEC-2014 07:43:28
  1    457     385497446  02-DEC-2014 07:43:28 387374483  02-DEC-2014 09:02:52
  1    458     387374483  02-DEC-2014 09:02:52 389258444  02-DEC-2014 10:02:59
  1    459     389258444  02-DEC-2014 10:02:59 391143370  02-DEC-2014 11:00:48
  1    460     391143370  02-DEC-2014 11:00:48 393031238  02-DEC-2014 11:56:26
  1    461     393031238  02-DEC-2014 11:56:26 394920721  02-DEC-2014 12:51:18
  1    462     394920721  02-DEC-2014 12:51:18 396813149  02-DEC-2014 13:42:53
  1    463     396813149  02-DEC-2014 13:42:53 398702559  02-DEC-2014 14:38:54
  1    464     398702559  02-DEC-2014 14:38:54 400590746  02-DEC-2014 15:34:38
  1    465     400590746  02-DEC-2014 15:34:38 402479975  02-DEC-2014 16:30:12
  1    466     402479975  02-DEC-2014 16:30:12 404366251  02-DEC-2014 17:27:10
  1    467     404366251  02-DEC-2014 17:27:10 406257579  02-DEC-2014 18:17:07
  1    468     406257579  02-DEC-2014 18:17:07 408154834  02-DEC-2014 19:00:51
  1    469     408154834  02-DEC-2014 19:00:51 410055405  02-DEC-2014 19:43:19
  1    470     410055405  02-DEC-2014 19:43:19 411958987  02-DEC-2014 20:22:30
  1    471     411958987  02-DEC-2014 20:22:30 413864825  02-DEC-2014 20:57:55
  1    472     413864825  02-DEC-2014 20:57:55 415772442  02-DEC-2014 21:32:23
  1    473     415772442  02-DEC-2014 21:32:23 417659388  02-DEC-2014 22:09:16
  2    287     353441416  01-DEC-2014 15:19:59 359109379  01-DEC-2014 17:58:09
  2    288     359109379  01-DEC-2014 17:58:09 364793432  01-DEC-2014 20:14:15
  2    289     364793432  01-DEC-2014 20:14:15 370500508  01-DEC-2014 22:16:11
  2    290     370500508  01-DEC-2014 22:16:11 376192988  02-DEC-2014 00:21:02
  2    291     376192988  02-DEC-2014 00:21:02 381753921  02-DEC-2014 04:02:31
  2    292     381753921  02-DEC-2014 04:02:31 387374927  02-DEC-2014 09:02:53
  2    293     387374927  02-DEC-2014 09:02:53 393031775  02-DEC-2014 11:56:27
  2    294     393031775  02-DEC-2014 11:56:27 398702648  02-DEC-2014 14:38:54
  2    295     398702648  02-DEC-2014 14:38:54 404367460  02-DEC-2014 17:27:13
  2    296     404367460  02-DEC-2014 17:27:13 410056811  02-DEC-2014 19:43:22
  2    297     410056811  02-DEC-2014 19:43:22 415773210  02-DEC-2014 21:32:24

  Backup Set Copy #1 of backup set 534
  Device Type Elapsed Time Completion Time      Compressed Tag
  ----------- ------------ -------------------- ---------- ---
  DISK        00:07:22     04-DEC-2014 02:19:48 NO         TAG20141204T020512

    List of Backup Pieces for backup set 534 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    2338    1   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_1_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2339    2   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_2_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2340    3   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_3_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2341    4   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_4_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2342    5   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_5_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2343    6   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_6_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2344    7   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_7_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2345    8   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_8_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2346    9   AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_9_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2347    10  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_10_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2348    11  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_11_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2349    12  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_12_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2350    13  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_13_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2351    14  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_14_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2352    15  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_15_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2353    16  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_16_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2354    17  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_17_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2355    18  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_18_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2356    19  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_19_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2357    20  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_20_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2358    21  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_21_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2359    22  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_22_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2360    23  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_23_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2361    24  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_24_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2362    25  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_25_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2363    26  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_26_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2364    27  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_27_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2365    28  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_28_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2366    29  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_29_1_orcldb_20141204_ARCHIVELOG_04_12_2014
    2367    30  AVAILABLE   /backup/rmanbackup/rman_bkp_i2pp9joa_30_1_orcldb_20141204_ARCHIVELOG_04_12_2014

RMAN> list copy;
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
List of Archived Log Copies for database with db_unique_name orcldb
=====================================================================

Key     Thrd Seq     S Low Time
------- ---- ------- - --------------------
826     1    392     A 27-NOV-2014 02:05:02
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_392.267.870386331

838     1    393     A 27-NOV-2014 02:15:34
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_393.283.870386441

831     1    394     A 28-NOV-2014 18:10:36
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_394.277.870386335

840     1    395     A 29-NOV-2014 08:49:28
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_395.280.870386441

839     1    396     A 29-NOV-2014 10:42:31
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_396.282.870386441

837     1    397     A 29-NOV-2014 12:16:31
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_397.279.870386441

833     1    398     A 29-NOV-2014 13:42:54
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_398.275.870386335

835     1    399     A 29-NOV-2014 15:04:47
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_399.281.870386335

836     1    400     A 29-NOV-2014 16:26:34
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_400.276.870386441

829     1    401     A 29-NOV-2014 17:52:06
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_401.270.870386333

828     1    402     A 29-NOV-2014 19:09:17
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_402.265.870386333

834     1    403     A 29-NOV-2014 20:16:31
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_403.278.870386335

841     1    404     A 29-NOV-2014 21:20:17
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_404.393.870386441

832     1    405     A 29-NOV-2014 22:21:37
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_405.272.870386335

830     1    406     A 29-NOV-2014 23:24:06
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_406.274.870386335

842     1    407     A 30-NOV-2014 00:32:49
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_407.394.870386441

868     1    408     A 30-NOV-2014 02:05:04
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_408.420.870387171

878     1    409     A 30-NOV-2014 04:17:26
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_409.430.870387279

867     1    410     A 30-NOV-2014 07:00:54
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_410.419.870387171

869     1    411     A 30-NOV-2014 09:19:21
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_411.421.870387171

879     1    412     A 30-NOV-2014 11:03:06
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_412.431.870387279

857     1    413     A 30-NOV-2014 12:39:02
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_413.409.870387065

862     1    414     A 30-NOV-2014 14:01:22
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_414.414.870387065

856     1    415     A 30-NOV-2014 14:56:00
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_415.408.870386959

871     1    416     A 30-NOV-2014 15:48:49
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_416.423.870387173

860     1    417     A 30-NOV-2014 16:40:47
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_417.412.870387065

875     1    418     A 30-NOV-2014 17:31:36
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_418.427.870387277

864     1    419     A 30-NOV-2014 18:20:34
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_419.416.870387065

851     1    420     A 30-NOV-2014 19:07:45
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_420.403.870386957

850     1    421     A 30-NOV-2014 19:51:40
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_421.402.870386957

870     1    422     A 30-NOV-2014 20:31:05
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_422.422.870387173

881     1    423     A 30-NOV-2014 21:08:00
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_423.433.870387383

849     1    424     A 30-NOV-2014 21:44:16
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_424.401.870386957

877     1    425     A 30-NOV-2014 22:22:08
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_425.429.870387279

855     1    426     A 30-NOV-2014 23:03:09
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_426.407.870386959

858     1    427     A 30-NOV-2014 23:49:08
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_427.410.870387065

873     1    428     A 01-DEC-2014 00:42:54
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_428.425.870387277

874     1    429     A 01-DEC-2014 01:39:53
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_429.426.870387277

876     1    430     A 01-DEC-2014 03:09:16
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_430.428.870387279

872     1    431     A 01-DEC-2014 05:06:37
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_431.424.870387173

880     1    432     A 01-DEC-2014 07:09:34
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_432.432.870387279

866     1    433     A 01-DEC-2014 08:45:18
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_433.418.870387171

863     1    434     A 01-DEC-2014 09:54:59
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_434.415.870387065

861     1    435     A 01-DEC-2014 10:54:41
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_435.413.870387065

853     1    436     A 01-DEC-2014 11:50:51
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_436.405.870386957

852     1    437     A 01-DEC-2014 12:40:44
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_437.404.870386957

854     1    438     A 01-DEC-2014 13:34:24
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_438.406.870386959

865     1    439     A 01-DEC-2014 14:28:20
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_439.417.870387171

859     1    440     A 01-DEC-2014 15:19:58
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_1_seq_440.411.870387065

771     1    474     A 02-DEC-2014 22:09:16
        Name: +FRA/orcldb/archivelog/2014_12_02/thread_1_seq_474.351.865291583

773     1    475     A 02-DEC-2014 22:46:23
        Name: +FRA/orcldb/archivelog/2014_12_02/thread_1_seq_475.352.865293843

774     1    476     A 02-DEC-2014 23:24:03
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_476.354.865296515

775     1    477     A 03-DEC-2014 00:08:34
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_477.355.865299389

777     1    478     A 03-DEC-2014 00:56:29
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_478.356.865303511

778     1    479     A 03-DEC-2014 02:05:10
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_479.358.865309161

779     1    480     A 03-DEC-2014 03:39:21
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_480.359.865316487

781     1    481     A 03-DEC-2014 05:41:27
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_481.360.865322749

782     1    482     A 03-DEC-2014 07:25:48
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_482.362.865327729

783     1    483     A 03-DEC-2014 08:48:48
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_483.363.865331865

785     1    484     A 03-DEC-2014 09:57:44
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_484.364.865335329

786     1    485     A 03-DEC-2014 10:55:27
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_485.366.865338603

787     1    486     A 03-DEC-2014 11:50:02
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_486.367.865341793

789     1    487     A 03-DEC-2014 12:43:12
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_487.368.865345067

790     1    488     A 03-DEC-2014 13:37:47
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_488.370.865348267

791     1    489     A 03-DEC-2014 14:31:06
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_489.371.865351367

793     1    490     A 03-DEC-2014 15:22:47
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_490.372.865354593

794     1    491     A 03-DEC-2014 16:16:33
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_491.374.865357729

795     1    492     A 03-DEC-2014 17:08:49
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_492.375.865360923

797     1    493     A 03-DEC-2014 18:02:02
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_493.376.865363537

798     1    494     A 03-DEC-2014 18:45:36
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_494.378.865365977

799     1    495     A 03-DEC-2014 19:26:17
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_495.379.865368307

801     1    496     A 03-DEC-2014 20:05:07
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_496.380.865370613

802     1    497     A 03-DEC-2014 20:43:33
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_497.382.865372803

803     1    498     A 03-DEC-2014 21:20:02
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_498.383.865374789

805     1    499     A 03-DEC-2014 21:53:09
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_499.384.865376911

806     1    500     A 03-DEC-2014 22:28:31
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_500.386.865379277

807     1    501     A 03-DEC-2014 23:07:57
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_1_seq_501.387.865381817

809     1    502     A 03-DEC-2014 23:50:16
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_502.388.865384929

810     1    503     A 04-DEC-2014 00:42:08
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_503.390.865388651

812     1    504     A 04-DEC-2014 01:44:10
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_504.392.865389907

813     1    505     A 04-DEC-2014 02:05:07
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_505.350.865395725

815     1    506     A 04-DEC-2014 03:42:05
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_506.348.865403127

816     1    507     A 04-DEC-2014 05:45:26
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_507.349.865409313

817     1    508     A 04-DEC-2014 07:28:32
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_1_seq_508.346.865414217

956     1    509     A 04-DEC-2014 08:50:16
        Name: +FRA/orcldb/archivelog/2014_12_05/thread_1_seq_509.344.865504341

953     1    510     A 05-DEC-2014 09:52:20
        Name: +FRA/orcldb/archivelog/2014_12_07/thread_1_seq_510.345.865643287

954     1    511     A 07-DEC-2014 00:28:06
        Name: +FRA/orcldb/archivelog/2014_12_07/thread_1_seq_511.342.865649103

952     1    512     A 07-DEC-2014 02:05:02
        Name: +FRA/orcldb/archivelog/2014_12_08/thread_1_seq_512.339.865804589

951     1    513     A 08-DEC-2014 21:16:28
        Name: +FRA/orcldb/archivelog/2014_12_10/thread_1_seq_513.341.865951355

949     1    514     A 10-DEC-2014 14:02:35
        Name: +FRA/orcldb/archivelog/2014_12_11/thread_1_seq_514.338.865994705

948     1    515     A 11-DEC-2014 02:05:04
        Name: +FRA/orcldb/archivelog/2014_12_12/thread_1_seq_515.335.866144541

946     1    516     A 12-DEC-2014 19:42:21
        Name: +FRA/orcldb/archivelog/2014_12_14/thread_1_seq_516.337.866253903

945     1    517     A 14-DEC-2014 02:05:03
        Name: +FRA/orcldb/archivelog/2014_12_15/thread_1_seq_517.332.866395837

944     1    518     A 15-DEC-2014 17:30:36
        Name: +FRA/orcldb/archivelog/2014_12_17/thread_1_seq_518.331.866547803

942     1    519     A 17-DEC-2014 11:43:22
        Name: +FRA/orcldb/archivelog/2014_12_18/thread_1_seq_519.333.866599505

941     1    520     A 18-DEC-2014 02:05:04
        Name: +FRA/orcldb/archivelog/2014_12_19/thread_1_seq_520.328.866746863

939     1    521     A 19-DEC-2014 19:01:02
        Name: +FRA/orcldb/archivelog/2014_12_21/thread_1_seq_521.327.866858705

938     1    522     A 21-DEC-2014 02:05:04
        Name: +FRA/orcldb/archivelog/2014_12_22/thread_1_seq_522.326.867004305

937     1    523     A 22-DEC-2014 18:31:44
        Name: +FRA/orcldb/archivelog/2014_12_24/thread_1_seq_523.324.867151875

936     1    524     A 24-DEC-2014 11:31:13
        Name: +FRA/orcldb/archivelog/2014_12_25/thread_1_seq_524.325.867204305

934     1    525     A 25-DEC-2014 02:05:04
        Name: +FRA/orcldb/archivelog/2014_12_26/thread_1_seq_525.322.867345485

933     1    526     A 26-DEC-2014 17:18:04
        Name: +FRA/orcldb/archivelog/2014_12_28/thread_1_seq_526.319.867463505

931     1    527     A 28-DEC-2014 02:05:05
        Name: +FRA/orcldb/archivelog/2014_12_29/thread_1_seq_527.321.867610709

929     1    528     A 29-DEC-2014 18:58:29
        Name: +FRA/orcldb/archivelog/2014_12_31/thread_1_seq_528.318.867762723

928     1    529     A 31-DEC-2014 13:12:02
        Name: +FRA/orcldb/archivelog/2015_01_01/thread_1_seq_529.317.867809105

926     1    530     A 01-JAN-2015 02:05:05
        Name: +FRA/orcldb/archivelog/2015_01_02/thread_1_seq_530.314.867960171

924     1    531     A 02-JAN-2015 20:02:50
        Name: +FRA/orcldb/archivelog/2015_01_04/thread_1_seq_531.312.868068303

923     1    532     A 04-JAN-2015 02:05:03
        Name: +FRA/orcldb/archivelog/2015_01_05/thread_1_seq_532.313.868211281

922     1    533     A 05-JAN-2015 17:48:00
        Name: +FRA/orcldb/archivelog/2015_01_07/thread_1_seq_533.310.868330951

921     1    534     A 07-JAN-2015 03:02:31
        Name: +FRA/orcldb/archivelog/2015_01_08/thread_1_seq_534.307.868413905

919     1    535     A 08-JAN-2015 02:05:05
        Name: +FRA/orcldb/archivelog/2015_01_09/thread_1_seq_535.309.868545933

917     1    536     A 09-JAN-2015 14:45:32
        Name: +FRA/orcldb/archivelog/2015_01_10/thread_1_seq_536.306.868662819

916     1    537     A 10-JAN-2015 23:13:38
        Name: +FRA/orcldb/archivelog/2015_01_11/thread_1_seq_537.305.868673105

914     1    538     A 11-JAN-2015 02:05:04
        Name: +FRA/orcldb/archivelog/2015_01_12/thread_1_seq_538.302.868815959

912     1    539     A 12-JAN-2015 17:45:58
        Name: +FRA/orcldb/archivelog/2015_01_14/thread_1_seq_539.300.868956203

911     1    540     A 14-JAN-2015 08:43:22
        Name: +FRA/orcldb/archivelog/2015_01_15/thread_1_seq_540.298.869018703

909     1    541     A 15-JAN-2015 02:05:03
        Name: +FRA/orcldb/archivelog/2015_01_16/thread_1_seq_541.296.869162717

907     1    542     A 16-JAN-2015 18:05:16
        Name: +FRA/orcldb/archivelog/2015_01_18/thread_1_seq_542.295.869277903

906     1    543     A 18-JAN-2015 02:05:03
        Name: +FRA/orcldb/archivelog/2015_01_19/thread_1_seq_543.294.869417763

905     1    544     A 19-JAN-2015 16:56:03
        Name: +FRA/orcldb/archivelog/2015_01_21/thread_1_seq_544.292.869538385

904     1    545     A 21-JAN-2015 02:26:25
        Name: +FRA/orcldb/archivelog/2015_01_22/thread_1_seq_545.293.869623505

902     1    546     A 22-JAN-2015 02:05:05
        Name: +FRA/orcldb/archivelog/2015_01_23/thread_1_seq_546.290.869754475

898     1    547     A 23-JAN-2015 14:27:54
        Name: +FRA/orcldb/archivelog/2015_01_25/thread_1_seq_547.288.869881487

901     1    548     A 25-JAN-2015 01:44:46
        Name: +FRA/orcldb/archivelog/2015_01_25/thread_1_seq_548.286.869882709

897     1    549     A 25-JAN-2015 02:05:08
        Name: +FRA/orcldb/archivelog/2015_01_26/thread_1_seq_549.284.870019983

895     1    550     A 26-JAN-2015 16:13:03
        Name: +FRA/orcldb/archivelog/2015_01_28/thread_1_seq_550.266.870155813

894     1    551     A 28-JAN-2015 05:56:52
        Name: +FRA/orcldb/archivelog/2015_01_29/thread_1_seq_551.263.870228305

827     2    269     A 27-NOV-2014 02:05:02
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_269.273.870386331

843     2    270     A 27-NOV-2014 02:15:33
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_270.395.870386441

844     2    271     A 29-NOV-2014 08:49:29
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_271.396.870386451

845     2    272     A 29-NOV-2014 13:42:56
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_272.397.870386455

846     2    273     A 29-NOV-2014 17:52:08
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_273.398.870386455

847     2    274     A 29-NOV-2014 21:20:18
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_274.399.870386455

848     2    275     A 30-NOV-2014 00:32:52
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_275.400.870386455

892     2    276     A 30-NOV-2014 02:05:02
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_276.444.870387385

889     2    277     A 30-NOV-2014 07:00:55
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_277.441.870387385

884     2    278     A 30-NOV-2014 12:39:05
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_278.436.870387385

886     2    279     A 30-NOV-2014 15:48:52
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_279.438.870387385

890     2    280     A 30-NOV-2014 18:20:37
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_280.442.870387385

891     2    281     A 30-NOV-2014 20:31:07
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_281.443.870387385

888     2    282     A 30-NOV-2014 22:22:09
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_282.440.870387385

882     2    283     A 01-DEC-2014 00:42:55
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_283.434.870387385

883     2    284     A 01-DEC-2014 05:06:40
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_284.435.870387385

885     2    285     A 01-DEC-2014 09:55:01
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_285.437.870387385

887     2    286     A 01-DEC-2014 12:40:46
        Name: +FRA/orcldb/archivelog/2015_01_30/thread_2_seq_286.439.870387385

772     2    298     A 02-DEC-2014 21:32:24
        Name: +FRA/orcldb/archivelog/2014_12_02/thread_2_seq_298.353.865293845

776     2    299     A 02-DEC-2014 23:24:03
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_299.357.865303511

780     2    300     A 03-DEC-2014 02:05:11
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_300.361.865322751

784     2    301     A 03-DEC-2014 07:25:51
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_301.365.865335329

788     2    302     A 03-DEC-2014 10:55:28
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_302.369.865345069

792     2    303     A 03-DEC-2014 13:37:47
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_303.373.865354595

796     2    304     A 03-DEC-2014 16:16:33
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_304.377.865363537

800     2    305     A 03-DEC-2014 18:45:37
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_305.381.865370615

804     2    306     A 03-DEC-2014 20:43:34
        Name: +FRA/orcldb/archivelog/2014_12_03/thread_2_seq_306.385.865376915

808     2    307     A 03-DEC-2014 22:28:34
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_2_seq_307.389.865384931

811     2    308     A 04-DEC-2014 00:42:10
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_2_seq_308.391.865389903

814     2    309     A 04-DEC-2014 02:05:02
        Name: +FRA/orcldb/archivelog/2014_12_04/thread_2_seq_309.347.865403129

957     2    310     A 04-DEC-2014 05:45:29
        Name: +FRA/orcldb/archivelog/2014_12_05/thread_2_seq_310.343.865504343

955     2    311     A 05-DEC-2014 09:52:21
        Name: +FRA/orcldb/archivelog/2014_12_07/thread_2_seq_311.340.865649105

950     2    312     A 07-DEC-2014 02:05:05
        Name: +FRA/orcldb/archivelog/2014_12_11/thread_2_seq_312.336.865994705

947     2    313     A 11-DEC-2014 02:05:05
        Name: +FRA/orcldb/archivelog/2014_12_14/thread_2_seq_313.334.866253905

943     2    314     A 14-DEC-2014 02:05:03
        Name: +FRA/orcldb/archivelog/2014_12_18/thread_2_seq_314.330.866599507

940     2    315     A 18-DEC-2014 02:05:06
        Name: +FRA/orcldb/archivelog/2014_12_21/thread_2_seq_315.329.866858705

935     2    316     A 21-DEC-2014 02:05:04
        Name: +FRA/orcldb/archivelog/2014_12_25/thread_2_seq_316.323.867204305

932     2    317     A 25-DEC-2014 02:05:03
        Name: +FRA/orcldb/archivelog/2014_12_28/thread_2_seq_317.320.867463503

930     2    318     A 28-DEC-2014 02:05:03
        Name: +FRA/orcldb/archivelog/2014_12_31/thread_2_seq_318.316.867762725

927     2    319     A 31-DEC-2014 13:12:05
        Name: +FRA/orcldb/archivelog/2015_01_01/thread_2_seq_319.315.867809103

925     2    320     A 01-JAN-2015 02:05:03
        Name: +FRA/orcldb/archivelog/2015_01_04/thread_2_seq_320.311.868068305

920     2    321     A 04-JAN-2015 02:05:03
        Name: +FRA/orcldb/archivelog/2015_01_08/thread_2_seq_321.308.868413903

918     2    322     A 08-JAN-2015 02:05:03
        Name: +FRA/orcldb/archivelog/2015_01_10/thread_2_seq_322.304.868662821

915     2    323     A 10-JAN-2015 23:13:40
        Name: +FRA/orcldb/archivelog/2015_01_11/thread_2_seq_323.303.868673103

913     2    324     A 11-JAN-2015 02:05:02
        Name: +FRA/orcldb/archivelog/2015_01_14/thread_2_seq_324.299.868956205

910     2    325     A 14-JAN-2015 08:43:24
        Name: +FRA/orcldb/archivelog/2015_01_15/thread_2_seq_325.301.869018703

908     2    326     A 15-JAN-2015 02:05:02
        Name: +FRA/orcldb/archivelog/2015_01_18/thread_2_seq_326.297.869277903

903     2    327     A 18-JAN-2015 02:05:03
        Name: +FRA/orcldb/archivelog/2015_01_22/thread_2_seq_327.291.869623503

899     2    328     A 22-JAN-2015 02:05:03
        Name: +FRA/orcldb/archivelog/2015_01_25/thread_2_seq_328.287.869881489

900     2    329     A 25-JAN-2015 01:44:47
        Name: +FRA/orcldb/archivelog/2015_01_25/thread_2_seq_329.289.869882705

896     2    330     A 25-JAN-2015 02:05:04
        Name: +FRA/orcldb/archivelog/2015_01_28/thread_2_seq_330.285.870155815

893     2    331     A 28-JAN-2015 05:56:53
        Name: +FRA/orcldb/archivelog/2015_01_29/thread_2_seq_331.264.870228303

RMAN> list backup of datafile 11;
specification does not match any backup in the repository

RMAN> list copy of datafile 11;
specification does not match any datafile copy in the repository

RMAN> run {
2> set until time "to_date('29-NOV-2014 19:09:17','DD-MON-RRRR HH24:MI:SS')";
3> restore datafile 11;
4> }
executing command: SET until clause

Starting restore at 31-JAN-2015 04:42:12
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=10 instance=orcldb2 device type=DISK
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/31/2015 04:42:12
RMAN-20201: datafile not found in the recovery catalog
RMAN-06010: error while looking up datafile: 11

RMAN> spool log off;

Analysis
1/ The datafile# 11 was created on ’04-DEC-2014 09:16:22′.

2/ That explains why datafile# 11 has no backup taken before ’04-DEC-2014 09:16:22′.

3/ By the way, how far do you want to recover the database? Please provide the exact date and time that you want to recover the database.

Action-2

Let say we need to recover database till 27Nov 14.

As mentioned, the 10 datafiles have CHECKPOINT_TIME='29-NOV-2014 19:09:17',
and the datafile# 11, '+DATA/orcldb/datafile/TBSORCL21.268.865415781' has
CHECKPOINT_TIME='04-DEC-2014 09:16:22'. However, you want to recover the
database to November 27th.

I suggest to perform the following:

1/ First, make a copy of the current controlfile.

RMAN> backup current controlfile format '/tmp/controlfile.rmanbkup';

2/ Next, shutdown the database.

SQL> shutdown immediate;

3/ Startup nomount.

SQL> startup nomount;

4/ Restore the controlfile.

RMAN> restore controlfile from '/u01/app/oracle/product/11.2.0/db_1/dbs/c-489766533-20141127-00';

5/ Mount the database;

RMAN> sql "alter database mount";

6/ Catalog the RMAN backuppieces.

RMAN> catalog start with '/backup/rmanbackup/';

7/ Restore the database.

RMAN> restore database;

8/ Recover the database.

run {
set until time "to_date('27-NOV-2014 02:15:37','DD-MON-RRRR HH24:MI:SS')";
recover database;
}

9/ After the recovery is completed, run the following SQL statement to
verify the status and checkpoint of the datafiles. If the query return 1
row with STATUS='ONLINE', FUZZY='NO' and CHECKPOINT_CHANGE#/TIME, the
proceed to open the database.

select error, fuzzy, status, checkpoint_change#,
to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
count(*)
from v$datafile_header
group by error, fuzzy, status, checkpoint_change#, checkpoint_time
order by checkpoint_change#, checkpoint_time;

10/ Open the database.

RMAN> alter database open resetlogs;
I am getting error in fourth point. find below log..

RMAN> restore controlfile from '/u01/app/oracle/product/11.2.0/db_1/dbs/c-489766533-20141127-00';

Starting restore at 31-JAN-15
using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 01/31/2015 05:26:13
RMAN-06172: no AUTOBACKUP found or specified handle is not a valid copy or piece

RMAN> exit

"c-489766533-20141127-00" file is not available at mentioned location..
Find all files from "'/u01/app/oracle/product/11.2.0/db_1/dbs" location.

-bash-3.2$ ll
total 36496
-rw-r----- 1 oracle oinstall 18808832 Jan 31 01:55 c-489766533-20141204-00
-rw-rw---- 1 oracle oinstall 1544 Jan 31 05:25 hc_orcldb2.dat
-rw-r----- 1 oracle oinstall 1660 Jan 30 18:34 initorcldb2.ora
-rw-r--r-- 1 oracle oinstall 2851 Jul 27 2013 init.ora
-rw-r----- 1 oracle oinstall 1536 Jul 27 2013 orapworcldb2
-rw-r----- 1 oracle oinstall 18497536 Jul 29 2013 snapcf_orcldb2.f
-bash-3.2$

Recommendation-2

1/ Before you do any RMAN restore, please run the following OS commands,
as shown here. If the required RMAN backuppieces containing the datafiles
are not in the directory '/backup/rmanbackup/', then proceed to the next
step, which is to restore the datafiles.

uname -a
id
env | grep ORACLE
ps -ef | grep smon
ls -l /backup/rmanbackup/

2/ I suggest to perform the following:

a. First, make sure the database is already mounted.

b. Offline the datafile# 11.

SQL> alter database datafile 11 offline drop;

c. Restore the database.

spool log to rman_db_restore01.log
set echo on
run {
set until time "to_date('27-NOV-2014 02:15:37','DD-MON-RRRR HH24:MI:SS')";
restore database;
}
spool log off

Important Note: Before running the RMAN commands posted above, please
issue the following OS command to set the NLS_DATE_FORMAT, as shown below.
This will allow to display the date, as well as, the time information,
which will help us in our analysis.

NLS_DATE_FORMAT="DD-MON-RRRR HH24:MI:SS"
export NLS_DATE_FORMAT

d. Recover the database.

spool log to rman_db_recover01.log
set echo on
run {
set until time "to_date('27-NOV-2014 02:15:37','DD-MON-RRRR HH24:MI:SS')";
recover database;
}
spool log off

e. After the recovery is completed, run the following SQL statement to
verify the status and checkpoint of the datafiles. If the query return 1
row with STATUS='ONLINE', FUZZY='NO' and CHECKPOINT_CHANGE#/TIME, the
proceed to open the database.

select error, fuzzy, status, checkpoint_change#,
to_char(checkpoint_time, 'DD-MON-YYYY HH24:MI:SS') as checkpoint_time,
count(*)
from v$datafile_header
group by error, fuzzy, status, checkpoint_change#, checkpoint_time
order by checkpoint_change#, checkpoint_time;

f. Open the database.

RMAN> alter database open resetlogs;

🙂

The price we pay for the speedup of the insert

The Great artical by uhesse

The outcome of NOLOGGING operations, should the affected datafiles get damaged before we manage to take a backup of them.

As you probably know, we are allowed to suppress the usual redo protocol generation for certain statements, especially for
CREATE TABLE AS SELECT, INSERT INTO … SELECT and CREATE INDEX. If we can take a backup of the related datafiles after these
operations, everything is ok. We simply saved time during the above mentioned operations. But what if the datafiles actually
get damaged?

Hands On
http://uhesse.com/2009/09/15/how-do-nologging-operations-affect-recovery/

Oracle Data Guard – OTN Thread
NOLOGGING tables and recovery of database (and standby)

Even if you have tables with NOLOGGING minimal logging with respect to table structure changes are recorded, so in the case
of recovery, you can recover the database with nologging tables from the last full backup but data changes after the full
backup can not be recovered on the nologging tables.

You should avoid this situation by saying

SQL> alter database force logging;

on the Primary – best before creation of the Standby. Else you will lose the objects created with nologging in case of a failover.
If nologging operations have been done on the Primary already, but no damage there yet – better recreate the Standby after force
logging on the Primary.

1. So basically, if we are using Dataguard, NOLOGGING is not a good idea.
exactly.
2. What actually happens there? does the standby is not maintained at all?
No. It is maintained.
3. only the NOLOGGING objects will be in a corrupt/unusable state?
Yes
4. Will the standby have the DDL changes on NOLOGGING objects?
yes
5. Is it possible to find out such corrupt objects (if we are switching to the standby)?
You use them and get error messages.
6. Also, even if we are FORCE LOGGING, if we truncate a table or partition, will we brake the standby?
no. the truncate is reproduced on the standby.

https://community.oracle.com/thread/2146256?start=0&tstart=0

How to Recover !!!!!
No way, still last valid datafile backup

http://docs.oracle.com/cd/E11882_01/server.112/e41134/scenarios.htm#i1015738

13.4 Recovering After the NOLOGGING Clause Is Specified

In some SQL statements, the user has the option of specifying the NOLOGGING clause, which indicates that the database operation is not logged in the online redo log file. Even though the user specifies the clause, a redo record is still written to the online redo log file. However, there is no data associated with this record. This can result in log application or data access errors at the standby site and manual recovery might be required to resume applying log files.

Note:
To avoid these problems, Oracle recommends that you always specify the FORCE LOGGING clause in the CREATE DATABASE or ALTER DATABASE statements. See the Oracle Database Administrator’s Guide.

13.4.1 Recovery Steps for Logical Standby Databases

For logical standby databases, when SQL Apply encounters a redo record for an operation performed on an interesting table with the NOLOGGING clause, it stops with the following error: ORA-16211 unsupported record found in the archived redo log.

To recover after the NOLOGGING clause is specified, re-create one or more tables from the primary database, as described in Section 10.5.5.

Note:
In general, use of the NOLOGGING clause is not recommended. Optionally, if you know in advance that operations using the NOLOGGING clause will be performed on certain tables in the primary database, you might want to prevent the application of SQL statements associated with these tables to the logical standby database by using the DBMS_LOGSTDBY.SKIP procedure.
13.4.2 Recovery Steps for Physical Standby Databases

When the archived redo log file is copied to the standby site and applied to the physical standby database, a portion of the datafile is unusable and is marked as being unrecoverable. When you either fail over to the physical standby database, or open the standby database for read-only access, and attempt to read the range of blocks that are marked as UNRECOVERABLE, you will see error messages similar to the following:

ORA-01578: ORACLE data block corrupted (file # 1, block # 2521)
ORA-01110: data file 1: ‘/oracle/dbs/stdby/tbs_1.dbf’
ORA-26040: Data block was loaded using the NOLOGGING option

To recover after the NOLOGGING clause is specified, you need to copy the datafile that contains the missing redo data from the primary site to the physical standby site. Perform the following steps:

Step 1 Determine which datafiles should be copied.

Follow these steps:

Query the primary database:

        SQL> SELECT NAME, UNRECOVERABLE_CHANGE# FROM V$DATAFILE;

        NAME                                                  UNRECOVERABLE
        ----------------------------------------------------- -------------
        /oracle/dbs/tbs_1.dbf                                       5216
        /oracle/dbs/tbs_2.dbf                                          0
        /oracle/dbs/tbs_3.dbf                                          0
        /oracle/dbs/tbs_4.dbf                                          0
        4 rows selected.

Query the standby database:

        SQL> SELECT NAME, UNRECOVERABLE_CHANGE# FROM V$DATAFILE;

        NAME                                                  UNRECOVERABLE
        ----------------------------------------------------- -------------
        /oracle/dbs/stdby/tbs_1.dbf                                 5186
        /oracle/dbs/stdby/tbs_2.dbf                                    0
        /oracle/dbs/stdby/tbs_3.dbf                                    0
        /oracle/dbs/stdby/tbs_4.dbf                                    0
        4 rows selected.

Compare the query results of the primary and standby databases.

Compare the value of the UNRECOVERABLE_CHANGE# column in both query results.
If the value of the UNRECOVERABLE_CHANGE# column in the primary database is greater than the same column in the standby database, then the datafile needs to be copied from the primary site to the standby site.

In this example, the value of the UNRECOVERABLE_CHANGE# in the primary database for the tbs_1.dbf datafile is greater, so you need
to copy the tbs_1.dbf datafile to the standby site.

Step 2 On the primary site, back up the datafile you need to copy to the standby site.

Issue the following SQL statements:

    SQL> ALTER TABLESPACE system BEGIN BACKUP;
    SQL> EXIT;

    Copy the needed datafile to a local directory.

    SQL> ALTER TABLESPACE system END BACKUP;

Step 3 Copy the datafile to the standby database.

Copy the datafile that contains the missing redo data from the primary site to a location on the physical standby site where files related to recovery are stored.

Step 4 On the standby database, restart Redo Apply.

Issue the following SQL statement:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;

You might get the following error messages (possibly in the alert log) when you try to restart Redo Apply:

ORA-00308: cannot open archived log ‘standby1’
ORA-27037: unable to obtain file status
SVR4 Error: 2: No such file or directory
Additional information: 3
ORA-01547: warning: RECOVER succeeded but OPEN RESETLOGS would get error below
ORA-01152: file 1 was not restored from a sufficiently old backup
ORA-01110: data file 1: ‘/oracle/dbs/stdby/tbs_1.dbf’

If you get the ORA-00308 error and Redo Apply does not terminate automatically, you can cancel recovery by issuing the following SQL statement from another terminal window:

SQL> ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;

These error messages are returned when one or more log files in the archive gap have not been successfully applied. If you receive these errors, manually resolve the gaps, and repeat Step 4. See Section 6.4.3.1 for information about manually resolving an archive gap.

13.4.3 Determining If a Backup Is Required After Unrecoverable Operations

If you performed unrecoverable operations on your primary database, determine if a new backup operation is required by following these steps:

Query the V$DATAFILE view on the primary database to determine the system change number (SCN) or the time at which the Oracle database generated the most recent invalidated redo data.

Issue the following SQL statement on the primary database to determine if you need to perform another backup:

    SQL> SELECT UNRECOVERABLE_CHANGE#,TO_CHAR(UNRECOVERABLE_TIME, 'mm-dd-yyyy hh:mi:ss') FROM   V$DATAFILE;

If the query in the previous step reports an unrecoverable time for a datafile that is more recent than the time when the datafile was last backed up, then make another backup of the datafile in question.

See Oracle Database Reference for more information about the V$DATAFILE view.

Ref

Nologging operations affect standby database

How to check Corruption in Database ?

The primary tool for checking for corruption in an Oracle database is DBVERIFY. It can be used to perform a physical data structure integrity check on data files whether the database is online or offline. The big benefit of this is that DBVERIFY can be used to check backup data files without adding load to the database server. You invoke DBVERIFY from the operating system command line like this:
$ dbv file=data01.dbf logfile=verify.log blocksize=8192 feedback=100
In this example data01.dbf is the data file to check, and the tablespace this file belongs to has a block size of 8192 bytes. The feedback parameter tells DBVERIFY to draw a period on the screen after every 100 pages (blocks) of the file are verified.
In the log file you’ll see output like this:

DBVERIFY – Verification starting : FILE = data01.dbf

DBVERIFY – Verification complete

Total Pages Examined : 640
Total Pages Processed (Data) : 631
Total Pages Failing (Data) : 0
Total Pages Processed (Index): 0
Total Pages Failing (Index): 0
Total Pages Processed (Other): 9
Total Pages Empty : 0
Total Pages Marked Corrupt : 0
Total Pages Influx : 0
The Total Pages Failing values show the number of blocks that failed either the data block or index block checking routine. The Total Pages Marked Corrupt figure shows the number of blocks for which the cache header is invalid, thereby making it impossible for DBVERIFY to identify the block type. And the Total Pages Influx is the number of blocks for which DBVERIFY could not get a consistent image. (This could happen if the database is open when DBVERIFY is run. DBVERIFY reads blocks multiple times to try to get a consistent image, but DBVERIFY cannot get a consistent image of pages that are in flux.)
If you want to verify only a portion of a data file, you can specify a starting and ending block when running DBVERIFY. If you want to verify the entire database, you can generate a short shell script to run DBVERIFY on every data file in the database. You can do this easily using SQL*Plus:

SQL> SPOOL dbv_on_all_files.sh
SQL> SELECT ‘dbv file=’ || file_name ||
2 ‘ logfile=file’ || ROWNUM ||
3 ‘.log blocksize=8192′
4 FROM dba_data_files;
SQL> SPOOL OFF
After running the shell script you can quickly scan all of the DBVERIFY log files with Unix commands like:
$ grep Failing file*.log
$ grep Corrupt file*.log
$ grep Influx file*.log
You can also use DBVERIFY to validate a single data or index segment. To do this you must be logged onto the database with SYSDBA privileges. During the verification the segment is locked; if the segment is an index then the parent table is also locked.
There are other ways to check for database corruption besides DBVERIFY. You can take a full database export, with the dump file optionally specified as a null device. This will read every row in every user table in the database, discovering any corrupted data blocks along the way. However, this technique does not access every index entry or the entire data dictionary.

If you want to check one table and all of its indexes, you can use the ANALYZE statement to read every row of the table, read every entry in each of the table’s indexes, and make sure the table and index data are consistent with each other:

SQL> ANALYZE TABLE emp VALIDATE STRUCTURE CASCADE;
This will lock the table, preventing DML on the table, unless you specify the ONLINE keyword. Online validation reduces the amount of validation performed to allow for concurrency.
There are several ways to check for corruption in an Oracle database, but the DBVERIFY tool is the most versatile. DBVERIFY does not limit concurrency or DML while it is running, and it can be run against a database backup. Just remember that if DBVERIFY detects corruption in your database and you are planning to recover the corrupt file from a backup, you should perform a DBVERIFY validation on the backup file before beginning the recovery. This will tell you if the corruption exists in the backup also.