温馨提示×

温馨提示×

您好,登录后才能下订单哦!

密码登录×
登录注册×
其他方式登录
点击 登录注册 即表示同意《亿速云用户服务条款》

rman中report命令

发布时间:2020-08-10 19:32:55 来源:ITPUB博客 阅读:146 作者:banana_62 栏目:关系型数据库
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






向AI问一下细节

免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。

AI