473,397 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,397 software developers and data experts.

Oracle9i standby database setup in RH9 .. a minor error pls help

hello,

Thanx for the suggestions on my Listener query. Now i am performing a
simple work.. STANDBY DATABASE creation.

I have followed the instraction from Oracle 9i Release 1 documentation
but have some doubts. here are the basic stpes i followed.
1 Either make a new backup of the primary database datafiles or access
an old backup.

2 Ensure the primary database is in ARCHIVELOG mode.

3 Connect to the primary database and create the standby control file.

4 Copy the backup datafiles and control file from the primary site to
the standby site.

5 Set the initialization parameters for the primary database.

6 Create the standby initialization parameter file and set the
initialization parameters for the standby database. Depending on your
configuration, you may need to set filename conversion parameters.

7 Start the standby instance and mount the standby database.

8 Create standby redo log files, if necessary.

9 Manually change the names of the primary datafiles and redo logs in
the standby control file for all files not automatically renamed using
DB_FILE_NAME_CONVERT and LOG_FILE_NAME_CONVERT in step 7. If step 7
renamed all files, skip this step.

10 Manually enable initialization parameter changes on the primary
database so that it can initiate archival to the standby site.

11 Use the Oracle Net Manager to configure a listener on the standby
database. If you plan to manage this standby database using the Data
Guard broker, you must configure the listener to use the TCP/IP
protocol and statically register the standby database service using
its SID.

12 Use the Oracle Net Manager to create a net service name that the
standby database can use to connect to the primary database. The net
service name must resolve to a connect descriptor that uses the same
protocol, host address, port, and SID that you specified when you
configured the listener on the primary database site. If you are
unsure what values to use for these parameters, run the Oracle Net
Manager on the primary database site to display the listener
configuration.

13 Use the Oracle Net Manager to create a net service name that the
primary database can use to connect to the standby database. The net
service name must resolve to a connect descriptor that uses the same
protocol, host address, port, and SID that you specified when you
configured the listener on the standby database site. If you are
unsure what values to use for these parameters, run the Oracle Net
Manager on the standby database site to display the listener
configuration.

I have followed each step .. but have some simple queries

# How can i test the standby database ?.. by shuting down 1 DB , will
it work ?

# By wat means do i synchronise the data in two database?

# Wat are the necessary init.ora parameters in either database that i
have to add/modify ?

# i did take backup of Db files,init.ora w.r.t first database..I
copied it to secondary DB then .. what shall i do next?

# In short, i would be very grateful if anyone could send me the
detail procedure to setup and implement standby database.

i am using two machines - node2 & node 3 with datbabase apple & intel
respectively.i am working on Red Hat Linux 9.

Wish u a Blasting New Year
regards,
Cherrish Vaidiyan
Jul 19 '05 #1
0 3892

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
by: A. Fuentes | last post by:
Fellow Oracle Netters: I have the following problem: Enviroment: Oracle9i/AIX5.2/Veritas vxvm I am trying to create an Oracle database using RAW devices UNDER the Veritas vxvm.(Veritas...
0
by: Cherrish Vaidiyan | last post by:
sir, The following are the steps that i followed in setting up standby database on Red hat Linux 9. i am using Oracle 9i. i have followed the steps in this site : ...
0
by: Officer | last post by:
I want to setup standby database which reside on the same host with my primary database -dbSA is my primary and dbSB is my standby database. I select v$log as follows: SVRMGR> select...
3
by: Nathan Sokalski | last post by:
When I attempt to run a form created with Oracle9i Forms Builder I receive a dialog box asking for the following info: User Name: Password: Database: I obviously know my User Name and...
1
by: Kamal | last post by:
Hi, Currently we have logshipping setup with one production db server sending the logs to one standby database server. we would like to have setup where there will be two standby db servers....
9
by: Wayne Smith | last post by:
I've come up against a major headache that I can't seem to find a solution for but I'm sure there must be a workaround and I would really be grateful of any help. I'm currently building a web...
6
by: shorti | last post by:
db2 8.1 fix pack 12 on AIX 5.3 This is a newly configured HADR machine. The HADR was up and running. I was 'playing' around some on the standby and did a db2 deactivate and things sort of went...
0
by: Vinod Sadanandan | last post by:
STANDBY DATABASE MONITORING & PROTECION MODES (9iR2) This document is written for understanding and monitoring standby database configured with diffrent protection modes . MAXIMUM PROTECTION ...
0
by: Cherrish Vaidiyan | last post by:
hello, Thanx for the suggestions on my Listener query. Now i am performing a simple work.. STANDBY DATABASE creation. I have followed the instraction from Oracle 9i Release 1 documentation...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.