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

This article will explain in detail how to recover the loss of Controlfile and system01 data files through standby. The content of the article is of high quality, so the editor shares it for you as a reference. I hope you will have some understanding of the relevant knowledge after reading this article.

Problems

DELL 2950 server + Oracle 9.2.0.7

/, / U01 (ORACLE_HOME,ORACLE_BASE) related to RAID1 (76G) and

The magnetic queue card is disabled at the same time.

/ data (most datafile,redo logfile) RAID5 (146g) does not have any errors

Analysis.

If the backup is activated, you need to change the IP, redo the new standbyDB, and the data in the redo will vary.

Since redo logfile is not lost under / data, resetlog mode is not required for all main database open.

Deal with

Better hardware and queue cards, retain / data magnetic reinstallation system.

Only the data under / data is valid after reinstalling the system, and other data is lost.

1. Restore the database copy

The original database oracle installer is installed in the / U01 directory and can be used through copy in standby DB after loss.

two。 Restore system01.dbf

/ u01/product/oradata/bzdt2/system01.dbf

/ u01/product/oradata/bzdt2/cwmlite01.dbf

/ u01/product/oradata/bzdt2/indx01.dbf

Also through copy standby

3. Restore controlfile

Controlfile in copy standby first

4. Recover database in standby mode

Sql > startup nomunt

Sql > alter database mount standby database

Sql > recover standby database;-- specify redologfile at this time

Specify log: {= suggested | filename | AUTO | CANCEL}

/ data/bzdt2/redo01b.log

5. Build the master database controlfile

At this time, the SCN of all datafile is the same, but according to the standby status, it is necessary to re-establish the standby database if activated. Use alter database backup controlfile to trace

After alter database nomount;, set up ccontrolfile through this manual and use noresetlog method.

Re-recover database

6. Final alter database open

About Controlfile and system01 data file loss through standby recovery to share here, I hope the above content can be of some help to you, can learn more knowledge. If you think the article is good, you can share it for more people to see.

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.