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

Today, I will talk to you about how to solve the loss of Oracle11g control files, which may not be well understood by many people. in order to make you understand better, the editor has summarized the following contents for you. I hope you can get something according to this article.

First connect to the database and check the path where the control file is located

4. Execute a statement to check whether the database is back to normal

Serial number

Redo log file

Size (M)

one

/ u01/app/oracle/oradata/cams/redo01.log

fifty-one

two

/ u01/app/oracle/oradata/cams/redo02.log

fifty-one

three

/ u01/app/oracle/oradata/cams/redo03.log

fifty-one

Serial number

Tablespace file

Size (M)

one

/ u01/app/oracle/oradata/cams/example01.dbf

three hundred and thirty one

two

/ u01/app/oracle/oradata/cams/finchina01.dbf

8625

three

/ u01/app/oracle/oradata/cams/finchina02.dbf

8025

four

/ u01/app/oracle/oradata/cams/finchina03.dbf

8225

five

/ u01/app/oracle/oradata/cams/finchina101.dbf

1025

six

/ u01/app/oracle/oradata/cams/finchina1.dbf

10241

seven

/ u01/app/oracle/oradata/cams/finchina.dbf

32768

eight

/ u01/app/oracle/oradata/cams/sysaux01.dbf

seven hundred and thirty one

nine

/ u01/app/oracle/oradata/cams/system01.dbf

eight hundred and thirty one

ten

/ u01/app/oracle/oradata/cams/temp01.dbf

eight hundred and fifty three

eleven

/ u01/app/oracle/oradata/cams/undotbs01.dbf

four hundred and eleven

twelve

/ u01/app/oracle/oradata/cams/users01.dbf

six

two。 Shut down the database.

3. Back up all data files and redo log files in the database.

4. Start a new instance, but do not mount or open the database:

6. Do a simple database check to fix some unhandled problems.

The database is now open and available.

The fourth case: the database is closed and all control files are lost.

The processing method in this case is basically the same as in the third case, but if the control file is not restored well, the database cannot provide services to the outside world. But in the third case, the database can also provide services such as additions, deletions, changes and queries that have nothing to do with the control files.

Finally, a summary.

It is important to control the multiplexing of files and the backup of control files. Use ALTER DATABASE BACKUP CONTROLFILE statements to back up your control files. You have two choices:

L back up the control file to the binary file (a copy of the existing control file) using the following statement:

ALTER DATABASE BACKUP CONTROLFILE TO'/ u01qapplash oraclecontrol. Bkp'

Generate SQL statements that can be used to recreate the control file:

ALTER DATABASE BACKUP CONTROLFILE TO TRACE

This command writes the SQL script to the trace file, which can be crawled and edited to reproduce the control file. You can determine the name and location of the trace file by viewing the alarm log.

After reading the above, do you have any further understanding of how to solve the loss of Oracle11g control files? If you want to know more knowledge or related content, 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.