Solved

Oracle RMAN Database Restore

Posted on 2016-10-24
5
32 Views
Last Modified: 2016-10-26
Hi,

  My RMAN restore is failing.    I am restoring from a Cold Backup made to a database on server A to a another server B.

 Below the the complete RMAN session.

 Please let me know if i am missing something.

C:\Users\a-981738>oradim -new -sid QMS01PRD -intpwd oradba
Instance created.

C:\Users\a-981738>set oracle_sid=QMS01PRD

C:\Users\a-981738>rman target /

Recovery Manager: Release 10.2.0.4.0 - Production on Mon Oct 24 11:01:26 2016

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

connected to target database (not started)

RMAN> set dbid=1936131573;

executing command: SET DBID

RMAN> startup force nomount;

startup failed: ORA-01078: failure in processing system parameters
LRM-00109: could not open parameter file 'O:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE
\INITQMS01PRD.ORA'

starting Oracle instance without parameter file for retrival of spfile
Oracle instance started

Total System Global Area     159383552 bytes

Fixed Size                     2064184 bytes
Variable Size                 71303368 bytes
Database Buffers              79691776 bytes
Redo Buffers                   6324224 bytes

RMAN> SET CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'T:\QMS01PRD_Col
dbackup\%F';

executing command: SET CONTROLFILE AUTOBACKUP FORMAT
using target database control file instead of recovery catalog

RMAN> restore spfile to 'O:\oracle\product\10.2.0\admin\QMS01PRD\pfile\spfileQMS
01PRD.Ora' from autobackup;

Starting restore at 24-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=35 devtype=DISK

channel ORA_DISK_1: looking for autobackup on day: 20161024
channel ORA_DISK_1: looking for autobackup on day: 20161023
channel ORA_DISK_1: looking for autobackup on day: 20161022
channel ORA_DISK_1: looking for autobackup on day: 20161021
channel ORA_DISK_1: looking for autobackup on day: 20161020
channel ORA_DISK_1: autobackup found: T:\QMS01PRD_Coldbackup\c-1936131573-201610
20-00
channel ORA_DISK_1: SPFILE restore from autobackup complete
Finished restore at 24-OCT-16

RMAN> shutdown immediate;

Oracle instance shut down

RMAN> startup force pfile='O:\oracle\product\10.2.0\admin\QMS01PRD\pfile\InitQMS
01PRD.ORA' nomunt;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found "identifier": expecting one of: "dba, force, mou
nt, newline, nomount, pfile, ;"
RMAN-01008: the bad identifier was: nomunt
RMAN-01007: at line 1 column 86 file: standard input

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00558: error encountered while parsing input commands
RMAN-01009: syntax error: found ";": expecting one of: "allocate, alter, backup,
 beginline, blockrecover, catalog, change, connect, copy, convert, create, cross
