Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 265
  • Last Modified:

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

Dear all,

Any data guard dataguard failover step by steps guide ?
0
marrowyung
Asked:
marrowyung
  • 3
  • 3
1 Solution
 
DavidSenior Oracle Database AdministratorCommented:
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
 
marrowyungAuthor Commented:
"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
 
marrowyungAuthor Commented:
sorry the link is about RMAN, not about data guard, please help.
0
Nothing ever in the clear!

This technical paper will help you implement VMware’s VM encryption as well as implement Veeam encryption which together will achieve the nothing ever in the clear goal. If a bad guy steals VMs, backups or traffic they get nothing.

 
DavidSenior Oracle Database AdministratorCommented:
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
 
DavidSenior Oracle Database AdministratorCommented:
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
 
marrowyungAuthor Commented:
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 Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now