Disaster Recovery Test and DG

From: Montgomerie Steve <steve.montgomerie_at_siemens.com>
Date: Sat, 22 May 2004 02:58:56 -0400
Message-ID: <C9BDA479AFC02649B4B592CE30A7D1AE014811DB@orlq104a.us007.siemens.net>

Evening all,
I'm doing a DR test and ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; seems to be taking a long time (20 mins).  

Here's what I'm doing  

Shutdown the primary to simiulate site failure  

Issue the following on the primary  

ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH SKIP STANDBY LOGFILE; and then
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY;   Which is where it's hanging,  

Alert log reflects nothing really helpful Sat May 22 02:38:50 2004
ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY Database not recovered through End-Of-REDO Begin: Wait for standby logfiles to be archived  

Is this wait expected?    

Thanks  

Steve

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Sat May 22 2004 - 01:56:16 CDT