欧美一区二区三区老妇人-欧美做爰猛烈大尺度电-99久久夜色精品国产亚洲a-亚洲福利视频一区二区

11gRAC歸檔與非歸檔的切換

11g RAC 歸檔與非歸檔的切換

非歸檔------->歸檔
1.設置歸檔路徑
SYS@rac1> alter system set log_archive_dest_1='LOCATION=+fra' scope=both sid='rac1';
SYS@rac2> alter system set log_archive_dest_1='LOCATION=+fra' scope=both sid='rac2';

2.關閉所有實例
shutdown immediate

3.設置歸檔
SYS@rac1> startup mount
SYS@rac1> alter database archivelog;

4.打開數(shù)據(jù)庫
SYS@rac1> alter database open;

5。兩個節(jié)點驗證
節(jié)點1
SYS@rac1> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA
Oldest online log sequence 25
Next log sequence to archive 26
Current log sequence 26

節(jié)點2
SYS@rac2> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination +FRA
Oldest online log sequence 29
Next log sequence to archive 30
Current log sequence 30

6.查看歸檔文件
ASMCMD [+FRA/rac/archivelog/2018_03_23] > ls
thread_1_seq_26.263.971545091
thread_2_seq_29.261.971544421
thread_2_seq_30.262.971545055

歸檔------->非歸檔
1關閉數(shù)據(jù)庫
[oracle@rac1 ~]$ srvctl stop database -d rac

2.其中一個節(jié)點操作
SYS@rac1> startup mount;
SYS@rac1> alter database noarchivelog;
SYS@rac1> alter database open;

3.驗證
SYS@rac1> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +FRA
Oldest online log sequence 26
Current log sequence 27

SYS@rac2> archive log list
Database log mode No Archive Mode
Automatic archival Disabled
Archive destination +FRA
Oldest online log sequence 31
Current log sequence 32

使用rman 刪除歸檔
[oracle@rac1 ~]$ rman target /
RMAN> delete archivelog all;

ASMCMD [+fra/rac] > ls
CONTROLFILE/
ONLINELOG/
已經(jīng)刪除









網(wǎng)頁名稱：11gRAC歸檔與非歸檔的切換
當前鏈接：http://chinadenli.net/article2/gjdeoc.html

成都網(wǎng)站建設公司_創(chuàng)新互聯(lián)，為您提供網(wǎng)頁設計公司、營銷型網(wǎng)站建設、網(wǎng)站營銷、網(wǎng)站建設、建站公司、網(wǎng)站排名

廣告

聲明：本網(wǎng)站發(fā)布的內(nèi)容（圖片、視頻和文字）以用戶投稿、用戶轉載內(nèi)容為主，如果涉及侵權請盡快告知，我們將會在第一時間刪除。文章觀點不代表本網(wǎng)站立場，如需處理請聯(lián)系客服。電話：028-86922220；郵箱：631063699@qq.com。內(nèi)容未經(jīng)允許不得轉載，或轉載時需注明來源： 創(chuàng)新互聯(lián)

成都定制網(wǎng)站網(wǎng)頁設計