- 论坛徽章:
- 8
|
本帖最后由 wiliiwin 于 2014-10-20 14:39 编辑
你说的是不是这样的- awk -F "/" 'NR==FNR {a[++x]=$7substr($8,9,3);next}{for(y in a){if(a[y]==$4substr($5,14,3)){print $0}}}' 29.txt 30.txt
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_11/thread_1_seq_566.817.860662667';
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_12/thread_1_seq_567.590.860675203';
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_11/thread_2_seq_638.647.860686289';
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_12/thread_2_seq_639.524.860704083';
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_11/thread_3_seq_520.547.860686289';
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_12/thread_3_seq_521.624.873702153';
复制代码 sd.rman- delete force noprompt archivelog like '/u02/app/fast_recovery_area/STDB/archivelog/2014_10_11/o1_mf_1_5
- 66_b3k04d0j_.arc';
- delete force noprompt archivelog like '/u02/app/fast_recovery_area/STDB/archivelog/2014_10_12/o1_mf_1_5
- 67_b3kdd27v_.arc';
- delete force noprompt archivelog like '/u02/app/fast_recovery_area/STDB/archivelog/2014_10_11/o1_mf_2_6
- 38_b3kkjq66_.arc';
- delete force noprompt archivelog like '/u02/app/fast_recovery_area/STDB/archivelog/2014_10_12/o1_mf_2_6
- 39_b3kq6k6f_.arc';
- delete force noprompt archivelog like '/u02/app/fast_recovery_area/STDB/archivelog/2014_10_11/o1_mf_3_5
- 20_b3l8lmvn_.arc';
- delete force noprompt archivelog like '/u02/app/fast_recovery_area/STDB/archivelog/2014_10_12/o1_mf_3_5
- 21_b3e9lnvs_.arc';
- exit;
复制代码 fd.rman- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_11/thread_1_seq_566.817.860662667'
- ;
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_12/thread_1_seq_567.590.860675203'
- ;
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_13/thread_1_seq_568.700.860680471'
- ;
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_11/thread_2_seq_638.647.860686289'
- ;
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_12/thread_2_seq_639.524.860704083'
- ;
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_13/thread_2_seq_640.712.854680471'
- ;
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_11/thread_3_seq_520.547.860686289'
- ;
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_12/thread_3_seq_521.624.873702153'
- ;
- delete force noprompt archivelog like '+RECO/orcl/archivelog/2014_10_13/thread_3_seq_522.569.879614075'
- ;
复制代码 |
|