| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Advanced replication
Hello Seema
With advance replication you select which tables you want to replicate. You
can choose all of them or just a few.
Switching to the replicated site can be done in some ways:
1) Your application try to connect to primary database. If the connection
fails it try to connect to the secondary database.
2) In tnsnames.ora you define failover for the database.
3) Bring down the failed machine and configure the secondary machine to the
same name and tcp/ip address so the network thinks that it is the same
machine.
Do not forget to plan what you do after the primary machine is back up and you need to switch back.
Yechiel Adar
Mehish
----- Original Message -----
From: "Seema Singh" <oracledbam_at_hotmail.com>
To: <oracle-l_at_freelists.org>
Sent: Tuesday, May 18, 2004 11:27 PM
Subject: Advanced replication
> Hi,
> Setup:
> OS= Sun solaris 5.7
> oracle=8163
> objective: In case of disaster replica site would be as production site.
> I want to do disaster recover site for this ionstnace thru replication not
> satndby database.I need some information on advanced replication.
> -Can I do replictaion of few tables on replica site ? In case of failure
can
> we migrate to replica site?
> -If i setup snashot for few tables can I swich application in case of
> failure and replica site could treat as production site?
> please advice ,if someone have any good information let me know.
>
> thx
> -Seema
>
> _________________________________________________________________
> Learn to simplify your finances and your life in Streamline Your Life from
> MSN Money. http://special.msn.com/money/0405streamline.armx
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Thu May 20 2004 - 06:42:08 CDT
 |
 |