Все технические форумы на одном сайте Удобный поиск информации с популярных форумов в одном месте
Вопрос: RMAN горячий backup

Делаю горячий backup с рабочей базы на тестовую(точно такую )
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'F:\backups\cf_esdcontrol_%F';
BACKUP DATABASE FORMAT 'F:\backups\db_%t_%s_p%p' PLUS ARCHIVELOG


На тестовой - восстанавливаю
RESTORE CONTROLFILE FROM ..;
alter database mount;
restore database;
recover database;
alter database open resetlogs;

В основном работает без проблем(бэкап начинается с 19 часов - рабочий день у нас до 17.30).
Но если люди задерживаются после работы и активно работают во время бэкапа, то при переносе на тестовую базу
начинаются проблемы - база не консистентна - file 1 needs more recovery to be consistent а именно System.dbf
И тут начинаются пляски с бубном - я добавляю новый UNDO- переключаюсь на него. Иногда сразу помогает.
А иногда начинают валится REDO логи и помогает только полное восстановление с пересозданием control файла.
Я не понимаю физики происходящего. Я одной стороны я же архивирую полностью базу с архив логами, которые создаются пока идет бэкап. Плюс я сохраняю control файл со всеми текущими SCN. Правда на тестовой базе тоже работают, но там я перед восстановлением перевожу базу в состояние mount, восстанавливаю контрол файл из бэкапа и все связанные с ним данные.
Я понимаю, что нужен open resetlogs - но почему возникаю более сложные проблемы? Может быть мне ПЕРЕД восстановлением из бэкапа принудительно сбрасывать redo логи? Читая доку по ORACLE обратил внимание, что они нигде в примерах не делают горячего бэкапа базу. Только тейблспейсами при условии конструкции alter database begin backup. Но это совсем другой метод.
Что посоветуете?
Ответ: alex_lip,
знает только ОН, я же грешный токмо предполагаю.
ежели богопротивным считаете этот alter database recover finish, то попробуйте при повторе "file 1 needs more recovery to be consistent " архивный журнал на след сиквенс докопировать и опосля alter database recover until time (или until cancel).
Вопрос: rman hot backup

Тема уже затяганная, но прошу терпения и прояснить немного об предназначении архивлогов в бэкапе.
Здесь на форуме не раз упоминалось что горячий бэкап rman нужно делать так:
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;

но мне не понятно, какие архивлоги будут включены в бэкап:
- все что есть на диске, и зачем они все нужны?
- или те что могут появиться после начала создания бэкапа?
Ответ: Совсем разленились )))


4.3.7.2 Backing Up Logs with BACKUP ... PLUS ARCHIVELOG
You can add archived redo logs to a backup of other files by using the BACKUP ... PLUS ARCHIVELOG clause. Adding BACKUP ... PLUS ARCHIVELOG causes RMAN to do the following:

- Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command.

- Runs BACKUP ARCHIVELOG ALL. Note that if backup optimization is enabled, then RMAN skips logs that it has already backed up to the specified device.

- Backs up the rest of the files specified in BACKUP command.

- Runs the ALTER SYSTEM ARCHIVE LOG CURRENT command.

- Backs up any remaining archived logs generated during the backup.
Вопрос: На горячий backup expdp применить архивные логи

Добрый день!
Такой вопрос...
База данных oracle11 умерла, испорчены блоки и требуется восстановление из бекапа
Есть горячий backup от 09-06 одной основной схемы данных и архивные логи с упавшей базы
Сейчас я создал новую базу и загрузил туда основные данные. Есть ли какая-то возможность применить к ней архивные логи от упавшей базы?
Ответ: Viewer, это уже придирки. :) Понятно, что это любое сохранение данных, отчасти, можно обозвать бекапом. Тут же был не тот "бекап", на который можно накатывать архлоги.
Вопрос: Восстановление backup при потере archivelog

Уважаемые спецы, помогите советом. Необходимо восстановить БД ORACLE. Ситуация такая
1 БД работает в режиме ARCHIVELOG
2 Есть backup, созданный в RMAN командой 'backup database',т.е. не сключает в себя необходимые журналы.
3 Есть соответствующий backup-у CONTROLFILE
4 Журналы в FRA потеряны
Все что нагуглил пока не помогло.
Помогите советом пожалуйста. Нужно очень срочно.
Ответ: не все файлы согласованы на SCN 333 в момент backup ( и это нормально )
select * from (select 
	hxfil file#
	,fhscn checkpoint_change#
	,fhafs Absolute_Fuzzy_SCN 
from x$kcvfh
union all
select 
	999999
	,to_char(current_scn,'999999999999999')
	,log_mode
from v$database
)
order by 1;
Вопрос: RMAN бэкап завершается со статусом "Running with warnings"

