0

I had my database working properly but I had an issue and when I tried to repair it I executed the following command

alter tablespace system add datafile '/var/oracle/oradata/data.dbf' size 10000m autoextend on maxsize unlimited;

Then I noticed that the command didn't resolve my problem then I deleted the file data.dbf... But the problem that I'm having right now is that when I'm trying to restart my database it doesn't run.

I looked and didn't find how to fix the problem. Can someone help me? Any help please... I'm down

  • Did you try drop datafile? – mustaccio Aug 23 at 17:03
  • what was your initial issue? – Joe W Aug 23 at 17:13
  • @mustaccio i dont have even the possibility to connect in my db i'm getting this error ORA-01033: ORACLE initialization or shutdown in progress – ArkaL Aug 23 at 17:17
  • @JoeW my initial issue was that when i was execute a select query it's was giving an error to extend my tablespace – ArkaL Aug 23 at 17:20
  • Posting the exact error message would help as it seems strange that you would need to extend the system tablespace to run a query. Also providing your version of oracle will help. – Joe W Aug 23 at 17:25
0

If you deleted the SYSTEM tablespace datafile as you say, and do not have a backup, there is no recovery. You will need to recreate the database.

Side note, you should never delete a datafile directly at the OS level and never the SYSTEM.

  • then I lost all my datas??? Just for clarification @Ross the datafile that i deleted was a new one which had nothing but i have others datafile that were working before properly. There is only no way to create a new database by using those datafile which were working before? – ArkaL Aug 23 at 18:25
  • Ok, that's good then. What state is the database in? Running? Was it already shutdown? If you have some screenshots of where your system01.dbf file is, as well as some sqlplus screenshots of the state of the database, that will be helpful. – Ross Aug 23 at 18:27
  • The state of the database is in shutdown state – ArkaL Aug 23 at 18:28
  • connect / as sysdba; startup mount; ALTER DATABASE DATAFILE '/var/oracle/oradata/data.dbf' OFFLINE DROP; alter database open; As long as you still have your original system01.dbf file! – Ross Aug 23 at 18:37
  • It's gives me this error ORA-01589: must use RESETLOGS or NORESETLOGS option for database open – ArkaL Aug 23 at 18:45

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.