Logo MurCode
Oracle Новое сообщение

rman restore ORA-01110: data file 1 system01.dbf

gda
Дата: 19.10.2015 11:23:51
Получаю "ORA-01110: data file 1: '/opt/oracle/oradata/prod/system01.dbf'" при "rman> restore database;".

Ниже привожу результаты команд:

list backup of controlfileж
list backup of database;
restore database;
show all;
list incarnation;


RMAN> list backup of controlfile;


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

BS Key  Type LV Size
------- ---- -- ----------
18967   Full    284.86M
  Control File Included: Ckp SCN: 7515635068   Ckp time: 04-OCT-15

  Backup Set Copy #1 of backup set 18967
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151004T024428

    List of Backup Pieces for backup set 18967 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19208   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_04/o1_mf_s_892176268_c10t2z87_.bkp

  Backup Set Copy #2 of backup set 18967
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151004T024428

    List of Backup Pieces for backup set 18967 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19222   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_04/o1_mf_s_892176268_c10t2z87_.bkp

BS Key  Type LV Size
------- ---- -- ----------
18978   Full    284.86M
  Control File Included: Ckp SCN: 7516099553   Ckp time: 05-OCT-15

  Backup Set Copy #1 of backup set 18978
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151005T024229

    List of Backup Pieces for backup set 18978 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19210   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_05/o1_mf_s_892262549_c13gc88l_.bkp

  Backup Set Copy #2 of backup set 18978
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151005T024229

    List of Backup Pieces for backup set 18978 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19224   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_05/o1_mf_s_892262549_c13gc88l_.bkp

