RMAN使用备份按时间点传输表空间(2)


Starting backup at 2015-03-26 20:32:19
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=68 recid=75 stamp=875286167
input archive log thread=1 sequence=69 recid=76 stamp=875291999
input archive log thread=1 sequence=70 recid=77 stamp=875302397
input archive log thread=1 sequence=71 recid=78 stamp=875308491
input archive log thread=1 sequence=72 recid=79 stamp=875350203
input archive log thread=1 sequence=73 recid=80 stamp=875351397
input archive log thread=1 sequence=74 recid=81 stamp=875390545
input archive log thread=1 sequence=75 recid=82 stamp=875390643
input archive log thread=1 sequence=76 recid=83 stamp=875391627
input archive log thread=1 sequence=77 recid=84 stamp=875391661
input archive log thread=1 sequence=78 recid=85 stamp=875391764
input archive log thread=1 sequence=79 recid=86 stamp=875392340
channel ORA_DISK_1: starting piece 1 at 2015-03-26 20:32:22
channel ORA_DISK_1: finished piece 1 at 2015-03-26 20:32:29
piece handle=/u02/ora_test875392341_991 tag=TAG20150326T203220 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:08
Finished backup at 2015-03-26 20:32:29

Starting backup at 2015-03-26 20:32:29
using channel ORA_DISK_1
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
input datafile fno=00001 name=/u01/app/oracle/oradata/test/system01.dbf
input datafile fno=00003 name=/u01/app/oracle/oradata/test/sysaux01.dbf
input datafile fno=00005 name=/u01/app/oracle/oradata/test/example01.dbf
input datafile fno=00006 name=/u01/app/oracle/oradata/test/tspitr01.dbf
input datafile fno=00002 name=/u01/app/oracle/oradata/test/undotbs01.dbf
input datafile fno=00004 name=/u01/app/oracle/oradata/test/users01.dbf
input datafile fno=00007 name=/u01/app/oracle/oradata/test/test01.dbf
channel ORA_DISK_1: starting piece 1 at 2015-03-26 20:32:30
channel ORA_DISK_1: finished piece 1 at 2015-03-26 20:33:45
piece handle=/u02/ora_test875392350_1001 tag=TAG20150326T203229 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15
channel ORA_DISK_1: starting full datafile backupset
channel ORA_DISK_1: specifying datafile(s) in backupset
including current control file in backupset
channel ORA_DISK_1: starting piece 1 at 2015-03-26 20:33:46
channel ORA_DISK_1: finished piece 1 at 2015-03-26 20:33:47
piece handle=/u02/ora_test875392425_1011 tag=TAG20150326T203229 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 2015-03-26 20:33:47

Starting backup at 2015-03-26 20:33:47
current log archived
using channel ORA_DISK_1
channel ORA_DISK_1: starting archive log backupset
channel ORA_DISK_1: specifying archive log(s) in backup set
input archive log thread=1 sequence=80 recid=87 stamp=875392427
channel ORA_DISK_1: starting piece 1 at 2015-03-26 20:33:49
channel ORA_DISK_1: finished piece 1 at 2015-03-26 20:33:50
piece handle=/u02/ora_test875392428_1021 tag=TAG20150326T203348 comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02
Finished backup at 2015-03-26 20:33:50

Starting Control File and SPFILE Autobackup at 2015-03-26 20:33:50
piece handle=/u02/c-2168949517-20150326-07 comment=NONE
Finished Control File and SPFILE Autobackup at 2015-03-26 20:33:54

RMAN> list backup;


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

BS Key  Size      Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ -------------------
6565    56.14M    DISK        00:00:07    2015-03-26 20:32:28
        BP Key: 6566  Status: AVAILABLE  Compressed: NO  Tag: TAG20150326T203220
        Piece Name: /u02/ora_test875392341_991

List of Archived Logs in backup set 6565
  Thrd Seq    Low SCN    Low Time            Next SCN  Next Time
  ---- ------- ---------- ------------------- ---------- ---------
  1    68      1040304    2015-03-25 09:33:41 1064641    2015-03-25 15:02:45
  1    69      1064641    2015-03-25 15:02:45 1067420    2015-03-25 16:39:58
  1    70      1067420    2015-03-25 16:39:58 1090668    2015-03-25 19:33:17
  1    71      1090668    2015-03-25 19:33:17 1093434    2015-03-25 21:14:51
  1    72      1093434    2015-03-25 21:14:51 1125870    2015-03-26 08:50:00
  1    73      1125870    2015-03-26 08:50:00 1126817    2015-03-26 09:09:56
  1    74      1126817    2015-03-26 09:09:56 1144051    2015-03-26 20:02:21
  1    75      1144051    2015-03-26 20:02:21 1144106    2015-03-26 20:04:02
  1    76      1144106    2015-03-26 20:04:02 1144862    2015-03-26 20:20:27
  1    77      1144862    2015-03-26 20:20:27 1144893    2015-03-26 20:21:00
  1    78      1144893    2015-03-26 20:21:00 1144980    2015-03-26 20:22:44
  1    79      1144980    2015-03-26 20:22:44 1145259    2015-03-26 20:32:19

内容版权声明:除非注明,否则皆为本站原创文章。

转载注明出处:https://www.heiqu.com/6f0e541c5be09521da9fe30f738be130.html