您好,登錄后才能下訂單哦!
最近一直在搭建ORACLE 12C ADG ,其中包括單機(jī)到單機(jī)的ADG, RAC到RAC的ADG,還有RAC到單機(jī)的ADG,遇到不少小問(wèn)題,在此做一下記錄。
Oracle 12c R1 RAC 修改啟動(dòng)方式
$srvctl modify database -d orcldg -s nomount orcldg為數(shù)據(jù)庫(kù)名
$srvctl modify database -d orcldg -s mount
$srvctl modify database -d orcldg -s open
置完DATAGUARD之后,默認(rèn)是mount,但是我們要求自動(dòng)啟動(dòng)成ADG模式,這里就需要做一個(gè)小小的改動(dòng)。
1.查看啟動(dòng)方式
$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.修改啟動(dòng)方式
$srvctl modify database -db orcldg -startoption open
3.在此驗(yàn)證啟動(dòng)方式
<orcldg:orcldg:/home/oracle>$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.啟動(dòng)數(shù)據(jù)庫(kù),查看open_mode 已經(jīng)啟動(dòng)為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>
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。