使用Rman 全备份以及增量备份

一.RMAN 简介

详情见百度百科

二.查看属否开启归档模式

 1: SQL> archive log list;

 2: Database log mode Archive Mode

 3: Automatic archival Enabled

 4: Archive destination USE_DB_RECOVERY_FILE_DEST

 5: Oldest online log sequence 127

 6: Next log sequence to archive 129

 7: Current log sequence 129

如果未开启归档模式,开启归档模式.

 1: SQL> startup nomount ;

 2: ORACLE instance started.

 3:  

 4: Total System Global Area 608174080 bytes

 5: Fixed Size 1220820 bytes

 6: Variable Size 192941868 bytes

 7: Database Buffers 406847488 bytes

 8: Redo Buffers 7163904 bytes

 9: SQL> alter database mount;

 10:  

 11: Database altered.

 12: SQL> alter database archivelog;

三.RMAN全备

   1: $ rman target /

    2:  

    3: Recovery Manager: Release 10.2.0.4.0 - Production on Tue Jun 21 19:30:52 2011

    4:  

    5: Copyright (c) 1982, 2007, Oracle.  All rights reserved.

    6:  

    7: connected to target database: JCT (DBID=786899877)

    8:  -----

    9: RMAN>; report schema;

列出数据库当前的schema

  10:  

   11: using target database control file instead of recovery catalog

   12: Report of database schema

   13:  

   14: List of Permanent Datafiles

   15: ===========================

   16: File Size(MB) Tablespace           RB segs Datafile Name

   17: ---- -------- -------------------- ------- ------------------------

   18: 1    490      SYSTEM               ***     /oradata/jct/jct/system01.dbf

   19: 2    45       UNDOTBS1             ***     /oradata/jct/jct/undotbs01.dbf

   20: 3    400      SYSAUX               ***     /oradata/jct/jct/sysaux01.dbf

   21: 4    22       USERS                ***     /oradata/jct/jct/users01.dbf

   22: 5    800      DINFO                ***     /oradata/jct/jct/DINFO.dbf

   23:  

   24: List of Temporary Files

   25: =======================

   26: File Size(MB) Tablespace           Maxsize(MB) Tempfile Name

   27: ---- -------- -------------------- ----------- --------------------

   28: 1    20       TEMP                 32767       /oradata/jct/jct/temp01.dbf

数据库全备

   1: MAN>; run

    2: 2>; {

    3: 3>; allocate channel c1 type disk;

    4: 4>; backup database

    5: 5>; format '/oradata/bakup/db_%d_%s.bak';

    6: 6>; }

    7:  

    8: allocated channel: c1

    9: channel c1: sid=123 devtype=DISK

   10:  

   11: Starting backup at 21-JUN-11

   12: channel c1: starting full datafile backupset

   13: channel c1: specifying datafile(s) in backupset

   14: input datafile fno=00005 name=/oradata/jct/jct/DINFO.dbf

   15: input datafile fno=00001 name=/oradata/jct/jct/system01.dbf

   16: input datafile fno=00003 name=/oradata/jct/jct/sysaux01.dbf

   17: input datafile fno=00002 name=/oradata/jct/jct/undotbs01.dbf

   18: input datafile fno=00004 name=/oradata/jct/jct/users01.dbf

   19: channel c1: starting piece 1 at 21-JUN-11

   20: channel c1: finished piece 1 at 21-JUN-11

   21: piece handle=/oradata/bakup/db_JCT_1.bak tag=TAG20110621T203141 comment=NONE

   22: channel c1: backup set complete, elapsed time: 00:00:28

   23: channel c1: starting full datafile backupset

   24: channel c1: specifying datafile(s) in backupset

   25: including current control file in backupset

   26: including current SPFILE in backupset

   27: channel c1: starting piece 1 at 21-JUN-11

   28: channel c1: finished piece 1 at 21-JUN-11

   29: piece handle=/oradata/bakup/db_JCT_2.bak tag=TAG20110621T203141 comment=NONE

   30: channel c1: backup set complete, elapsed time: 00:00:02

   31: Finished backup at 21-JUN-11

   32: released channel: c1

   33:  

查看备份数据

   1: $ ls -l

    2: total 1467256

    3: -rw-r-----    1 oracle   dba       745562112 Jun 21 20:32 db_JCT_1.bak

    4: -rw-r-----    1 oracle   dba         5668864 Jun 21 20:32 db_JCT_2.bak

