[20151207]不斷應用日誌.txt
[20151207]不斷應用日誌.txt
--許多講rman的書都提到這個類似的指令碼:
RUN {
RECOVER COPY OF DATABASE WITH TAG 'incr_update';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' DATABASE format '/home/oracle/backup/%U';
}
--透過不斷的應用日誌(最好開啟塊跟蹤),減少切換事件,自己也測試看看，先刪除備份再測試：
1.環境：
SCOTT@book> @ &r/ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.4.0 Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
RMAN> list copy ;
specification does not match any datafile copy in the repository
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
RMAN> list backup;
specification does not match any backup in the repository
2.先測試format '%b'是否有效：
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' datafile 5 format '/home/oracle/backup/%b';
Starting backup at 2015-12-07 09:26:37
using channel ORA_DISK_1
no parent backup or copy of datafile 5 found
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
output file name=/u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_example_c69r2f64_.dbf tag=INCR_UPDATE RECID=19 STAMP=897816398
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
Finished backup at 2015-12-07 09:26:40
RMAN> BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' datafile 5 format '/home/oracle/backup/%b';
Starting backup at 2015-12-07 09:26:44
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
channel ORA_DISK_1: starting piece 1 at 2015-12-07 09:26:44
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/07/2015 09:26:44
ORA-19715: invalid format b for generated name
ORA-27302: failure occurred at: slgpn
--可以發現這樣格式無效。
RMAN> list copy ;
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - ------------------- ---------- -------------------
19 5 A 2015-12-07 09:26:38 13212707504 2015-12-07 09:26:37
Name: /u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_example_c69r2f64_.dbf
Tag: INCR_UPDATE
RMAN> delete copy of database ;
released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: SID=134 device type=DISK
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - ------------------- ---------- -------------------
19 5 A 2015-12-07 09:26:38 13212707504 2015-12-07 09:26:37
Name: /u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_example_c69r2f64_.dbf
Tag: INCR_UPDATE
Do you really want to delete the above objects (enter YES or NO)? yes
deleted datafile copy
datafile copy file name=/u01/app/oracle/fast_recovery_area/BOOK/datafile/o1_mf_example_c69r2f64_.dbf RECID=19 STAMP=897816398
Deleted 1 objects
3.先建立as copy 備份
--要保持原來的檔名，必須先執行如下：
RMAN> backup as copy database format '/home/oracle/backup/%b';
Starting backup at 2015-12-07 09:29:45
using channel ORA_DISK_1
channel ORA_DISK_1: starting datafile copy
input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf
output file name=/home/oracle/backup/users01.dbf tag=TAG20151207T092945 RECID=20 STAMP=897816589
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:07
channel ORA_DISK_1: starting datafile copy
input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf
output file name=/home/oracle/backup/system01.dbf tag=TAG20151207T092945 RECID=21 STAMP=897816595
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf
output file name=/home/oracle/backup/sysaux01.dbf tag=TAG20151207T092945 RECID=22 STAMP=897816598
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
output file name=/home/oracle/backup/example01.dbf tag=TAG20151207T092945 RECID=23 STAMP=897816600
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting datafile copy
input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf
output file name=/home/oracle/backup/undotbs01.dbf tag=TAG20151207T092945 RECID=24 STAMP=897816603
channel ORA_DISK_1: datafile copy complete, elapsed time: 00:00:01
channel ORA_DISK_1: starting datafile copy
copying current control file
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/07/2015 09:30:03
ORA-19715: invalid format b for generated name
ORA-27302: failure occurred at: slgpn
continuing other job steps, job failed will not be re-run
channel ORA_DISK_1: starting full datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2015-12-07 09:30:03
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03009: failure of backup command on ORA_DISK_1 channel at 12/07/2015 09:30:03
ORA-19715: invalid format b for generated name
ORA-27302: failure occurred at: slgpn
--注意後面的錯誤並不重要，主要問題是格式%b無法建立spfile以及控制檔案的備份。
RMAN> list copy ;
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - ------------------- ---------- -------------------
21 1 A 2015-12-07 09:29:55 13212707624 2015-12-07 09:29:52
Name: /home/oracle/backup/system01.dbf
Tag: TAG20151207T092945
22 2 A 2015-12-07 09:29:58 13212707626 2015-12-07 09:29:56
Name: /home/oracle/backup/sysaux01.dbf
Tag: TAG20151207T092945
24 3 A 2015-12-07 09:30:03 13212707630 2015-12-07 09:30:02
Name: /home/oracle/backup/undotbs01.dbf
Tag: TAG20151207T092945
20 4 A 2015-12-07 09:29:49 13212707621 2015-12-07 09:29:45
Name: /home/oracle/backup/users01.dbf
Tag: TAG20151207T092945
23 5 A 2015-12-07 09:30:00 13212707628 2015-12-07 09:29:59
Name: /home/oracle/backup/example01.dbf
Tag: TAG20151207T092945
--可以發現現在的copy備份儲存的檔名與原來一樣。
4.轉換為0級備份：
catalog datafilecopy '/home/oracle/backup/system01.dbf' level 0 tag 'incr_update';
catalog datafilecopy '/home/oracle/backup/sysaux01.dbf' level 0 tag 'incr_update';
catalog datafilecopy '/home/oracle/backup/undotbs01.dbf' level 0 tag 'incr_update';
catalog datafilecopy '/home/oracle/backup/users01.dbf' level 0 tag 'incr_update';
catalog datafilecopy '/home/oracle/backup/example01.dbf' level 0 tag 'incr_update';
RMAN> list copy ;
specification does not match any control file copy in the repository
specification does not match any archived log in the repository
List of Datafile Copies
=======================
Key File S Completion Time Ckp SCN Ckp Time
------- ---- - ------------------- ---------- -------------------
25 1 A 2015-12-07 09:36:15 13212707624 2015-12-07 09:29:52
Name: /home/oracle/backup/system01.dbf
Tag: INCR_UPDATE
26 2 A 2015-12-07 09:36:15 13212707626 2015-12-07 09:29:56
Name: /home/oracle/backup/sysaux01.dbf
Tag: INCR_UPDATE
27 3 A 2015-12-07 09:36:15 13212707630 2015-12-07 09:30:02
Name: /home/oracle/backup/undotbs01.dbf
Tag: INCR_UPDATE
20 4 A 2015-12-07 09:29:49 13212707621 2015-12-07 09:29:45
Name: /home/oracle/backup/users01.dbf
Tag: TAG20151207T092945
28 5 A 2015-12-07 09:36:15 13212707628 2015-12-07 09:29:59
Name: /home/oracle/backup/example01.dbf
Tag: INCR_UPDATE
SCOTT@book> select file#, tag, incremental_level, name ,CHECKPOINT_CHANGE# from v$datafile_copy where deleted='NO' order by 1;
FILE# TAG INCREMENTAL_LEVEL NAME CHECKPOINT_CHANGE#
------------ -------------------------------- ----------------- -------------------------------------------------- ------------------
1 INCR_UPDATE 0 /home/oracle/backup/system01.dbf 13212707624
2 INCR_UPDATE 0 /home/oracle/backup/sysaux01.dbf 13212707626
3 INCR_UPDATE 0 /home/oracle/backup/undotbs01.dbf 13212707630
4 INCR_UPDATE 0 /home/oracle/backup/users01.dbf 13212707621
5 INCR_UPDATE 0 /home/oracle/backup/example01.dbf 13212707628
5.建立指令碼:
RUN {
RECOVER COPY OF DATABASE WITH TAG 'incr_update';
BACKUP INCREMENTAL LEVEL 1 FOR RECOVER OF COPY WITH TAG 'incr_update' DATABASE format '/home/oracle/backup/%U';
}
--不斷執行就可以保證日誌不斷應用到備份。
Starting recover at 2015-12-07 09:39:13
using channel ORA_DISK_1
no copy of datafile 1 found to recover
no copy of datafile 2 found to recover
no copy of datafile 3 found to recover
no copy of datafile 4 found to recover
no copy of datafile 5 found to recover
Finished recover at 2015-12-07 09:39:13
Starting backup at 2015-12-07 09:39:13
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf
input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf
input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 2015-12-07 09:39:14
channel ORA_DISK_1: finished piece 1 at 2015-12-07 09:39:17
piece handle=/home/oracle/backup/11qo76i2_1_1 tag=INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2015-12-07 09:39:18
channel ORA_DISK_1: finished piece 1 at 2015-12-07 09:39:19
piece handle=/home/oracle/backup/12qo76i5_1_1 tag=INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2015-12-07 09:39:19
$ ll | grep -v "dbf"
total 3121492
-rw-r----- 1 oracle oinstall 196608 2015-12-07 09:39:15 11qo76i2_1_1
-rw-r----- 1 oracle oinstall 10321920 2015-12-07 09:39:18 12qo76i5_1_1
SCOTT@book> select file#, tag, incremental_level, name ,CHECKPOINT_CHANGE# from v$datafile_copy where deleted='NO' order by 1;
FILE# TAG INCREMENTAL_LEVEL NAME CHECKPOINT_CHANGE#
------------ -------------------------------- ----------------- -------------------------------------------------- ------------------
1 INCR_UPDATE 0 /home/oracle/backup/system01.dbf 13212707624
2 INCR_UPDATE 0 /home/oracle/backup/sysaux01.dbf 13212707626
3 INCR_UPDATE 0 /home/oracle/backup/undotbs01.dbf 13212707630
4 INCR_UPDATE 0 /home/oracle/backup/users01.dbf 13212707621
5 INCR_UPDATE 0 /home/oracle/backup/example01.dbf 13212707628
--可以發現第1次因為沒有1級備份，日誌不應用。下次就ok了。
Starting recover at 2015-12-07 09:41:15
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental datafile backup set restore
channel ORA_DISK_1: specifying datafile copies to recover
recovering datafile copy file number=00001 name=/home/oracle/backup/system01.dbf
recovering datafile copy file number=00002 name=/home/oracle/backup/sysaux01.dbf
recovering datafile copy file number=00003 name=/home/oracle/backup/undotbs01.dbf
recovering datafile copy file number=00004 name=/home/oracle/backup/users01.dbf
recovering datafile copy file number=00005 name=/home/oracle/backup/example01.dbf
channel ORA_DISK_1: reading from backup piece /home/oracle/backup/11qo76i2_1_1
channel ORA_DISK_1: piece handle=/home/oracle/backup/11qo76i2_1_1 tag=INCR_UPDATE
channel ORA_DISK_1: restored backup piece 1
channel ORA_DISK_1: restore complete, elapsed time: 00:00:01
Finished recover at 2015-12-07 09:41:16
Starting backup at 2015-12-07 09:41:16
using channel ORA_DISK_1
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
input datafile file number=00004 name=/mnt/ramdisk/book/users01.dbf
input datafile file number=00001 name=/mnt/ramdisk/book/system01.dbf
input datafile file number=00002 name=/mnt/ramdisk/book/sysaux01.dbf
input datafile file number=00005 name=/mnt/ramdisk/book/example01.dbf
input datafile file number=00003 name=/mnt/ramdisk/book/undotbs01.dbf
channel ORA_DISK_1: starting piece 1 at 2015-12-07 09:41:16
channel ORA_DISK_1: finished piece 1 at 2015-12-07 09:41:19
piece handle=/home/oracle/backup/13qo76ls_1_1 tag=INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:03
channel ORA_DISK_1: starting incremental level 1 datafile backup set
channel ORA_DISK_1: specifying datafile(s) in backup set
including current control file in backup set
including current SPFILE in backup set
channel ORA_DISK_1: starting piece 1 at 2015-12-07 09:41:20
channel ORA_DISK_1: finished piece 1 at 2015-12-07 09:41:21
piece handle=/home/oracle/backup/14qo76lv_1_1 tag=INCR_UPDATE comment=NONE
channel ORA_DISK_1: backup set complete, elapsed time: 00:00:01
Finished backup at 2015-12-07 09:41:21
$ ll | grep -v "dbf"
total 3131808
-rw-r----- 1 oracle oinstall 196608 2015-12-07 09:39:15 11qo76i2_1_1
-rw-r----- 1 oracle oinstall 10321920 2015-12-07 09:39:18 12qo76i5_1_1
-rw-r----- 1 oracle oinstall 221184 2015-12-07 09:41:17 13qo76ls_1_1
-rw-r----- 1 oracle oinstall 10321920 2015-12-07 09:41:20 14qo76lv_1_1
--看來增量備份不能放在這個目錄，這樣比較混亂。
SCOTT@book> select file#, tag, incremental_level, name ,CHECKPOINT_CHANGE# from v$datafile_copy where deleted='NO' order by 1;
FILE# TAG INCREMENTAL_LEVEL NAME CHECKPOINT_CHANGE#
------------ -------------------------------- ----------------- -------------------------------------------------- ------------------
1 INCR_UPDATE 0 /home/oracle/backup/system01.dbf 13212707950
2 INCR_UPDATE 0 /home/oracle/backup/sysaux01.dbf 13212707950
3 INCR_UPDATE 0 /home/oracle/backup/undotbs01.dbf 13212707950
4 INCR_UPDATE 0 /home/oracle/backup/users01.dbf 13212707950
5 INCR_UPDATE 0 /home/oracle/backup/example01.dbf 13212707950
--補充如果
RMAN> backup as copy database format '/home/oracle/backup/%b';
SCOTT@book> select file#, tag, incremental_level, name ,CHECKPOINT_CHANGE# from v$datafile_copy where deleted='NO' order by 1;
FILE# TAG INCREMENTAL_LEVEL NAME CHECKPOINT_CHANGE#
------------ -------------------------------- ----------------- -------------------------------------------------- ------------------
1 TAG20151207T094732 /home/oracle/backup/system01.dbf 13212708292
2 TAG20151207T094732 /home/oracle/backup/sysaux01.dbf 13212708294
3 TAG20151207T094732 /home/oracle/backup/undotbs01.dbf 13212708298
4 TAG20151207T094732 /home/oracle/backup/users01.dbf 13212708288
5 TAG20151207T094732 /home/oracle/backup/example01.dbf 13212708296
-- INCREMENTAL_LEVEL = NULL.
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/267265/viewspace-1867921/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- [Java/日誌] 日誌框架列印應用程式日誌程式碼的執行情況Java框架
- ELK日誌系統之通用應用程式日誌接入方案
- [20181217]ogg抽取日誌分析.txt
- Docker應用容器日誌資訊收集Docker
- 通過helm部署EFK收集應用日誌，ingress-nginx日誌解析。應用日誌Nginx
- 應用日誌採集是什麼意思？批次採集應用日誌軟體用哪個？怎麼操作？應用日誌
- [20180829]減少日誌生成量.txt
- [bug]MySQL 雜湊掃描錯誤地應用日誌導致主從中斷MySql應用日誌
- feign配置日誌不列印
- [20211105]索引分裂 塊清除 日誌增加.txt索引
- 判斷standby日誌是否同步primary
- Java-異常、斷言和日誌Java
- linux 日誌log檔案 截斷Linux
- 利用ELK搭建Docker容器化應用日誌中心Docker應用日誌
- dg庫日誌應用慢引數調整
- 基於Docker應用容器日誌檔案收集Docker
- 使用 adb 命令獲取指定應用的日誌
- 應急響應:日誌分析
- [20181116]18c DML 日誌優化.txt優化
- [20180625]簡單計算日誌生成率.txt
- 【Java雜記】日誌：Java日誌體系，從應用場景到發展歷史Java
- Data Guard備庫日誌的實時應用與非實時應用
- 【Azure 事件中心】為應用程式閘道器(Application Gateway with WAF) 配置診斷日誌，傳送到事件中心事件APPGateway
- 如何在iOS手機上檢視應用日誌iOS應用日誌
- Java應用日誌如何與Jaeger的trace關聯Java應用日誌
- 如何在多個應用程式中共享日誌配置
- TXT文字Log日誌分割工具(附工具連結)
- [20221121]rman刪除歸檔日誌問題.txt
- [20220826]顯示alert日誌檔案全路徑.txt
- zabbix應用教程：基於Nginx頁面響應的日誌監控用例Nginx
- laravel5.7 不記錄 sql 報錯日誌，自定義日誌資訊LaravelSQL
- ELK 處理 Spring Boot 日誌，不錯！Spring Boot
- LightDB不記錄WAL日誌的表
- Util應用框架基礎(六) - 日誌記錄(一) - 正文框架
- 阿里雲日誌服務sls的典型應用場景阿里
- 運維平臺之應用日誌解決方案--ELK運維應用日誌
- [20181112]11g 日誌傳輸壓縮模式.txt模式
- [20211105]索引分裂塊清除日誌增加(唯一索引).txt索引
- 解決ELK日誌被截斷的問題