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