Hello all,
Please help me understanding the following
In oracle documentation it is mentioned
ref.
#https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sbydb/upgrading-patching-downgrading-oracle-data-guard-configuration.html#GUID-FDB0FA2C-EA66-423C-AFD9-51F3FA4899F8
#Data Guard configuration that does not contain a logical standby database.
#Ensure that all physical standby databases are mounted,
#but not open. Do not open the standby database(s) until prim and standby are in sync
#Downgrade the primary database
#keeping the following in mind:
#At each step of the downgrade procedure where a script is executed,
#execute the script only at the primary database.
#Do not perform the next downgrade step until all redo generated by
#the execution of the script at the primary database has been applied
#to each physical standby database.
#At each step of the downgrade procedure where an action other than
#running a script is performed, perform the step at the primary database
#first and then at each physical standby database.
#Do not perform the next downgrade step at the primary database
#until the action has been performed at each physical standby database.
Instead can this be done and is there any disadvantage or impact to do it ?
shutdown standby databases, downgrade primary database, Then later mount standby database from old home and apply all the logs generated during downgrade of primary