增量备份

   1: RMAN> backup incremental level 1 database;

    2:  

    3: Starting backup at 21-JUN-11

    4: using channel ORA_DISK_1

    5: channel ORA_DISK_1: starting incremental level 1 datafile backupset

    6: channel ORA_DISK_1: specifying datafile(s) in backupset

    7: input datafile fno=00005 name=/oradata/jct/jct/DINFO.dbf

    8: input datafile fno=00001 name=/oradata/jct/jct/system01.dbf

    9: input datafile fno=00003 name=/oradata/jct/jct/sysaux01.dbf

   10: input datafile fno=00002 name=/oradata/jct/jct/undotbs01.dbf

   11: input datafile fno=00004 name=/oradata/jct/jct/users01.dbf

   12: channel ORA_DISK_1: starting piece 1 at 21-JUN-11

   13: channel ORA_DISK_1: finished piece 1 at 21-JUN-11

   14: piece handle=/oracle/flash_recovery_area/JCT/backupset/2011_06_21/o1_mf_nnnd1_TAG20110621T203939_70148ddp_.bkp tag=TAG20110621T203939 comment=NONE

   15: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45

   16: channel ORA_DISK_1: starting incremental level 1 datafile backupset

   17: channel ORA_DISK_1: specifying datafile(s) in backupset

   18: including current control file in backupset

   19: including current SPFILE in backupset

   20: channel ORA_DISK_1: starting piece 1 at 21-JUN-11

   21: channel ORA_DISK_1: finished piece 1 at 21-JUN-11

   22: piece handle=/oracle/flash_recovery_area/JCT/backupset/2011_06_21/o1_mf_ncsn1_TAG20110621T203939_70149voy_.bkp tag=TAG20110621T203939 comment=NONE

   23: channel ORA_DISK_1: backup set complete, elapsed time: 00:00:02

   24: Finished backup at 21-JUN-11

