Database Administration (MOSC)

MOSC Banner

Logical inconsistent blocks on main and standby.

edited Jun 5, 2018 5:04AM in Database Administration (MOSC) 3 commentsAnswered

Hello experts.

Situation.

The main and standby databases worked in the "no force logging" mode for a long time. Several times the roles were switched. In both bases appeared corrupted blocks. Quantity is different.

Question.

Old backups are not saved. Read 28814.1 and 794505.1. Errors ORA-26040 and ORA-1578 do not occur. Doc ID 794505.1 said:

When ORA-26040 is not produced along with ORA-1578 the block is then corrupt by a different reason and RMAN Block Media Recovery can be used to repair the corruption.

Is it possible to recover corrupted blocks on the main database from incremental backups of good blocks of standby database, and vice versa?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center