Home > database >  Oracle control file has 3, in the use of the list archive log all command, found that can't rea
Oracle control file has 3, in the use of the list archive log all command, found that can't rea

Time:09-19

But in normal running, oracle by copying the three control files to other partitions found the other two replicate success, the first control files cannot be copied, this kind of situation is proved that the control file 1 have damaged? Since three the same size as the control file, the first is damaged, the other two can also be normal to write? And what cause the control file damaged? Only hard disk failure? Now that the hard drive is damaged, other documents are also likely to be damaged (including data file), so, problem is more serious, if just may be a control file is damaged, why the control file so easy damage? A series of problems, very want to solve, thank you, first

CodePudding user response:

CTL can't copy, what wrong, depending on, another database running normally, how do you suspect database is broken?

CodePudding user response:

Because the list in rman archivelog all error, reading ctl01 control file failed

CodePudding user response:

Must be a set of three control file online at the same time can be read to write, if there is a no, complains that run log files, you can see it in the alter log now, if the database is stopped to rev., rev. Don't get up, the reason is that the first control file has a problem, I generally is to apply for a downtime, normal clearance database, shutdown immediate (do not use abort or kill kill), and then put all the backup control file, after the two normal casually pick a control file, copied to the first control file and cover, and the server, you should can, if not, that is about to change a parameter, the first control in the control file path file location, and then would have a normal
  • Related