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 2: If All Control files loss or corrupted and you have no backup

Case 2: If All Control files loss or corrupted and you have no backup

Anup - Thursday, 19 May 2011
If All Control files loss or corrupted and you have no backup (Also you have not taken control backup by using alter database backup controlfile to tarce command). In this case, we will have to restore cold backup and recover.

Step 1 Shutdown database with abort options

SQL> shutdown abort

Step 2 Startup the database with nomount option

SQL> startup nomount

Step 3 Recover database

SQL> recover database using backup controlfile;
SQL> recover database using backup controlfile until cancel;

Step 4 Open the database

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