ITPub博客

首页 > Linux操作系统 > Linux操作系统 > rman backup

rman backup

原创 Linux操作系统 作者:oracle_db 时间:2012-04-21 14:28:24 0 删除 编辑
前提:归档模式下!
 1. 全库备份
2.指定备份集存储的位置
3.查看创建的全库备份

RMAN> list backup of database;


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

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
5       Full    367.53M    DISK        00:00:37     18-APR-12      
  List of Datafiles in backup set 5
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1236730    18-APR-12 /u01/oradata/dbtest/system01.dbf
  4       Full 1236730    18-APR-12 /u01/oradata/dbtest/users01.dbf

  Backup Set Copy #1 of backup set 5
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:00:37     18-APR-12       NO         TAG20120418T134805

    List of Backup Pieces for backup set 5 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    5       1   AVAILABLE   /u01/flash_recovery_area/DBTEST/backupset/2012_04_18/o1_mf_nnndf_TAG20120418T134805_7rwododh_.bkp
    6       2   AVAILABLE   /u01/flash_recovery_area/DBTEST/backupset/2012_04_18/o1_mf_nnndf_TAG20120418T134805_7rwodwc4_.bkp
    7       3   AVAILABLE   /u01/flash_recovery_area/DBTEST/backupset/2012_04_18/o1_mf_nnndf_TAG20120418T134805_7rwofof7_.bkp
    8       4   AVAILABLE   /u01/flash_recovery_area/DBTEST/backupset/2012_04_18/o1_mf_nnndf_TAG20120418T134805_7rwofrg7_.bkp

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
6       Full    194.16M    DISK        00:02:36     18-APR-12      
  List of Datafiles in backup set 6
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  3       Full 1236749    18-APR-12 /u01/oradata/dbtest/sysaux01.dbf
  7       Full 1236749    18-APR-12 /u01/oradata/dbtest/wenchuan01.dbf
  8       Full 1236749    18-APR-12 /u01/oradata/dbtest/wenchuan2.dbf

  Backup Set Copy #1 of backup set 6
  Device Type Elapsed Time Completion Time Compressed Tag
  ----------- ------------ --------------- ---------- ---
  DISK        00:02:36     18-APR-12       NO         TAG20120418T134805

    List of Backup Pieces for backup set 6 Copy #1
    BP Key  Pc# Status      Piece Name
    ------- --- ----------- ----------
    9       1   AVAILABLE   /u01/flash_recovery_area/DBTEST/backupset/2012_04_18/o1_mf_nnndf_TAG20120418T134805_7rwofvr7_.bkp
    10      2   AVAILABLE   /u01/flash_recovery_area/DBTEST/backupset/2012_04_18/o1_mf_nnndf_TAG20120418T134805_7rwoj6p6_.bkp

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
7       Full    91.05M     DISK        00:01:02     18-APR-12      
        BP Key: 11   Status: AVAILABLE  Compressed: NO  Tag: TAG20120418T134805
        Piece Name: /u01/flash_recovery_area/DBTEST/backupset/2012_04_18/o1_mf_nnndf_TAG20120418T134805_7rwolww1_.bkp
  List of Datafiles in backup set 7
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  2       Full 1236814    18-APR-12 /u01/oradata/dbtest/undotbs01.dbf
  5       Full 1236814    18-APR-12 /u01/oradata/dbtest/example01.dbf
  6       Full 1236814    18-APR-12 /u01/oradata/dbtest/paul01.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
9       Full    657.27M    DISK        00:01:48     21-APR-12      
        BP Key: 13   Status: AVAILABLE  Compressed: NO  Tag: TAG20120421T142707
        Piece Name: /u01/flash_recovery_area/DBTEST/backupset/2012_04_21/o1_mf_nnndf_TAG20120421T142707_7s4nsx0k_.bkp
  List of Datafiles in backup set 9
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1384584    21-APR-12 /u01/oradata/dbtest/system01.dbf
  2       Full 1384584    21-APR-12 /u01/oradata/dbtest/undotbs01.dbf
  3       Full 1384584    21-APR-12 /u01/oradata/dbtest/sysaux01.dbf
  4       Full 1384584    21-APR-12 /u01/oradata/dbtest/users01.dbf
  5       Full 1384584    21-APR-12 /u01/oradata/dbtest/example01.dbf
  6       Full 1384584    21-APR-12 /u01/oradata/dbtest/paul01.dbf
  7       Full 1384584    21-APR-12 /u01/oradata/dbtest/wenchuan01.dbf
  8       Full 1384584    21-APR-12 /u01/oradata/dbtest/wenchuan2.dbf

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
11      Full    657.27M    DISK        00:01:25     21-APR-12      
        BP Key: 15   Status: AVAILABLE  Compressed: NO  Tag: TAG20120421T143730
        Piece Name: /backup/rmanbackup/bak_0bn905pb_1_1
  List of Datafiles in backup set 11
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  1       Full 1384922    21-APR-12 /u01/oradata/dbtest/system01.dbf
  2       Full 1384922    21-APR-12 /u01/oradata/dbtest/undotbs01.dbf
  3       Full 1384922    21-APR-12 /u01/oradata/dbtest/sysaux01.dbf
  4       Full 1384922    21-APR-12 /u01/oradata/dbtest/users01.dbf
  5       Full 1384922    21-APR-12 /u01/oradata/dbtest/example01.dbf
  6       Full 1384922    21-APR-12 /u01/oradata/dbtest/paul01.dbf
  7       Full 1384922    21-APR-12 /u01/oradata/dbtest/wenchuan01.dbf
  8       Full 1384922    21-APR-12 /u01/oradata/dbtest/wenchuan2.dbf

RMAN> 
4.备份指定表空间
5.查看指定表空间的备份情况
6.删除指定的备份集【BACKUPSET】
7.备份指定的数据文件


8.备份控制文件

9.备份归档文件

r1.JPG

r2.JPG

r3.JPG

r4.JPG

r5.jpg

r6.JPG

r7.JPG

r8.JPG

r9.JPG

r10.JPG

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

上一篇: oracle-tom死锁演示
请登录后发表评论 登录
全部评论

注册时间:2008-11-13

  • 博文量
    158
  • 访问量
    313883