1 reputation
bio website
location
age
visits member for 1 year, 3 months
seen Jan 13 '13 at 14:39

Jan
13
comment Oracle 10gR2 Data Guard Switchover
Yes, before both shipping and applying worked properly! Something that it seems strange is that in the standby database data guard didn't set the log_archive_dest_1 variable. I tried to set a similar to primary db variable but again it didn't work.
Jan
13
comment Oracle 10gR2 Data Guard Switchover
With that I meant that not. Log Transport service does not ship logs (for both directions) after the switchover, so they are not applied.
Jan
13
comment Oracle 10gR2 Data Guard Switchover
The problem is that the primary database after the switchover remains primary (mouted) and standby remains standby (mounted). Swithover fails with the following error. DGMGRL> switchover to 'INTER'; Performing switchover NOW. Please wait... Error: ORA-16772: Error in switching over between primary and standby databases Failed. Can not proceed to switchover. Primary is still "MILAN".
Jan
13
comment Oracle 10gR2 Data Guard Switchover
MILAN is the primary database. And this was initially open as primary.
Jan
9
asked Oracle 10gR2 Data Guard Switchover