Доброго времени суток.

Столкнулись со следующей проблемой - RMAN full backup завершается корректно, по крайней мере согласно логам, но в RC_RMAN_STATUS статус этого бэкапа определен как "Running with warnings".
Бэкап организован следующим образом:
производится клонирование дисков ASM с PROD-сервера на BACKUP-сервер, предварительно база PROD переводится в режим бэкапа командой alter database begin backup. Клонирование производится на уровне storage серверов. По окончании клонирования выполняется команда alter database end backup.
Монтируется дисковая группа ASM.
База BACKUP поднимается в mount моде.
Производится RMAN full database backup.
База BACKUP опускается.
Дисковая группа ASM BACKUP демонтируется.
По окончании процесса, как уже было сказано, согласно логам бэкап завершен корректно, но статус этого бэкапа в RC_RMAN_STATUS - "Running with warnings".
Такая картина наблюдается на разных версиях, от 10.2.0.5 до 11.2.0.4.

Если выполнять RMAN full backup базы в среде DR, где база также открыта в mount и выполняется recover, то бэкап также выполняется корректно но при этом статус бэкапа в RC_RMAN_STATUS - Completed.

Кто-нибудь сталкивался с подобным?
Ответ: Вячеслав Любомудров,

Спасибо за ответ.
Вопрос: Настроить горячий бэкап (Linux, Oracle, Rman)

Доброго времени суток! Подскажите пожалуйста, как исправить кривые ручонки.

Задача: настроить горячий бэкап
Дано:
OS Linux red hat
Oracle 12.1.0.2

Имеется скриптик backup.sh следующего вида:

+
date=` '+%d.%m.%y_%H.%M.%S'`
export PATH="..."
export ORACLE_HOME="..."
export ORACLE_SID=".."
rman target ='sys/password' mslog=my_path/rman_DB-$date.log << EOF
RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE
DISK FORMAT 'my_path/BACKUP-$date.bus';
BACKUP DATABASE PLUS ARCHIVELOG DELETE INPUT;
}
EXIT;
EOF


Предполагается, что он делает "горячий" бэкап БД + архив логи и удаляет забэкапленный архив логи.

Если его запускать из терминала sh backup.sh - все хорошо отрабатывает, все замечательно.

Хочу запускать в планировщике.
Запускаю в crontab, допустим, каждый четверг в 10.30
30 10 * * 4 /my_path/backup.sh

В итоге, бэкап появляется в указанном месте, но! В лог файле есть строчки

Finished backup at 30-JUN-16

Starting backup at 30-JUN-16
channel c1: starting full datafile backup set
channel c1: specifying datafale(s) in backup set

...........

RMAN-03002: failure of backup plus archivelog command at 06/30/2016 10:31:03
ORA-19504: failed to create file "my_path/backup-30.06.16-10.30.01.bus"
ORA-27038: created file already exists
Additional information: 1

RMAN>

Recovery Manager complete.

Т.е., rman сделал бэкап, а потом хочет сделать еще раз, но не может, из-за совпадения имен файлов.

P.S. Предыдущая версия скрипта без даты в имени файла отрабатывала следующим образом: создавалось столько бэкапов, сколько возможно, пока не закончится место на диске.
Ответ: Вот только имя файла (а не путь, насколько я понял) у него один и тот же для всех BACKUP PIECE-s.
И, соответственно -- это враньё
Oracle is so Oracle
Если его запускать из терминала sh backup.sh - все хорошо отрабатывает, все замечательно.
ибо BACKUP DATABASE PLUS ARCHIVELOG делает минимум 2 файлика бэкапа, что с одним именем никак нельзя

Чтоб файлики бэкапа различались -- туда надо добавлять шаблон ()
Самое простое, но не очень "говорящее" -- %U
+
$ ORACLE_SID=tst rman target /

Recovery Manager: Release 11.2.0.3.0 - Production on Fri Jul 1 13:58:34 2016

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

connected to target database: TST (DBID=1662986732)

