All apps dba Blog is the blog contributed by Doyensys Employees, With the view to share the knowledge out of their experience.
Doyensys Is a Fast Growing Oracle Technology Based Solutions Company Located in the US And Offshore Delivery Centers in India. With rich experience In Oracle E-Business, Oracle Database, Oracle Application Express (APEX), Oracle J Developer, Oracle OBIEE and E-Business Suite
Standby Archivelog is wrongly being shipped to Oracle home dbs location after database switchover
After switchover of the database from Primary to Standby. The archive from new primary to the new standby is being shipped to the Oracle home dbs location, which is the default location for the initialization parameter. This issue was identified due to the following parameter getting changed after the switch over.
Standby_archive_dest was set to "Auto".
One we changed this parameter to the actual archive log destination the issue got fixed. So we need to check this parameter after switchover