In the following example, we find
out what the datafiles looked like back on 8/30/07, and then we query the current status of the
datafiles:
RMAN> report schema at time='30-aug-07';
Report of database schema for database with db_unique_name DW
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 750 SYSTEM YES
+DATA/dw/datafile/system.256.630244579
2 829 SYSAUX NO
+DATA/dw/datafile/sysaux.257.630244581
3 60 UNDOTBS1 YES
+DATA/dw/datafile/undotbs1.258.630244583
4 5 USERS NO
+DATA/dw/datafile/users.259.632441707
474 Oracle Database 11g DBA Handbook
5 100 EXAMPLE NO
+DATA/dw/datafile/example.265.630244801
6 500 USERS_CRYPT NO
+DATA/dw/datafile/users_crypt.267.630456963
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 60 TEMP 32767
+DATA/dw/tempfile/temp.264.630244787
RMAN> report schema;
Report of database schema for database with db_unique_name DW
List of Permanent Datafiles
===========================
File Size(MB) Tablespace RB segs Datafile Name
---- -------- -------------------- ------- ------------------------
1 750 SYSTEM YES
+DATA/dw/datafile/system.256.630244579
2 829 SYSAUX NO
+DATA/dw/datafile/sysaux.257.630244581
3 60 UNDOTBS1 YES
+DATA/dw/datafile/undotbs1.
Pages:
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719