BS Key  Type LV Size
------- ---- -- ----------
18993   Full    284.86M
  Control File Included: Ckp SCN: 7518970578   Ckp time: 06-OCT-15

  Backup Set Copy #1 of backup set 18993
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151006T025918

    List of Backup Pieces for backup set 18993 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19205   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_06/o1_mf_s_892349958_c163psnr_.bkp

  Backup Set Copy #2 of backup set 18993
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151006T025918

    List of Backup Pieces for backup set 18993 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19215   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_06/o1_mf_s_892349958_c163psnr_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19008   Full    284.86M
  Control File Included: Ckp SCN: 7523132776   Ckp time: 07-OCT-15

  Backup Set Copy #1 of backup set 19008
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151007T025816

    List of Backup Pieces for backup set 19008 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19212   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_07/o1_mf_s_892436296_c18r0vro_.bkp

  Backup Set Copy #2 of backup set 19008
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151007T025816

    List of Backup Pieces for backup set 19008 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19226   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_07/o1_mf_s_892436296_c18r0vro_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19024   Full    284.86M
  Control File Included: Ckp SCN: 7527052237   Ckp time: 08-OCT-15

  Backup Set Copy #1 of backup set 19024
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151008T025733

    List of Backup Pieces for backup set 19024 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19206   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_08/o1_mf_s_892522653_c1cdcjkc_.bkp

  Backup Set Copy #2 of backup set 19024
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:06     19-OCT-15       NO         TAG20151008T025733

    List of Backup Pieces for backup set 19024 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19216   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_08/o1_mf_s_892522653_c1cdcjkc_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19040   Full    284.86M
  Control File Included: Ckp SCN: 7529559607   Ckp time: 09-OCT-15

  Backup Set Copy #1 of backup set 19040
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151009T025936

    List of Backup Pieces for backup set 19040 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19211   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_09/o1_mf_s_892609176_c1g0vd8b_.bkp

  Backup Set Copy #2 of backup set 19040
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151009T025936

    List of Backup Pieces for backup set 19040 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19225   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_09/o1_mf_s_892609176_c1g0vd8b_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19055   Full    284.86M
  Control File Included: Ckp SCN: 7532260598   Ckp time: 10-OCT-15

  Backup Set Copy #1 of backup set 19055
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151010T085737

    List of Backup Pieces for backup set 19055 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19209   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_10/o1_mf_s_892717057_c1kb6okh_.bkp

  Backup Set Copy #2 of backup set 19055
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151010T085737

    List of Backup Pieces for backup set 19055 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19223   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_10/o1_mf_s_892717057_c1kb6okh_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19067   Full    284.86M
  Control File Included: Ckp SCN: 7532519100   Ckp time: 11-OCT-15

  Backup Set Copy #1 of backup set 19067
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     11-OCT-15       NO         TAG20151011T024505

    List of Backup Pieces for backup set 19067 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19098   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_11/o1_mf_s_892781105_c1m8r4js_.bkp

  Backup Set Copy #2 of backup set 19067
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151011T024505

    List of Backup Pieces for backup set 19067 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19219   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_11/o1_mf_s_892781105_c1m8r4js_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19079   Full    284.86M
  Control File Included: Ckp SCN: 7533016342   Ckp time: 12-OCT-15

  Backup Set Copy #1 of backup set 19079
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     12-OCT-15       NO         TAG20151012T024339

    List of Backup Pieces for backup set 19079 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19110   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_12/o1_mf_s_892867419_c1ox1gtk_.bkp

  Backup Set Copy #2 of backup set 19079
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151012T024339

    List of Backup Pieces for backup set 19079 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19221   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_12/o1_mf_s_892867419_c1ox1gtk_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19095   Full    284.86M
  Control File Included: Ckp SCN: 7536292455   Ckp time: 13-OCT-15

  Backup Set Copy #1 of backup set 19095
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     13-OCT-15       NO         TAG20151013T030228

    List of Backup Pieces for backup set 19095 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19126   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_13/o1_mf_s_892954948_c1rljr37_.bkp

  Backup Set Copy #2 of backup set 19095
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151013T030228

    List of Backup Pieces for backup set 19095 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19213   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_13/o1_mf_s_892954948_c1rljr37_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19109   Full    284.86M
  Control File Included: Ckp SCN: 7543119741   Ckp time: 14-OCT-15

  Backup Set Copy #1 of backup set 19109
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     14-OCT-15       NO         TAG20151014T025635

    List of Backup Pieces for backup set 19109 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19140   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_14/o1_mf_s_893040995_c1v6kqfk_.bkp

  Backup Set Copy #2 of backup set 19109
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151014T025635

    List of Backup Pieces for backup set 19109 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19228   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_14/o1_mf_s_893040995_c1v6kqfk_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19122   Full    284.86M
  Control File Included: Ckp SCN: 7546690634   Ckp time: 15-OCT-15

  Backup Set Copy #1 of backup set 19122
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     15-OCT-15       NO         TAG20151015T025130

    List of Backup Pieces for backup set 19122 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19153   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_15/o1_mf_s_893127090_c1xtn5pn_.bkp

  Backup Set Copy #2 of backup set 19122
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151015T025130

    List of Backup Pieces for backup set 19122 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19214   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_15/o1_mf_s_893127090_c1xtn5pn_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19138   Full    284.86M
  Control File Included: Ckp SCN: 7549653184   Ckp time: 16-OCT-15

  Backup Set Copy #1 of backup set 19138
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     16-OCT-15       NO         TAG20151016T025745

    List of Backup Pieces for backup set 19138 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19169   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_16/o1_mf_s_893213865_c20hcwvv_.bkp

  Backup Set Copy #2 of backup set 19138
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151016T025745

    List of Backup Pieces for backup set 19138 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19217   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_16/o1_mf_s_893213865_c20hcwvv_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19152   Full    284.86M
  Control File Included: Ckp SCN: 7552937885   Ckp time: 17-OCT-15

  Backup Set Copy #1 of backup set 19152
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:08     17-OCT-15       NO         TAG20151017T082801

    List of Backup Pieces for backup set 19152 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19183   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_17/o1_mf_s_893320081_c23q362h_.bkp

  Backup Set Copy #2 of backup set 19152
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:08     19-OCT-15       NO         TAG20151017T082801

    List of Backup Pieces for backup set 19152 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19227   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_17/o1_mf_s_893320081_c23q362h_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19163   Full    284.86M
  Control File Included: Ckp SCN: 7553234943   Ckp time: 18-OCT-15

  Backup Set Copy #1 of backup set 19163
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     18-OCT-15       NO         TAG20151018T024229

    List of Backup Pieces for backup set 19163 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19194   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_18/o1_mf_s_893385749_c25q78sg_.bkp

  Backup Set Copy #2 of backup set 19163
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:07     19-OCT-15       NO         TAG20151018T024229

    List of Backup Pieces for backup set 19163 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19218   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_18/o1_mf_s_893385749_c25q78sg_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19174   Full    284.86M
  Control File Included: Ckp SCN: 7553671990   Ckp time: 19-OCT-15

  Backup Set Copy #1 of backup set 19174
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:00     19-OCT-15       NO         TAG20151019T024010

    List of Backup Pieces for backup set 19174 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19207   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/autobackup/2015_10_19/o1_mf_s_893472010_c28cgy0x_.bkp

  Backup Set Copy #2 of backup set 19174
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:00     19-OCT-15       NO         TAG20151019T024010

    List of Backup Pieces for backup set 19174 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19220   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/autobackup/2015_10_19/o1_mf_s_893472010_c28cgy0x_.bkp

