rman中report命令

千家信息网最后更新 2025年02月14日rman中report命令report需要备份的文件
RMAN> report need backup;


RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
---- ----- -----------------------------------------------------


redundancy为1表示有1个备份就足够


report不可恢复的文件
经过nologging操作的数据不可恢复
RMAN> report unrecoverable;


Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
---- ----------------------- -----------------


report obsolete的备份
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 2017-07-23 22:28:56
Backup Piece 1 2017-07-23 22:28:56 /u01/app/oracle/product/11.2/dbs/01sa3qgt_1_1
Datafile Copy 2 2017-07-23 23:50:01 /home/oracle/c1.bakset
Backup Set 2 2017-07-23 22:29:01
Backup Piece 2 2017-07-23 22:29:01 /u01/app/oracle/product/11.2/dbs/02sa3qhc_1_1
…
report schema
RMAN> report schema;


Report of database schema for database with db_unique_name TEST


List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 920 SYSTEM *** /u01/app/oracle/oradata/test/system01.dbf
2 640 SYSAUX *** /u01/app/oracle/oradata/test/sysaux01.dbf
3 90 UNDOTBS1 *** /u01/app/oracle/oradata/test/undotbs01.dbf
4 408 USERS *** /u01/app/oracle/oradata/test/users01.dbf


List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
2 500 TEMP 500 /u01/app/oracle/oradata/test/temp02.dbf