on 01-05-2010 12:27 AM
When I was setting up the physical standby DB several years ago no DataGuard got involved), I had the impression that the standby DB is in MOUNT status.
But since when using DataGuard to set up the logical standby DB, the logical standby DB can be used as it is already OPENed.
Is it actually in OPEN status? If so, can the primary and logical standby have the same SID without any trouble?
Please help advise. Thanks a lot!
Yes ,we had setup dataguard using the same SID for the primary and logical standby,you should be fine.
we need only the db_unique_name identifier(in the initXXX.ora to be unique for the primary and standby.
Gerard
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Christy,
yes it is ok that both database are in status OPEN, that is also the main reason for using logical standby databases (you can do changes and queries on standby too).
I hope you don't use a logical standby database in a SAP environment, because of this is NOT supported. Check sapnote #105047 - Point "14. Data Guard". A logical standby database has limitations.
If you just want to use the physical standby database for queries you can open it in read only or you can use flashback technology for read/write. With Oracle 11g you have these features included in data guard itself (Active Data Guard / Snapshot StandBy) to perform such steps automatically.
Regards
Stefan
Hello Christy,
> 1) how to activate (or enable) DataGuard?
If you have a standby databases, you are already using the "Data Guard feature" ..
> 2) 11g is not certified by SAP yet (not in PAM), right?
Correct - actually planned for Q1/2010 ... but you can also do that "special stuff" on Oracle 10g - the limitation is that you have to do it manually and not with the Data Guard (Broker) itself.
The important point from my previous reply is: Logical standby databases are not supported in a SAP environment.
Regards
Stefan
User | Count |
---|---|
74 | |
26 | |
10 | |
10 | |
7 | |
6 | |
4 | |
4 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.