We're here to help!

Switchover issues in Version 7.0 standby with database 11.1.0.7 in ASM

Follow

Read our docs This article explains how to workaround a Graceful Switchover issue with standby version7.0 and database version 11.1.0.7 with ASM

Problem Details

Problem Statement

Graceful switchover might fail since the file created in ASM via CP command might give different aliases , which might affect the switchover. 

Applicable Error Code

N/A

Affected Versions

Standby Version 7.0 and Database Version 11.1.0.7

Affected Platforms

Check Oracle Support Note for Patch 8465740

 
Description

 In Version 7.0 with database version 11.1.0.7 , there might be issues during the graceful switchover process , since the ASM file created via CP command might add aliases to the files , there by failing to be identified by the Standby Switchover process.

Solution

There are two possible solution for this issue. 

 1. Apply the patch 8465740 , which is recommended so that the graceful switchover can be done without any issues.

2. Set the parameter _FORCE_ASM_READ_WRITE = Yes in the DDC file(this is a workaround so test this in a local environment).

Please note this only affects the Graceful switchover process since the process copies file to the ASM , It does not affect any of the other processes like standby creation or synchronisation process. It does not affect the standby activation as well.

 

Have more questions? Submit a request

Comments