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

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 Received on Sat Dec 27 2003 - 07:53:15 CET