Saturday, 29 August 2020

Shutdown the Oracle Standby Database

On Production Database Server

Run the below command to defer the archive log destination parameter set for Standby Database

SQL> alter system set log_archive_dest_stat_2=DEFER;

__________________________________________________________________

On Standby Database Server

SQL> select process,status from v$managed_standby


Cancel Managed Recovery

SQL> alter database recover managed standby database cancel

 Shutdown the standby Database

SQL > shutdown immediate

__________________________________________________________________



No comments:

Post a Comment