RMAN> list backup of database;


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

BS Key  Type LV Size
------- ---- -- ----------
19143   Incr 0  22.46G
  List of Datafiles in backup set 19143
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    0  Incr 7552778254 17-OCT-15 /opt/oracle/oradata/prod/absolut_rap01.dbf
  8    0  Incr 7552778254 17-OCT-15 /opt/oracle/oradata/prod/absolut_trn02.dbf
  18   0  Incr 7552778254 17-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn05.dbf
  23   0  Incr 7552778254 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap03.dbf
  28   0  Incr 7552778254 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx05.dbf

  Backup Set Copy #1 of backup set 19143
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        01:05:22     17-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19143 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19174   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c2322xkf_.bkp

  Backup Set Copy #2 of backup set 19143
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        01:05:22     19-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19143 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19258   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c2322xkf_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19144   Incr 0  18.04G
  List of Datafiles in backup set 19144
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9    0  Incr 7552782294 17-OCT-15 /opt/oracle/oradata/prod/absolut_trn03.dbf
  24   0  Incr 7552782294 17-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn07.dbf
  25   0  Incr 7552782294 17-OCT-15 /opt/oracle/oradata/prod/system02.dbf
  29   0  Incr 7552782294 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap04.dbf
  31   0  Incr 7552782294 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap05.dbf
  33   0  Incr 7552782294 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx06.dbf

  Backup Set Copy #1 of backup set 19144
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:55:44     17-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19144 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19175   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c235xm5y_.bkp

  Backup Set Copy #2 of backup set 19144
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:55:44     19-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19144 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19256   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c235xm5y_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19145   Incr 0  18.53G
  List of Datafiles in backup set 19145
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    0  Incr 7552785441 17-OCT-15 /opt/oracle/oradata/prod/undotbs01.dbf
  12   0  Incr 7552785441 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx01.dbf
  15   0  Incr 7552785441 17-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn04.dbf

  Backup Set Copy #1 of backup set 19145
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:53:12     17-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19145 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19176   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23964pv_.bkp

  Backup Set Copy #2 of backup set 19145
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:53:12     19-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19145 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19255   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23964pv_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19146   Incr 0  14.15G
  List of Datafiles in backup set 19146
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    0  Incr 7552788390 17-OCT-15 /opt/oracle/oradata/prod/absolut_trn01.dbf
  14   0  Incr 7552788390 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx02.dbf
  16   0  Incr 7552788390 17-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs02.dbf

  Backup Set Copy #1 of backup set 19146
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:49:32     17-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19146 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19177   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23db0kb_.bkp

  Backup Set Copy #2 of backup set 19146
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:49:32     19-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19146 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19249   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23db0kb_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19147   Incr 0  12.90G
  List of Datafiles in backup set 19147
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  13   0  Incr 7552791172 17-OCT-15 /opt/oracle/oradata/prod/newdim_tbs01.dbf
  19   0  Incr 7552791172 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx03.dbf
  20   0  Incr 7552791172 17-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn06.dbf
  22   0  Incr 7552791172 17-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx04.dbf

  Backup Set Copy #1 of backup set 19147
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:42:54     17-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19147 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19178   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23h70ms_.bkp

  Backup Set Copy #2 of backup set 19147
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:42:54     19-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19147 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19251   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23h70ms_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19148   Incr 0  10.49G
  List of Datafiles in backup set 19148
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  10   0  Incr 7552794221 17-OCT-15 /opt/oracle/oradata/prod/absolut_rap02.dbf
  17   0  Incr 7552794221 17-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs03.dbf
  21   0  Incr 7552794221 17-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs04.dbf
  32   0  Incr 7552794221 17-OCT-15 /opt/oracle/oradata/prod/absolut_trn10.dbf

  Backup Set Copy #1 of backup set 19148
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:34:25     17-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19148 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19179   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23kqhrb_.bkp

  Backup Set Copy #2 of backup set 19148
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:34:25     19-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19148 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19259   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23kqhrb_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19149   Incr 0  9.00G
  List of Datafiles in backup set 19149
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 7552934202 17-OCT-15 /opt/oracle/oradata/prod/system01.dbf
  30   0  Incr 7552934202 17-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn09.dbf

  Backup Set Copy #1 of backup set 19149
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:28:39     17-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19149 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19180   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23mr151_.bkp

  Backup Set Copy #2 of backup set 19149
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:28:39     19-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19149 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19254   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23mr151_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19150   Incr 0  8.84G
  List of Datafiles in backup set 19150
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    0  Incr 7552935752 17-OCT-15 /opt/oracle/oradata/prod/sysaux01.dbf
  4    0  Incr 7552935752 17-OCT-15 /opt/oracle/oradata/prod/users01.dbf
  7    0  Incr 7552935752 17-OCT-15 /opt/oracle/oradata/prod/exmd_tbs01.dbf
  11   0  Incr 7552935752 17-OCT-15 /opt/oracle/oradata/prod/indx_tbs01.dbf
  26   0  Incr 7552935752 17-OCT-15 /opt/oracle/oradata/prod/system03.dbf
  27   0  Incr 7552935752 17-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn08.dbf

  Backup Set Copy #1 of backup set 19150
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:27:43     17-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19150 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19181   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23ofyjn_.bkp

  Backup Set Copy #2 of backup set 19150
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:27:43     19-OCT-15       YES        TAG20151017T022933

    List of Backup Pieces for backup set 19150 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19253   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_17/o1_mf_nnnd0_TAG20151017T022933_c23ofyjn_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19154   Incr 1  85.68M
  List of Datafiles in backup set 19154
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    1  Incr 7553233903 18-OCT-15 /opt/oracle/oradata/prod/absolut_rap01.dbf
  8    1  Incr 7553233903 18-OCT-15 /opt/oracle/oradata/prod/absolut_trn02.dbf
  18   1  Incr 7553233903 18-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn05.dbf
  23   1  Incr 7553233903 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap03.dbf
  28   1  Incr 7553233903 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx05.dbf

  Backup Set Copy #1 of backup set 19154
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:03:13     18-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19154 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19185   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25p03w2_.bkp

  Backup Set Copy #2 of backup set 19154
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:03:13     19-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19154 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19238   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25p03w2_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19155   Incr 1  45.69M
  List of Datafiles in backup set 19155
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9    1  Incr 7553234046 18-OCT-15 /opt/oracle/oradata/prod/absolut_trn03.dbf
  24   1  Incr 7553234046 18-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn07.dbf
  25   1  Incr 7553234046 18-OCT-15 /opt/oracle/oradata/prod/system02.dbf
  29   1  Incr 7553234046 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap04.dbf
  31   1  Incr 7553234046 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap05.dbf
  33   1  Incr 7553234046 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx06.dbf

  Backup Set Copy #1 of backup set 19155
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:03:04     18-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19155 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19186   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25p673n_.bkp

  Backup Set Copy #2 of backup set 19155
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:03:04     19-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19155 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19233   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25p673n_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19156   Incr 1  144.59M
  List of Datafiles in backup set 19156
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    1  Incr 7553234203 18-OCT-15 /opt/oracle/oradata/prod/undotbs01.dbf
  12   1  Incr 7553234203 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx01.dbf
  15   1  Incr 7553234203 18-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn04.dbf

  Backup Set Copy #1 of backup set 19156
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:48     18-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19156 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19187   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25pd0hs_.bkp

  Backup Set Copy #2 of backup set 19156
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:48     19-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19156 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19234   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25pd0hs_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19157   Incr 1  48.80M
  List of Datafiles in backup set 19157
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    1  Incr 7553234356 18-OCT-15 /opt/oracle/oradata/prod/absolut_trn01.dbf
  14   1  Incr 7553234356 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx02.dbf
  16   1  Incr 7553234356 18-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs02.dbf

  Backup Set Copy #1 of backup set 19157
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:28     18-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19157 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19188   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25pkhp9_.bkp

  Backup Set Copy #2 of backup set 19157
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:28     19-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19157 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19235   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25pkhp9_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19158   Incr 1  94.19M
  List of Datafiles in backup set 19158
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  13   1  Incr 7553234505 18-OCT-15 /opt/oracle/oradata/prod/newdim_tbs01.dbf
  19   1  Incr 7553234505 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx03.dbf
  20   1  Incr 7553234505 18-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn06.dbf
  22   1  Incr 7553234505 18-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx04.dbf

  Backup Set Copy #1 of backup set 19158
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:44     18-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19158 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19189   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25ppbx0_.bkp

  Backup Set Copy #2 of backup set 19158
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:44     19-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19158 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19237   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25ppbx0_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19159   Incr 1  2.28M
  List of Datafiles in backup set 19159
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  10   1  Incr 7553234627 18-OCT-15 /opt/oracle/oradata/prod/absolut_rap02.dbf
  17   1  Incr 7553234627 18-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs03.dbf
  21   1  Incr 7553234627 18-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs04.dbf
  32   1  Incr 7553234627 18-OCT-15 /opt/oracle/oradata/prod/absolut_trn10.dbf

  Backup Set Copy #1 of backup set 19159
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:00     18-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19159 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19190   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25pvj3x_.bkp

  Backup Set Copy #2 of backup set 19159
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:00     19-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19159 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19236   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25pvj3x_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19160   Incr 1  4.15M
  List of Datafiles in backup set 19160
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 7553234749 18-OCT-15 /opt/oracle/oradata/prod/system01.dbf
  30   1  Incr 7553234749 18-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn09.dbf

  Backup Set Copy #1 of backup set 19160
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:38     18-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19160 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19191   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25pzf8y_.bkp

  Backup Set Copy #2 of backup set 19160
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:38     19-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19160 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19231   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25pzf8y_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19161   Incr 1  14.14M
  List of Datafiles in backup set 19161
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    1  Incr 7553234822 18-OCT-15 /opt/oracle/oradata/prod/sysaux01.dbf
  4    1  Incr 7553234822 18-OCT-15 /opt/oracle/oradata/prod/users01.dbf
  7    1  Incr 7553234822 18-OCT-15 /opt/oracle/oradata/prod/exmd_tbs01.dbf
  11   1  Incr 7553234822 18-OCT-15 /opt/oracle/oradata/prod/indx_tbs01.dbf
  26   1  Incr 7553234822 18-OCT-15 /opt/oracle/oradata/prod/system03.dbf
  27   1  Incr 7553234822 18-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn08.dbf

  Backup Set Copy #1 of backup set 19161
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:55     18-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19161 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19192   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25q2pmy_.bkp

  Backup Set Copy #2 of backup set 19161
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:55     19-OCT-15       YES        TAG20151018T022137

    List of Backup Pieces for backup set 19161 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19229   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_18/o1_mf_nnnd1_TAG20151018T022137_c25q2pmy_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19165   Incr 1  608.00K
  List of Datafiles in backup set 19165
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  6    1  Incr 7553671102 19-OCT-15 /opt/oracle/oradata/prod/absolut_rap01.dbf
  8    1  Incr 7553671102 19-OCT-15 /opt/oracle/oradata/prod/absolut_trn02.dbf
  18   1  Incr 7553671102 19-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn05.dbf
  23   1  Incr 7553671102 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap03.dbf
  28   1  Incr 7553671102 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx05.dbf

  Backup Set Copy #1 of backup set 19165
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:51     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19165 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19196   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bckmg_.bkp

  Backup Set Copy #2 of backup set 19165
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:51     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19165 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19243   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bckmg_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19166   Incr 1  968.00K
  List of Datafiles in backup set 19166
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  9    1  Incr 7553671233 19-OCT-15 /opt/oracle/oradata/prod/absolut_trn03.dbf
  24   1  Incr 7553671233 19-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn07.dbf
  25   1  Incr 7553671233 19-OCT-15 /opt/oracle/oradata/prod/system02.dbf
  29   1  Incr 7553671233 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap04.dbf
  31   1  Incr 7553671233 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_rap05.dbf
  33   1  Incr 7553671233 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx06.dbf

  Backup Set Copy #1 of backup set 19166
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:55     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19166 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19197   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bk0s9_.bkp

  Backup Set Copy #2 of backup set 19166
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:55     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19166 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19246   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bk0s9_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19167   Incr 1  48.14M
  List of Datafiles in backup set 19167
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2    1  Incr 7553671365 19-OCT-15 /opt/oracle/oradata/prod/undotbs01.dbf
  12   1  Incr 7553671365 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx01.dbf
  15   1  Incr 7553671365 19-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn04.dbf

  Backup Set Copy #1 of backup set 19167
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:18     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19167 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19198   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bpjcv_.bkp

  Backup Set Copy #2 of backup set 19167
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:18     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19167 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19239   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bpjcv_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19168   Incr 1  568.00K
  List of Datafiles in backup set 19168
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5    1  Incr 7553671506 19-OCT-15 /opt/oracle/oradata/prod/absolut_trn01.dbf
  14   1  Incr 7553671506 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx02.dbf
  16   1  Incr 7553671506 19-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs02.dbf

  Backup Set Copy #1 of backup set 19168
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:10     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19168 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19199   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bv15o_.bkp

  Backup Set Copy #2 of backup set 19168
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:10     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19168 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19244   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bv15o_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19169   Incr 1  1.05M
  List of Datafiles in backup set 19169
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  13   1  Incr 7553671596 19-OCT-15 /opt/oracle/oradata/prod/newdim_tbs01.dbf
  19   1  Incr 7553671596 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx03.dbf
  20   1  Incr 7553671596 19-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn06.dbf
  22   1  Incr 7553671596 19-OCT-15 /opt/oracle2/u001/oradata/prod/absolut_trnindx04.dbf

  Backup Set Copy #1 of backup set 19169
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:24     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19169 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19200   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bz8d0_.bkp

  Backup Set Copy #2 of backup set 19169
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:24     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19169 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19248   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28bz8d0_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19170   Incr 1  1.45M
  List of Datafiles in backup set 19170
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  10   1  Incr 7553671708 19-OCT-15 /opt/oracle/oradata/prod/absolut_rap02.dbf
  17   1  Incr 7553671708 19-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs03.dbf
  21   1  Incr 7553671708 19-OCT-15 /opt/oracle2/u002/oradata/prod/newdim_tbs04.dbf
  32   1  Incr 7553671708 19-OCT-15 /opt/oracle/oradata/prod/absolut_trn10.dbf

  Backup Set Copy #1 of backup set 19170
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:01     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19170 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19201   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28c3sl4_.bkp

  Backup Set Copy #2 of backup set 19170
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:01     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19170 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19247   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28c3sl4_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19171   Incr 1  2.05M
  List of Datafiles in backup set 19171
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    1  Incr 7553671823 19-OCT-15 /opt/oracle/oradata/prod/system01.dbf
  30   1  Incr 7553671823 19-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn09.dbf

  Backup Set Copy #1 of backup set 19171
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:32     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19171 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19202   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28c7ppw_.bkp

  Backup Set Copy #2 of backup set 19171
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:32     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19171 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19242   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28c7ppw_.bkp

