• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General
Home » Oracle » Oracle Database » how to Flashback when we have dataguard

how to Flashback when we have dataguard

June 19, 2012 by techgoeasy Leave a Comment


We generally have Dataguard in the Production env and for some reason  if we have to flashback Production,then below steps could be used which will keep the standby in the Sync
1. Disable Log Transport Services to the Standby Database On Primary database
alter system set log_archive_dest_state_n = ‘defer’ scope=both;

2. Perform a Log Switch on all Primary Database Instances
alter system switch logfile;

3. Stop Managed Recovery on the Standby Database using SQL*PLUS

alter database recover managed standby database cancel;

4. Shutdown the Primary database and startup in mount state
shutdown immediate
startup mount

5. Flashback the Primary Database to the desired Restore Point and open the database with resetlogs
flashback database to restore point ;
alter database open resetlogs;

6. Flashback the Standby Database to the desired Restore Point:

flashback database to restore point ;

7. Enable Log Transport Services to the Standby Database

On  Primary database,
alter system set log_archive_dest_state_n = ‘enable’ scope=both;

8. Perform a Log Switch on all Primary Database Instances
alter system switch logfile;

9. Once Log Transport Services are running again you can enable Managed Recovery on the Standby Database:
alter database recover managed standby database using current logfile disconnect

10.Verify the Standby Database is now following the Primary Database into the new Incarnation


Filed Under: Oracle, Oracle Database Tagged With: how to Flashback when we have dataguard

Reader Interactions

Leave a Reply Cancel reply

Primary Sidebar

Top Posts & Pages

  • How to check Tablespace in Oracle -Size ,Free space,datafiles ,growth
  • how to check all constraints on a table in oracle
  • Oracle dba interview questions and answers
  • Oracle Indexes and types of indexes in oracle with example
  • Query to check table size in Oracle database



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to run Autoconfig on Patch system in R12.2
  • Admin scripts in R12.2 Ebuisness Suite
  • Timezone settings in Oracle database
  • how to enable trace in oracle apps r12
  • Transparent Data Encryption Queries

Copyright © 2021 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us