TEST
Powered by Blogger.
Responsive Ad
Responsive Ad

Author Profile

About Me

Start Sharing

Start Sharing

Drive Traffic on Social Platforms

Blog Archive

Blog Journey

Blog Journey

Learn how to start a perfect Blog

Work Smart, Not Hard - Let's See

Make your Blogging experience faster and easiest …
Work Smart, Not Hard - Let's See
Design by - Blogger Templates | Distributed by Free Blogger Templates

Made with Love by

Material UI Template is Designed Theme for Giving Enhanced look Various Features are available Whic…

Random Posts

Ads Section

HOME > > Case 5: If all database lost and we have no backup of newly created data file.

Case 5: If all database lost and we have no backup of newly created data file.

Anup - Friday, 20 May 2011

Step 1 Restore database and mount the database

Step 2 Recover the database

SQL> recover database using backup controlfile;

Step 3 Check file status

SQL> select file#,name,status from v$datafile;

Step 4 Create datafile

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

Step 5 Recovery the database

SQL> recover automatic database using backup controlfile until cancel;

Contact me

Get in Touch

Need to get touch with me? Please fill out the form with your enquiry.

Name
Anup Srivastav
Address
Lucknow - Utter Pradesh
Email
myindiandba@gmail.com
Message me