Shulou(Shulou.com)05/31 Report--

What is the solution for parameter file damage and control file loss caused by abnormal power outage of the server? many beginners are not very clear about this. In order to help you solve this problem, the following editor will explain it in detail. People with this need can come and learn. I hope you can get something.

Solution:

1. Use pfile to generate the spfile file in reverse: find the pfile file location: d:\ app\ Administrator\ admin\\ pfile

two。 Use the sqlplus "/ nolog" command to enter the database and execute the conn / as sysdba command

3. Generate spfile by executing the command create spfile from pfile='D:\ app\ Administrator\ admin\\ pfile\ init.ora';

4. Try to start the database: startup. Check the alert log after reporting an error. You can see that it is caused by the loss of the control file.

5. Locate the control file location: d:\ app\ Administrator\ oradata

6. Copy the control file and rename control02.ctl,control03.ctl

7. Rebuild the control file, alter system set control_files='D:\ app\ Administrator\ oradata\ $ORACLE_SID\ control02.ctl','D:\ app\ Administrator\ oradata\ $ORACLE_SID\ control03.ctl' scope=spfile

8. Execute shutdown immediate

9. Restart the database: startup successful

Is it helpful for you to read the above content? If you want to know more about the relevant knowledge or read more related articles, please follow the industry information channel, thank you for your support.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.