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博客 ” ，链接：https://blog.itpub.net/31448824/viewspace-2137527/ ，如需转载，请注明出处，否则将追究法律责任。