BS Key  Type LV Size
------- ---- -- ----------
19172   Incr 1  12.14M
  List of Datafiles in backup set 19172
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3    1  Incr 7553671886 19-OCT-15 /opt/oracle/oradata/prod/sysaux01.dbf
  4    1  Incr 7553671886 19-OCT-15 /opt/oracle/oradata/prod/users01.dbf
  7    1  Incr 7553671886 19-OCT-15 /opt/oracle/oradata/prod/exmd_tbs01.dbf
  11   1  Incr 7553671886 19-OCT-15 /opt/oracle/oradata/prod/indx_tbs01.dbf
  26   1  Incr 7553671886 19-OCT-15 /opt/oracle/oradata/prod/system03.dbf
  27   1  Incr 7553671886 19-OCT-15 /opt/oracle2/u002/oradata/prod/absolut_trn08.dbf

  Backup Set Copy #1 of backup set 19172
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:53     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19172 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19203   1   AVAILABLE   /opt/oracle/flash_recovery_area/PROD/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28cbp2n_.bkp

  Backup Set Copy #2 of backup set 19172
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:01:53     19-OCT-15       YES        TAG20151019T022118

    List of Backup Pieces for backup set 19172 Copy #2
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    19241   1   AVAILABLE   /opt/oracle/flash_recovery_area/prod/backupset/2015_10_19/o1_mf_nnnd1_TAG20151019T022118_c28cbp2n_.bkp

