1. Do you use ARCH or LGWR to transfer redo? 2. When you decide to failover standby to a new primary in Oracle9iR2, you need to confirm is there any gap archive log from V$ARCHIVE_GAP. 3. If no reply after you "commit to swtich over to primary", you should: a. restart standby: SHUTDOWN IMMEDIATE; STARTUP NOMOUNT; ALTER DATABASE MOUNT STANDBY DATABASE; b. try to skip current standby redolog if you used: ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH [skip standby logfile]; c. switch to primary: ALTER DATABASE COMMIT TO SWITCHOVER TO PRIMARY; d. restart: SHUTDOWN IMMEDIATE; STARTUP OPEN; -- Kamus <kamusis@xxxxxxxxx> Visit my blog for more : http://www.dbform.com Join ACOUG: http://www.acoug.org On Thu, May 27, 2010 at 4:17 PM, Alessandro Lia <a.lia@xxxxxxxxxx> wrote: > Sorry Stefano, in this moment I'm not able to attach the log file. > The behaviour is that after the 2nd command I write in 1st e-mail the system > simply don't reply. > It seems not ending loop. > So my doubts is if those commands are not enough or are wrong or there is > something wrong in what I'm doing. > As soon as I can obtain the alert log I can post it. > > Ale > > > > > > ----- Original Message ----- > From: Stefano Cislaghi > To: Alessandro Lia > Cc: oracle-l > Sent: Thursday, May 27, 2010 9:43 AM > Subject: Re: 9i r2 Data Guard - failover procedure > Ok, u missed the alert log. > I understand when you say that don't work, but you have to explain. Whici is > the prompt responde to your commands? which are last 100 lines in your alert > log? > Stefano > > -- > http://www.stefanocislaghi.eu > > -- //www.freelists.org/webpage/oracle-l