[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 272
  • 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
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
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

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

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