RMAN维护命令list

最新推荐文章于 2024-09-15 19:32:11 发布

cuanlielian4510

最新推荐文章于 2024-09-15 19:32:11 发布

阅读量70

点赞数

文章标签：数据库

1，列出可用的备份

RMAN> list backup summary;

List of Backups

===============

Key TY LV S Device Type Completion Time #Pieces #Copies Compressed Tag

------- -- -- - ----------- --------------- ------- ------- ---------- ---

1 B F X DISK 17-MAR-14 1 1 YES TAG20140317T090818

2 B F A DISK 17-MAR-14 1 1 NO TAG20140317T091054

3 B F X DISK 17-MAR-14 1 1 YES TAG20140317T091821

4 B F X DISK 17-MAR-14 1 1 NO TAG20140317T092008

5 B F A DISK 17-MAR-14 1 1 NO TAG20140317T092010

6 B A X DISK 17-MAR-14 1 1 NO TAG20140317T092158

7 B A X DISK 17-MAR-14 1 1 NO TAG20140317T092158

8 B F X DISK 17-MAR-14 1 1 NO TAG20140317T092209

9 B F A DISK 17-MAR-14 1 1 NO TAG20140317T092326

10 B A X DISK 17-MAR-14 1 1 NO TABLESPACE BACKUP

11 B F X DISK 17-MAR-14 1 1 NO TAG20140317T092807

12 B F X DISK 17-MAR-14 1 1 NO TAG20140317T092807

13 B F A DISK 17-MAR-14 1 1 NO TAG20140317T092810

14 B A X DISK 17-MAR-14 1 1 NO TAG20140317T093223

15 B F X DISK 17-MAR-14 1 1 NO TAG20140317T093227

16 B F A DISK 17-MAR-14 1 1 NO TAG20140317T093229

17 B A X DISK 17-MAR-14 1 1 NO TAG20140317T093424

18 B F A DISK 17-MAR-14 1 1 NO TAG20140317T093429

19 B A X DISK 17-MAR-14 1 1 NO TAG20140317T094650

20 B 0 X DISK 17-MAR-14 1 1 NO TAG20140317T094656

21 B F A DISK 17-MAR-14 1 1 NO TAG20140317T094833

22 B F A DISK 17-MAR-14 1 1 NO TAG20140317T101451

23 B F A DISK 17-MAR-14 1 1 NO TAG20140317T102931

24 B A A DISK 17-MAR-14 1 1 NO TAG20140317T103433

25 B A A DISK 17-MAR-14 1 1 NO TAG20140317T103433

26 B A A DISK 17-MAR-14 1 1 NO TAG20140317T103433

27 B A A DISK 17-MAR-14 1 1 NO TAG20140317T103433

28 B F A DISK 17-MAR-14 1 1 NO TAG20140317T103819

29 B A A DISK 17-MAR-14 1 1 NO TAG20140317T104025

30 B F A DISK 17-MAR-14 1 1 NO TAG20140317T104028

31 B F A DISK 17-MAR-14 1 1 NO TAG20140317T105228

32 B F A DISK 17-MAR-14 1 1 NO TAG20140317T105436

2.按照备份类型列出备份

RMAN> list backup by file;

List of Datafile Backups

========================

File Key TY LV S Ckp SCN Ckp Time #Pieces #Copies Compressed Tag

---- ------- - -- - ---------- --------- ------- ------- ---------- ---

1 28 B F A 1308752 17-MAR-14 1 1 NO TAG20140317T103819

22 B F A 1308332 17-MAR-14 1 1 NO TAG20140317T101451

20 B 0 X 1308332 17-MAR-14 1 1 NO TAG20140317T094656

8 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092209

3 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T091821

1 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T090818

2 28 B F A 1308752 17-MAR-14 1 1 NO TAG20140317T103819

22 B F A 1308332 17-MAR-14 1 1 NO TAG20140317T101451

20 B 0 X 1308332 17-MAR-14 1 1 NO TAG20140317T094656

8 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092209

3 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T091821

1 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T090818

3 28 B F A 1308752 17-MAR-14 1 1 NO TAG20140317T103819

22 B F A 1308332 17-MAR-14 1 1 NO TAG20140317T101451

20 B 0 X 1308332 17-MAR-14 1 1 NO TAG20140317T094656

