2. The server has three online redo log group, each group has two members, distribution on different disk, if one of the found damage, start what happens? How to solve

CodePudding user response:

Database normal boot, alert log write redo damage error,

The solution: the alter database clear logfile group x; If it is, of course, the current log, need and become INACTIVE state after switch to clear,

CodePudding user response:

If one of the found damage, the record would be on another member,
Since damaged, must be to find a way to restore, a lot of online fault recovery method,
Such as: online redo log file is missing failure analysis and solution process
http://blog.itpub.net/31403259/viewspace-2136963/

CodePudding user response:

reference 1st floor minsic78 response:

database normal boot, alert log write redo damage error,

The solution: the alter database clear logfile group x; If it is, of course, the current log, need and become INACTIVE state after switch to the clear,

Supplement: group of x x is damaged log of the group,

CodePudding user response:

Another solution: can copy another intact in the group member to startup

CodePudding user response:

A kick-off meeting for failure,

According to the 4th floor, the method of direct copies of the same group of come over,

CodePudding user response:

reference 5 floor wmxcn2000 reply:

can fail,

According to the 4th floor, the method of direct copies of the same group of come over,

How can start failure

Actually this subject yourself to do a test is very simple, every minute, the original poster can get the answer myself...

CodePudding user response:

Artificial redo under the specified file is ok, copy is also a way