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
There are two options in IMAQ palette a low level and a normal one. Both have the same function names and the same icons the only difference being the balck and white icon of low level functions and colored icons of the normal functions. What is the [More]
My shift Key does not work when used to collect multiple files.Murilo.mac wrote: You shall hold the Cmd key if you want to select multiple files Not if they are sequential, which is what the OP seems to want.Read other 11 answers [More]
I got my iPad taken away recently and used my phone to find my ipad. I have now gotten back my ipad and can not unlock it because my passcode is no longer working. I have tried to restore it but am unable to because it is locked and in lost mode. I h [More]
Hello! I' m in trouble... I'd like to define a substitution rule that works out before message error KI235 appears in posting a document by using FB01 or FB50 trx. I've tried to do it by using OKB9 trx and inserting a default cost center. It is not a [More]
Trying to update my iphone 6 plus to ios 8.1 using windows laptop running windows 7. It failed with giving message update failed with unknown error (6). Exact error is:      The iPhone "iPhone" could not be restored. An unknown error occured (6) [More]
I just upgraded from TCS 2.0 to 2.5. When I try to open my RoboHelp projects, I get the following error: "This project is from a newver version of the program. This project is no longer compatible with this version. Please make sure you have the newe [More]
Hi all, i am presently running a server that has no video card. No problem to access it because a use rlogin to manage and maintain the server. Now i need to reconfigure the server to "see" the new tape drive i installed. One way to reconfigure [More]
Hi, Im using a DBPreferenceStore for storing portlet defaults for the page designer to use (editDefaultsPage). Im using data = (EventPersonalization)PortletRendererUtil.getEditData(pr); for grabbing the personalization object and PortletRendererUtil. [More]
You are running an operating system that Photoshop no longer supports. Refer to the system requirements for a full list of supported platforms. What do I need to do to be able to download this program?Mathis88 what version of Photoshop are you trying [More]
My iPhoto doesn't work. It opens to an empty library stays like that for about 20-30 seconds and then crashes. I have tried uninstalling and reinstalling and I've rebooted my phone. I've also freed up almost 4GB of space on my iPhone.It opens to an e [More]