Database Reference
In-Depth Information
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 60 TEMP 32767 +DATA/CDB1/TEMPFILE/temp.270.826623561
2 20 PDB$SEED:TEMP 32767 +DATA/CDB1/DD[...]403/DATAFILE/pdbseed_temp01.dbf
3 20 PDB1:TEMP 32767 +DATA/CDB1/DD7[...]F577/DATAFILE/pdb1_temp01.dbf
Oracle enhanced the report schema command by showing you information about the container for the data file.
In the figure above you can see data files from the root (CDB$ROOT), the seed database (PDB$SEED), and finally a
user-PDB (PDB1).
If you are unsure if all files of the database have been backed up and satisfy the retention policy, then you can
use the report need backup clause to view any file that needs backing up. Assume for example that a new data file
has been added to a database during a change window. Consequently, before the nightly backup has run, RMAN will
report the file as a candidate for backups:
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to recovery window of 7 days
Report of files that must be backed up to satisfy 7 days recovery window
File Days Name
---- ----- -----------------------------------------------------
21 0 +DATA/CDB1/E6C[...]436638A8C0DB6C/DATAFILE/pdb1_tbs4.299.826877399
Another useful report is the check for existing backups. If you want to know which backups of datafile 1 exist, you
can query the repository as shown in this example:
RMAN> list backup of datafile 1;
List of Backup Sets
===================
[some other output omitted]
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ----------------
105 Incr 0 665.39M DISK 00:00:11 23.09.2013 08:24
List of Datafiles in backup set 105
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- ---------------- ----
1 0 Incr 2210065 23.09.2013 08:24 +DATA/CDB1/DATAFILE/system.265.826666771
Backup Set Copy #1 of backup set 105
Device Type Elapsed Time Completion Time Compressed Tag
----------- ------------ ---------------- ---------- ---
DISK 00:00:11 23.09.2013 08:24 NO TAG20130923T082446
Search WWH ::
Custom Search