8 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092209

3 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T091821

1 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T090818

4 28 B F A 1308752 17-MAR-14 1 1 NO TAG20140317T103819

22 B F A 1308332 17-MAR-14 1 1 NO TAG20140317T101451

20 B 0 X 1308332 17-MAR-14 1 1 NO TAG20140317T094656

15 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T093227

11 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092807

8 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092209

3 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T091821

1 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T090818

5 28 B F A 1308752 17-MAR-14 1 1 NO TAG20140317T103819

22 B F A 1308332 17-MAR-14 1 1 NO TAG20140317T101451

20 B 0 X 1308332 17-MAR-14 1 1 NO TAG20140317T094656

8 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092209

3 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T091821

1 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T090818

6 28 B F A 1308752 17-MAR-14 1 1 NO TAG20140317T103819

22 B F A 1308332 17-MAR-14 1 1 NO TAG20140317T101451

20 B 0 X 1308332 17-MAR-14 1 1 NO TAG20140317T094656

8 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092209

3 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T091821

1 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T090818

7 28 B F A 1308752 17-MAR-14 1 1 NO TAG20140317T103819

22 B F A 1308332 17-MAR-14 1 1 NO TAG20140317T101451

20 B 0 X 1308332 17-MAR-14 1 1 NO TAG20140317T094656

8 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092209

3 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T091821

1 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T090818

8 28 B F A 1308752 17-MAR-14 1 1 NO TAG20140317T103819

22 B F A 1308332 17-MAR-14 1 1 NO TAG20140317T101451

20 B 0 X 1308332 17-MAR-14 1 1 NO TAG20140317T094656

8 B F X 1308332 17-MAR-14 1 1 NO TAG20140317T092209

3 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T091821

1 B F X 1308332 17-MAR-14 1 1 YES TAG20140317T090818

List of Archived Log Backups

============================

Thrd Seq Low SCN Low Time BS Key S #Pieces #Copies Compressed Tag

---- ------- ---------- --------- ------- - ------- ------- ---------- ---

1 3 478663 16-MAY-13 24 A 1 1 NO TAG20140317T103433

1 4 514841 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 5 539764 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 6 546653 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 7 561454 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 8 581967 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 9 592428 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 10 602660 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 11 612940 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 12 623407 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 13 628488 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 14 634580 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 15 637930 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 17 655892 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 18 667328 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 19 676163 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 20 683015 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 21 689434 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 23 714381 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 24 721489 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 25 734092 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 26 747324 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 27 754255 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 28 757564 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 29 766951 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 30 773213 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 32 783402 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 33 820116 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 34 843996 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 35 860399 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 36 885037 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 37 895148 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 38 908264 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 39 915177 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 40 929461 17-MAY-13 24 A 1 1 NO TAG20140317T103433

1 64 1071179 04-MAR-14 24 A 1 1 NO TAG20140317T103433

1 65 1100639 04-MAR-14 24 A 1 1 NO TAG20140317T103433

1 66 1137294 06-MAR-14 24 A 1 1 NO TAG20140317T103433

1 67 1145351 06-MAR-14 24 A 1 1 NO TAG20140317T103433

1 71 1194914 09-MAR-14 24 A 1 1 NO TAG20140317T103433

1 1 1200636 11-MAR-14 27 A 1 1 NO TAG20140317T103433

1 1 1221613 11-MAR-14 7 X 1 1 NO TAG20140317T092158

1 1 1227665 11-MAR-14 25 A 1 1 NO TAG20140317T103433

19 X 1 1 NO TAG20140317T094650

17 X 1 1 NO TAG20140317T093424

14 X 1 1 NO TAG20140317T093223

10 X 1 1 NO TABLESPACE BACKUP

6 X 1 1 NO TAG20140317T092158

1 2 1258770 14-MAR-14 25 A 1 1 NO TAG20140317T103433

19 X 1 1 NO TAG20140317T094650

17 X 1 1 NO TAG20140317T093424

14 X 1 1 NO TAG20140317T093223

10 X 1 1 NO TABLESPACE BACKUP

6 X 1 1 NO TAG20140317T092158

1 3 1281272 15-MAR-14 25 A 1 1 NO TAG20140317T103433

