1 minutes readCase 4: Lost datafile and No backup (When database abnormal terminated)

Reader Mode
Step 1 Startup the database with mount option

SQL> startup mount


Step 2 Recreate datafile

SQL> alter database create database datafile ‘’ as ‘’ size ;

Step 3 Online the datafile

SQL> alter database datafile ‘’ online;

Step 4 Now Open the database

SQL> alter database open

Related Articles

Responses

Your email address will not be published. Required fields are marked *

Password Reset
Please enter your e-mail address. You will receive a new password via e-mail.