一.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