| Activate 2nd standby database as primary [message #657450] |
Wed, 09 November 2016 04:24  |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
Hi,
currently we have a primary and 1 physical standby database (PSB) in sync ( max availability mode).
now, I have done the following
1. Added 2nd Physical standby database using online duplicate target database from primary
2. Then, the redo are in sync for both 1st and 2nd PSB w.r.t Primary
3. Next, when I redo log switch , the redo shipping was fine and even applied=YES condition was showing the updated SEQUENCE# as that of Primary
4. But I did not configure the 2nd PSB in dgmgrl.
5. Now, the next step what I did was that , I want to make 2nd PSB as Primary, for that, I made the log_archive_dest_3 as DEFER to top shipping once I confirmed the logs are in sync
6. Later, on 2nd PSB ,Disable all the parameters set in PSB-2 for standby
7. Shutdown Current Pri and 1st PSB
8. i cancelled the recovery and executed the 2nd PSB convert as PRIMARY
ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;
Waiting for all non-current ORLs to be archived...
All non-current ORLs have been archived.
Media Recovery Log +TEST_FRA/test_tst/archivelog/2016_08_10/thread_1_seq_5608.376.919550367
Media Recovery Log +TEST_FRA/test_tst/archivelog/2016_08_10/thread_1_seq_5609.375.919550367
...........
......................
Media Recovery Log +TEST_FRA/test_tst/archivelog/2016_08_19/thread_1_seq_6062.813.920276499
Recovery of Online Redo Log: Thread 1 Group 11 Seq 6063 Reading mem 0
Mem# 0: +TEST_DATA/test/stdby_redo_11.log
Fri Aug 19 08:39:29 2016
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE FINISH
My query is, when I execute "ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE;" , why the db is looking for the recovery of the logs file even though it as already applied. Here the 2nd PSB came in to sync on Aug 10 and the activate command got executed on Aug 19. So, it was looking for archive logs from Aug 10 to Aug 19.
If I want to avoid this recovery during the activate physical standby database command, how can I do it. ..
does Failover command from dgmgrl will remove this time for recovery. ??
|
|
|
|
| Re: Activate 2nd standby database as primary [message #657452 is a reply to message #657450] |
Wed, 09 November 2016 04:41  |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
I do not understand what you are describing: today is 9 November, why are you talking about August? Why do you want to failover rather than switchover? Why did you not do it all with the DAta Guard Broker? Did the operation succeed or not?
|
|
|
|
| Re: Activate 2nd standby database as primary [message #657454 is a reply to message #657452] |
Wed, 09 November 2016 04:52 |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
Hi Watson,
I understand that I posted late. .
I failed over on Aug and this is the 2nd PSB which I converted as Primary and looking for using this strategy in moving production. I am using this for moving the database from Windows VM ( Primary and 1 PSB) to Linux Physical box ( 2nd PSB).
Once the 2nd PSB is made as Primary, I will be rebuilding another PSB for this new PSB.
This was done in a integration env. Now, if I follow the same steps in Prod, it may cause more downtime for log recovery. So, looking for more details on how to avoid this recovery like using cascading standby and how far it will help.
|
|
|
|
|
|
| Re: Activate 2nd standby database as primary [message #657457 is a reply to message #657454] |
Wed, 09 November 2016 04:55 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
|
I asked four questions, you have answered one. I do not understand what you are trying to do or whether you succeeded. Particularly as you have now (out of nowhere!) mentioned moving from Windows to Linux. What does that have to do with anything?
|
|
|
|
|
|
| Re: Activate 2nd standby database as primary [message #657461 is a reply to message #657459] |
Wed, 09 November 2016 07:18 |
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
|
Senior Member |
|
|
You forgot to explain tat reference to migration from Window to Linux.
However, your methd was not good. Recovery is always neeed after failover. I would have registered the new standby with the Broker, and then performed a switchover. Remove the oter datbase from the configuration after that. Downtime would be minimal, single digit minutes.
|
|
|
|
| Re: Activate 2nd standby database as primary [message #657472 is a reply to message #657461] |
Wed, 09 November 2016 10:31 |
sanei05
Messages: 104
Registered: September 2008
|
Senior Member |
|
|
Thanks Watson..
Let me try that option too.
But the thing is we used to do failover in our normal 1 Primary and One standby. Then the recovery used to happen only for the logs which were applied.
Also, in past we had issue and one of my colleague had executed the command '"ALTER DATABASE ACTIVATE PHYSICAL STANDBY DATABASE; " and it was quick and applied only the pending log files that needs recovery.
But when we built the 2nd PSB on Aug 11 and executed the above command to activate the 2nd PSB to Primary, this started the recovery from Aug 11 2016 to Aug 19 2016 (that was already applied on 2nd PSB). Any reason why is it so.
[Updated on: Wed, 09 November 2016 10:49] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