check, configure, duplicate, debug, delete, drop, exit, endinline, flashback, ho
st, {, library, list, mount, open, print, quit, recover, register, release, repl
ace, report, renormalize, reset, restore, resync, rman, run, rpctest, set, setli
mit, sql, switch, spool, startup, shutdown, send, show, test, transport, upgrade
, unregister, validate"
RMAN-01007: at line 1 column 92 file: standard input

RMAN> startup force pfile='O:\oracle\product\10.2.0\admin\QMS01PRD\pfile\InitQMS
01PRD.ORA' nomount;

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of startup command at 10/24/2016 11:17:52
RMAN-04014: startup failed: ORA-01261: Parameter db_recovery_file_dest destinati
on string cannot be translated
ORA-01263: Name given for file destination directory is invalid
OSD-04018: Unable to access the specified directory or device.
O/S-Error: (OS 3) The system cannot find the path specified.

RMAN> startup force pfile='O:\oracle\product\10.2.0\admin\QMS01PRD\pfile\InitQMS
01PRD.ORA' nomount;

Oracle instance started

Total System Global Area   17179869184 bytes

Fixed Size                     2095928 bytes
Variable Size               8472495304 bytes
Database Buffers            8690597888 bytes
Redo Buffers                  14680064 bytes

RMAN> restore controlfile from autobackup;

Starting restore at 24-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK

recovery area destination: T:\BACKUPS\QMS01PRD\FLASH_RECOVERY_AREA
database name (or database unique name) used for search: QMS01PRD
channel ORA_DISK_1: no autobackups found in the recovery area
channel ORA_DISK_1: looking for autobackup on day: 20161024
channel ORA_DISK_1: looking for autobackup on day: 20161023
channel ORA_DISK_1: looking for autobackup on day: 20161022
channel ORA_DISK_1: looking for autobackup on day: 20161021
channel ORA_DISK_1: looking for autobackup on day: 20161020
channel ORA_DISK_1: autobackup found: T:\QMS01PRD_Coldbackup\c-1936131573-201610
20-00
channel ORA_DISK_1: control file restore from autobackup complete
output filename=E:\ORADATA\QMS01PRD\CONTROL01.CTL
output filename=E:\ORADATA\QMS01PRD\CONTROL02.CTL
output filename=E:\ORADATA\QMS01PRD\CONTROL03.CTL
Finished restore at 24-OCT-16

RMAN> alter database mount;

database mounted
released channel: ORA_DISK_1

RMAN> restore database;

Starting restore at 24-OCT-16
Starting implicit crosscheck backup at 24-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK
Crosschecked 55 objects
Finished implicit crosscheck backup at 24-OCT-16

Starting implicit crosscheck copy at 24-OCT-16
using channel ORA_DISK_1
Finished implicit crosscheck copy at 24-OCT-16

searching for all files in the recovery area
cataloging files...
no files cataloged

using channel ORA_DISK_1

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/24/2016 11:24:03
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

Open in new window

0
Comment
Question by:joe_echavarria
  • 4
5 Comments
 
LVL 1

Author Comment

by:joe_echavarria
ID: 41857290
Below the Show All command Output.
RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'T:\BACKUPS\QMS0
1PRD\RMAN\%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'T:\BACKUPS\QMS01PRD\RMAN\%U';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'O:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
NCFQMS01PRD.ORA'; # default

Open in new window

0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 41857437
I made some changes but still have the error.

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'T:\BACKUPS\QMS0
1PRD\RMAN\%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'T:\BACKUPS\QMS01PRD\RMAN\%U';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'O:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
NCFQMS01PRD.ORA'; # default

RMAN> show channel
2> ;

RMAN configuration parameters are:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'T:\BACKUPS\QMS01PRD\RMAN\%U';

RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT 'T:\QMS01PRD_Coldbackup\%U';

old RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'T:\BACKUPS\QMS01PRD\RMAN\%U';
new RMAN configuration parameters:
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'T:\QMS01PRD_Coldbackup\%U';
new RMAN configuration parameters are successfully stored
released channel: ORA_DISK_1

RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'T:\QMS01P
RD_Coldbackup\%F';

old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'T:\BACKUPS\QMS0
1PRD\RMAN\%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'T:\QMS01PRD_Col
dbackup\%F';
new RMAN configuration parameters are successfully stored

RMAN> show all;

RMAN configuration parameters are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1;
CONFIGURE BACKUP OPTIMIZATION ON;
CONFIGURE DEFAULT DEVICE TYPE TO DISK;
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO 'T:\QMS01PRD_Col
dbackup\%F';
CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET PARALLELISM 1;
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1;
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT   'T:\QMS01PRD_Coldbackup\%U';
CONFIGURE MAXSETSIZE TO UNLIMITED;
CONFIGURE ENCRYPTION FOR DATABASE OFF;
CONFIGURE ENCRYPTION ALGORITHM 'AES128';
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE;
CONFIGURE SNAPSHOT CONTROLFILE NAME TO 'O:\ORACLE\PRODUCT\10.2.0\DB_1\DATABASE\S
NCFQMS01PRD.ORA'; # default

RMAN> restore database;

Starting restore at 24-OCT-16
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=155 devtype=DISK

RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 10/24/2016 13:07:44
RMAN-06026: some targets not found - aborting restore
RMAN-06023: no backup or copy of datafile 6 found to restore
RMAN-06023: no backup or copy of datafile 5 found to restore
RMAN-06023: no backup or copy of datafile 4 found to restore
RMAN-06023: no backup or copy of datafile 3 found to restore
RMAN-06023: no backup or copy of datafile 2 found to restore
RMAN-06023: no backup or copy of datafile 1 found to restore

RMAN>

Open in new window

0
 
LVL 1

Author Comment

by:joe_echavarria
ID: 41857453
Below the Output of the List Backup Command.
Spooling started in log file: c:\list_backup.txt

Recovery Manager10.2.0.4.0

RMAN> 

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

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5384    428.65M    DISK        00:01:08     30-SEP-16      
        BP Key: 5384   Status: EXPIRED  Compressed: YES  Tag: 4PM_ARCH_BACKUP_QM_093016040503
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8GRH46DP_1_1

  List of Archived Logs in backup set 5384
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138386  14878490116 30-SEP-16 14878498448 30-SEP-16
  1    138387  14878498448 30-SEP-16 14878508612 30-SEP-16
  1    138388  14878508612 30-SEP-16 14878518487 30-SEP-16
  1    138389  14878518487 30-SEP-16 14878524275 30-SEP-16
  1    138390  14878524275 30-SEP-16 14878531072 30-SEP-16
  1    138391  14878531072 30-SEP-16 14878537506 30-SEP-16
  1    138392  14878537506 30-SEP-16 14878546516 30-SEP-16
  1    138393  14878546516 30-SEP-16 14878556711 30-SEP-16
  1    138394  14878556711 30-SEP-16 14878558664 30-SEP-16
  1    138395  14878558664 30-SEP-16 14878559401 30-SEP-16
  1    138396  14878559401 30-SEP-16 14878560125 30-SEP-16
  1    138397  14878560125 30-SEP-16 14878566904 30-SEP-16
  1    138398  14878566904 30-SEP-16 14878575638 30-SEP-16
  1    138399  14878575638 30-SEP-16 14878583280 30-SEP-16
  1    138400  14878583280 30-SEP-16 14878586037 30-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5386    69.55M     DISK        00:00:12     30-SEP-16      
        BP Key: 5386   Status: EXPIRED  Compressed: YES  Tag: 8PM_ARCH_QMS01PRD._093016075501
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8IRH4JT6_1_1

  List of Archived Logs in backup set 5386
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138401  14878586037 30-SEP-16 14878591044 30-SEP-16
  1    138402  14878591044 30-SEP-16 14878596219 30-SEP-16
  1    138403  14878596219 30-SEP-16 14878604280 30-SEP-16
  1    138404  14878604280 30-SEP-16 14878612209 30-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5388    185.03M    DISK        00:00:40     01-OCT-16      
        BP Key: 5388   Status: EXPIRED  Compressed: YES  Tag: 6AM_ARCH_BACKUP_QM_100116060001
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8KRH8BNR_1_1

  List of Archived Logs in backup set 5388
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138405  14878612209 30-SEP-16 14878624444 30-SEP-16
  1    138406  14878624444 30-SEP-16 14878728499 30-SEP-16
  1    138407  14878728499 30-SEP-16 14878747984 01-OCT-16
  1    138408  14878747984 01-OCT-16 14878754713 01-OCT-16
  1    138409  14878754713 01-OCT-16 14878759947 01-OCT-16
  1    138410  14878759947 01-OCT-16 14878770930 01-OCT-16
  1    138411  14878770930 01-OCT-16 14878783446 01-OCT-16
  1    138412  14878783446 01-OCT-16 14878792848 01-OCT-16
  1    138413  14878792848 01-OCT-16 14878800258 01-OCT-16
  1    138414  14878800258 01-OCT-16 14878807111 01-OCT-16
  1    138415  14878807111 01-OCT-16 14878815883 01-OCT-16
  1    138416  14878815883 01-OCT-16 14878827049 01-OCT-16
  1    138417  14878827049 01-OCT-16 14878833771 01-OCT-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5390    115.23M    DISK        00:00:23     01-OCT-16      
        BP Key: 5390   Status: EXPIRED  Compressed: YES  Tag: 12PM_ARCH_BACKUP_Q_100116120001
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8MRH90QI_1_1

  List of Archived Logs in backup set 5390
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138418  14878833771 01-OCT-16 14878888536 01-OCT-16
  1    138419  14878888536 01-OCT-16 14878928873 01-OCT-16
  1    138420  14878928873 01-OCT-16 14878937075 01-OCT-16
  1    138421  14878937075 01-OCT-16 14878945998 01-OCT-16
  1    138422  14878945998 01-OCT-16 14878955741 01-OCT-16
  1    138423  14878955741 01-OCT-16 14878964284 01-OCT-16
  1    138424  14878964284 01-OCT-16 14878971925 01-OCT-16
  1    138425  14878971925 01-OCT-16 14878973493 01-OCT-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5392    34.44M     DISK        00:00:07     01-OCT-16      
        BP Key: 5392   Status: EXPIRED  Compressed: YES  Tag: 4PM_ARCH_BACKUP_QM_100116040501
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8ORH9F5Q_1_1

  List of Archived Logs in backup set 5392
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138426  14878973493 01-OCT-16 14878982368 01-OCT-16
  1    138427  14878982368 01-OCT-16 14878992791 01-OCT-16
  1    138428  14878992791 01-OCT-16 14879000674 01-OCT-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5394    6.96M      DISK        00:00:03     01-OCT-16      
        BP Key: 5394   Status: EXPIRED  Compressed: YES  Tag: 8PM_ARCH_QMS01PRD._100116075502
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8QRH9SLA_1_1

  List of Archived Logs in backup set 5394
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138429  14879000674 01-OCT-16 14879014431 01-OCT-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5396    31.79M     DISK        00:00:07     02-OCT-16      
        BP Key: 5396   Status: EXPIRED  Compressed: YES  Tag: 6AM_ARCH_BACKUP_QM_100216060003
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8SRHB03Q_1_1

  List of Archived Logs in backup set 5396
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138430  14879014431 01-OCT-16 14879027325 01-OCT-16
  1    138431  14879027325 01-OCT-16 14879050924 02-OCT-16
  1    138432  14879050924 02-OCT-16 14879054525 02-OCT-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5398    11.25M     DISK        00:00:04     02-OCT-16      
        BP Key: 5398   Status: EXPIRED  Compressed: YES  Tag: 12PM_ARCH_BACKUP_Q_100216120002
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8URHBL6K_1_1

  List of Archived Logs in backup set 5398
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138433  14879054525 02-OCT-16 14879077332 02-OCT-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5400    7.82M      DISK        00:00:05     02-OCT-16      
        BP Key: 5400   Status: EXPIRED  Compressed: YES  Tag: 4PM_ARCH_BACKUP_QM_100216040501
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\90RHC3I5_1_1

  List of Archived Logs in backup set 5400
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138434  14879077332 02-OCT-16 14879092171 02-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5402    Incr 0  847.96G    DISK        51:42:17     02-OCT-16      
        BP Key: 5402   Status: EXPIRED  Compressed: YES  Tag: BACKUP_QMS01PRD.FE_093016030001
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\8FRH42JM_1_1
  List of Datafiles in backup set 5402
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1    0  Incr 14878563166 30-SEP-16 E:\ORADATA\QMS01PRD\SYSTEM01.DBF
  2    0  Incr 14878563166 30-SEP-16 E:\ORADATA\QMS01PRD\UNDOTBS01.DBF
  3    0  Incr 14878563166 30-SEP-16 E:\ORADATA\QMS01PRD\SYSAUX01.DBF
  4    0  Incr 14878563166 30-SEP-16 E:\ORADATA\QMS01PRD\USERS01.DBF
  5    0  Incr 14878563166 30-SEP-16 E:\ORADATA\QMS01PRD\SMTSLV_DATA01.DBF
  6    0  Incr 14878563166 30-SEP-16 D:\ORADATA\QMS01PRD\SMTSLV_INDX01.DBF

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5404    4.16M      DISK        00:00:02     02-OCT-16      
        BP Key: 5404   Status: EXPIRED  Compressed: YES  Tag: BACKUP_QMS01PRD.FE_093016030001
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\93RHCCP9_1_1

  List of Archived Logs in backup set 5404
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138435  14879092171 02-OCT-16 14879100687 02-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5405    Full    19.52M     DISK        00:00:01     02-OCT-16      
        BP Key: 5405   Status: EXPIRED  Compressed: NO  Tag: TAG20161002T184254
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161002-04
  Control File Included: Ckp SCN: 14879100700   Ckp time: 02-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5406    2.87M      DISK        00:00:02     02-OCT-16      
        BP Key: 5406   Status: EXPIRED  Compressed: YES  Tag: 8PM_ARCH_QMS01PRD._100216075501
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\95RHCH15_1_1

  List of Archived Logs in backup set 5406
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138436  14879100687 02-OCT-16 14879104683 02-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5407    Full    19.52M     DISK        00:00:02     02-OCT-16      
        BP Key: 5407   Status: EXPIRED  Compressed: NO  Tag: TAG20161002T195522
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161002-05
  Control File Included: Ckp SCN: 14879104704   Ckp time: 02-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5408    89.89M     DISK        00:00:16     03-OCT-16      
        BP Key: 5408   Status: EXPIRED  Compressed: YES  Tag: 6AM_ARCH_BACKUP_QM_100316060004
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\97RHDKFH_1_1

  List of Archived Logs in backup set 5408
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138437  14879104683 02-OCT-16 14879116160 02-OCT-16
  1    138438  14879116160 02-OCT-16 14879132286 03-OCT-16
  1    138439  14879132286 03-OCT-16 14879139773 03-OCT-16
  1    138440  14879139773 03-OCT-16 14879149924 03-OCT-16
  1    138441  14879149924 03-OCT-16 14879160742 03-OCT-16
  1    138442  14879160742 03-OCT-16 14879167549 03-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5409    Full    19.52M     DISK        00:00:03     03-OCT-16      
        BP Key: 5409   Status: EXPIRED  Compressed: NO  Tag: TAG20161003T060036
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161003-00
  Control File Included: Ckp SCN: 14879167562   Ckp time: 03-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5410    450.29M    DISK        00:01:17     03-OCT-16      
        BP Key: 5410   Status: EXPIRED  Compressed: YES  Tag: 12PM_ARCH_BACKUP_Q_100316120003
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\99RHE9IJ_1_1

  List of Archived Logs in backup set 5410
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138443  14879167549 03-OCT-16 14879175825 03-OCT-16
  1    138444  14879175825 03-OCT-16 14879183210 03-OCT-16
  1    138445  14879183210 03-OCT-16 14879183987 03-OCT-16
  1    138446  14879183987 03-OCT-16 14879185156 03-OCT-16
  1    138447  14879185156 03-OCT-16 14879189554 03-OCT-16
  1    138448  14879189554 03-OCT-16 14879195239 03-OCT-16
  1    138449  14879195239 03-OCT-16 14879202361 03-OCT-16
  1    138450  14879202361 03-OCT-16 14879208657 03-OCT-16
  1    138451  14879208657 03-OCT-16 14879214468 03-OCT-16
  1    138452  14879214468 03-OCT-16 14879222890 03-OCT-16
  1    138453  14879222890 03-OCT-16 14879229877 03-OCT-16
  1    138454  14879229877 03-OCT-16 14879238982 03-OCT-16
  1    138455  14879238982 03-OCT-16 14879244376 03-OCT-16
  1    138456  14879244376 03-OCT-16 14879251973 03-OCT-16
  1    138457  14879251973 03-OCT-16 14879257755 03-OCT-16
  1    138458  14879257755 03-OCT-16 14879263467 03-OCT-16
  1    138459  14879263467 03-OCT-16 14879268649 03-OCT-16
  1    138460  14879268649 03-OCT-16 14879273730 03-OCT-16
  1    138461  14879273730 03-OCT-16 14879280849 03-OCT-16
  1    138462  14879280849 03-OCT-16 14879286736 03-OCT-16
  1    138463  14879286736 03-OCT-16 14879289024 03-OCT-16
  1    138464  14879289024 03-OCT-16 14879292009 03-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5411    Full    19.52M     DISK        00:00:02     03-OCT-16      
        BP Key: 5411   Status: EXPIRED  Compressed: NO  Tag: TAG20161003T120137
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161003-01
  Control File Included: Ckp SCN: 14879292969   Ckp time: 03-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5412    211.87M    DISK        00:00:32     03-OCT-16      
        BP Key: 5412   Status: EXPIRED  Compressed: YES  Tag: 4PM_ARCH_BACKUP_QM_100316040501
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9BRHENTT_1_1

  List of Archived Logs in backup set 5412
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138465  14879292009 03-OCT-16 14879297364 03-OCT-16
  1    138466  14879297364 03-OCT-16 14879303337 03-OCT-16
  1    138467  14879303337 03-OCT-16 14879312953 03-OCT-16
  1    138468  14879312953 03-OCT-16 14879320619 03-OCT-16
  1    138469  14879320619 03-OCT-16 14879329339 03-OCT-16
  1    138470  14879329339 03-OCT-16 14879337316 03-OCT-16
  1    138471  14879337316 03-OCT-16 14879346202 03-OCT-16
  1    138472  14879346202 03-OCT-16 14879352987 03-OCT-16
  1    138473  14879352987 03-OCT-16 14879358925 03-OCT-16
  1    138474  14879358925 03-OCT-16 14879365188 03-OCT-16
  1    138475  14879365188 03-OCT-16 14879375492 03-OCT-16
  1    138476  14879375492 03-OCT-16 14879386990 03-OCT-16
  1    138477  14879386990 03-OCT-16 14879387101 03-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5413    Full    19.52M     DISK        00:00:02     03-OCT-16      
        BP Key: 5413   Status: EXPIRED  Compressed: NO  Tag: TAG20161003T160555
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161003-02
  Control File Included: Ckp SCN: 14879387237   Ckp time: 03-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5414    163.97M    DISK        00:00:28     03-OCT-16      
        BP Key: 5414   Status: EXPIRED  Compressed: YES  Tag: 8PM_ARCH_QMS01PRD._100316075500
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9DRHF5D7_1_1

  List of Archived Logs in backup set 5414
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138478  14879387101 03-OCT-16 14879390518 03-OCT-16
  1    138479  14879390518 03-OCT-16 14879392798 03-OCT-16
  1    138480  14879392798 03-OCT-16 14879400462 03-OCT-16
  1    138481  14879400462 03-OCT-16 14879405223 03-OCT-16
  1    138482  14879405223 03-OCT-16 14879408202 03-OCT-16
  1    138483  14879408202 03-OCT-16 14879420330 03-OCT-16
  1    138484  14879420330 03-OCT-16 14879423954 03-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5415    Full    19.52M     DISK        00:00:02     03-OCT-16      
        BP Key: 5415   Status: EXPIRED  Compressed: NO  Tag: TAG20161003T195557
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161003-03
  Control File Included: Ckp SCN: 14879424015   Ckp time: 03-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5416    142.42M    DISK        00:00:24     04-OCT-16      
        BP Key: 5416   Status: EXPIRED  Compressed: YES  Tag: 6AM_ARCH_BACKUP_QM_100416060003
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9FRHG8RG_1_1

  List of Archived Logs in backup set 5416
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138485  14879423954 03-OCT-16 14879470520 03-OCT-16
  1    138486  14879470520 03-OCT-16 14879562419 03-OCT-16
  1    138487  14879562419 03-OCT-16 14879585771 04-OCT-16
  1    138488  14879585771 04-OCT-16 14879587269 04-OCT-16
  1    138489  14879587269 04-OCT-16 14879602990 04-OCT-16
  1    138490  14879602990 04-OCT-16 14879612363 04-OCT-16
  1    138491  14879612363 04-OCT-16 14879626576 04-OCT-16
  1    138492  14879626576 04-OCT-16 14879627356 04-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5417    Full    19.52M     DISK        00:00:03     04-OCT-16      
        BP Key: 5417   Status: EXPIRED  Compressed: NO  Tag: TAG20161004T060044
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161004-00
  Control File Included: Ckp SCN: 14879627478   Ckp time: 04-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5418    148.97M    DISK        00:00:28     04-OCT-16      
        BP Key: 5418   Status: EXPIRED  Compressed: YES  Tag: 12PM_ARCH_BACKUP_Q_100416120002
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9HRHGTUL_1_1

  List of Archived Logs in backup set 5418
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138493  14879627356 04-OCT-16 14879638520 04-OCT-16
  1    138494  14879638520 04-OCT-16 14879644976 04-OCT-16
  1    138495  14879644976 04-OCT-16 14879654199 04-OCT-16
  1    138496  14879654199 04-OCT-16 14879661309 04-OCT-16
  1    138497  14879661309 04-OCT-16 14879669083 04-OCT-16
  1    138498  14879669083 04-OCT-16 14879675675 04-OCT-16
  1    138499  14879675675 04-OCT-16 14879684861 04-OCT-16
  1    138500  14879684861 04-OCT-16 14879691546 04-OCT-16
  1    138501  14879691546 04-OCT-16 14879698930 04-OCT-16
  1    138502  14879698930 04-OCT-16 14879705102 04-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5419    Full    19.52M     DISK        00:00:03     04-OCT-16      
        BP Key: 5419   Status: EXPIRED  Compressed: NO  Tag: TAG20161004T120100
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161004-01
  Control File Included: Ckp SCN: 14879705473   Ckp time: 04-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5420    125.62M    DISK        00:00:23     04-OCT-16      
        BP Key: 5420   Status: EXPIRED  Compressed: YES  Tag: 4PM_ARCH_BACKUP_QM_100416040503
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9JRHHC9N_1_1

  List of Archived Logs in backup set 5420
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138503  14879705102 04-OCT-16 14879715236 04-OCT-16
  1    138504  14879715236 04-OCT-16 14879724227 04-OCT-16
  1    138505  14879724227 04-OCT-16 14879732678 04-OCT-16
  1    138506  14879732678 04-OCT-16 14879742791 04-OCT-16
  1    138507  14879742791 04-OCT-16 14879751426 04-OCT-16
  1    138508  14879751426 04-OCT-16 14879759528 04-OCT-16
  1    138509  14879759528 04-OCT-16 14879768958 04-OCT-16
  1    138510  14879768958 04-OCT-16 14879771264 04-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5421    Full    19.52M     DISK        00:00:01     04-OCT-16      
        BP Key: 5421   Status: EXPIRED  Compressed: NO  Tag: TAG20161004T160539
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161004-02
  Control File Included: Ckp SCN: 14879771329   Ckp time: 04-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5422    41.59M     DISK        00:00:09     04-OCT-16      
        BP Key: 5422   Status: EXPIRED  Compressed: YES  Tag: 8PM_ARCH_QMS01PRD._100416075501
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9LRHHPP4_1_1

  List of Archived Logs in backup set 5422
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138511  14879771264 04-OCT-16 14879781564 04-OCT-16
  1    138512  14879781564 04-OCT-16 14879793163 04-OCT-16
  1    138513  14879793163 04-OCT-16 14879797119 04-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5423    Full    19.52M     DISK        00:00:03     04-OCT-16      
        BP Key: 5423   Status: EXPIRED  Compressed: NO  Tag: TAG20161004T195534
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161004-03
  Control File Included: Ckp SCN: 14879797157   Ckp time: 04-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5424    110.24M    DISK        00:00:18     05-OCT-16      
        BP Key: 5424   Status: EXPIRED  Compressed: YES  Tag: 6AM_ARCH_BACKUP_QM_100516060001
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9NRHIT7J_1_1

  List of Archived Logs in backup set 5424
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138514  14879797119 04-OCT-16 14879842528 04-OCT-16
  1    138515  14879842528 04-OCT-16 14879920928 04-OCT-16
  1    138516  14879920928 04-OCT-16 14879921980 04-OCT-16
  1    138517  14879921980 04-OCT-16 14879941851 05-OCT-16
  1    138518  14879941851 05-OCT-16 14879954985 05-OCT-16
  1    138519  14879954985 05-OCT-16 14879963919 05-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5425    Full    19.52M     DISK        00:00:04     05-OCT-16      
        BP Key: 5425   Status: EXPIRED  Compressed: NO  Tag: TAG20161005T060046
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161005-00
  Control File Included: Ckp SCN: 14879964115   Ckp time: 05-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5426    741.96M    DISK        00:01:52     05-OCT-16      
        BP Key: 5426   Status: EXPIRED  Compressed: YES  Tag: 12PM_ARCH_BACKUP_Q_100516120002
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9PRHJIAR_1_1

  List of Archived Logs in backup set 5426
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138520  14879963919 05-OCT-16 14879973618 05-OCT-16
  1    138521  14879973618 05-OCT-16 14879975986 05-OCT-16
  1    138522  14879975986 05-OCT-16 14879979100 05-OCT-16
  1    138523  14879979100 05-OCT-16 14879984408 05-OCT-16
  1    138524  14879984408 05-OCT-16 14879994515 05-OCT-16
  1    138525  14879994515 05-OCT-16 14879999794 05-OCT-16
  1    138526  14879999794 05-OCT-16 14880000579 05-OCT-16
  1    138527  14880000579 05-OCT-16 14880001309 05-OCT-16
  1    138528  14880001309 05-OCT-16 14880002060 05-OCT-16
  1    138529  14880002060 05-OCT-16 14880010566 05-OCT-16
  1    138530  14880010566 05-OCT-16 14880017353 05-OCT-16
  1    138531  14880017353 05-OCT-16 14880026146 05-OCT-16
  1    138532  14880026146 05-OCT-16 14880033845 05-OCT-16
  1    138533  14880033845 05-OCT-16 14880037608 05-OCT-16
  1    138534  14880037608 05-OCT-16 14880041312 05-OCT-16
  1    138535  14880041312 05-OCT-16 14880046078 05-OCT-16
  1    138536  14880046078 05-OCT-16 14880054351 05-OCT-16
  1    138537  14880054351 05-OCT-16 14880061231 05-OCT-16
  1    138538  14880061231 05-OCT-16 14880065524 05-OCT-16
  1    138539  14880065524 05-OCT-16 14880070122 05-OCT-16
  1    138540  14880070122 05-OCT-16 14880074271 05-OCT-16
  1    138541  14880074271 05-OCT-16 14880082580 05-OCT-16
  1    138542  14880082580 05-OCT-16 14880090439 05-OCT-16
  1    138543  14880090439 05-OCT-16 14880098362 05-OCT-16
  1    138544  14880098362 05-OCT-16 14880104949 05-OCT-16
  1    138545  14880104949 05-OCT-16 14880112591 05-OCT-16
  1    138546  14880112591 05-OCT-16 14880115962 05-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5427    Full    19.52M     DISK        00:00:02     05-OCT-16      
        BP Key: 5427   Status: EXPIRED  Compressed: NO  Tag: TAG20161005T120224
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161005-01
  Control File Included: Ckp SCN: 14880117113   Ckp time: 05-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5428    438.54M    DISK        00:01:08     05-OCT-16      
        BP Key: 5428   Status: EXPIRED  Compressed: YES  Tag: 4PM_ARCH_BACKUP_QM_100516040500
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9RRHK0LN_1_1

  List of Archived Logs in backup set 5428
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138547  14880115962 05-OCT-16 14880123453 05-OCT-16
  1    138548  14880123453 05-OCT-16 14880128793 05-OCT-16
  1    138549  14880128793 05-OCT-16 14880135426 05-OCT-16
  1    138550  14880135426 05-OCT-16 14880140029 05-OCT-16
  1    138551  14880140029 05-OCT-16 14880145721 05-OCT-16
  1    138552  14880145721 05-OCT-16 14880153487 05-OCT-16
  1    138553  14880153487 05-OCT-16 14880157039 05-OCT-16
  1    138554  14880157039 05-OCT-16 14880165087 05-OCT-16
  1    138555  14880165087 05-OCT-16 14880170240 05-OCT-16
  1    138556  14880170240 05-OCT-16 14880176843 05-OCT-16
  1    138557  14880176843 05-OCT-16 14880185165 05-OCT-16
  1    138558  14880185165 05-OCT-16 14880190085 05-OCT-16
  1    138559  14880190085 05-OCT-16 14880192621 05-OCT-16
  1    138560  14880192621 05-OCT-16 14880199046 05-OCT-16
  1    138561  14880199046 05-OCT-16 14880207486 05-OCT-16
  1    138562  14880207486 05-OCT-16 14880208211 05-OCT-16
  1    138563  14880208211 05-OCT-16 14880208938 05-OCT-16
  1    138564  14880208938 05-OCT-16 14880213296 05-OCT-16
  1    138565  14880213296 05-OCT-16 14880219868 05-OCT-16
  1    138566  14880219868 05-OCT-16 14880219943 05-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5429    Full    19.52M     DISK        00:00:02     05-OCT-16      
        BP Key: 5429   Status: EXPIRED  Compressed: NO  Tag: TAG20161005T160628
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161005-02
  Control File Included: Ckp SCN: 14880220192   Ckp time: 05-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5430    49.19M     DISK        00:00:09     05-OCT-16      
        BP Key: 5430   Status: EXPIRED  Compressed: YES  Tag: 8PM_ARCH_QMS01PRD._100516075502
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9TRHKE53_1_1

  List of Archived Logs in backup set 5430
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138567  14880219943 05-OCT-16 14880228728 05-OCT-16
  1    138568  14880228728 05-OCT-16 14880233445 05-OCT-16
  1    138569  14880233445 05-OCT-16 14880247139 05-OCT-16
  1    138570  14880247139 05-OCT-16 14880249576 05-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5431    Full    19.52M     DISK        00:00:02     05-OCT-16      
        BP Key: 5431   Status: EXPIRED  Compressed: NO  Tag: TAG20161005T195533
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161005-03
  Control File Included: Ckp SCN: 14880249607   Ckp time: 05-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5432    111.74M    DISK        00:00:18     06-OCT-16      
        BP Key: 5432   Status: EXPIRED  Compressed: YES  Tag: 6AM_ARCH_BACKUP_QM_100616060001
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\9VRHLHJD_1_1

  List of Archived Logs in backup set 5432
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138571  14880249576 05-OCT-16 14880330619 05-OCT-16
  1    138572  14880330619 05-OCT-16 14880499020 05-OCT-16
  1    138573  14880499020 05-OCT-16 14881638181 06-OCT-16
  1    138574  14881638181 06-OCT-16 14881646267 06-OCT-16
  1    138575  14881646267 06-OCT-16 14881659651 06-OCT-16
  1    138576  14881659651 06-OCT-16 14881672238 06-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5433    Full    19.52M     DISK        00:00:03     06-OCT-16      
        BP Key: 5433   Status: EXPIRED  Compressed: NO  Tag: TAG20161006T060041
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161006-00
  Control File Included: Ckp SCN: 14881672544   Ckp time: 06-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5434    625.38M    DISK        00:01:41     06-OCT-16      
        BP Key: 5434   Status: EXPIRED  Compressed: YES  Tag: 12PM_ARCH_BACKUP_Q_100616120001
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\A1RHM6MG_1_1

  List of Archived Logs in backup set 5434
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138577  14881672238 06-OCT-16 14881681657 06-OCT-16
  1    138578  14881681657 06-OCT-16 14881690266 06-OCT-16
  1    138579  14881690266 06-OCT-16 14881698604 06-OCT-16
  1    138580  14881698604 06-OCT-16 14881706063 06-OCT-16
  1    138581  14881706063 06-OCT-16 14881713838 06-OCT-16
  1    138582  14881713838 06-OCT-16 14881720850 06-OCT-16
  1    138583  14881720850 06-OCT-16 14881728716 06-OCT-16
  1    138584  14881728716 06-OCT-16 14881735869 06-OCT-16
  1    138585  14881735869 06-OCT-16 14881742054 06-OCT-16
  1    138586  14881742054 06-OCT-16 14881749135 06-OCT-16
  1    138587  14881749135 06-OCT-16 14881756813 06-OCT-16
  1    138588  14881756813 06-OCT-16 14881765916 06-OCT-16
  1    138589  14881765916 06-OCT-16 14881775495 06-OCT-16
  1    138590  14881775495 06-OCT-16 14881784443 06-OCT-16
  1    138591  14881784443 06-OCT-16 14881792945 06-OCT-16
  1    138592  14881792945 06-OCT-16 14881800430 06-OCT-16
  1    138593  14881800430 06-OCT-16 14881810279 06-OCT-16
  1    138594  14881810279 06-OCT-16 14881818364 06-OCT-16
  1    138595  14881818364 06-OCT-16 14881823169 06-OCT-16
  1    138596  14881823169 06-OCT-16 14881828541 06-OCT-16
  1    138597  14881828541 06-OCT-16 14881837967 06-OCT-16
  1    138598  14881837967 06-OCT-16 14881843719 06-OCT-16
  1    138599  14881843719 06-OCT-16 14881848266 06-OCT-16
  1    138600  14881848266 06-OCT-16 14881855986 06-OCT-16
  1    138601  14881855986 06-OCT-16 14881865266 06-OCT-16
  1    138602  14881865266 06-OCT-16 14881872286 06-OCT-16
  1    138603  14881872286 06-OCT-16 14881881379 06-OCT-16
  1    138604  14881881379 06-OCT-16 14881882421 06-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5435    Full    19.52M     DISK        00:00:03     06-OCT-16      
        BP Key: 5435   Status: EXPIRED  Compressed: NO  Tag: TAG20161006T120204
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161006-01
  Control File Included: Ckp SCN: 14881883555   Ckp time: 06-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5436    253.71M    DISK        00:00:38     06-OCT-16      
        BP Key: 5436   Status: EXPIRED  Compressed: YES  Tag: 4PM_ARCH_BACKUP_QM_100616040500
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\A3RHML1M_1_1

  List of Archived Logs in backup set 5436
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138605  14881882421 06-OCT-16 14881891464 06-OCT-16
  1    138606  14881891464 06-OCT-16 14881899532 06-OCT-16
  1    138607  14881899532 06-OCT-16 14881905096 06-OCT-16
  1    138608  14881905096 06-OCT-16 14881912412 06-OCT-16
  1    138609  14881912412 06-OCT-16 14881918531 06-OCT-16
  1    138610  14881918531 06-OCT-16 14881927334 06-OCT-16
  1    138611  14881927334 06-OCT-16 14881934716 06-OCT-16
  1    138612  14881934716 06-OCT-16 14881940165 06-OCT-16
  1    138613  14881940165 06-OCT-16 14881947074 06-OCT-16
  1    138614  14881947074 06-OCT-16 14881955278 06-OCT-16
  1    138615  14881955278 06-OCT-16 14881962448 06-OCT-16
  1    138616  14881962448 06-OCT-16 14881970662 06-OCT-16
  1    138617  14881970662 06-OCT-16 14881978954 06-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5437    Full    19.52M     DISK        00:00:02     06-OCT-16      
        BP Key: 5437   Status: EXPIRED  Compressed: NO  Tag: TAG20161006T160559
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161006-02
  Control File Included: Ckp SCN: 14881979029   Ckp time: 06-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5438    27.42M     DISK        00:00:06     06-OCT-16      
        BP Key: 5438   Status: EXPIRED  Compressed: YES  Tag: 8PM_ARCH_QMS01PRD._100616075500
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\A5RHN2H9_1_1

  List of Archived Logs in backup set 5438
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138618  14881978954 06-OCT-16 14881989738 06-OCT-16
  1    138619  14881989738 06-OCT-16 14882003416 06-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5439    Full    19.52M     DISK        00:00:01     06-OCT-16      
        BP Key: 5439   Status: EXPIRED  Compressed: NO  Tag: TAG20161006T195530
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161006-03
  Control File Included: Ckp SCN: 14882003426   Ckp time: 06-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5440    193.40M    DISK        00:00:35     07-OCT-16      
        BP Key: 5440   Status: EXPIRED  Compressed: YES  Tag: 6AM_ARCH_BACKUP_QM_100716060002
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\A7RHO5VG_1_1

  List of Archived Logs in backup set 5440
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138620  14882003416 06-OCT-16 14882069945 06-OCT-16
  1    138621  14882069945 06-OCT-16 14882116375 06-OCT-16
  1    138622  14882116375 06-OCT-16 14882132228 07-OCT-16
  1    138623  14882132228 07-OCT-16 14882137978 07-OCT-16
  1    138624  14882137978 07-OCT-16 14882142745 07-OCT-16
  1    138625  14882142745 07-OCT-16 14882152443 07-OCT-16
  1    138626  14882152443 07-OCT-16 14882161389 07-OCT-16
  1    138627  14882161389 07-OCT-16 14882168234 07-OCT-16
  1    138628  14882168234 07-OCT-16 14882176483 07-OCT-16
  1    138629  14882176483 07-OCT-16 14882189516 07-OCT-16
  1    138630  14882189516 07-OCT-16 14882189872 07-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5441    Full    19.52M     DISK        00:00:02     07-OCT-16      
        BP Key: 5441   Status: EXPIRED  Compressed: NO  Tag: TAG20161007T060054
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161007-00
  Control File Included: Ckp SCN: 14882190032   Ckp time: 07-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5442    539.06M    DISK        00:01:21     07-OCT-16      
        BP Key: 5442   Status: EXPIRED  Compressed: YES  Tag: 12PM_ARCH_BACKUP_Q_100716120001
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\A9RHOR2G_1_1

  List of Archived Logs in backup set 5442
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138631  14882189872 07-OCT-16 14882200478 07-OCT-16
  1    138632  14882200478 07-OCT-16 14882205799 07-OCT-16
  1    138633  14882205799 07-OCT-16 14882212814 07-OCT-16
  1    138634  14882212814 07-OCT-16 14882222910 07-OCT-16
  1    138635  14882222910 07-OCT-16 14882228843 07-OCT-16
  1    138636  14882228843 07-OCT-16 14882236103 07-OCT-16
  1    138637  14882236103 07-OCT-16 14882244931 07-OCT-16
  1    138638  14882244931 07-OCT-16 14882249138 07-OCT-16
  1    138639  14882249138 07-OCT-16 14882256346 07-OCT-16
  1    138640  14882256346 07-OCT-16 14882266314 07-OCT-16
  1    138641  14882266314 07-OCT-16 14882275861 07-OCT-16
  1    138642  14882275861 07-OCT-16 14882285016 07-OCT-16
  1    138643  14882285016 07-OCT-16 14882293692 07-OCT-16
  1    138644  14882293692 07-OCT-16 14882299790 07-OCT-16
  1    138645  14882299790 07-OCT-16 14882307222 07-OCT-16
  1    138646  14882307222 07-OCT-16 14882312302 07-OCT-16
  1    138647  14882312302 07-OCT-16 14882319503 07-OCT-16
  1    138648  14882319503 07-OCT-16 14882327252 07-OCT-16
  1    138649  14882327252 07-OCT-16 14882332410 07-OCT-16
  1    138650  14882332410 07-OCT-16 14882333437 07-OCT-16
  1    138651  14882333437 07-OCT-16 14882338134 07-OCT-16
  1    138652  14882338134 07-OCT-16 14882341625 07-OCT-16
  1    138653  14882341625 07-OCT-16 14882347715 07-OCT-16
  1    138654  14882347715 07-OCT-16 14882356106 07-OCT-16
  1    138655  14882356106 07-OCT-16 14882363754 07-OCT-16
  1    138656  14882363754 07-OCT-16 14882370277 07-OCT-16
  1    138657  14882370277 07-OCT-16 14882375999 07-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5443    Full    19.52M     DISK        00:00:01     07-OCT-16      
        BP Key: 5443   Status: EXPIRED  Compressed: NO  Tag: TAG20161007T120143
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161007-01
  Control File Included: Ckp SCN: 14882376725   Ckp time: 07-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5444    269.01M    DISK        00:00:37     07-OCT-16      
        BP Key: 5444   Status: EXPIRED  Compressed: YES  Tag: 4PM_ARCH_BACKUP_QM_100716040504
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\ABRHP9DM_1_1

  List of Archived Logs in backup set 5444
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138658  14882375999 07-OCT-16 14882383504 07-OCT-16
  1    138659  14882383504 07-OCT-16 14882390886 07-OCT-16
  1    138660  14882390886 07-OCT-16 14882397935 07-OCT-16
  1    138661  14882397935 07-OCT-16 14882404824 07-OCT-16
  1    138662  14882404824 07-OCT-16 14882412860 07-OCT-16
  1    138663  14882412860 07-OCT-16 14882417763 07-OCT-16
  1    138664  14882417763 07-OCT-16 14882424289 07-OCT-16
  1    138665  14882424289 07-OCT-16 14882431857 07-OCT-16
  1    138666  14882431857 07-OCT-16 14882439469 07-OCT-16
  1    138667  14882439469 07-OCT-16 14882444516 07-OCT-16
  1    138668  14882444516 07-OCT-16 14882450636 07-OCT-16
  1    138669  14882450636 07-OCT-16 14882459486 07-OCT-16
  1    138670  14882459486 07-OCT-16 14882461065 07-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5445    Full    19.52M     DISK        00:00:02     07-OCT-16      
        BP Key: 5445   Status: EXPIRED  Compressed: NO  Tag: TAG20161007T160558
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161007-02
  Control File Included: Ckp SCN: 14882461119   Ckp time: 07-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Size       Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
5446    44.21M     DISK        00:00:08     07-OCT-16      
        BP Key: 5446   Status: EXPIRED  Compressed: YES  Tag: 8PM_ARCH_QMS01PRD._100716075500
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\ADRHPMT8_1_1

  List of Archived Logs in backup set 5446
  Thrd Seq     Low SCN    Low Time  Next SCN   Next Time
  ---- ------- ---------- --------- ---------- ---------
  1    138671  14882461065 07-OCT-16 14882468006 07-OCT-16
  1    138672  14882468006 07-OCT-16 14882475378 07-OCT-16
  1    138673  14882475378 07-OCT-16 14882485762 07-OCT-16
  1    138674  14882485762 07-OCT-16 14882491899 07-OCT-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5447    Full    19.52M     DISK        00:00:02     07-OCT-16      
        BP Key: 5447   Status: EXPIRED  Compressed: NO  Tag: TAG20161007T195528
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\C-1936131573-20161007-03
  Control File Included: Ckp SCN: 14882491909   Ckp time: 07-OCT-16
  SPFILE Included: Modification time: 28-SEP-16

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5448    Full    849.05G    DISK        48:16:52     20-OCT-16      
        BP Key: 5448   Status: EXPIRED  Compressed: YES  Tag: TAG20161018T085234
        Piece Name: T:\BACKUPS\QMS01PRD\RMAN\AFRILG6I_1_1
  List of Datafiles in backup set 5448
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 14882518680 18-OCT-16 E:\ORADATA\QMS01PRD\SYSTEM01.DBF
  2       Full 14882518680 18-OCT-16 E:\ORADATA\QMS01PRD\UNDOTBS01.DBF
  3       Full 14882518680 18-OCT-16 E:\ORADATA\QMS01PRD\SYSAUX01.DBF
  4       Full 14882518680 18-OCT-16 E:\ORADATA\QMS01PRD\USERS01.DBF
  5       Full 14882518680 18-OCT-16 E:\ORADATA\QMS01PRD\SMTSLV_DATA01.DBF
  6       Full 14882518680 18-OCT-16 D:\ORADATA\QMS01PRD\SMTSLV_INDX01.DBF

RMAN> 

Open in new window

0
 
LVL 4

Accepted Solution

by:
Abhimanyu Suri earned 500 total points
ID: 41857538
Use "catalog start with" if backup location is different across server A and B .

Thanks,
Suri
0
 
LVL 1

Author Closing Comment

by:joe_echavarria
ID: 41860489
Best Solution.
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows syntax for various backup options while discussing how the different basic backup types work.  It explains how to take full backups, incremental level 0 backups, incremental level 1 backups in both differential and cumulative mode a…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now