RMAN维护命令report命令

1.报告过去3天内没有备份的表空间

RMAN> report need backup days=3;

Report of files whose recovery needs more than 3 days of archived logs

File Days  Name

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

2.报告数据库模式

RMAN> report schema;

Report of database schema

List of Permanent Datafiles

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

File Size(MB) Tablespace           RB segs Datafile Name

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

1    870      SYSTEM               ***     /dat/DBData/oradata/NACEC/system01.dbf

2    360      UNDOTBS1             ***     /dat/DBData/oradata/NACEC/undotbs01.dbf

3    280      SYSAUX               ***     /dat/DBData/oradata/NACEC/sysaux01.dbf

4    5        USERS                ***     /dat/DBData/oradata/NACEC/users01.dbf

5    40       TEST_UNDO            ***     /dat/DBData/oradata/NACEC/test_undo.dbf

6    100      TEMPUNDOTBS          ***     /dat/DBData/oradata/NACEC/tempundotbs.dbf

7    20       TEST                 ***     /dat/DBData/oradata/NACEC/test.dbf

8    20       TEST1                ***     /dat/DBData/oradata/NACEC/test1.dbf

List of Temporary Files

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

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

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

1    20       TEMP                 20          /dat/DBData/oradata/NACEC/temp02.dbf

3.报告丢弃的备份

RMAN> report obsolete;

RMAN retention policy will be applied to the command

RMAN retention policy is set to redundancy 1

Report of obsolete backups and copies

Type                 Key    Completion Time    Filename/Handle

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

Backup Set           1      17-MAR-14        

  Backup Piece       1      17-MAR-14          /bak/rman/backup_01p3d0c2_1_1

Backup Set           2      17-MAR-14        

  Backup Piece       2      17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-00

Backup Set           3      17-MAR-14        

  Backup Piece       3      17-MAR-14          /bak/ecoalchina_03p3d0ut_1_1

Backup Set           4      17-MAR-14        

  Backup Piece       4      17-MAR-14          /bak/ecoalchina_04p3d128_1_1

Backup Set           5      17-MAR-14        

  Backup Piece       5      17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-01

Backup Set           6      17-MAR-14        

  Backup Piece       6      17-MAR-14          /bak/rman/backup_06p3d15m_1_1

Backup Set           7      17-MAR-14        

  Backup Piece       7      17-MAR-14          /bak/rman/backup_07p3d15v_1_1

Backup Set           8      17-MAR-14        

  Backup Piece       8      17-MAR-14          /bak/rman/backup_08p3d161_1_1

Backup Set           9      17-MAR-14        

  Backup Piece       9      17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-02

Backup Set           10     17-MAR-14        

  Backup Piece       10     17-MAR-14          /bak/rman/backup_0ap3d1gv_1_1

Backup Set           11     17-MAR-14        

  Backup Piece       11     17-MAR-14          /bak/rman/backup_0bp3d1h7_1_1

Backup Set           12     17-MAR-14        

  Backup Piece       12     17-MAR-14          /bak/rman/backup_0cp3d1h8_1_1

Backup Set           13     17-MAR-14        

  Backup Piece       13     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-03

Backup Set           14     17-MAR-14        

  Backup Piece       14     17-MAR-14          /bak/rman/backup_0ep3d1p7_1_1

Backup Set           15     17-MAR-14        

  Backup Piece       15     17-MAR-14          /bak/rman/backup_0fp3d1pb_1_1

Backup Set           16     17-MAR-14        

  Backup Piece       16     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-04

Backup Set           17     17-MAR-14        

  Backup Piece       17     17-MAR-14          /bak/rman/backup_0hp3d1t0_1_1

Backup Set           18     17-MAR-14        

  Backup Piece       18     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-05

Backup Set           19     17-MAR-14        

  Backup Piece       19     17-MAR-14          /bak/rman/backup_0jp3d2kb_1_1

Backup Set           20     17-MAR-14        

  Backup Piece       20     17-MAR-14          /bak/rman/backup_0kp3d2kg_1_1

Backup Set           21     17-MAR-14        

  Backup Piece       21     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-06

Archive Log          12     17-MAR-14          /dat/DBSoftware/oracle/flash_recovery_area/NACEC/archivelog/2014_03_10/o1_mf_1_71_9kvbkxjg_.arc

Backup Set           22     17-MAR-14        

  Backup Piece       22     17-MAR-14          /bak/rman/backup_0np3d48r_1_1

Backup Set           23     17-MAR-14        

  Backup Piece       23     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-08

Backup Set           24     17-MAR-14        

  Backup Piece       24     17-MAR-14          /bak/rman/backup_0rp3d5dq_1_1

Backup Set           25     17-MAR-14        

  Backup Piece       25     17-MAR-14          /bak/rman/backup_0sp3d5k6_1_1

Backup Set           26     17-MAR-14        

  Backup Piece       26     17-MAR-14          /bak/rman/backup_0tp3d5km_1_1

Backup Set           27     17-MAR-14        

  Backup Piece       27     17-MAR-14          /bak/rman/backup_0up3d5ko_1_1

Backup Set           30     17-MAR-14        

  Backup Piece       30     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-09

Backup Set           31     17-MAR-14        

  Backup Piece       31     17-MAR-14          /bak/contf/ecoalchina_c-364029283-20140317-0a

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

转载于:http://blog.itpub.net/31448824/viewspace-2137527/