最近一直在搭建ORACLE 12C ADG ，其中包括單機到單機的ADG, RAC到RAC的ADG，還有RAC到單機的ADG，遇到不少小問題，在此做一下記錄。

成都創新互聯主要從事成都網站建設、成都做網站、網頁設計、企業做網站、公司建網站等業務。立足成都服務南寧,10多年網站建設經驗,價格優惠、服務專業,歡迎來電咨詢建站服務:18980820575

Oracle 12c R1 RAC 修改啟動方式

$srvctl modify database -d orcldg -s nomount  orcldg為數據庫名

$srvctl modify database -d orcldg -s mount  

$srvctl modify database -d orcldg -s open  

置完DATAGUARD之后，默認是mount，但是我們要求自動啟動成ADG模式，這里就需要做一個小小的改動。

1.查看啟動方式

$srvctl config database -d orcldg

Database unique name: orcldg

Database name:

Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1

Oracle user: oracle

Spfile: +DATADG/orcldg/spfileorcldg.ora

Password file: +DATADG/orcldg/PASSWORD/pworcldg

Domain:

Start options: mount

Stop options: immediate

Database role: PHYSICAL_STANDBY

Management policy: AUTOMATIC

Disk Groups: DATADG

Services:

OSDBA group:

OSOPER group:

Database instance: orcldg

 2.修改啟動方式

$srvctl modify database -db orcldg -startoption open

3.在此驗證啟動方式

$srvctl config database -d orcldg

Database unique name: orcldg

Database name:

Oracle home: /u01/app/oracle/product/12.1.0/dbhome_1

Oracle user: oracle

Spfile: +DATADG/orcldg/spfileorcldg.ora

Password file: +DATADG/orcldg/PASSWORD/pworcldg

Domain:

Start options: open

Stop options: immediate

Database role: PHYSICAL_STANDBY

Management policy: AUTOMATIC

Disk Groups: DATADG

Services:

OSDBA group:

OSOPER group:

Database instance: orcldg

4.啟動數據庫，查看open_mode 已經啟動為ADG模式了

SQL> startup

ORACLE instance started.

Total System Global Area 1174405120 bytes

Fixed Size                  2923680 bytes

Variable Size             436208480 bytes

Database Buffers          721420288 bytes

Redo Buffers               13852672 bytes

Database mounted.

Database opened.

SQL> select open_mode from v$database;

OPEN_MODE

--------------------

READ ONLY WITH APPLY

SQL>