ITPub博客

首页 > 数据库 > Oracle > RMAN 备份全库

RMAN 备份全库

原创 Oracle 作者:zzh_ds 时间:2017-05-07 01:03:23 0 删除 编辑
登入目标数据库
  1. [oracle@hu app]$ rman target /

  2. Recovery Manager: Release 11.2.0.4.0 - Production on Fri May 5 16:18:22 2017

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

  4. connected to target database: HU (DBID=3569073582)

  5. RMAN>
执行全库备份(以备份集方式备份,包括控制文件和归档日志,删除已备份的归档日志)
  1. RMAN> backup as backupset database include current controlfile plus archivelog format '/u01/app/backup/db_%U.rum' delete all input;


  2. Starting backup at 05-MAY-17
  3. current log archived
  4. using target database control file instead of recovery catalog
  5. allocated channel: ORA_DISK_1
  6. channel ORA_DISK_1: SID=43 device type=DISK
  7. channel ORA_DISK_1: starting archived log backup set
  8. channel ORA_DISK_1: specifying archived log(s) in backup set
  9. input archived log thread=1 sequence=9 RECID=1 STAMP=943201362
  10. channel ORA_DISK_1: starting piece 1 at 05-MAY-17
  11. channel ORA_DISK_1: finished piece 1 at 05-MAY-17
  12. piece handle=/u01/app/backup/db_01s3g72k_1_1.rum tag=TAG20170505T162244 comment=NONE
  13. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  14. channel ORA_DISK_1: deleting archived log(s)
  15. archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_9_941998577.dbf RECID=1 STAMP=943201362
  16. Finished backup at 05-MAY-17

  17. Starting backup at 05-MAY-17
  18. using channel ORA_DISK_1
  19. channel ORA_DISK_1: starting full datafile backup set
  20. channel ORA_DISK_1: specifying datafile(s) in backup set
  21. input datafile file number=00001 name=/u01/app/oracle/oradata/HU/system01.dbf
  22. input datafile file number=00002 name=/u01/app/oracle/oradata/HU/sysaux01.dbf
  23. input datafile file number=00005 name=/u01/app/oracle/oradata/HU/example01.dbf
  24. input datafile file number=00003 name=/u01/app/oracle/oradata/HU/undotbs01.dbf
  25. input datafile file number=00004 name=/u01/app/oracle/oradata/HU/users01.dbf
  26. channel ORA_DISK_1: starting piece 1 at 05-MAY-17
  27. channel ORA_DISK_1: finished piece 1 at 05-MAY-17
  28. piece handle=/u01/app/backup/db_02s3g72m_1_1.rum tag=TAG20170505T162246 comment=NONE
  29. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:55
  30. channel ORA_DISK_1: starting full datafile backup set
  31. channel ORA_DISK_1: specifying datafile(s) in backup set
  32. including current control file in backup set
  33. including current SPFILE in backup set
  34. channel ORA_DISK_1: starting piece 1 at 05-MAY-17
  35. channel ORA_DISK_1: finished piece 1 at 05-MAY-17
  36. piece handle=/u01/app/backup/db_03s3g74e_1_1.rum tag=TAG20170505T162246 comment=NONE
  37. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  38. Finished backup at 05-MAY-17

  39. Starting backup at 05-MAY-17
  40. current log archived
  41. using channel ORA_DISK_1
  42. channel ORA_DISK_1: starting archived log backup set
  43. channel ORA_DISK_1: specifying archived log(s) in backup set
  44. input archived log thread=1 sequence=10 RECID=2 STAMP=943201424
  45. channel ORA_DISK_1: starting piece 1 at 05-MAY-17
  46. channel ORA_DISK_1: finished piece 1 at 05-MAY-17
  47. piece handle=/u01/app/backup/db_04s3g74g_1_1.rum tag=TAG20170505T162344 comment=NONE
  48. channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
  49. channel ORA_DISK_1: deleting archived log(s)
  50. archived log file name=/u01/app/oracle/product/11.2.0/dbhome_1/dbs/arch1_10_941998577.dbf RECID=2 STAMP=943201424
  51. Finished backup at 05-MAY-17

  52. RMAN>


来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/31399171/viewspace-2138602/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2016-09-29

  • 博文量
    61
  • 访问量
    47811