This content has been marked as final. Show 8 replies
Undo tablespace and datafile would be used, if you have got the automatic Undo management enabled. If you are not sure about the backups of yours taken for it, I believe on metalink, there is a note which explains how to start your db in the manual undo management and then open the database(would require a trick to be involved) .
hi have this problem and i cannot solve it, the customer has not backup data base
can you help me ?
can you send me the note you are talking about ?
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