This discussion is archived
8 Replies Latest reply: May 4, 2013 6:55 AM by 1007086 RSS

How to get undo datafile number without opening the database ?

993678 Newbie
Currently Being Moderated
I cannot open the database because the my undotbs01.dbf file is corrupted :
SQL> connect sys/... as sysdba
Connected to an idle instance.
SQL> startup mount;
ORACLE instance started.
SQL> alter database open;
alter database open
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
Process ID: 6627
Session ID: 170 Serial number: 5

I tryed several solutions but I failed. So I want to use RMAN :
set newname for datafile X to '/location/undotbs01.dbf';

But how can I get X which is the file number for my undo tablespace ? I cannot call
SELECT tablespace_name,file_id,file_name FROM dba_data_files;
because my database cannot be opened.


  • Correct Answers - 10 points
  • Helpful Answers - 5 points