RMAN> list incarnation;


List of Database Incarnations
DB Key  Inc Key DB Name  DB ID            STATUS  Reset SCN  Reset Time
------- ------- -------- ---------------- --- ---------- ----------
1       1       PROD     130474031        PARENT  1          10-MAY-10
2       2       PROD     130474031        PARENT  195833299  21-OCT-10
3       3       PROD     130474031        PARENT  3655020271 06-OCT-12
4       4       PROD     130474031        PARENT  3655121615 08-OCT-12
5       5       PROD     130474031        CURRENT 5588371557 19-OCT-14

RMAN> restore database;

Starting restore at 19-OCT-15
using channel ORA_DISK_1

creating datafile fno=1 name=/opt/oracle/oradata/prod/system01.dbf
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/19/2015 11:18:02
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/opt/oracle/oradata/prod/system01.dbf'

RMAN>
user interrupt received


RMAN>

RMAN>

RMAN>

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
CONFIGURE BACKUP OPTIMIZATION ON;
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 COMPRESSED BACKUPSET;
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 ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/opt/oracle/app/db10gR2/dbs/snapcf_prod.f'; # default

RMAN>
Vadim Lejnin
Дата: 19.10.2015 11:39:36
gda,
...
ORA-01180: can not create datafile 1
ORA-01110: data file 1: '/opt/oracle/oradata/prod/system01.dbf'
...