1 1 1308334 17-MAR-14 26 A 1 1 NO TAG20140317T103433

1 2 1308652 17-MAR-14 29 A 1 1 NO TAG20140317T104025

List of Control File Backups

============================

CF Ckp SCN Ckp Time BS Key S #Pieces #Copies Compressed Tag

---------- --------- ------- - ------- ------- ---------- ---

1309990 17-MAR-14 32 A 1 1 NO TAG20140317T105436

1309882 17-MAR-14 31 A 1 1 NO TAG20140317T105228

1308854 17-MAR-14 30 A 1 1 NO TAG20140317T104028

1308448 17-MAR-14 23 A 1 1 NO TAG20140317T102931

1308332 17-MAR-14 21 A 1 1 NO TAG20140317T094833

1308332 17-MAR-14 18 A 1 1 NO TAG20140317T093429

1308332 17-MAR-14 16 A 1 1 NO TAG20140317T093229

1308332 17-MAR-14 13 A 1 1 NO TAG20140317T092810

1308332 17-MAR-14 12 X 1 1 NO TAG20140317T092807

1308332 17-MAR-14 9 A 1 1 NO TAG20140317T092326

1308332 17-MAR-14 5 A 1 1 NO TAG20140317T092010

1308332 17-MAR-14 4 X 1 1 NO TAG20140317T092008

1308332 17-MAR-14 2 A 1 1 NO TAG20140317T091054

List of SPFILE Backups

======================

Modification Time BS Key S #Pieces #Copies Compressed Tag

----------------- ------- - ------- ------- ---------- ---

17-MAR-14 32 A 1 1 NO TAG20140317T105436

17-MAR-14 31 A 1 1 NO TAG20140317T105228

17-MAR-14 30 A 1 1 NO TAG20140317T104028

17-MAR-14 23 A 1 1 NO TAG20140317T102931

17-MAR-14 21 A 1 1 NO TAG20140317T094833

17-MAR-14 18 A 1 1 NO TAG20140317T093429

17-MAR-14 16 A 1 1 NO TAG20140317T093229

17-MAR-14 13 A 1 1 NO TAG20140317T092810

17-MAR-14 9 A 1 1 NO TAG20140317T092326

17-MAR-14 5 A 1 1 NO TAG20140317T092010

17-MAR-14 2 A 1 1 NO TAG20140317T091054

3.列出其他备份信息：

RMAN> list backup;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

1 Full 223.61M DISK 00:02:36 17-MAR-14

BP Key: 1 Status: EXPIRED Compressed: YES Tag: TAG20140317T090818

Piece Name: /bak/rman/backup_01p3d0c2_1_1

List of Datafiles in backup set 1

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/system01.dbf

2 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/undotbs01.dbf

3 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/sysaux01.dbf

4 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

5 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test_undo.dbf

6 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/tempundotbs.dbf

7 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test.dbf

8 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test1.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

2 Full 7.11M DISK 00:00:02 17-MAR-14

BP Key: 2 Status: AVAILABLE Compressed: NO Tag: TAG20140317T091054

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-00

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

3 Full 223.61M DISK 00:01:41 17-MAR-14

BP Key: 3 Status: EXPIRED Compressed: YES Tag: TAG20140317T091821

Piece Name: /bak/ecoalchina_03p3d0ut_1_1

List of Datafiles in backup set 3

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/system01.dbf

2 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/undotbs01.dbf

3 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/sysaux01.dbf

4 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

5 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test_undo.dbf

6 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/tempundotbs.dbf

7 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test.dbf

8 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test1.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

4 Full 7.08M DISK 00:00:01 17-MAR-14

BP Key: 4 Status: EXPIRED Compressed: NO Tag: TAG20140317T092008

Piece Name: /bak/ecoalchina_04p3d128_1_1

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

5 Full 7.11M DISK 00:00:01 17-MAR-14

BP Key: 5 Status: AVAILABLE Compressed: NO Tag: TAG20140317T092010

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-01

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

6 98.09M DISK 00:00:05 17-MAR-14

BP Key: 6 Status: EXPIRED Compressed: NO Tag: TAG20140317T092158

Piece Name: /bak/rman/backup_06p3d15m_1_1

List of Archived Logs in backup set 6

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1227665 11-MAR-14 1258770 14-MAR-14

