您好,登錄后才能下訂單哦!
今天就跟大家聊聊有關(guān)oracle11g RAC啟動(dòng)歸檔模式的示例分析,可能很多人都不太了解,為了讓大家更加了解,小編給大家總結(jié)了以下內(nèi)容,希望大家根據(jù)這篇文章可以有所收獲。
根據(jù)客戶要求,需要將歸檔日志存放在ASM上。因此需要在ASM建歸檔路徑
ASMCMD> mkdir arch
ASMCMD> cd arch
ASMCMD> pwd
+data1/kdcs/arch
修改歸檔路徑參數(shù)
SQL> alter system set log_archive_dest_1='location=+data1/kdcs/arch' scope=spfile sid='*';
System altered.
關(guān)閉數(shù)據(jù)庫(kù),全部節(jié)點(diǎn)都要關(guān)閉
[grid@zhcs-db1 ~]$ srvctl stop database -d kdcs
檢查數(shù)據(jù)庫(kù)關(guān)閉后狀態(tài)
[grid@zhcs-db1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.LISTENER.lsnr
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.OCR_DISK.dg
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.asm
ONLINE ONLINE zhcs-db1 Started
ONLINE ONLINE zhcs-db2 Started
ora.gsd
OFFLINE OFFLINE zhcs-db1
OFFLINE OFFLINE zhcs-db2
ora.net1.network
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.ons
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.registry.acfs
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE zhcs-db1
ora.cvu
1 OFFLINE OFFLINE
ora.kdcs.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.kdcs.ser_scanip.svc
1 OFFLINE OFFLINE
2 OFFLINE OFFLINE
ora.oc4j
1 ONLINE ONLINE zhcs-db2
ora.scan1.vip
1 ONLINE ONLINE zhcs-db1
ora.zhcs-db1.vip
1 ONLINE ONLINE zhcs-db1
ora.zhcs-db2.vip
1 ONLINE ONLINE zhcs-db2
將一個(gè)節(jié)點(diǎn)數(shù)據(jù)庫(kù)啟動(dòng)到mount狀態(tài)
[grid@zhcs-db1 ~]$ srvctl start instance -d kdcs -i kdcs1 -o mount
修改數(shù)據(jù)庫(kù)的歸檔模式并啟動(dòng)數(shù)據(jù)庫(kù)
SQL> alter database archivelog;
Database altered.
SQL> alter database open;
Database altered.
檢查狀態(tài)
SQL> archive log list;
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +DATA1/kdcs/arch
Oldest online log sequence 86
Next log sequence to archive 87
Current log sequence 87
SQL>
啟動(dòng)2節(jié)點(diǎn)數(shù)據(jù)庫(kù)
[grid@zhcs-db1 ~]$ srvctl start instance -d kdcs -i kdcs2
檢查集群狀態(tài)
[grid@zhcs-db1 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA1.dg
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.LISTENER.lsnr
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.OCR_DISK.dg
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.asm
ONLINE ONLINE zhcs-db1 Started
ONLINE ONLINE zhcs-db2 Started
ora.gsd
OFFLINE OFFLINE zhcs-db1
OFFLINE OFFLINE zhcs-db2
ora.net1.network
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.ons
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
ora.registry.acfs
ONLINE ONLINE zhcs-db1
ONLINE ONLINE zhcs-db2
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE zhcs-db1
ora.cvu
1 OFFLINE OFFLINE
ora.kdcs.db
1 ONLINE ONLINE zhcs-db1 Open
2 ONLINE ONLINE zhcs-db2 Open
ora.kdcs.ser_scanip.svc
1 ONLINE ONLINE zhcs-db1
2 ONLINE ONLINE zhcs-db2
ora.oc4j
1 ONLINE ONLINE zhcs-db2
ora.scan1.vip
1 ONLINE ONLINE zhcs-db1
ora.zhcs-db1.vip
1 ONLINE ONLINE zhcs-db1
ora.zhcs-db2.vip
1 ONLINE ONLINE zhcs-db2
[grid@zhcs-db1 ~]$
看完上述內(nèi)容,你們對(duì)oracle11g RAC啟動(dòng)歸檔模式的示例分析有進(jìn)一步的了解嗎?如果還想了解更多知識(shí)或者相關(guān)內(nèi)容,請(qǐng)關(guān)注億速云行業(yè)資訊頻道,感謝大家的支持。
免責(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)容。