Перевести?

Для начала:
1) Что ты хочешь получить
2) По какому документу делаешь


p.s. Большие портянки рекомендуется прятать под spoiler
gda
Дата: 19.10.2015 16:22:13
Vadim Lejnin,

надо востановить базу с фул бэкапа.
Vadim Lejnin
Дата: 19.10.2015 16:36:37
gda
Vadim Lejnin,

надо востановить базу с фул бэкапа.

И...?
Какая хоть версия-то? База в archivelog mode?
Как восстанавливал controlfile?
Что именно случилось, что осталось от базы?
Что конкретно сделано для восстановления?

Вот это прочитал: Preparing for Complete Database Recovery (Для db11g)
и сделал что там указано?

p.s. У Вас rman не может записать файл 
/opt/oracle/oradata/prod/system01.dbf

Советы будут сильно разные в зависимости от того что есть и того что хотите

HOWTO :: Как правильно задавать вопросы
Vadim Lejnin
Дата: 19.10.2015 16:45:32
gda,
Если база упала и не в archivelog mode
То сначала сохраните то что есть, если конечно Вам интересны данные которые появились в базе после последнего backup

если места хватает, то перенесите оставшиеся controlfile/datafile/redo/archivelog в другую директорию

Посмотреть полный список файлов БД для сохранения и состояние (SCN) файлов:
sqlplus / as sysdba
SQL> select name from v$datafile;
SQL> select name from v$controlfile;
SQL> select member from v$logfile;
SQL> select hxfil file#,fhscn checkpoint_change#, fhafs Absolute_Fuzzy_SCN from x$kcvfh;
SQL> select current_scn from v$database;
gda
Дата: 19.10.2015 21:38:36
1. есть прод база в режиме архив лог
2. сейчас надо поднять на стэтдбае (другой сервер) бэкап. я скопировал последний фул и все инкрементал бэкапы, задал тотже дб ид, crosscheck database, delete expired, restore controlfile from autobackup, mount database и потом ресторе и вот что получаю. что не так?
Vadim Lejnin
Дата: 19.10.2015 22:04:30
gda
1. есть прод база в режиме архив лог
2. сейчас надо поднять на стэтдбае (другой сервер) бэкап. я скопировал последний фул и все инкрементал бэкапы, задал тотже дб ид, crosscheck database, delete expired, restore controlfile from autobackup, mount database и потом ресторе и вот что получаю. что не так?