RMAN> run {
2> allocate channel c1 device type disk format '/orabackup/backup/tst/aaa';
3> backup database plus archivelog;
4> }

using target database control file instead of recovery catalog
allocated channel: c1
channel c1: SID=72 device type=DISK


Starting backup at 01-JUL-16
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=28067 RECID=58748 STAMP=915903938
...
input archived log thread=1 sequence=28084 RECID=58782 STAMP=916063184
channel c1: starting piece 1 at 01-JUL-16
channel c1: finished piece 1 at 01-JUL-16
piece handle=/orabackup/backup/tst/aaa tag=TAG20160701T135945 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:07
Finished backup at 01-JUL-16

Starting backup at 01-JUL-16
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u/app/oracle/oradata/tst/users01.dbf
...
input datafile file number=00004 name=/u/app/oracle/oradata/tst/idx01.dbf
channel c1: starting piece 1 at 01-JUL-16
released channel: c1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of backup plus archivelog command at 07/01/2016 13:59:55
ORA-19504: failed to create file "/orabackup/backup/tst/aaa"
ORA-27038: created file already exists
Additional information: 1

RMAN> run {
2> allocate channel c1 device type disk format '/orabackup/backup/tst/aaa-%U';
3> backup database plus archivelog;
4> }

allocated channel: c1
channel c1: SID=72 device type=DISK


Starting backup at 01-JUL-16
current log archived
skipping archived logs of thread 1 from sequence 28067 to 28084; already backed up
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=28085 RECID=58783 STAMP=916063237
channel c1: starting piece 1 at 01-JUL-16
channel c1: finished piece 1 at 01-JUL-16
piece handle=/orabackup/backup/tst/aaa-clr9k106_1_1 tag=TAG20160701T140038 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-JUL-16

Starting backup at 01-JUL-16
channel c1: starting full datafile backup set
channel c1: specifying datafile(s) in backup set
input datafile file number=00006 name=/u/app/oracle/oradata/tst/users01.dbf
...
input datafile file number=00004 name=/u/app/oracle/oradata/tst/idx01.dbf
channel c1: starting piece 1 at 01-JUL-16
channel c1: finished piece 1 at 01-JUL-16
piece handle=/orabackup/backup/tst/aaa-cmr9k108_1_1 tag=TAG20160701T140040 comment=NONE
channel c1: backup set complete, elapsed time: 00:01:45
Finished backup at 01-JUL-16

Starting backup at 01-JUL-16
current log archived
channel c1: starting archived log backup set
channel c1: specifying archived log(s) in backup set
input archived log thread=1 sequence=28086 RECID=58786 STAMP=916063346
channel c1: starting piece 1 at 01-JUL-16
channel c1: finished piece 1 at 01-JUL-16
piece handle=/orabackup/backup/tst/aaa-cnr9k13i_1_1 tag=TAG20160701T140226 comment=NONE
channel c1: backup set complete, elapsed time: 00:00:01
Finished backup at 01-JUL-16

Starting Control File and SPFILE Autobackup at 01-JUL-16
piece handle=/orabackup/backup/tst/TST-c-1662986732-20160701-02 comment=NONE
Finished Control File and SPFILE Autobackup at 01-JUL-16
released channel: c1

Естественно, никто не мешает добавлять туда и дату-время

Oracle is so Oracle
Предыдущая версия скрипта без даты в имени файла отрабатывала следующим образом: создавалось столько бэкапов, сколько возможно, пока не закончится место на диске
А для этого существует RMAN-команда DELETE
Вопрос: rman restore ORA-01110: data file 1 system01.dbf

Получаю "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>
Ответ:
gda
1. есть прод база в режиме архив лог
2. сейчас надо поднять на стэтдбае (другой сервер) бэкап. я скопировал последний фул и все инкрементал бэкапы, задал тотже дб ид, crosscheck database, delete expired, restore controlfile from autobackup, mount database и потом ресторе и вот что получаю. что не так?

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

Вам нужно standby controlfile
А лучше используй , что то вроде:
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
}
Вопрос: ERROR MESSAGE STACK FOLLOWS (RMAN)

Доброго дня Всем! Прошу помочь разобраться с ошибками при бэкапе! Взял за основу скрипты по бэкапу, но почему-то получаю одну и ту же ошибку, возможно, что надо настроить на rman-е?
Скрипты:
Исполняемый скрипт, который в свою очередь запускает скрипт бэкапа.

