Sitemap

Amicuk Programming Answers

Switchover to 1 of 3 Physical Standby (oracle 10g R2)

-0001-11-30   Views:0

Advertisement

Hi all, Previously I already had done switchover primary to standby (only 1 Physical standby was in the configuration) now i have some additional physical standbys (3 Physical standbys) stby1 stby2 stby3 i want to switch to stby1 ,what needs to be do

Hi all,
Previously I already had done switchover primary to standby (only 1 Physical standby was in the configuration)
now i have some additional physical standbys (3 Physical standbys)
stby1
stby2
stby3
i want to switch to stby1 ,what needs to be done at stby2,stby3 to make them capable of identifying stby1 as their new primary.
Kindly suggest!
Best Regards,
Muhammad Shakeel Azeem

The replay answer
Advertisement
921542 wrote:
Hi all,
Previously I already had done switchover primary to standby (only 1 Physical standby was in the configuration)
now i have some additional physical standbys (3 Physical standbys)
stby1
stby2
stby3
i want to switch to stby1 ,what needs to be done at stby2,stby3 to make them capable of identifying stby1 as their new primary.
Kindly suggest!
Best Regards,
Muhammad Shakeel AzeemAzeem,
Welcome to OTN,
Once you performed switchover, You need to perform changes with some parameters from standby FAL_SERVER
Earlier this parameter points to old primary, Now after switchover you have to put service name of new primary database service.
Also Make changes with remote destinations log_archive_dest_n with correct service names.
Refer this manual to work with multiple standby databases.
http://www.oracle.com/technetwork/database/features/availability/maa10gr2multiplestandbybp-1-131937.pdf

Go to See the other 4 answers

Switchover to 1 of 3 Physical Standby (oracle 10g R2)

Category:DefaultRelease time:-0001-11-30Views:130

Hi all, Previously I already had done switchover primary to standby (only 1 Physical standby was in the configuration) now i have some additional physical standbys (3 Physical standbys) stby1 stby2 stby3 i want to switch to stby1 ,what needs to be do[More]

Lost datafile on Standby Oracle 10g

Category:DefaultRelease time:-0001-11-30Views:130

Hi all. i have lost one datafile on my standby ,how to recover it ,this file is created when primary database is in noarchive mode (before i set up the data guard) ,so i can't use alter database create datafile statement bocz i dont have all the arch[More]

Data guard synchronization after link down b/w primary and physical standby

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I have configured data guard on oracle 11gr2 db. Normally switchover between my primary and physical standby happens smoothly and the Apply lag would be zero. Recently We had to test a scenario when the network link between Primary and Physic[More]

Failover to Physical Standby

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I have a configured data guard  in my local system . Please find the below configuration of the Data guard Data Guard Type : - Physical Standby (Oracle version 11g) Service Responsible for Log Transport : - ARCH No Standby Redo log : - Neithe[More]

About physical standby database

Category:DefaultRelease time:-0001-11-30Views:130

We have physical standby database(10g). what are steps to put standby database in ready only mode for time being and then put it back in primary-secondary relationship once cheking is done?Cancel the redo Apply SQL>ALTER DATABASE RECOVER MANAGED STAN[More]

Switchover to a Physical Standby Database

Category:DefaultRelease time:-0001-11-30Views:130

Hello all, i have completed Switchover to a Physical Standby Database succesfully, there is no error in alter log file but when i fire on my new primary database " select * from dba_segments order by 2" then it give me following error SQL Error:[More]

Switchover to physical standby failed

Category:DefaultRelease time:-0001-11-30Views:130

Hi gurus, Could anyone pls help for this issue, i'm working on oracle 9i dataguard in solaris box. we succesully switchover our physical standby to primary but when tried to bring back again to physical standby it is throwing an error SQL> alter data[More]

Problem in switchover to physical standby database

Category:DefaultRelease time:-0001-11-30Views:130

Hi All, I am doing switchover from primary to physical standby database. Physical standby is in 'managed recovery' mode using real time apply and is in mount mode. I executed alter database commit to switchover to physical standby with session shutdo[More]

Error while creating physical standby database using Oracle Grid 10.2.0.5

Category:DefaultRelease time:2015-10-11Views:130

Hi All, I am setting up data guard using oracle grid. Primary database version: - 10.2.0.4 Standby database version: - 10.2.0.4 Primary OS Red Hat Enterprise Linux AS release 4 (Nahant Update 8)2.6.9 Standby OS Red Hat Enterprise Linux AS release 4 ([More]

Db_file parameter change in oracle 8i with physical standby configured

Category:DefaultRelease time:-0001-11-30Views:130

i have oracle 8i (8.1.7) with physical standby configured. i need to change the db_file parameter value. kindly check the below steps are correct? Thanks. 1. alter database backup controlfile to trace; 2. edit the init.ora file as db_file=<new value>[More]

Question-Recovering tablespace in physical Standby...Oracle 10g?

Category:DefaultRelease time:-0001-11-30Views:130

Hello: I have an interesting issue. I thought I will ask the group. I have a physical standby database in 10g. Once of the datafile is in inconsistent state due to a crashed DB during recovery from the last time around. I do not have any archivelogs,[More]

Hot
I would like to pass a value from a form to a page containing two forms (one of the forms is in a tab).Once the value is passed, I want the two forms to be executed with the value passed. Can this be done and how? Any help would be appreciated. Thank [More]
Hello. I just reformatted my Apple Computer because the Safari was not working correctly. I have been using it for a while now when I thought everything had been resolved. BTW - did a clean reformat so it took a long time. However again when I am on [More]
how do i get a movie on my ipod if it says ive already used five computersIf you don't have the option to buy then there's nothing you can do about it. The film studios are the one that decide how the movies are consumed. (Maybe it's new and just rel [More]
I recently brought a mac mini. First thing i did was update all the software, most importantly OSX to 10.5.1. I inserted a usb jump drive to transfer some file then properly ejected it. Now none of the usb ports work. I tried different devices; mouse [More]
Hi, I have got a table 'T' (Source table) with columns T_Lat Varchar2(50); T_Amt Varchar2(50); T_Cat Varchar2(50); Actually, Here I have taken all the columns from table 'T' having numeric data. Now I have another table 'M'(Destination Table) with co [More]
Hi, I've created alot of Network Shared Variables through Project Explorer...and i have also added a description for each one in the shared variable properties screen Could someone please tell me how i can get access to the description through LabVIE [More]
Hi, I was wondering if anyone could help me. I have finally managed to download software that both enables the me to recognise and input Japanese, but now I have a new problem. When I send to my friends' hotmail (for example) all they receive is a lo [More]
Does Photoshop Element 6 work (compatable) with windows 7 on a pc?Yes. It should work fine. See http://forums.adobe.com/thread/1030480 for more info. Thanks AndaleebRead other 3 answers [More]
Hi every one, I have a requirement to develop an interface system, based on my requirement; I want to post GL balance for every month end (sap t-code F-02). My GL balance will come from, external system, itu2019s developed in dot.net, and I have to t [More]
Hi, Gurus, My datafile(sysaux01.dbf) has been deleted and wanted to create a new one instead of recover one pls help me in that so that atleast database should work. it is unable to open due this. Thnaks Edited by: user1124854 on Aug 26, 2010 1:02 AM [More]