Stadby server will be down due to maintenance
Our stand by server will be down during the maintenance work for 2 days. Find the steps to be issued before / after server is down / up.
Please correct me if there is any thing I am missing:
===========================================================================================
Pre move:
On Primary:
1.alter system set log_archive_dest_state_2 = 'defer';
On Stand by:
2. alter database recover managed standby database cancel;
3. shutdown immediate;
------------------------------------------------------------------------------------
Post move -- after the stand by available
------------------------------------------------------------------------------------
1. Copy all archive from primary to DR generated during shutdown. ( Do we have to copy manually???)
On Standby:
2. connect sys/password as sysdba
3. startup nomount pfile='<....\INITSTDBY.ora'>; --- check the path