| active data guard [message #377082] |
Sat, 20 December 2008 00:57  |
allahmorad
Messages: 18
Registered: June 2006
|
Junior Member |
|
|
Hi,
I want implement active data guard in 11g , read/write mode for
real-time quey. for this I create phisical standby database in 11g same 10g.
startup :
STARTUP NOMOUNT;
ALTER DATABASE MOUNT STANDBY DATABASE;
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION;
alter database open read only;
shutdown:
ALTER DATABASE RECOVER MANAGED STANDBY DATABASE CANCEL;
SHUTDOWN IMMEDIATE;
can i change this for read/write mode ?
best regards
allahmorad
|
|
|
|
|
|
| Re: active data guard [message #377116 is a reply to message #377089] |
Sat, 20 December 2008 07:03  |
allahmorad
Messages: 18
Registered: June 2006
|
Junior Member |
|
|
Hi,
in 10g , if standby database is open , we can read from database
and cannot apply new archive log. for apply this. shoud be go to nomount mode and apply .
but in 11g we can have both. while database is open automotically apply new archive log.
i want use this feature but can't.
regards
allahmorad
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
