Databases Reference
In-Depth Information
When using the
report obsolete
command, it's always a good idea to run the
crosscheck database
command
beforehand to ensure that RMAN has the latest information about the status of different types of backups.
When using the
report obsolete
command, you can also specify the redundancy and recover window options,
as shown here:
RMAN> report obsolete recovery window of 5 days;
RMAN> report obsolete redundancy 2;
RMAN> report obsolete recovery window of 5 days device type disk;
Note that the last command in the preceding code examples specifies that only disk backups be considered in
determining whether there are any obsolete backups. If you don't specify the device type, RMAN takes into account
both disk and sbt backups in determining whether a backup is obsolete according to the configured policy.
Displaying Information About Database Files
Problem
You want to display information about all the data files in the target database.
Solution
You can get a report about all the data files in a database by using the
report schema
command, as shown in the
following example. The
report schema
command in the following example reports on all data files:
RMAN> report schema;
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 800 SYSTEM *** /u01/app/oracle/oradata/orcl/system01.dbf
2 341 EXAMPLE *** /u01/app/oracle/oradata/orcl/example01.dbf
3 680 SYSAUX *** /u01/app/oracle/oradata/orcl/sysaux01.dbf
4 50 UNDOTBS1 *** /u01/app/oracle/oradata/orcl/undotbs01.dbf
5 500 CATTBS *** /u01/app/oracle/oradata/orcl/cattbs_01.dbf
6 6 USERS *** /u01/app/oracle/oradata/orcl/users01.dbf
7 100 VIRT_CATALOG *** /u01/app/oracle/oradata/orcl/virt_catalog_01.dbf
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 105 TEMP 32767 /u01/app/oracle/oradata/orcl/temp01.dbf
RMAN>
The
report schema
command is helpful in finding out the names of all the data files of the target database.
