Home » RDBMS Server » Backup & Recovery » active data guard (Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit)
active data guard [message #377082] Sat, 20 December 2008 00:57 Go to next message
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 #377089 is a reply to message #377082] Sat, 20 December 2008 01:32 Go to previous messageGo to next message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to choose between:
- keeping the database as standby
- opening in read/write mode

You can't have both.

Regards
Michel
Re: active data guard [message #377116 is a reply to message #377089] Sat, 20 December 2008 07:03 Go to previous messageGo to next message
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
Re: active data guard [message #377122 is a reply to message #377116] Sat, 20 December 2008 09:20 Go to previous message
Michel Cadot
Messages: 64109
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is not the question you first posted.
Steps are explained in
Data Guard Concepts and Administration
Chapter 9 Managing Physical and Snapshot Standby Databases
Section 9.2 Opening a Physical Standby Database

Regards
Michel
Previous Topic: oracle - 9.2.0.8.0 o/s: HP-UX:11.23
Next Topic: Disaster recovery test
Goto Forum:
  


Current Time: Mon Dec 05 09:14:38 CST 2016

Total time taken to generate the page: 0.05125 seconds