rman中report命令-创新互联

repo

创新互联主营可克达拉网站建设的网络公司,主营网站建设方案,APP应用开发,可克达拉h5微信小程序搭建,可克达拉网站营销推广欢迎可克达拉等地区企业咨询rt需要备份的文件
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

名称栏目：rman中report命令-创新互联
本文来源：https://www.cdcxhl.com/article20/cddcco.html

成都网站建设公司_创新互联，为您提供网站导航、企业建站、响应式网站、外贸网站建设、网站策划、网站维护

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联