Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

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

Any data guard dataguard failover step by steps guide ?
0
Comment
Question by:marrowyung
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

 
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

Enroll in September's Course of the Month

This month’s featured course covers 16 hours of training in installation, management, and deployment of VMware vSphere virtualization environments. It's free for Premium Members, Team Accounts, and Qualified Experts!

Question has a verified solution.

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

Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

722 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