月度存档: 二月 2011

Physical Data Guard failover process

One of my application is oracle physical data guard, and server team found the memory on primary node is broken and BIOS is too old, so we have to replace RAM and update BIOS. Then the solution is to switch the standby database to primary and primary to standby – that means to switch the database role.

Today I finish this task, would like to record it since i don’t have enough RAM in my brain, I will forget the process.. 🙂

Step 1: Ask partner to shutdown application from their side, so no user is using the system when I’m switching the databases ;

Step 2: apply archive logs to standby database, make sure it’s syncing up with primary
archive log list
select max(sequence#) from v$log_history ;
recover standby database ;

Step 3: check both primary and standby database status, make sure they are ready for the switch ;
Select DATABASE_ROLE, SWITCHOVER_STATUS FROM V$DATABASE;
继续阅读 »