列出备份文件

   1: RMAN> list backup;

    2:  

    3: using target database control file instead of recovery catalog

    4:  

    5: List of Backup Sets

    6: ===================

    7:  

    8: BS Key  Type LV Size       Device Type Elapsed Time Completion Time

    9: ------- ---- -- ---------- ----------- ------------ ---------------

   10: 1       Full    711.02M    DISK        00:00:24     21-JUN-11      

   11:         BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20110621T203141

   12:         Piece Name: /oradata/bakup/db_JCT_1.bak

   13:   List of Datafiles in backup set 1

   14:   File LV Type Ckp SCN    Ckp Time  Name

   15:   ---- -- ---- ---------- --------- ----

   16:   1       Full 4771360    21-JUN-11 /oradata/jct/jct/system01.dbf

   17:   2       Full 4771360    21-JUN-11 /oradata/jct/jct/undotbs01.dbf

   18:   3       Full 4771360    21-JUN-11 /oradata/jct/jct/sysaux01.dbf

   19:   4       Full 4771360    21-JUN-11 /oradata/jct/jct/users01.dbf

   20:   5       Full 4771360    21-JUN-11 /oradata/jct/jct/DINFO.dbf

   21:  

   22: BS Key  Type LV Size       Device Type Elapsed Time Completion Time

   23: ------- ---- -- ---------- ----------- ------------ ---------------

   24: 2       Full    5.39M      DISK        00:00:01     21-JUN-11      

   25:         BP Key: 2   Status: AVAILABLE  Compressed: NO  Tag: TAG20110621T203141

   26:         Piece Name: /oradata/bakup/db_JCT_2.bak

   27:   Control File Included: Ckp SCN: 4771370      Ckp time: 21-JUN-11

   28:   SPFILE Included: Modification time: 09-MAY-11

   29:  

   30: BS Key  Type LV Size       Device Type Elapsed Time Completion Time

   31: ------- ---- -- ---------- ----------- ------------ ---------------

   32: 3       Full    711.02M    DISK        00:00:12     21-JUN-11      

   33:         BP Key: 3   Status: AVAILABLE  Compressed: NO  Tag: TAG20110621T203312

   34:         Piece Name: /oracle/flash_recovery_area/JCT/backupset/2011_06_21/o1_mf_nnndf_TAG20110621T203312_7013w9hb_.bkp

   35:   List of Datafiles in backup set 3

   36:   File LV Type Ckp SCN    Ckp Time  Name

   37:   ---- -- ---- ---------- --------- ----

   38:   1       Full 4771408    21-JUN-11 /oradata/jct/jct/system01.dbf

   39:   2       Full 4771408    21-JUN-11 /oradata/jct/jct/undotbs01.dbf

   40:   3       Full 4771408    21-JUN-11 /oradata/jct/jct/sysaux01.dbf

   41:   4       Full 4771408    21-JUN-11 /oradata/jct/jct/users01.dbf

   42:   5       Full 4771408    21-JUN-11 /oradata/jct/jct/DINFO.dbf

   43:  

   44: BS Key  Type LV Size       Device Type Elapsed Time Completion Time

   45: ------- ---- -- ---------- ----------- ------------ ---------------

   46: 4       Full    5.39M      DISK        00:00:00     21-JUN-11      

   47:         BP Key: 4   Status: AVAILABLE  Compressed: NO  Tag: TAG20110621T203312

   48:         Piece Name: /oracle/flash_recovery_area/JCT/backupset/2011_06_21/o1_mf_ncsnf_TAG20110621T203312_7013wrk8_.bkp

   49:   Control File Included: Ckp SCN: 4771421      Ckp time: 21-JUN-11

   50:   SPFILE Included: Modification time: 09-MAY-11

   51:  

   52: BS Key  Type LV Size       Device Type Elapsed Time Completion Time

   53: ------- ---- -- ---------- ----------- ------------ ---------------

   54: 5       Full    711.02M    DISK        00:00:14     21-JUN-11      

   55:         BP Key: 5   Status: AVAILABLE  Compressed: NO  Tag: TAG20110621T203512

   56:         Piece Name: /oracle/flash_recovery_area/JCT/backupset/2011_06_21/o1_mf_nnndf_TAG20110621T203512_701400pd_.bkp

   57:   List of Datafiles in backup set 5

   58:   File LV Type Ckp SCN    Ckp Time  Name

   59:   ---- -- ---- ---------- --------- ----

   60:   1       Full 4771470    21-JUN-11 /oradata/jct/jct/system01.dbf

   61:   2       Full 4771470    21-JUN-11 /oradata/jct/jct/undotbs01.dbf

   62:   3       Full 4771470    21-JUN-11 /oradata/jct/jct/sysaux01.dbf

   63:   4       Full 4771470    21-JUN-11 /oradata/jct/jct/users01.dbf

   64:   5       Full 4771470    21-JUN-11 /oradata/jct/jct/DINFO.dbf

   65:  

   66: BS Key  Type LV Size       Device Type Elapsed Time Completion Time

   67: ------- ---- -- ---------- ----------- ------------ ---------------

   68: 6       Full    5.39M      DISK        00:00:02     21-JUN-11      

   69:         BP Key: 6   Status: AVAILABLE  Compressed: NO  Tag: TAG20110621T203512

   70:         Piece Name: /oracle/flash_recovery_area/JCT/backupset/2011_06_21/o1_mf_ncsnf_TAG20110621T203512_70140msj_.bkp

   71:   Control File Included: Ckp SCN: 4771511      Ckp time: 21-JUN-11

   72:   SPFILE Included: Modification time: 09-MAY-11

   73:  

   74: BS Key  Type LV Size       Device Type Elapsed Time Completion Time

   75: ------- ---- -- ---------- ----------- ------------ ---------------

   76: 7       Incr 1  731.46M    DISK        00:00:35     21-JUN-11      

   77:         BP Key: 7   Status: AVAILABLE  Compressed: NO  Tag: TAG20110621T203939

   78:         Piece Name: /oracle/flash_recovery_area/JCT/backupset/2011_06_21/o1_mf_nnnd1_TAG20110621T203939_70148ddp_.bkp

   79:   List of Datafiles in backup set 7

   80:   File LV Type Ckp SCN    Ckp Time  Name

   81:   ---- -- ---- ---------- --------- ----

   82:   1    1  Incr 4771627    21-JUN-11 /oradata/jct/jct/system01.dbf

   83:   2    1  Incr 4771627    21-JUN-11 /oradata/jct/jct/undotbs01.dbf

   84:   3    1  Incr 4771627    21-JUN-11 /oradata/jct/jct/sysaux01.dbf

   85:   4    1  Incr 4771627    21-JUN-11 /oradata/jct/jct/users01.dbf

   86:   5    1  Incr 4771627    21-JUN-11 /oradata/jct/jct/DINFO.dbf

   87:  

   88: BS Key  Type LV Size       Device Type Elapsed Time Completion Time

   89: ------- ---- -- ---------- ----------- ------------ ---------------

   90: 8       Incr 1  5.39M      DISK        00:00:01     21-JUN-11      

   91:         BP Key: 8   Status: AVAILABLE  Compressed: NO  Tag: TAG20110621T203939

   92:         Piece Name: /oracle/flash_recovery_area/JCT/backupset/2011_06_21/o1_mf_ncsn1_TAG20110621T203939_70149voy_.bkp

   93:   Control File Included: Ckp SCN: 4771645      Ckp time: 21-JUN-11

   94:   SPFILE Included: Modification time: 09-MAY-11

多吃东西多喝水，

少玩游戏少睡觉！ -------

望月飞鱼(珏石头)

©著作权归作者所有：来自51CTO博客作者珏石头的原创作品，谢绝转载，否则将追究法律责任

oracle职场休闲DateBase