1.
ORACLE_BASE=/u01/app/oracle12/product/12.1.0; export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle12/product/12.1.0/dbhome_1; export ORACLE_HOME
LD_LIBRARY_PATH=$ORACLE_HOME/lib; export LD_LIBRARY_PATH
PATH=$PATH:/usr/local/bin:$ORACLE_HOME/bin; export PATH
ORACLE_SID=WAY4TST1; export ORACLE_SID
export ULIMIT=unlimited
export NLS_DATE_FORMAT="YYYY/MM/DD HH24:MI:SS"


scriptdir=/home/oracle12/rcv
logdir=/home/oracle12/bin/logs
datedir=`date "+%Y%m%d_%H%M%S"`

bkpdir=home/oracle12/bkp/BACKUP/WAY4SRV2

find $bkpdir -type f -name "WAY4_*" -mtime +91 -exec ls -l {} \; > $logdir/bkp_files_for_rm_ls.log 2>&1
find $bkpdir -type f -name "c-3111778763*" -mtime +91 -exec ls -l {} \; >> $logdir/bkp_files_for_rm_ls.log 2>&1
find $bkpdir -type f -name "WAY4_*" -mtime +91 -exec rm {} \; >> $logdir/bkp_files_for_rm_ls.log 2>&1
find $bkpdir -type f -name "c-3111778763*" -mtime +91 -exec rm {} \; >> $logdir/bkp_files_for_rm_ls.log 2>&1


rman target / cmdfile=$scriptdir/bkp_full.rcv log=$logdir/bkp_full_$datedir.log append

exit


2.
run {
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK;
ALLOCATE CHANNEL disk2 DEVICE TYPE DISK;
ALLOCATE CHANNEL disk3 DEVICE TYPE DISK;
ALLOCATE CHANNEL disk4 DEVICE TYPE DISK;
crosscheck archivelog all;
report obsolete;
sql 'alter system archive log current';
backup as compressed backupset incremental level 0 format '/home/oracle12/bkp/BACKUP/WAY4SRV2/WAY4_FULL-%t-%s-%p' tag=WAY4_FULL database;
backup current controlfile format '/home/oracle12/bkp/BACKUP/WAY4SRV2/WAY4_ctl-%t-%s-%p' tag=controlfile_backup;
release channel disk1;
release channel disk2;
release channel disk3;
release channel disk4;
}
sql 'alter system archive log current';
run {
ALLOCATE CHANNEL disk1 DEVICE TYPE DISK;
ALLOCATE CHANNEL disk2 DEVICE TYPE DISK;
ALLOCATE CHANNEL disk3 DEVICE TYPE DISK;
ALLOCATE CHANNEL disk4 DEVICE TYPE DISK;
BACKUP as compressed backupset ARCHIVELOG ALL not backed up format '/home/oracle12/bkp/BACKUP/WAY4SRV2/WAY4_ARC-%t-%s-%p' tag=WAY4_ARCHIVELOG;
backup current controlfile format '/home/oracle12/bkp/BACKUP/WAY4SRV2/WAY4_ctl-%t-%s-%p' tag=controlfile_backup;
release channel disk1;
release channel disk2;
release channel disk3;
release channel disk4;
}


В дальнейшем хотел исполняемый файл зашить в cron для автоматического бэкапа. Но тестируя скрипты, у меня возникает одна и та же ошибка:

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of allocate command at 09/08/2016 15:59:08
RMAN-06403: could not obtain a fully authorized session
ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
Linux-x86_64 Error: 2: No such file or directory

На самом деле база стартована и в статусе open! Почему rman этого не видит? И подскажите, что необходимо дописать в скриптах или в самом rman-е,чтобы данная ошибка больше не выскакивала?!
Ответ: landy,

Чудесным образом все получилось, добавил лишь одну строку в шеловский файл с переменными -

. ~/.bash_profile


И Бэкап пробежал без ошибок!

кусочек из лога:
Starting backup at 2016/09/09 16:39:17
channel disk1: starting full datafile backup set
channel disk1: specifying datafile(s) in backup set
including current control file in backup set
channel disk1: starting piece 1 at 2016/09/09 16:39:18
channel disk1: finished piece 1 at 2016/09/09 16:39:19
piece handle=/home/oracle12/bkp/BACKUP/WAY4SRV2/WAY4_ctl-922120757-28-1 tag=CONTROLFILE_BACKUP comment=NONE
channel disk1: backup set complete, elapsed time: 00:00:01
Finished backup at 2016/09/09 16:39:19

