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

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

BS Key  Type LV Size      Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ -------------------
6607    Full    640.39M    DISK        00:01:08    2015-03-26 20:33:38
        BP Key: 6621  Status: AVAILABLE  Compressed: NO  Tag: TAG20150326T203229
        Piece Name: /u02/ora_test875392350_1001
  List of Datafiles in backup set 6607
  File LV Type Ckp SCN    Ckp Time            Name
  ---- -- ---- ---------- ------------------- ----
  1      Full 1145279    2015-03-26 20:32:30 /u01/app/oracle/oradata/test/system01.dbf
  2      Full 1145279    2015-03-26 20:32:30 /u01/app/oracle/oradata/test/undotbs01.dbf
  3      Full 1145279    2015-03-26 20:32:30 /u01/app/oracle/oradata/test/sysaux01.dbf
  4      Full 1145279    2015-03-26 20:32:30 /u01/app/oracle/oradata/test/users01.dbf
  5      Full 1145279    2015-03-26 20:32:30 /u01/app/oracle/oradata/test/example01.dbf
  6      Full 1145279    2015-03-26 20:32:30 /u01/app/oracle/oradata/test/tspitr01.dbf
  7      Full 1145279    2015-03-26 20:32:30 /u01/app/oracle/oradata/test/test01.dbf

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

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