CODEWITHSUNDEEP
oracle-database
user3375401
user3375401

Reputation: 491

How to start Oracle 12c database when table space file was accidentally deleted

I've accidentally deleted a tablespace file and now Oracle 12c will not open.

How can I remove this tablespace from oracle without the database being open?

Upvotes: 4

Views: 472

Answers (2)

atokpas
atokpas

Reputation: 3351

If you have deleted the datafiles then you have to restore it from the physical backup if you don't want loose data.

Performing Complete Recovery of a Tablespace

The datafiles information is checked by Oracle during open database process. It means you can mount the database and make the datafile offline.

ALTER DATABASE DATAFILE 'path to datafile' OFFLINE;

ALTER DATABASE OPEN;

Upvotes: 4

user3375401
user3375401

Reputation: 491

ALTER DATABASE DATAFILE '/u02/oracle/rbdb1/stuff01.dbf' OFFLINE;

Upvotes: 1

Related Questions