This content has been marked as final. Show 5 replies
DB wrote:Assuming your application hanged on production, If you give above command the redo transport will be disabled to remote destination hence no archives will be even applied on standby database. Am not sure how you saying by above query everything is normal :(
My DR has got Aborted.Due to Fire accident.It was happened at 5:30 am today morning.
what are the Consequence technically happend ?
just before my application got hanged ..
Alter system set log_archive_dest_state_2=’DEFER’ scope=both sid=’*’;
After i give the above query in production..it got normal.
If you start MRP after enabling redo transport from primary later if the standby is synchronized with primary then i think you are safe.
DB wrote:What is your protection mode on?
sorry CKPT the query is
Alter system set log_archive_dest_state_2=’ENABLE’ scope=both sid=’*’;
My question is why our production DB is get hanged?
Edited by: DB on Jan 4, 2013 4:33 PM
Why will you think issue only with above command?
Can you take ASH report of that time, after you issued command? That should help you.