oracle11g RAC啟動(dòng)歸檔模式的示例分析

152次閱讀

共計(jì) 3610 個(gè)字符，預(yù)計(jì)需要花費(fèi) 10 分鐘才能閱讀完成。

今天就跟大家聊聊有關(guān) oracle11g RAC 啟動(dòng)歸檔模式的示例分析，可能很多人都不太了解，為了讓大家更加了解，丸趣 TV 小編給大家總結(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 ~]$