1 2 1258770 14-MAR-14 1281272 15-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

7 9.80M DISK 00:00:01 17-MAR-14

BP Key: 7 Status: EXPIRED Compressed: NO Tag: TAG20140317T092158

Piece Name: /bak/rman/backup_07p3d15v_1_1

List of Archived Logs in backup set 7

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1221613 11-MAR-14 1228173 11-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

8 Full 1.16G DISK 00:01:15 17-MAR-14

BP Key: 8 Status: EXPIRED Compressed: NO Tag: TAG20140317T092209

Piece Name: /bak/rman/backup_08p3d161_1_1

List of Datafiles in backup set 8

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/system01.dbf

2 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/undotbs01.dbf

3 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/sysaux01.dbf

4 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

5 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test_undo.dbf

6 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/tempundotbs.dbf

7 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test.dbf

8 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test1.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

9 Full 7.11M DISK 00:00:01 17-MAR-14

BP Key: 9 Status: AVAILABLE Compressed: NO Tag: TAG20140317T092326

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-02

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

10 98.09M DISK 00:00:05 17-MAR-14

BP Key: 10 Status: EXPIRED Compressed: NO Tag: TABLESPACE BACKUP

Piece Name: /bak/rman/backup_0ap3d1gv_1_1

List of Archived Logs in backup set 10

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1227665 11-MAR-14 1258770 14-MAR-14

1 2 1258770 14-MAR-14 1281272 15-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

11 Full 376.00K DISK 00:00:00 17-MAR-14

BP Key: 11 Status: EXPIRED Compressed: NO Tag: TAG20140317T092807

Piece Name: /bak/rman/backup_0bp3d1h7_1_1

List of Datafiles in backup set 11

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

4 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

12 Full 7.08M DISK 00:00:01 17-MAR-14

BP Key: 12 Status: EXPIRED Compressed: NO Tag: TAG20140317T092807

Piece Name: /bak/rman/backup_0cp3d1h8_1_1

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

13 Full 7.11M DISK 00:00:00 17-MAR-14

BP Key: 13 Status: AVAILABLE Compressed: NO Tag: TAG20140317T092810

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-03

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

14 98.09M DISK 00:00:03 17-MAR-14

BP Key: 14 Status: EXPIRED Compressed: NO Tag: TAG20140317T093223

Piece Name: /bak/rman/backup_0ep3d1p7_1_1

List of Archived Logs in backup set 14

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1227665 11-MAR-14 1258770 14-MAR-14

1 2 1258770 14-MAR-14 1281272 15-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

15 Full 376.00K DISK 00:00:00 17-MAR-14

BP Key: 15 Status: EXPIRED Compressed: NO Tag: TAG20140317T093227

Piece Name: /bak/rman/backup_0fp3d1pb_1_1

List of Datafiles in backup set 15

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

4 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

16 Full 7.11M DISK 00:00:00 17-MAR-14

BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20140317T093229

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-04

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

17 98.09M DISK 00:00:03 17-MAR-14

BP Key: 17 Status: EXPIRED Compressed: NO Tag: TAG20140317T093424

Piece Name: /bak/rman/backup_0hp3d1t0_1_1

List of Archived Logs in backup set 17

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1227665 11-MAR-14 1258770 14-MAR-14

1 2 1258770 14-MAR-14 1281272 15-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

18 Full 7.11M DISK 00:00:00 17-MAR-14

BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20140317T093429

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-05

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

19 98.09M DISK 00:00:03 17-MAR-14

BP Key: 19 Status: EXPIRED Compressed: NO Tag: TAG20140317T094650

Piece Name: /bak/rman/backup_0jp3d2kb_1_1

List of Archived Logs in backup set 19

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1227665 11-MAR-14 1258770 14-MAR-14

1 2 1258770 14-MAR-14 1281272 15-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

20 Incr 0 1.16G DISK 00:01:30 17-MAR-14

BP Key: 20 Status: EXPIRED Compressed: NO Tag: TAG20140317T094656

Piece Name: /bak/rman/backup_0kp3d2kg_1_1

List of Datafiles in backup set 20

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 0 Incr 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/system01.dbf

2 0 Incr 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/undotbs01.dbf

3 0 Incr 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/sysaux01.dbf

4 0 Incr 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

