Today i had to restore a very large (2TB) and also a very active system (loads of redo) onto a test server. I wanted to minimize the amount of redo i had to apply to the restore of the last full incremental (level 0) backup that was taken so i needed to know when the incremental level 0 backup in live actually finished.
And i didn't have the logfiles from the actual backup still on disk and i don;t have access to the live database - so how could i find out what time period i needed to pick for the recover so it was just after the full backup finished - that way i only have to apply archive redo that covers the time the backup took and not hundreds of files if i pick some random time.
I thought this would be pretty easy to find, but unless I've missed somethign glaringly obvious I couldn't see a way to find what time the last level 0 backup actually finished using simple rman commands or simple sql queries.
I ended up writing some sql against the rman catalog to give me what i wanted.
This SQL shows the start/end time of each level 0 backup (which repeats for every row of output from the backup) along with the full log output.
In the end this has proved quite useful and maybe the SQL helps someone else too
with times as (
select distinct bsd.session_key session_key ,to_char(bjd.start_time,'dd-mon-yyyy hh24:mi:ss') st, to_char(bjd.end_time,'dd-mon-yyyy hh24:mi:ss') et
from rc_rman_backup_job_details bjd, rc_backup_set_details bsd
where bsd.session_recid = bjd.session_recid
and bsd.session_key = bjd.session_key
and bsd.SESSION_STAMP = bjd.SESSION_STAMP
and bsd.BACKUP_TYPE || bsd.INCREMENTAL_LEVEL = 'D0'
and bjd.status = 'COMPLETED'
and bsd.db_name='you-database-name_here')
select st,et,output from times,rc_rman_output op
where op.session_key=times.session_key
order by op.session_key,op.recid
/
This gives output like shown below - I've just pasted the full output from the last L0 backup. I can tell from this that i want to recover to a point just after 05-feb-2014 04:31:39 - as SCN's are mapped every 3 secs and thats as accurate as it can be i choose a time thats a few seconds after that time to be sure that the database will be completely consistent if i recover to that time and with the minimum amount of redo to trawl through.
04-feb-2014 20:48:36 05-feb-2014 04:31:39 connected to target database: dbname (DBID=123456)
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39 connected to recovery catalog database
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39 RMAN configuration parameters for database with db_unique_name dbname are:
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 60 DAYS;
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE BACKUP OPTIMIZATION OFF; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE CONTROLFILE AUTOBACKUP ON;
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE 'SBT_TAPE' TO 'cf_auto_%F';
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE DEVICE TYPE SBT_TAPE PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE SBT_TAPE TO 1; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE CHANNEL DEVICE TYPE 'SBT_TAPE' PARMS 'ENV=(TDPO_OPTFILE=/tsm/dbname/conf/tdpo.opt)';
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/oracle/trans/bck_%U';
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE MAXSETSIZE TO UNLIMITED; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39 CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/11.2.0.2.11.DB/dbs/snapcf_dbname.f'; # default
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39 allocated channel: t1
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: SID=656 device type=SBT_TAPE
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: Data Protection for Oracle: version 5.4.1.0
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39 starting full resync of recovery catalog
04-feb-2014 20:48:36 05-feb-2014 04:31:39 full resync complete
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39 Starting backup at 04-FEB-2014 20:48:36
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00015 name=/oracle/dbname/oradata/dbname_PRD_07.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00025 name=/oracle/dbname/oradata/.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00055 name=/oracle/dbname/oradata/dbname_PRD_45.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 20:48:41
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 21:07:17
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838673321_20140204_82196.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:18:36
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00017 name=/oracle/dbname/oradata/dbname_PRD_09.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00020 name=/oracle/dbname/oradata/dbname_PRD_11.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00054 name=/oracle/dbname/oradata/dbname_PRD_44.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 21:07:17
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 21:27:33
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838674437_20140204_82197.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:20:16
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00016 name=/oracle/dbname/oradata/dbname_PRD_08.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00059 name=/oracle/dbname/oradata/undotbs03.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00040 name=/oracle/dbname/oradata/dbname_PRD_30.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 21:27:33
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 21:45:09
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838675653_20140204_82200.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:17:36
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00003 name=/oracle/dbname/oradata/undotbs01.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00035 name=/oracle/dbname/oradata/dbname_PRD_25.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00046 name=/oracle/dbname/oradata/dbname_PRD_36.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 21:45:09
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 22:02:14
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838676709_20140204_82201.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:17:05
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00007 name=/oracle/dbname/oradata/dbname_PRD_01.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00036 name=/oracle/dbname/oradata/dbname_PRD_26.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00042 name=/oracle/dbname/oradata/dbname_PRD_32.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 22:02:14
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 22:20:00
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838677734_20140204_82202.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:17:46
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00008 name=/oracle/dbname/oradata/dbname_PRD_02.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00037 name=/oracle/dbname/oradata/dbname_PRD_27.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00041 name=/oracle/dbname/oradata/dbname_PRD_31.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 22:20:00
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 22:37:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838678800_20140204_82203.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:17:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00009 name=/oracle/dbname/oradata/dbname_PRD_03.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00038 name=/oracle/dbname/oradata/dbname_PRD_28.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00044 name=/oracle/dbname/oradata/dbname_PRD_34.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 22:37:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 22:58:32
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838679876_20140204_82206.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:20:36
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00024 name=/oracle/dbname/oradata/dbname_PRD_15.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00072 name=/oracle/dbname/oradata/dbname_PRD_55.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00053 name=/oracle/dbname/oradata/dbname_PRD_43.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 22:58:32
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 23:13:08
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838681112_20140204_82207.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:14:36
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00026 name=/oracle/dbname/oradata/dbname_PRD_16.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00073 name=/oracle/dbname/oradata/dbname_PRD_56.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00045 name=/oracle/dbname/oradata/dbname_PRD_35.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 23:13:09
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 23:26:04
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838681988_20140204_82208.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:12:55
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00010 name=/oracle/dbname/oradata/dbname_PRD_04.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00039 name=/oracle/dbname/oradata/dbname_PRD_29.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00067 name=/oracle/dbname/oradata/undotbs05.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 23:26:04
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 23:41:40
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838682764_20140204_82209.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:15:36
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00034 name=/oracle/dbname/oradata/dbname_PRD_24.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00052 name=/oracle/dbname/oradata/dbname_PRD_42.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00060 name=/oracle/dbname/oradata/undotbs04.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 23:41:40
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 04-FEB-2014 23:56:45
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838683700_20140204_82211.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:15:05
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00033 name=/oracle/dbname/oradata/dbname_PRD_23.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00047 name=/oracle/dbname/oradata/dbname_PRD_37.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00068 name=/oracle/dbname/oradata/dbname_PRD_51.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 04-FEB-2014 23:56:46
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 00:10:31
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838684605_20140204_82213.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:13:45
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00032 name=/oracle/dbname/oradata/dbname_PRD_22.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00043 name=/oracle/dbname/oradata/dbname_PRD_33.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00057 name=/oracle/dbname/oradata/RMDS_INTERFACE_DATA_02.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 00:10:31
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 00:23:47
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838685431_20140205_82214.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:13:16
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00031 name=/oracle/dbname/oradata/dbname_PRD_21.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00070 name=/oracle/dbname/oradata/dbname_PRD_54.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00058 name=/oracle/dbname/oradata/RMDS_INTERFACE_DATA_03.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 00:23:48
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 00:33:13
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838686227_20140205_82215.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:09:25
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00030 name=/oracle/dbname/oradata/dbname_PRD_20.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00049 name=/oracle/dbname/oradata/dbname_PRD_39.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00069 name=/oracle/dbname/oradata/dbname_PRD_52.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 00:33:13
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 01:00:09
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838686793_20140205_82216.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:26:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00029 name=/oracle/dbname/oradata/dbname_PRD_19.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00050 name=/oracle/dbname/oradata/dbname_PRD_40.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00002 name=/oracle/dbname/oradata/sysaux01.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 01:00:09
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 01:26:35
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838688409_20140205_82218.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:26:26
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00011 name=/oracle/dbname/oradata/dbname_PRD_05.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00056 name=/oracle/dbname/oradata/RMDS_INTERFACE_DATA_01.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 01:26:35
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 01:40:40
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838689995_20140205_82221.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:14:05
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00012 name=/oracle/dbname/oradata/dbname_PRD_06.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00065 name=/oracle/dbname/oradata/dbname_PRD_50.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 01:40:40
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 02:00:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838690840_20140205_82222.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:20:16
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00028 name=/oracle/dbname/oradata/dbname_PRD_18.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00051 name=/oracle/dbname/oradata/dbname_PRD_41.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00001 name=/oracle/dbname/oradata/system01.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 02:00:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 02:18:52
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838692056_20140205_82225.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:17:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00018 name=/oracle/dbname/oradata/dbname_PRD_10.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00061 name=/oracle/dbname/oradata/dbname_PRD_46.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00014 name=/oracle/dbname/oradata/users_tiv_itm6.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 02:18:52
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 02:34:08
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838693132_20140205_82226.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:15:16
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00019 name=/oracle/dbname/oradata/undotbs02.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00062 name=/oracle/dbname/oradata/dbname_PRD_47.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00066 name=/oracle/dbname/oradata/dbspi_users01.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 02:34:09
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 02:57:47
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838694049_20140205_82227.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:23:38
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00021 name=/oracle/dbname/oradata/dbname_PRD_12.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00063 name=/oracle/dbname/oradata/dbname_PRD_48.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00013 name=/oracle/dbname/oradata/AQ_ENDUR_ODINBASE_01.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 02:57:47
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 03:48:43
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838695467_20140205_82229.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:50:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00022 name=/oracle/dbname/oradata/dbname_PRD_13.DBF
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00064 name=/oracle/dbname/oradata/dbname_PRD_49.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00006 name=/oracle/dbname/oradata/users_tiv01.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 03:48:44
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 04:04:59
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838698524_20140205_82231.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:16:15
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00023 name=/oracle/dbname/oradata/dbname_PRD_14.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00071 name=/oracle/dbname/oradata/dbname_PRD_53.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00004 name=/oracle/dbname/oradata/users01.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 04:04:59
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 04:14:55
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838699499_20140205_82233.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:09:56
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting incremental level 0 datafile backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: specifying datafile(s) in backup set
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00027 name=/oracle/dbname/oradata/dbname_PRD_17.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00048 name=/oracle/dbname/oradata/dbname_PRD_38.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 input datafile file number=00005 name=/oracle/dbname/oradata/eisdba01.dbf
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: starting piece 1 at 05-FEB-2014 04:14:55
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: finished piece 1 at 05-FEB-2014 04:31:10
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=database_online_dbname_838700095_20140205_82234.rman tag=TAG20140204T204837 comment=API Version 2.0,MMS Version 5.4
04-feb-2014 20:48:36 05-feb-2014 04:31:39 channel t1: backup set complete, elapsed time: 00:16:15
04-feb-2014 20:48:36 05-feb-2014 04:31:39 Finished backup at 05-FEB-2014 04:31:10
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39 Starting Control File and SPFILE Autobackup at 05-FEB-2014 04:31:12
04-feb-2014 20:48:36 05-feb-2014 04:31:39 piece handle=cf_auto_c-4228324600-20140205-08 comment=API Version 2.0,MMS Version 5.4.1.0
04-feb-2014 20:48:36 05-feb-2014 04:31:39 Finished Control File and SPFILE Autobackup at 05-FEB-2014 04:31:35
04-feb-2014 20:48:36 05-feb-2014 04:31:39 released channel: t1
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39
04-feb-2014 20:48:36 05-feb-2014 04:31:39
Comments
Post a Comment