Solved

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

Posted on 2015-01-18
6
221 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 23

Accepted Solution

by:
David earned 500 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

813 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now