5 0 Incr 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test_undo.dbf

6 0 Incr 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/tempundotbs.dbf

7 0 Incr 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test.dbf

8 0 Incr 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test1.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

21 Full 7.11M DISK 00:00:02 17-MAR-14

BP Key: 21 Status: AVAILABLE Compressed: NO Tag: TAG20140317T094833

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-06

Control File Included: Ckp SCN: 1308332 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

22 Full 1.16G DISK 00:02:15 17-MAR-14

BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20140317T101451

Piece Name: /bak/rman/backup_0np3d48r_1_1

List of Datafiles in backup set 22

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/system01.dbf

2 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/undotbs01.dbf

3 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/sysaux01.dbf

4 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

5 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test_undo.dbf

6 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/tempundotbs.dbf

7 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test.dbf

8 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test1.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

23 Full 7.11M DISK 00:00:00 17-MAR-14

BP Key: 23 Status: AVAILABLE Compressed: NO Tag: TAG20140317T102931

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-08

Control File Included: Ckp SCN: 1308448 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

24 1.81G DISK 00:03:10 17-MAR-14

BP Key: 24 Status: AVAILABLE Compressed: NO Tag: TAG20140317T103433

Piece Name: /bak/rman/backup_0rp3d5dq_1_1

List of Archived Logs in backup set 24

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 3 478663 16-MAY-13 514841 17-MAY-13

1 4 514841 17-MAY-13 539764 17-MAY-13

1 5 539764 17-MAY-13 546653 17-MAY-13

1 6 546653 17-MAY-13 561454 17-MAY-13

1 7 561454 17-MAY-13 581967 17-MAY-13

1 8 581967 17-MAY-13 592428 17-MAY-13

1 9 592428 17-MAY-13 602660 17-MAY-13

1 10 602660 17-MAY-13 612940 17-MAY-13

1 11 612940 17-MAY-13 623407 17-MAY-13

1 12 623407 17-MAY-13 628488 17-MAY-13

1 13 628488 17-MAY-13 634580 17-MAY-13

1 14 634580 17-MAY-13 637930 17-MAY-13

1 15 637930 17-MAY-13 639055 17-MAY-13

1 17 655892 17-MAY-13 667328 17-MAY-13

1 18 667328 17-MAY-13 676163 17-MAY-13

1 19 676163 17-MAY-13 683015 17-MAY-13

1 20 683015 17-MAY-13 689434 17-MAY-13

1 21 689434 17-MAY-13 704984 17-MAY-13

1 23 714381 17-MAY-13 721489 17-MAY-13

1 24 721489 17-MAY-13 734092 17-MAY-13

1 25 734092 17-MAY-13 747324 17-MAY-13

1 26 747324 17-MAY-13 754255 17-MAY-13

1 27 754255 17-MAY-13 757564 17-MAY-13

1 28 757564 17-MAY-13 766951 17-MAY-13

1 29 766951 17-MAY-13 773213 17-MAY-13

1 30 773213 17-MAY-13 773922 17-MAY-13

1 32 783402 17-MAY-13 820116 17-MAY-13

1 33 820116 17-MAY-13 843996 17-MAY-13

1 34 843996 17-MAY-13 860399 17-MAY-13

1 35 860399 17-MAY-13 885037 17-MAY-13

1 36 885037 17-MAY-13 895148 17-MAY-13

1 37 895148 17-MAY-13 908264 17-MAY-13

1 38 908264 17-MAY-13 915177 17-MAY-13

1 39 915177 17-MAY-13 929461 17-MAY-13

1 40 929461 17-MAY-13 950893 17-MAY-13

1 64 1071179 04-MAR-14 1100639 04-MAR-14

1 65 1100639 04-MAR-14 1137294 06-MAR-14

1 66 1137294 06-MAR-14 1145351 06-MAR-14

1 67 1145351 06-MAR-14 1145510 06-MAR-14

1 71 1194914 09-MAR-14 1204771 10-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

25 128.32M DISK 00:00:08 17-MAR-14

BP Key: 25 Status: AVAILABLE Compressed: NO Tag: TAG20140317T103433

Piece Name: /bak/rman/backup_0sp3d5k6_1_1

List of Archived Logs in backup set 25

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1227665 11-MAR-14 1258770 14-MAR-14

