OracleRMAN備份深入解析--聯(lián)機(jī)備份
Oracle RMAN備份深入解析--聯(lián)機(jī)備份
我們提供的服務(wù)有：成都網(wǎng)站制作、網(wǎng)站建設(shè)、微信公眾號(hào)開發(fā)、網(wǎng)站優(yōu)化、網(wǎng)站認(rèn)證、蕭山ssl等。為超過千家企事業(yè)單位解決了網(wǎng)站和推廣的問題。提供周到的售前咨詢和貼心的售后服務(wù)，是有科學(xué)管理、有技術(shù)的蕭山網(wǎng)站制作公司
RMAN> backup database plus archivelog;
此命令將觸發(fā)以下操作：
1、首先，進(jìn)程使用alter system archivelog current命令完成了日志切換操作。
2、進(jìn)程將現(xiàn)存所有歸檔重做日志備份
3、開始執(zhí)行實(shí)際的數(shù)據(jù)庫備份操作，此時(shí)會(huì)發(fā)生一次日志切換（alter system archivelog current），同時(shí)RMAN備份剩余的歸檔重做日志（使用backup archivelog all命令）。
4、執(zhí)行控制文件和服務(wù)器參數(shù)文件的自動(dòng)備份操作。
案例：
1、查看備份前的日志信息
17:13:50 SYS@ prod>select group#,sequence#,thread#,status from v$log; GROUP# SEQUENCE# THREAD# STATUS ---------- ---------- ---------- ---------------- 1 16 1 CURRENT 2 14 1 INACTIVE 3 15 1 INACTIVE Elapsed: 00:00:00.05
2、執(zhí)行備份
RMAN> backup database plus archivelog; Starting backup at 03-JUL-14 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=13 RECID=41 STAMP=851966028 input archived log thread=1 sequence=14 RECID=42 STAMP=851966028 input archived log thread=1 sequence=15 RECID=43 STAMP=851966030 input archived log thread=1 sequence=16 RECID=44 STAMP=851966141 channel ORA_DISK_1: starting piece 1 at 03-JUL-14 channel ORA_DISK_1: finished piece 1 at 03-JUL-14 piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0kpcfu5t_1_1 tag=TAG20140703T171541 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:04 Finished backup at 03-JUL-14 Starting backup at 03-JUL-14 using channel ORA_DISK_1 channel ORA_DISK_1: starting full datafile backup set channel ORA_DISK_1: specifying datafile(s) in backup set input datafile file number=00001 name=/u01/app/oracle/oradata/prod/system01.dbf input datafile file number=00002 name=/u01/app/oracle/oradata/prod/sysaux01.dbf input datafile file number=00008 name=/u01/app/oracle/oradata/prod/perftbs01.dbf input datafile file number=00004 name=/u01/app/oracle/oradata/prod/users01.dbf input datafile file number=00005 name=/u01/app/oracle/oradata/prod/example01.dbf input datafile file number=00007 name=/u01/app/oracle/oradata/prod/undotbs2.dbf input datafile file number=00006 name=/u01/app/oracle/oradata/prod/tbs1.dbf input datafile file number=00003 name=/u01/app/oracle/oradata/prod/undotbs1.dbf channel ORA_DISK_1: starting piece 1 at 03-JUL-14 channel ORA_DISK_1: finished piece 1 at 03-JUL-14 piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0lpcfu61_1_1 tag=TAG20140703T171545 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:01:26 Finished backup at 03-JUL-14 Starting backup at 03-JUL-14 current log archived using channel ORA_DISK_1 channel ORA_DISK_1: starting archived log backup set channel ORA_DISK_1: specifying archived log(s) in backup set input archived log thread=1 sequence=17 RECID=45 STAMP=851966231 channel ORA_DISK_1: starting piece 1 at 03-JUL-14 channel ORA_DISK_1: finished piece 1 at 03-JUL-14 piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/0mpcfu8o_1_1 tag=TAG20140703T171712 comment=NONE channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01 Finished backup at 03-JUL-14 Starting Control File and SPFILE Autobackup at 03-JUL-14 piece handle=/u01/app/oracle/product/11.2.0/db_1/dbs/c-239333010-20140703-00 comment=NONE Finished Control File and SPFILE Autobackup at 03-JUL-14
3、查看告警日志
[oracle@rh7 ~]$ tail -f /u01/app/oracle/diag/rdbms/prod/prod/trace/alert_prod.log
Current log# 1 seq# 16 mem# 1: /dsk2/oradata/prod/redo01b.log
Thu Jul 03 17:13:50 2014
Archived Log entry 43 added for thread 1 sequence 15 ID 0xfaf1e60 dest 2:
Thu Jul 03 17:15:41 2014
ALTER SYSTEM ARCHIVE LOG
Thu Jul 03 17:15:41 2014
Thread 1 advanced to log sequence 17 (LGWR switch)
Current log# 2 seq# 17 mem# 0: /dsk1/oradata/prod/redo02a.log
Current log# 2 seq# 17 mem# 1: /dsk2/oradata/prod/redo02b.log
Archived Log entry 44 added for thread 1 sequence 16 ID 0xfaf1e60 dest 2:
Thu Jul 03 17:17:11 2014
ALTER SYSTEM ARCHIVE LOG
Thu Jul 03 17:17:11 2014
Thread 1 advanced to log sequence 18 (LGWR switch)
Current log# 3 seq# 18 mem# 0: /dsk1/oradata/prod/redo03a.log
Current log# 3 seq# 18 mem# 1: /dsk2/oradata/prod/redo03b.log
Archived Log entry 45 added for thread 1 sequence 17 ID 0xfaf1e60 dest 2:
4、備份后的日志切換信息
17:13:56 SYS@ prod>select group#,sequence#,thread#,status from v$log; GROUP# SEQUENCE# THREAD# STATUS ---------- ---------- ---------- ---------------- 1 16 1 INACTIVE 2 17 1 ACTIVE 3 18 1 CURRENT Elapsed: 00:00:00.01
5、查看備份信息
RMAN> list backup of database; List of Backup Sets =================== BS Key Type LV Size Device Type Elapsed Time Completion Time ------- ---- -- ---------- ----------- ------------ --------------- 17 Full 1.13G DISK 00:01:21 03-JUL-14 BP Key: 17 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171545 Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0lpcfu61_1_1 List of Datafiles in backup set 17 File LV Type Ckp SCN Ckp Time Name ---- -- ---- ---------- --------- ---- 1 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/system01.dbf 2 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/sysaux01.dbf 3 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs1.dbf 4 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/users01.dbf 5 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/example01.dbf 6 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/tbs1.dbf 7 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/undotbs2.dbf 8 Full 2066885 03-JUL-14 /u01/app/oracle/oradata/prod/perftbs01.dbf RMAN> list backup of archivelog all; List of Backup Sets =================== BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 16 31.11M DISK 00:00:01 03-JUL-14 BP Key: 16 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171541 Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0kpcfu5t_1_1 List of Archived Logs in backup set 16 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 13 2051289 03-JUL-14 2066660 03-JUL-14 1 14 2066660 03-JUL-14 2066663 03-JUL-14 1 15 2066663 03-JUL-14 2066666 03-JUL-14 1 16 2066666 03-JUL-14 2066878 03-JUL-14 BS Key Size Device Type Elapsed Time Completion Time ------- ---------- ----------- ------------ --------------- 18 104.00K DISK 00:00:00 03-JUL-14 BP Key: 18 Status: AVAILABLE Compressed: NO Tag: TAG20140703T171712 Piece Name: /u01/app/oracle/product/11.2.0/db_1/dbs/0mpcfu8o_1_1 List of Archived Logs in backup set 18 Thrd Seq Low SCN Low Time Next SCN Next Time ---- ------- ---------- --------- ---------- --------- 1 17 2066878 03-JUL-14 2066956 03-JUL-14
分享題目：OracleRMAN備份深入解析--聯(lián)機(jī)備份
本文來源：http://bm7419.com/article10/ijhjgo.html
成都網(wǎng)站建設(shè)公司_創(chuàng)新互聯(lián)，為您提供做網(wǎng)站、網(wǎng)站營銷、網(wǎng)站設(shè)計(jì)公司、動(dòng)態(tài)網(wǎng)站、虛擬主機(jī)、服務(wù)器托管
聲明：本網(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í)需注明來源： 創(chuàng)新互聯(lián)
- 為什么要建設(shè)響應(yīng)式網(wǎng)站 2023-04-09
- RWD響應(yīng)式網(wǎng)站的優(yōu)點(diǎn)有哪些？ 2023-02-22
- 做網(wǎng)站為什么要選擇做響應(yīng)式網(wǎng)站 2022-08-24
- 響應(yīng)式網(wǎng)站常見的布局是什么？ 2014-12-10
- 響應(yīng)式網(wǎng)站建設(shè)有什么特點(diǎn) 2022-09-20
- 響應(yīng)式網(wǎng)站該如何建設(shè)? 2023-01-28
- 響應(yīng)式網(wǎng)站如何兼顧設(shè)計(jì)和營銷型 2023-02-07
- 響應(yīng)式網(wǎng)站設(shè)計(jì)要注意什么問題? 2020-08-19
- 淺析自適應(yīng)網(wǎng)站和響應(yīng)式網(wǎng)站的不同 2021-05-11
- 濟(jì)南響應(yīng)式網(wǎng)站建設(shè)有助于用戶體驗(yàn) 2021-11-24
- 響應(yīng)式網(wǎng)站設(shè)計(jì)的頂級(jí)SEO優(yōu)勢(shì)-中山建站 2016-08-31
- 響應(yīng)式網(wǎng)站H5頁面設(shè)計(jì)如何制作？ 2020-12-01