Директория есть?
/opt/oracle/oradata/

Вам нужно standby controlfile
А лучше используй Using the DUPLICATE Command to Create a Standby Database, что то вроде: 
set echo on
host 'rm -f $ORACLE_HOME/dbs/spfilepstb.ora';
run {
# set 5 disk channel
allocate channel d1 type disk;
allocate channel d2 type disk;
allocate channel d3 type disk;
allocate channel d4 type disk;
allocate channel d5 type disk;
allocate auxiliary channel aux1 type disk;
allocate auxiliary channel aux2 type disk;
allocate auxiliary channel aux3 type disk;
allocate auxiliary channel aux4 type disk;
allocate auxiliary channel aux5 type disk;
duplicate target database for standby 
# from active database ## direct duplicate
backup location '/backup/prod'  ## backup duplication
DORECOVER
NOFILENAMECHECK
## spfile generation
spfile
## convert spfile parameters
parameter_value_convert 'prod','pstb'
## convert datafile name
set db_unique_name='pstb'   # set db_unique_name
set db_create_file_dest='+DATA'  # OMF
# DB_FILE_NAME_CONVERT='prod','pstb' # non-OMF
set db_create_online_log_dest_1='+DATA' # OMF
# LOG_FILE_NAME_CONVERT = 'prod','pstb' # non-OMF
## set parameters
set log_archive_max_processes='7'
reset control_files   # OMF need for new controlfile name 
set fal_server='prod'
set standby_file_management='AUTO'
set log_archive_config='dg_config=(prod,pstb)'
set log_archive_dest_1='service=prod ASYNC valid_for=(ONLINE_LOGFILE,PRIMARY_ROLE) db_unique_name=prod'
set log_archive_dest_10='location=use_db_recovery_file_dest';
# reset notneed parameters
reset set log_archive_dest_2
}