InstallationOracle11gR2RAC---修改在線日志
連接數(shù)據(jù)庫(kù)服務(wù)器，查詢現(xiàn)有在線日志組信息并添加在線日志組。
成都創(chuàng)新互聯(lián)公司專(zhuān)注于建水企業(yè)網(wǎng)站建設(shè),自適應(yīng)網(wǎng)站建設(shè),成都做商城網(wǎng)站。建水網(wǎng)站建設(shè)公司,為建水等地區(qū)提供建站服務(wù)。全流程定制網(wǎng)站開(kāi)發(fā)，專(zhuān)業(yè)設(shè)計(jì)，全程項(xiàng)目跟蹤，成都創(chuàng)新互聯(lián)公司專(zhuān)業(yè)和態(tài)度為您提供的服務(wù)
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.4.0
Connected as system
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- ------------------------------------------------- ---------------------
2 ONLINE +DATA/oracle/onlinelog/group_2.262.900549871 NO
2 ONLINE +FRA/oracle/onlinelog/group_2.258.900549873 YES
1 ONLINE +DATA/oracle/onlinelog/group_1.261.900549865 NO
1 ONLINE +FRA/oracle/onlinelog/group_1.257.900549867 YES
3 ONLINE +DATA/oracle/onlinelog/group_3.265.900550437 NO
3 ONLINE +FRA/oracle/onlinelog/group_3.259.900550441 YES
4 ONLINE +DATA/oracle/onlinelog/group_4.266.900550445 NO
4 ONLINE +FRA/oracle/onlinelog/group_4.260.900550449 YES
8 rows selected
添加新的日志組文件
SQL> alter database add logfile thread 1 group 5 ('+DATA/oracle/onlinelog/group5','+FRA/oracle/onlinelog/group5') size 200M;
Database altered
SQL> alter database add logfile thread 2 group 6 ('+DATA/oracle/onlinelog/group6','+FRA/oracle/onlinelog/group6') size 200M;
Database altered
SQL> alter database add logfile thread 1 group 7 ('+DATA/oracle/onlinelog/group7','+FRA/oracle/onlinelog/group7') size 200M;
Database altered
SQL> alter database add logfile thread 2 group 8 ('+DATA/oracle/onlinelog/group8','+FRA/oracle/onlinelog/group8') size 200M;
Database altered
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- ----------------------------------------------- ---------------------
2 ONLINE +DATA/oracle/onlinelog/group_2.262.900549871 NO
2 ONLINE +FRA/oracle/onlinelog/group_2.258.900549873 YES
1 ONLINE +DATA/oracle/onlinelog/group_1.261.900549865 NO
1 ONLINE +FRA/oracle/onlinelog/group_1.257.900549867 YES
3 ONLINE +DATA/oracle/onlinelog/group_3.265.900550437 NO
3 ONLINE +FRA/oracle/onlinelog/group_3.259.900550441 YES
4 ONLINE +DATA/oracle/onlinelog/group_4.266.900550445 NO
4 ONLINE +FRA/oracle/onlinelog/group_4.260.900550449 YES
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
16 rows selected
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 1 NO CURRENT
1 2 YES INACTIVE
2 3 YES INACTIVE
2 4 NO CURRENT
1 5 YES UNUSED
2 6 YES UNUSED
1 7 YES UNUSED
2 8 YES UNUSED
8 rows selected
切換日志
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> alter system switch logfile;
System altered
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 1 YES ACTIVE
1 2 YES ACTIVE
2 3 YES INACTIVE
2 4 YES ACTIVE
1 5 NO CURRENT
2 6 YES ACTIVE
1 7 YES INACTIVE
2 8 NO CURRENT
8 rows selected
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- ----------------------------------------------- ---------------------
2 ONLINE +DATA/oracle/onlinelog/group_2.262.900549871 NO
2 ONLINE +FRA/oracle/onlinelog/group_2.258.900549873 YES
1 ONLINE +DATA/oracle/onlinelog/group_1.261.900549865 NO
1 ONLINE +FRA/oracle/onlinelog/group_1.257.900549867 YES
3 ONLINE +DATA/oracle/onlinelog/group_3.265.900550437 NO
3 ONLINE +FRA/oracle/onlinelog/group_3.259.900550441 YES
4 ONLINE +DATA/oracle/onlinelog/group_4.266.900550445 NO
4 ONLINE +FRA/oracle/onlinelog/group_4.260.900550449 YES
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
16 rows selected
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 1 YES INACTIVE
1 2 YES INACTIVE
2 3 YES INACTIVE
2 4 YES INACTIVE
1 5 NO CURRENT
2 6 YES INACTIVE
1 7 YES INACTIVE
2 8 NO CURRENT
8 rows selected
刪除原有在線日志組，同時(shí)物理文件也會(huì)自動(dòng)刪除。
SQL> alter database drop logfile group 1;
Database altered
SQL> alter database drop logfile group 2;
Database altered
SQL> alter database drop logfile group 3;
Database altered
SQL> alter database drop logfile group 4;
Database altered
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 5 NO CURRENT
2 6 YES INACTIVE
1 7 YES INACTIVE
2 8 NO CURRENT
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- --------------------------------- ---------------------
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
8 rows selected
SQL> /
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- -------------------------------- ---------------------
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
8 rows selected
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 5 NO CURRENT
2 6 YES INACTIVE
1 7 YES INACTIVE
2 8 NO CURRENT
SQL> alter system switch logfile;
System altered
SQL> /
System altered
SQL> /
System altered
SQL> /
System altered
SQL> /
System altered
SQL> select * from v$logfile;
GROUP# STATUS TYPE MEMBER IS_RECOVERY_DEST_FILE
---------- ------- ------- --------------------------------- ---------------------
5 ONLINE +DATA/oracle/onlinelog/group5 NO
5 ONLINE +FRA/oracle/onlinelog/group5 NO
6 ONLINE +DATA/oracle/onlinelog/group6 NO
6 ONLINE +FRA/oracle/onlinelog/group6 NO
7 ONLINE +DATA/oracle/onlinelog/group7 NO
7 ONLINE +FRA/oracle/onlinelog/group7 NO
8 ONLINE +DATA/oracle/onlinelog/group8 NO
8 ONLINE +FRA/oracle/onlinelog/group8 NO
8 rows selected
SQL> select thread#,group#,archived,status from v$log;
THREAD# GROUP# ARCHIVED STATUS
---------- ---------- -------- ----------------
1 5 YES ACTIVE
2 6 NO CURRENT
1 7 NO CURRENT
2 8 YES ACTIVE
SQL>
網(wǎng)站標(biāo)題：InstallationOracle11gR2RAC---修改在線日志
分享路徑：http://www.rwnh.cn/article0/gsjhio.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供外貿(mào)建站、微信公眾號(hào)、、品牌網(wǎng)站建設(shè)、自適應(yīng)網(wǎng)站、企業(yè)網(wǎng)站制作
聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉(zhuǎn)載內(nèi)容為主，如果涉及侵權(quán)請(qǐng)盡快告知，我們將會(huì)在第一時(shí)間刪除。文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng)，如需處理請(qǐng)聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉(zhuǎn)載，或轉(zhuǎn)載時(shí)需注明來(lái)源： 創(chuàng)新互聯(lián)
- 如何區(qū)別動(dòng)態(tài)網(wǎng)站和靜態(tài)網(wǎng)站以及他們的特點(diǎn) 2021-05-25
- 動(dòng)態(tài)網(wǎng)站是什么？動(dòng)態(tài)好還是靜態(tài)好 2014-12-09
- 動(dòng)態(tài)網(wǎng)頁(yè)是什么？4種動(dòng)態(tài)網(wǎng)站技術(shù)介紹 2022-09-01
- 生成靜態(tài)之靜態(tài)緩存和動(dòng)態(tài)緩存 2016-10-30
- 大型網(wǎng)站動(dòng)態(tài)運(yùn)用體系架構(gòu)淺析 2016-12-07
- 公司網(wǎng)站制作有關(guān)動(dòng)態(tài)網(wǎng)站的制作方法 2016-08-21
- 網(wǎng)站制作動(dòng)態(tài)網(wǎng)站與靜態(tài)網(wǎng)頁(yè)的優(yōu)劣勢(shì)對(duì)比 2023-01-22
- 動(dòng)態(tài)內(nèi)容的平衡有妙招！ 2014-02-21
- 網(wǎng)站建設(shè)基礎(chǔ)知識(shí)之靜態(tài)和動(dòng)態(tài)網(wǎng)站（一） 2016-09-16
- 網(wǎng)站安全措施應(yīng)該選擇什么樣的動(dòng)態(tài)程序和相應(yīng)的數(shù)據(jù)庫(kù) 2016-12-28
- ?網(wǎng)站制作動(dòng)態(tài)、靜態(tài)頁(yè)面哪種合適 2016-09-27
- 網(wǎng)站托管所說(shuō)的動(dòng)態(tài)網(wǎng)站是什么？ 2016-07-28