8 Replies Latest reply: May 4, 2013 8:55 AM by 1007086 RSS

    How to get undo datafile number without opening the database ?

      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.