rman backup

前提：归档模式下！

 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/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/15720542/viewspace-721882/