1 2 1258770 14-MAR-14 1281272 15-MAR-14

1 3 1281272 15-MAR-14 1308334 17-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

26 181.50K DISK 00:00:01 17-MAR-14

BP Key: 26 Status: AVAILABLE Compressed: NO Tag: TAG20140317T103433

Piece Name: /bak/rman/backup_0tp3d5km_1_1

List of Archived Logs in backup set 26

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1308334 17-MAR-14 1308652 17-MAR-14

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

27 2.50K DISK 00:00:01 17-MAR-14

BP Key: 27 Status: AVAILABLE Compressed: NO Tag: TAG20140317T103433

Piece Name: /bak/rman/backup_0up3d5ko_1_1

List of Archived Logs in backup set 27

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 1 1200636 11-MAR-14 1220640 11-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

28 Full 1.16G DISK 00:02:03 17-MAR-14

BP Key: 28 Status: AVAILABLE Compressed: NO Tag: TAG20140317T103819

Piece Name: /bak/rman/backup_0vp3d5kr_1_1

List of Datafiles in backup set 28

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/system01.dbf

2 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/undotbs01.dbf

3 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/sysaux01.dbf

4 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

5 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/test_undo.dbf

6 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/tempundotbs.dbf

7 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/test.dbf

8 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/test1.dbf

BS Key Size Device Type Elapsed Time Completion Time

------- ---------- ----------- ------------ ---------------

29 87.00K DISK 00:00:01 17-MAR-14

BP Key: 29 Status: AVAILABLE Compressed: NO Tag: TAG20140317T104025

Piece Name: /bak/rman/backup_10p3d5op_1_1

List of Archived Logs in backup set 29

Thrd Seq Low SCN Low Time Next SCN Next Time

---- ------- ---------- --------- ---------- ---------

1 2 1308652 17-MAR-14 1308826 17-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

30 Full 7.11M DISK 00:00:02 17-MAR-14

BP Key: 30 Status: AVAILABLE Compressed: NO Tag: TAG20140317T104028

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-09

Control File Included: Ckp SCN: 1308854 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

31 Full 7.11M DISK 00:00:04 17-MAR-14

BP Key: 31 Status: AVAILABLE Compressed: NO Tag: TAG20140317T105228

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-0a

Control File Included: Ckp SCN: 1309882 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

32 Full 7.11M DISK 00:00:00 17-MAR-14

BP Key: 32 Status: AVAILABLE Compressed: NO Tag: TAG20140317T105436

Piece Name: /bak/contf/ecoalchina_c-364029283-20140317-0b

Control File Included: Ckp SCN: 1309990 Ckp time: 17-MAR-14

SPFILE Included: Modification time: 17-MAR-14

4.列出适合恢复的备份

RMAN> list recoverable backup of database;

List of Backup Sets

===================

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

22 Full 1.16G DISK 00:02:15 17-MAR-14

BP Key: 22 Status: AVAILABLE Compressed: NO Tag: TAG20140317T101451

Piece Name: /bak/rman/backup_0np3d48r_1_1

List of Datafiles in backup set 22

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/system01.dbf

2 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/undotbs01.dbf

3 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/sysaux01.dbf

4 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

5 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test_undo.dbf

6 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/tempundotbs.dbf

7 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test.dbf

8 Full 1308332 17-MAR-14 /dat/DBData/oradata/NACEC/test1.dbf

BS Key Type LV Size Device Type Elapsed Time Completion Time

------- ---- -- ---------- ----------- ------------ ---------------

28 Full 1.16G DISK 00:02:03 17-MAR-14

BP Key: 28 Status: AVAILABLE Compressed: NO Tag: TAG20140317T103819

Piece Name: /bak/rman/backup_0vp3d5kr_1_1

List of Datafiles in backup set 28

File LV Type Ckp SCN Ckp Time Name

---- -- ---- ---------- --------- ----

1 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/system01.dbf

2 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/undotbs01.dbf

3 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/sysaux01.dbf

4 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/users01.dbf

5 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/test_undo.dbf

6 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/tempundotbs.dbf

7 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/test.dbf

8 Full 1308752 17-MAR-14 /dat/DBData/oradata/NACEC/test1.dbf

5.列出到期的备份----我已经从磁盘中删除的备份

RMAN> list expired backup;