Shulou(Shulou.com)06/01 Report--

Using flashback database (flashback) to repair the DG environment after Failover

1.1 BLOG document structure map

1.2Preface 1.2.1 introduction and precautions for technical enthusiasts, after reading this article, you can master the following skills, and you can also learn some other knowledge that you do not know, ~ O (∩ _ ∩) obsession:

Recovery methods of DG Environment after ① Failover (key points)

Basic maintenance operations of ② DG

Installation of ③ GC client software

④ uses GC to quickly build a set of DG environment

The difference between ⑤ Failover and Switchover

⑥ other maintenance operations

After finishing the OCM exam on October 23 and 24, I feel that the rule of passing is "real questions + more practice". After practicing for more than 10 times, I can basically pass the exam. OCM exam content in addition to GC this piece of wheat seedlings have not been touched, the other content is basically familiar. Basic commands are memorized by heart, and unfamiliar commands can immediately find official documentation and make good use of OEM and SQL Developer tools. Therefore, friends who want to pass the OCM exam quickly can contact Mai Miao privately, and Mai Miao will teach you all his experience.

All right, no more nonsense. Recently, in the DBA Baodian WeChat group of wheat seedlings, friends asked how to restore to the original DG environment after the Failover operation. Wheat seedlings probably know that flashbacks can be used to achieve this problem, but they have not done experiments, or they have done experiments, but they have not recorded documents. Anyway, they are too old to remember. All right, let's just take a moment to do this experiment recently. If there is something wrong, please still point out.

1.4 related knowledge points Literacy ① Switchover switching of physical DG: http://blog.itpub.net/26736162/viewspace-1753111/

Failover switching of ② physical DG: http://blog.itpub.net/26736162/viewspace-1753130/

③ uses flashback database (flashback) to repair the DG environment after Failover: http://blog.itpub.net/26736162/viewspace-2146883/

The difference between ④ Switchover and Failover: http://blog.itpub.net/26736162/viewspace-2141207/

-Chapter 2 Experimental preparation 2.2.The experimental environment introduces the experimental environment as the virtual machine environment for practicing OCM:

Project

Source DB

Target DB

DB Typ

Single machine

Single machine

DB VERSION

11.2.0.3.0

11.2.0.3.0

DB storage

FS

FS

OS version and kernel version

OEL linux 5.4 32

OEL linux 5.4 32

DB_NAME

PROD1

PROD1

ORACLE_SID

PROD1

SBDB1

ORACLE_HOME

/ u01/app/oracle/product/11.2.0/dbhome_1

/ u01/app/oracle/product/11.2.0/db_1

Hosts file

10.190.104.111 edsir4p1.us.oracle.com edsir4p1

10.190.104.28 edsir1p8.us.oracle.com edsir1p8

2.2 after the implementation of FAILOVER in the experimental target database, the DG environment is restored by flashback database technology without having to rebuild DG.

2.3 Experimental process

2.4 using GC to quickly build DG environment the DG environment for wheat seedlings is on a host, and the test is inconvenient. As it happens, the environment for practicing OCM is still there recently, so let's do this experiment with the environment for practicing OCM. If you already have a DG environment, you can skip this section.

For the full text, please refer to: http://blog.itpub.net/26736162/viewspace-2146883/

The fifth chapter is the summary of the experiment. 1. After the main library turns on the flashback database function, the standby database will not turn on the flashback database function.

2. PROD1 is the primary library and SBDB1 is the standby library. If PROD1 goes down unexpectedly, SBDB1 becomes the primary database by performing Failover operations. If you want to restore the DG environment, there are three ways to deal with it:

① flashes PROD1 back to the SCN point in time when SBDB1 became the primary database using the flashback database function, then converts PROD1 into a standby library, and finally uses switchover to transform it into the original environment.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.