Database Reference
In-Depth Information
delete the backup set pieces when space was needed or when you ran the
DELETE OBSOLETE
command. If you were not using the FRA, you would need to run the
DELETE OBSOLETE
com-
mand to remove those pieces.
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 424 11-OCT-13
Backup Piece 432 11-OCT-13
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\
2013_10_11\O1_MF_ANNNN_TAG20131011T142547_4H22YY00_.BKP
Backup Set 426 11-OCT-13
Backup Piece 434 11-OCT-13
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\BACKUPSET\
2013_10_11\O1_MF_NCSNF_TAG20131011T142622_4H23CVNJ_.BKP
Backup Set 429 11-OCT-13
Backup Piece 437 11-OCT-13
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\
2013_10_11\O1_MF_S_667838162_4H23KXWB_.BKP
Backup Set 430 12-OCT-13
Backup Piece 438 12-OCT-13
C:\ORACLE\FAST_RECOVERY_AREA\ORCL\AUTOBACKUP\
2013_10_12\O1_MF_S_667915771_4H4HCM7L_.BKP
Example of the
REPORT SCHEMA
Command
The
REPORT SCHEMA
command provides information on the tablespaces and related data files
(and tempfiles) in the database. Displayed by the
REPORT SCHEMA
command are the data file ID,
the size of the data file, and the tablespace that the data file is associated with. An example of
the use of the
REPORT SCHEMA
command is shown here:
RMAN> report schema;
using target database control file instead of recovery catalog
Report of database schema for database with db_unique_name ORCL
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- ----------------- ------- ------------------------
1 680 SYSTEM *** C:\ORACLE\ORADATA\ORCL\SYSTEM01.DBF
2 612 SYSAUX *** C:\ORACLE\ORADATA\ORCL\SYSAUX01.DBF
Search WWH ::
Custom Search