269.632009933
8 rows selected.
Incidentally, the alert log (and the session where you performed the startup command) would
give you another clue the next time you tried to start the database with a missing or corrupted
datafile:
ORA-01157: cannot identify/lock data file 4 - see DBWR trace file
ORA-01110: data file 4: '+DATA/dw/datafile/users.259.630244583'
After replacing the disk drive, we initiate an RMAN session and find out that file number 4
corresponds to the USERS tablespace:
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 826 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.630244583
5 100 EXAMPLE NO
+DATA/dw/datafile/example.265.630244801
6 500 USERS_CRYPT NO
+DATA/dw/datafile/users_crypt.267.630456963
7 100 INET_STAR NO
+DATA/dw/datafile/inet_star.268.632004213
8 50 INET_INTL_STAR NO
+DATA/dw/datafile/inet_intl_star.269.632009933
List of Temporary Files
=======================
File Size(MB) Tablespace Maxsize(MB) Tempfile Name
---- -------- -------------------- ----------- --------------------
1 60 TEMP 32767
+DATA/dw/tempfile/temp.
Pages:
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703