Improve company productivity with a Business Account.Sign Up

x
?
Solved

how to use data guard to failover Orace 11gR2 and 12c

Posted on 2015-01-18
6
Medium Priority
?
279 Views
Last Modified: 2015-01-29
Dear all,

Any data guard dataguard failover step by steps guide ?
0
Comment
Question by:marrowyung
  • 3
  • 3
6 Comments
 
LVL 23

Expert Comment

by:David
ID: 40556426
Many many sources, depending more specifically on what your setup is, and what you need to accomplish.  Basically you identify the secondary host as an archivelog destination in your primary.  The secondary database is set up as an online physical standby, which will process the incoming archivelogs and apply them so that both databases are kept in synchronization.  Failover can be configured as automatic, but my clients kept theirs to require a manual intervention -- someone had to "declare" the primary failure.

http://docs.oracle.com/cd/B28359_01/backup.111/b28270/toc.htm
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40556985
"Failover can be configured as automatic, but my clients kept theirs to require a manual intervention -- someone had to "declare" the primary failure."

you mean your client like manual effect on both failover and failback/switch back ?
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40559198
sorry the link is about RMAN, not about data guard, please help.
0
Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 23

Accepted Solution

by:
David earned 2000 total points
ID: 40559886
My bad, regrets.  Try http://docs.oracle.com/cd/B28359_01/server.111/b28294/log_transport.htm#BABCEEAI and its parent in the Database Concepts docs: http://docs.oracle.com/cd/B28359_01/server.111/b28294/toc.htm .

The big picture of "many sources" is https://www.google.com/search?q=how+to+use+oracle+data+guard&sourceid=ie7&rls=com.microsoft:en-US:IE-SearchBox&ie=&oe=&safe=active&gws_rd=ssl .

I think you are asking me to clarify that while DataGuard may be set up to failover automatically, my customer's requirements dictated a manual intervention.  I might mention there were competing sub-contractors involved, and the primary vendor was reluctant to failover to a site not under their control.
0
 
LVL 23

Expert Comment

by:David
ID: 40559891
FYI, search the E-E database as well.  Here's an in-house source: http://www.experts-exchange.com/Database/Oracle/Q_27953174.html
0
 
LVL 1

Author Comment

by:marrowyung
ID: 40577088
I am reading this:

http://oracle-base.com/articles/11g/data-guard-setup-11gr2.php

on which server I run this:

ALTER SYSTEM SET LOG_ARCHIVE_CONFIG='DG_CONFIG=(DB11G,DB11G_STBY)';

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=db11g_stby NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB11G_STBY';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;

ALTER SYSTEM SET LOG_ARCHIVE_FORMAT='%t_%s_%r.arc' SCOPE=SPFILE;
ALTER SYSTEM SET LOG_ARCHIVE_MAX_PROCESSES=30;
ALTER SYSTEM SET REMOTE_LOGIN_PASSWORDFILE=EXCLUSIVE SCOPE=SPFILE;

ALTER SYSTEM SET FAL_SERVER=DB11G_STBY;
--ALTER SYSTEM SET DB_FILE_NAME_CONVERT='DB11G_STBY','DB11G' SCOPE=SPFILE;
--ALTER SYSTEM SET LOG_FILE_NAME_CONVERT='DB11G_STBY','DB11G'  SCOPE=SPFILE;
ALTER SYSTEM SET STANDBY_FILE_MANAGEMENT=AUTO;

Open in new window

?

must be on the primary server, right?


also I dont' see where is the local destinations setting by that:


"suitable remote archive log destinations. In this case I'm using the fast recovery area for the local location, but you could specify an location explicitly if you prefer. Notice the SERVICE and the DB_UNIQUE_NAME for the remote location reference the standby location.

ALTER SYSTEM SET LOG_ARCHIVE_DEST_2='SERVICE=db11g_stby NOAFFIRM ASYNC VALID_FOR=(ONLINE_LOGFILES,PRIMARY_ROLE) DB_UNIQUE_NAME=DB11G_STBY';
ALTER SYSTEM SET LOG_ARCHIVE_DEST_STATE_2=ENABLE;"

"Create Redo Logs

Create online redo logs for the standby. It's a good idea to match the configuration of the primary server
"

why we need to create redo logs files ? this online file is not create automatically for new instance ?

"In my case, the following is standby redo logs must be created on both servers."

I think the oracle only have redo log file and archive log file? what is standby redo log file for ?
0

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Working with Network Access Control Lists in Oracle 11g (part 1) Part 2: http://www.e-e.com/A_9074.html So, you upgraded to a shiny new 11g database and all of a sudden every program that used UTL_MAIL, UTL_SMTP, UTL_TCP, UTL_HTTP or any oth…
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

579 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question