Re: 9i r2 Data Guard - failover procedure
- From: "Leyi Zhang (Kamus)" <kamusis@xxxxxxxxx>
- To: a.lia@xxxxxxxxxx
- Date: Sun, 30 May 2010 00:45:03 +0800
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
Other related posts:
