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
C and E are correct:
https://docs.oracle.com/cd/B28359_01/backup.111/b28270/rcmreprt.htm
Reporting on the Database Schema
The REPORT SCHEMA command lists and displays information about the database files, tablespaces, and so on. See Oracle Database Backup and Recovery Reference for a description of the REPORT SCHEMA output.
If you do not specify FOR DB_UNIQUE_NAME with REPORT SCHEMA, then a recovery catalog connection is optional, but a target database connection is required. In a Data Guard environment, you can specify REPORT SCHEMA FOR DB_UNIQUE_NAME to report the schema for a database in the environment. In this case, an RMAN connection to a target database is not required. You can connect RMAN to the recovery catalog and set the DBID instead.
To report on the database schema:
Start RMAN and connect to the desired databases.
If you did not connect RMAN to a target database in the previous step, and you intend to specify the FOR DB_UNIQUE_NAME clause on REPORT SCHEMA, then set the database DBID. For example, enter the following command:
RMAN> SET DBID 28014364;
Run the REPORT SCHEMA command as shown in the following example:
RMAN> REPORT SCHEMA;
Report of database schema for database with db_unique_name DGRDBMS
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
—- ——– ——————– ——- ————————
1 450 SYSTEM YES /disk1/oracle/dbs/t_db1.f
2 141 SYSAUX NO /disk1/oracle/dbs/t_ax1.f
3 50 UD1 YES /disk1/oracle/dbs/t_undo1.f
4 50 TBS_11 NO /disk1/oracle/dbs/tbs_111.f
5 50 TBS_11 NO /disk1/oracle/dbs/tbs_112.f
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
—- ——– ——————– ———– ——————–
1 40 TEMP 32767 /disk1/oracle/dbs/t_tmp1.f
A, B and D are correct.
https://docs.oracle.com/cd/B28359_01/backup.111/b28273/rcmsynta035.htm#BGBDDECG
REPORT SCHEMA
SCHEMA clause
Lists the names of all datafiles (permanent and temporary) and tablespaces for the target database at the specified point in time. See Table 2-28 for description of output.
Table 2-28
File The absolute datafile number.
Size(MB) The size of the file in megabytes.
Tablespace The tablespace name.
RB segs For datafiles only. YES if rollback segments
exist in the tablespace and NO if they do not
(only if connected to the recovery catalog). If
RMAN is not connected to the catalog, then ***
is displayed.
Datafile Name For permanent datafiles only. The filename of
the datafile.
Maxsize(MB) For tempfiles only. The maximum size of the
tempfile.
Tempfile Name For tempfiles only. The filename of the
Tempfile.
C and E are correct.
The question is:
What does the “report schema” command NOT provide.