released channel: disk1

released channel: disk2

released channel: disk3

released channel: disk4

Recovery Manager complete.


Еще раз всем спасибо!
Вопрос: RMAN Backup не запускается

Всем доброго времени суток! Пожалуйста подскажите дилетанту. Перестал создаваться backup в планировщике enterprise manager. Имеются ошибки, представленные ниже. В чем может быть проблема и как ее решить?


RMAN> allocate channel for maintenance device type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: SID=2861 device type=DISK


RMAN> run {
2>
3> backup as compressed backupset incremental level 0 database;
4> sql 'alter system archive log current';
5>
6> backup archivelog all delete input;
7>
8> report obsolete;
9> delete noprompt obsolete device type disk;
10>
11> backup current controlfile;
12> }
Starting backup at 18-FEB-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=3640 device type=DISK
channel ORA_DISK_1: starting compressed incremental level 0 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00006 name=/oracle/11g/oradata/omega/omp_ind.dbf
input datafile file number=00005 name=/oracle/11g/oradata/omega/omp_db.dbf
input datafile file number=00001 name=/oracle/11g/oradata/omega/system01.dbf
input datafile file number=00003 name=/oracle/11g/oradata/omega/undotbs01.dbf
input datafile file number=00002 name=/oracle/11g/oradata/omega/sysaux01.dbf
input datafile file number=00004 name=/oracle/11g/oradata/omega/users01.dbf
channel ORA_DISK_1: starting piece 1 at 18-FEB-16
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 02/18/2016 00:00:33
ORA-01264: Unable to create backup piece file name
ORA-19800: Unable to initialize Oracle Managed Destination
Solaris-AMD64 Error: 13: Permission denied


RMAN> exit;

Recovery Manager complete.
Ответ: Quinn Mallory,

ORA-01264: Unable to create backup piece file name
ORA-19800: Unable to initialize Oracle Managed Destination
Solaris-AMD64 Error: 13: Permission denied


Достаточно говорящие ошибки. РМАН, на всю кажущуюся сложность, очень простой и прямолинейный.
Вопрос: rman duplicate database из backup location - scn?

oracle 12.1

если не указывать явно докуда разворачивать "Backup-based duplication without connection to target and recovery catalog" - то какой берется scn?
и это не тот scn, который видно командой list backup of controlfile;
и если там лежит бэкап более старшего контрольника, то dublicate не проверяет, есть ли все нужные для восстановления архивлоги в бэкапе.
так какой жеж?
Ответ:
BACKUP AS COMPRESSED BACKUPSET DATABASE FORMAT ...dbfiles...
sql 'ALTER SYSTEM ARCHIVE LOG CURRENT';
BACKUP AS COMPRESSED BACKUPSET ARCHIVELOG ALL FORMAT ...archlogs... DELETE INPUT;
BACKUP AS COMPRESSED BACKUPSET CURRENT CONTROLFILE FORMAT ...ctrlfil...


$ pwd
/backup
$ ls
archlogs_xxx
autoback_ctrlfil_xxx (на момент dbfiles)
dbfiles_xxx
$

RMAN> list backup of controlfile;
using target database control file instead of recovery catalog
List of Backup Sets
===================
...
        Piece Name: /backup/autoback_ctrlfil_xxx
  Control File Included: Ckp SCN: 88692137991   Ckp time: 26-SEP-16

RMAN> list backup of archivelog all;  
...
        Piece Name: /backup/archlogs_xxx
...
последний   88692138008 26-SEP-16 88692138033 26-SEP-16
  
RMAN> DUPLICATE DATABASE TO NEWNAME BACKUP LOCATION '/backup' NOFILENAMECHECK;

...
contents of Memory Script:
{
   set until scn  88692138033;


если контрольник младше бэкапа архивлогов, то он взял по бэкапу архивлогов?

но если добавить в /backup
autoback_ctrlfil_yyy  (на момент ctrlfil, к тому времени появилось еще несколько архивлогов, но в бэкап они не попали)
  Control File Included: Ckp SCN: 88692464833   Ckp time: 26-SEP-16
то
   set until scn  88692418763; -- не проверяет, что в бэкапе архивлогов таких нет


похоже, что это последний scn архивлога, о котором знает забэкапированный контрольник.
в доке нигде такого не написано?