tag:blogger.com,1999:blog-6343291016565209274.post4964357427899317453..comments2023-04-15T09:05:49.911-07:00Comments on Nayyar Ahmad: Steps to shutdown Dataguard/Standby database for maintenance worknayyareshttp://www.blogger.com/profile/08730270201264365351noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-6343291016565209274.post-37787769974325410702019-09-30T10:35:06.219-07:002019-09-30T10:35:06.219-07:00Thank you, well explanation. very help full steps....Thank you, well explanation. very help full steps.Sudhakar Malinenihttps://www.blogger.com/profile/08347232751668174992noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-5391742043207797882015-09-07T12:37:02.361-07:002015-09-07T12:37:02.361-07:00As I see this forum is little active.. I have doub...As I see this forum is little active.. I have doubt if someone can help me out ...<br /><br />suppose I have a standby db with 5 nodes and I want to separate one node of my standby cluster and give it to unix team for some their patch activity... I want to make sure the recovery must continue with the remaining 4 nodes for time being until the 5th node is back in action with the team of other 4 nodes... I dont want to take off the node from cluster by giving cluster_db=false... Is there a way I can do this in RAC standby.. Is there a way I switch off the recovery only on 1 node without others getting affected and joining it back...<br /><br />-ZeeshanZeeshanhttps://www.blogger.com/profile/13909754557999070322noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-85737184031763350172015-05-15T10:29:22.308-07:002015-05-15T10:29:22.308-07:00In the process of removing the standby database, w...In the process of removing the standby database, we can have LOG_ARCHIVE_DEST_2 to defer and but what about the standby redo logs? are there any other things to consider for removing the standby completely.Anonymoushttps://www.blogger.com/profile/08809234715098774155noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-51879833431220028522015-04-20T11:26:05.907-07:002015-04-20T11:26:05.907-07:00hi,
Transport off in primary db
and apply off in ...hi,<br /><br />Transport off in primary db<br />and apply off in standby db are not required?Anonymoushttps://www.blogger.com/profile/02806758272998092402noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-53215230924608440332014-01-15T19:21:15.018-08:002014-01-15T19:21:15.018-08:00I'd add one step:
oracle@standby> lsnrctl ...I'd add one step:<br /><br />oracle@standby> lsnrctl startLChttps://www.blogger.com/profile/05364988452448777691noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-41764126321300768972011-12-14T07:10:18.564-08:002011-12-14T07:10:18.564-08:00Abdul, try to disabled and recreated Block Change ...Abdul, try to disabled and recreated Block Change Tracking - on the Standby.<br /><br />thanksnayyareshttps://www.blogger.com/profile/08730270201264365351noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-46146805808966722472011-12-04T06:17:00.402-08:002011-12-04T06:17:00.402-08:00SQL> alter database recover managed standby dat...SQL> alter database recover managed standby database disconnect from session;<br />alter database recover managed standby database disconnect from session<br />*<br />ERROR at line 1:<br />ORA-01153: an incompatible media recovery is activeabdulhttps://www.blogger.com/profile/17445671905507004614noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-84341125090861668672011-12-04T05:21:14.016-08:002011-12-04T05:21:14.016-08:00Hi ahmed
iam very much thanks for great collection...Hi ahmed<br />iam very much thanks for great collection , i have two node rac 11gr2 , for maintainence we need to down the standby , i followed ur steps here but node1 was mounted successfull , i have faced ORA-01153 while mounting node2 in MRM please help me <br /><br />Regards<br />Abdulabdulhttps://www.blogger.com/profile/17445671905507004614noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-45769138911183653552010-06-25T15:06:50.828-07:002010-06-25T15:06:50.828-07:00Hi Soljanuzi,
thanks for reading me :)
regarding...Hi Soljanuzi,<br /><br />thanks for reading me :)<br /><br />regarding your question, once you disable "LOG_ARCHIVE_DEST_2" your standby database is no logger attached to primary database, you can then just use standard procedure to remove your remote test database.<br /><br />you can use "alter system set log_archive_dest_state_2=defer scope = both sid = '*';" command to disable standby at primary database.<br /><br />cheersnayyareshttps://www.blogger.com/profile/08730270201264365351noreply@blogger.comtag:blogger.com,1999:blog-6343291016565209274.post-48485910001460740402010-06-23T11:46:20.573-07:002010-06-23T11:46:20.573-07:00Nayyar
I really enjoyed your blog. I have a quest...Nayyar <br />I really enjoyed your blog. I have a question about oracle standby and I wish you would give me a hint:<br />I created a standby database from a production database on a remote server to do some tests. Everything worked perfectly. What do I need to remove the standby database? I do not want the logs are transferred to the local LOG_ARCHIVE_DEST_2. I no longer need the standby database.<br />Thanks for advance.<br />Solange JanuziSolJanuzihttps://www.blogger.com/profile/09720134633222109272noreply@blogger.com