Oracle 19c使用dbca来搭建物理DG

Using DBCA to Create a Data Guard Standby

The Database Configuration Assistant (DBCA) can also be used as a simple command-line method to create an Oracle Data Guard physical standby database.

The DBCA command qualifier used to create the physical standby database is createDuplicateDB .

DBCA can only be used to create standby databases for non-multitenant primary databases. In addition, this capability creates only single instance standby databases,not Oracle Real Application Clusters (Oracle RAC) databases. If required, the standby can then be converted to an Oracle RAC standby database, either manually or using Oracle Enterprise Manager Cloud Control.

在 12cR2 （ 12.2.0.1 ）之前创建物理备库的方法有：

1 、使用 RMAN 备份恢复方法；

2 、在 11g 时可以选择 duplicate 方式创建物理备库；通过这种方式直接在线从主库搭建物理备库。

到 12cR2 （ 12.2.0.1 ）后， Oracle 又提供更简单的方式来创建物理备库，即使用 DBCA 方式直接建立物理备库。这个功能再次简化了创建备库的复杂度。

通过 DBCA 提供的参数 createDuplicateDB 可以很容易的搭建一个物理备库。其具体语法如下：

1

2

3

4

5

6

7

8

9

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

58

59

60

61

62

63

64

65

66

67

68

69

70

-------------- 12cR2

-createDuplicateDB - Command to Duplicate a database.

        -gdbName 

        -primaryDBConnectionString 

        -sid 

        [-initParams ]

                [-initParamsEscapeChar ]

        [-policyManaged | -adminManaged]

        [-policyManaged ]

                -serverPoolName 

                [-pqPoolName ]

                [-createServerPool ]

                        [-pqPoolName ]

                        [-forceServerPoolCreation ]

                        [-pqCardinality ]

                        [-cardinality ]

        [-adminManaged ]

        [-datafileDestination ]

        [-nodelist ]

        [-databaseConfigType ]

                [-RACOneNodeServiceName ]

        [-createAsStandby ]

                [-dbUniqueName ]

        [-customScripts ]

  

  

  

  

----------- 19c

  

-createDuplicateDB - Command to Duplicate a database.

        -gdbName 

        -primaryDBConnectionString