Check all datafile details with RMAN in oracle
Report schema list all the datafiles present in the database. It is command need to check the detail of the datafiles from control files.
RMAN> REPORT SCHEMA;
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 450 SYSTEM *** /oracle/oradata/tbs_01.f
2 50 SYSAUX *** /oracle/oradata/tbs_ax1.f
3 2 SYSTEM *** /oracle/oradata/tbs_02.f
4 2 TBS_1 *** /oracle/oradata/tbs_11.f
Advertisements