Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i R1 logical standby DB server

ericfjchen
Regular Advisor

Oracle 9i R1 logical standby DB server

Hi all,

Now we are using Oracle 9.0.1.4 RAC with 2 instances. And we also have a standby DB. But this standby db can't be open for read only. Once we open standby db, it will not be a standby DB anymore. But I heard Oracle 9i can be config a logical standby with read only mode. In other words, this standby can always be sync with primary DB and also can be read only. Does it work? How can I do?

Thanks

FJ
2 REPLIES
Peter Godron
Honored Contributor

Re: Oracle 9i R1 logical standby DB server

Hi,
have a look at metalink:
DocID:274170.1
That should start you off in the right direction.

I think the command is:
ALTER DATABASE GUARD [NONE|STANDBY|ALL]

Regards
Yogeeraj_1
Honored Contributor

Re: Oracle 9i R1 logical standby DB server

hi FJ,

also have a look at the Oracle documentations at url:
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96653/create_ls.htm#1073769

and also this great presentation:
http://otn.oracle.com/deploy/availability/pdf/40056_Ray_ppt.pdf

hope this helps too!

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)