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.
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