Oracle OCP 1Z0 053 Q351(Report Schema)

351.What information does the report schema command not provide? (Choose all that apply.)
A. Size of the datafiles
B. Size of the tempfiles
C. Date of last backup for datafiles and tempfiles
D. Filenames for each datafile
E. Checkpoint SCN associated with the last RMAN backup
Answer: CE

從輸出來看，report schema命令顯示了臨時檔案的大小, 資料檔案的大小，資料檔案的名稱

RMAN> report schema;


using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name CATDB


List of Permanent Datafiles
===========================
File Size(MB) Tablespace           RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1    760      SYSTEM               ***     /u01/app/oracle/oradata/catdb/system01.dbf
2    620      SYSAUX               ***     /u01/app/oracle/oradata/catdb/sysaux01.dbf
3    105      UNDOTBS1             ***     /u01/app/oracle/oradata/catdb/undotbs01.dbf
4    5        USERS                ***     /u01/app/oracle/oradata/catdb/users01.dbf
5    346      EXAMPLE              ***     /u01/app/oracle/oradata/catdb/example01.dbf
6    20       RMAN_TS              ***     /u01/app/oracle/oradata/catdb/rmants.dbf


List of Temporary Files
=======================
File Size(MB) Tablespace           Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1    29       TEMP                 32767       /u01/app/oracle/oradata/catdb/temp01.dbf


RMAN> 

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/8520577/viewspace-2074984/，如需轉載，請註明出處，否則將追究法律責任。