暂无图片
返回问答列表
分享
许朝阳
2019-04-08
关于oracle rman备份问题
oracle

问题描述：

您好，最近我给客户写了一个备份脚本，客户要求实现【在本地保留2天的备份内容】

但是我今天发现备份内容，当天的内容备份信息完整，但是前一天的内容spfile文件和 归档日志文件却缺失了，好像是被rman自动删除了。

我不知道是哪里配置的有问题麻烦帮忙查看一下,指出问题的地方和 以及如何修改这个脚本可以实现目标。

谢谢，


以下为所有的相关信息,如有不明确的问题，请回复。


备份脚本：

#!/bin/bash

export ORACLE_BASE=/oracle/

export ORACLE_HOME=/oracle/PRC/102_64

export ORACLE_SID=PRC

export PATH=$ORACLE_HOME/bin:$PATH


$ORACLE_HOME/bin/rman <<EOF

connect target /

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

run{

allocate channel ch1 type disk;

allocate channel ch2 type disk;

allocate channel ch3 type disk;

backup as compressed backupset INCREMENTAL level 0 tag='level 0' database format '/back_sqldata/full_backup/full_%d_%s_%T.bkp';

backup as compressed backupset current controlfile tag='controlfile' format '/back_sqldata/full_backup/control_%d_%s_%T.bkp';

backup as compressed backupset spfile tag='spfile' format '/back_sqldata/full_backup/spfile_%d_%s_%T.bkp';

backup as compressed backupset  archivelog all tag='archivelog' format '/back_sqldata/full_backup/archivelog_%d_%s_%T.bkp';

crosscheck backup;

crosscheck archivelog all;

delete noprompt obsolete;

release channel ch1;

release channel ch2;

release channel ch3;

}

exit;

EOF


备份结果：

csaplmp:oraprc 58> ll  /back_sqldata/full_backup/

-rw-r----- 1 oraprc dba  1620687872 Apr  8 01:41 archivelog_PRC_103_20190408.bkp     #归档日志为什么7号的没有了？

-rw-r----- 1 oraprc dba  1572785664 Apr  8 01:41 archivelog_PRC_105_20190408.bkp  #归档日志为什么7号的没有了？

-rw-r----- 1 oraprc dba     1327104 Apr  8 01:37 control_PRC_101_20190408.bkp

-rw-r----- 1 oraprc dba     1310720 Apr  7 01:37 control_PRC_92_20190407.bkp

-rw-r----- 1 oraprc dba 10773348352 Apr  7 01:33 full_PRC_85_20190407.bkp

-rw-r----- 1 oraprc dba  7263731712 Apr  7 01:26 full_PRC_86_20190407.bkp

-rw-r----- 1 oraprc dba  5959770112 Apr  7 01:20 full_PRC_87_20190407.bkp

-rw-r----- 1 oraprc dba  5408006144 Apr  7 01:35 full_PRC_88_20190407.bkp

-rw-r----- 1 oraprc dba  3950034944 Apr  7 01:37 full_PRC_89_20190407.bkp

-rw-r----- 1 oraprc dba 10773086208 Apr  8 01:33 full_PRC_94_20190408.bkp

-rw-r----- 1 oraprc dba  7263756288 Apr  8 01:26 full_PRC_95_20190408.bkp

-rw-r----- 1 oraprc dba  5966217216 Apr  8 01:20 full_PRC_96_20190408.bkp

-rw-r----- 1 oraprc dba  5407309824 Apr  8 01:36 full_PRC_97_20190408.bkp

-rw-r----- 1 oraprc dba  4010041344 Apr  8 01:36 full_PRC_98_20190408.bkp

-rw-r----- 1 oraprc dba     1327104 Apr  8 01:33 full_PRC_99_20190408.bkp

-rw-r----- 1 oraprc dba       98304 Apr  8 01:37 spfile_PRC_102_20190408.bkp  #spfile文件为什么7号的没有了？

csaplmp:oraprc 60> 


参数配置：

RMAN> show all;

using target database control file instead of recovery catalog

RMAN configuration parameters are:

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;

CONFIGURE BACKUP OPTIMIZATION OFF; # default

CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default

CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default

CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default

CONFIGURE MAXSETSIZE TO UNLIMITED; # default

CONFIGURE ENCRYPTION FOR DATABASE OFF; # default

CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default

CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default

CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/oracle/PRC/102_64/dbs/snapcf_PRC.f'; # default


日志：

tail -f /var/spool/mail/oraprc

RMAN> 

old RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

new RMAN configuration parameters:

CONFIGURE CONTROLFILE AUTOBACKUP OFF;

new RMAN configuration parameters are successfully stored


RMAN> 2> 3> 4> 5> 6> 7> 8> 9> 10> 11> 12> 13> 14> 15> 16> 17> 18> 

allocated channel: ch1

channel ch1: sid=1127 devtype=DISK


allocated channel: ch2

channel ch2: sid=1128 devtype=DISK


allocated channel: ch3

channel ch3: sid=1143 devtype=DISK


crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_78_20190406.bkp recid=56 stamp=1004835665

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_77_20190406.bkp recid=57 stamp=1004835665

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_76_20190406.bkp recid=58 stamp=1004835665

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_79_20190406.bkp recid=61 stamp=1004836852

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_80_20190406.bkp recid=62 stamp=1004837117

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/control_PRC_83_20190406.bkp recid=63 stamp=1004837798

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_87_20190407.bkp recid=65 stamp=1004922065

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_86_20190407.bkp recid=66 stamp=1004922064

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_85_20190407.bkp recid=67 stamp=1004922064

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_90_20190407.bkp recid=68 stamp=1004924034

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_88_20190407.bkp recid=70 stamp=1004923232

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_89_20190407.bkp recid=71 stamp=1004923586

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/control_PRC_92_20190407.bkp recid=72 stamp=1004924232

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/spfile_PRC_93_20190407.bkp recid=73 stamp=1004924234

Crosschecked 14 objects



Starting backup at 08-APR-19

channel ch1: starting compressed incremental level 0 datafile backupset

channel ch1: specifying datafile(s) in backupset

input datafile fno=00023 name=/oracle/PRC/sapdata4/sr3700_3/sr3700.data3

input datafile fno=00021 name=/oracle/PRC/sapdata2/sr3700_1/sr3700.data1

input datafile fno=00022 name=/oracle/PRC/sapdata3/sr3700_2/sr3700.data2

input datafile fno=00004 name=/oracle/PRC/sapdata1/sr3_1/sr3.data1

input datafile fno=00011 name=/oracle/PRC/sapdata4/sr3_8/sr3.data8

channel ch1: starting piece 1 at 08-APR-19

channel ch2: starting compressed incremental level 0 datafile backupset

channel ch2: specifying datafile(s) in backupset

input datafile fno=00005 name=/oracle/PRC/sapdata2/sr3_2/sr3.data2

input datafile fno=00014 name=/oracle/PRC/sapdata3/sr3_11/sr3.data11

input datafile fno=00008 name=/oracle/PRC/sapdata1/sr3_5/sr3.data5

input datafile fno=00007 name=/oracle/PRC/sapdata4/sr3_4/sr3.data4

input datafile fno=00003 name=/oracle/PRC/sapdata4/sysaux_1/sysaux.data1

input datafile fno=00009 name=/oracle/PRC/sapdata2/sr3_6/sr3.data6

channel ch2: starting piece 1 at 08-APR-19

channel ch3: starting compressed incremental level 0 datafile backupset

channel ch3: specifying datafile(s) in backupset

input datafile fno=00006 name=/oracle/PRC/sapdata3/sr3_3/sr3.data3

input datafile fno=00012 name=/oracle/PRC/sapdata1/sr3_9/sr3.data9

input datafile fno=00015 name=/oracle/PRC/sapdata4/sr3_12/sr3.data12

input datafile fno=00001 name=/oracle/PRC/sapdata4/system_1/system.data1

input datafile fno=00013 name=/oracle/PRC/sapdata2/sr3_10/sr3.data10

input datafile fno=00025 name=/oracle/PRC/sapdata2/sr3usr_1/sr3usr.data1

channel ch3: starting piece 1 at 08-APR-19

channel ch3: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/full_PRC_96_20190408.bkp tag=LEVEL 0 comment=NONE

channel ch3: backup set complete, elapsed time: 00:19:46

channel ch3: starting compressed incremental level 0 datafile backupset

channel ch3: specifying datafile(s) in backupset

input datafile fno=00010 name=/oracle/PRC/sapdata3/sr3_7/sr3.data7

input datafile fno=00016 name=/oracle/PRC/sapdata1/sr3_13/sr3.data13

input datafile fno=00019 name=/oracle/PRC/sapdata4/sr3_16/sr3.data16

input datafile fno=00017 name=/oracle/PRC/sapdata2/sr3_14/sr3.data14

channel ch3: starting piece 1 at 08-APR-19

channel ch2: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/full_PRC_95_20190408.bkp tag=LEVEL 0 comment=NONE

channel ch2: backup set complete, elapsed time: 00:25:22

channel ch2: starting compressed incremental level 0 datafile backupset

channel ch2: specifying datafile(s) in backupset

input datafile fno=00018 name=/oracle/PRC/sapdata3/sr3_15/sr3.data15

input datafile fno=00024 name=/oracle/PRC/sapdata1/sr3700_4/sr3700.data4

input datafile fno=00020 name=/oracle/PRC/sapdata1/sr3_17/sr3.data17

input datafile fno=00002 name=/oracle/PRC/sapdata4/undo_1/undo.data1

channel ch2: starting piece 1 at 08-APR-19

channel ch1: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/full_PRC_94_20190408.bkp tag=LEVEL 0 comment=NONE

channel ch1: backup set complete, elapsed time: 00:32:28

channel ch1: starting compressed incremental level 0 datafile backupset

channel ch1: specifying datafile(s) in backupset

including current control file in backupset

channel ch1: starting piece 1 at 08-APR-19

channel ch1: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/full_PRC_99_20190408.bkp tag=LEVEL 0 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:06

channel ch1: starting compressed incremental level 0 datafile backupset

channel ch1: specifying datafile(s) in backupset

including current SPFILE in backupset

channel ch1: starting piece 1 at 08-APR-19

channel ch1: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/full_PRC_100_20190408.bkp tag=LEVEL 0 comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:04

channel ch3: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/full_PRC_97_20190408.bkp tag=LEVEL 0 comment=NONE

channel ch3: backup set complete, elapsed time: 00:15:19

channel ch2: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/full_PRC_98_20190408.bkp tag=LEVEL 0 comment=NONE

channel ch2: backup set complete, elapsed time: 00:10:38

Finished backup at 08-APR-19


Starting backup at 08-APR-19

channel ch1: starting compressed full datafile backupset

channel ch1: specifying datafile(s) in backupset

including current control file in backupset

channel ch1: starting piece 1 at 08-APR-19

channel ch1: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/control_PRC_101_20190408.bkp tag=CONTROLFILE comment=NONE




channel ch1: backup set complete, elapsed time: 00:00:01

Finished backup at 08-APR-19


Starting backup at 08-APR-19

channel ch1: starting compressed full datafile backupset

channel ch1: specifying datafile(s) in backupset

including current SPFILE in backupset

channel ch1: starting piece 1 at 08-APR-19

channel ch1: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/spfile_PRC_102_20190408.bkp tag=SPFILE comment=NONE

channel ch1: backup set complete, elapsed time: 00:00:02

Finished backup at 08-APR-19


Starting backup at 08-APR-19

current log archived

channel ch1: starting compressed archive log backupset

channel ch1: specifying archive log(s) in backup set

input archive log thread=1 sequence=3464 recid=2786 stamp=1004918541

input archive log thread=1 sequence=3465 recid=2787 stamp=1004918550

input archive log thread=1 sequence=3466 recid=2788 stamp=1004918559

input archive log thread=1 sequence=3467 recid=2789 stamp=1004918569

input archive log thread=1 sequence=3468 recid=2790 stamp=1004918579

input archive log thread=1 sequence=3469 recid=2791 stamp=1004918589

input archive log thread=1 sequence=3470 recid=2792 stamp=1004918598

input archive log thread=1 sequence=3471 recid=2793 stamp=1004918605

input archive log thread=1 sequence=3472 recid=2794 stamp=1004918615

input archive log thread=1 sequence=3473 recid=2795 stamp=1004918624

input archive log thread=1 sequence=3474 recid=2796 stamp=1004918634

input archive log thread=1 sequence=3475 recid=2797 stamp=1004918644

input archive log thread=1 sequence=3476 recid=2798 stamp=1004922060

input archive log thread=1 sequence=3477 recid=2799 stamp=1004924237

input archive log thread=1 sequence=3478 recid=2800 stamp=1004929261

input archive log thread=1 sequence=3479 recid=2801 stamp=1004932883

input archive log thread=1 sequence=3480 recid=2802 stamp=1004936469

input archive log thread=1 sequence=3481 recid=2803 stamp=1004940065

input archive log thread=1 sequence=3482 recid=2804 stamp=1004943680

input archive log thread=1 sequence=3483 recid=2805 stamp=1004949300

input archive log thread=1 sequence=3484 recid=2806 stamp=1004952902

input archive log thread=1 sequence=3485 recid=2807 stamp=1004958064

input archive log thread=1 sequence=3486 recid=2808 stamp=1004961667

input archive log thread=1 sequence=3487 recid=2809 stamp=1004967300

input archive log thread=1 sequence=3488 recid=2810 stamp=1004970902

input archive log thread=1 sequence=3489 recid=2811 stamp=1004976006

input archive log thread=1 sequence=3490 recid=2812 stamp=1004979608

input archive log thread=1 sequence=3491 recid=2813 stamp=1004985301

input archive log thread=1 sequence=3492 recid=2814 stamp=1004988915

channel ch1: starting piece 1 at 08-APR-19

channel ch2: starting compressed archive log backupset

channel ch2: specifying archive log(s) in backup set

input archive log thread=1 sequence=3435 recid=2757 stamp=1004837802

input archive log thread=1 sequence=3436 recid=2758 stamp=1004842851

input archive log thread=1 sequence=3437 recid=2759 stamp=1004846476

input archive log thread=1 sequence=3438 recid=2760 stamp=1004850059

input archive log thread=1 sequence=3439 recid=2761 stamp=1004853656

input archive log thread=1 sequence=3440 recid=2762 stamp=1004857266

input archive log thread=1 sequence=3441 recid=2763 stamp=1004862893

input archive log thread=1 sequence=3442 recid=2764 stamp=1004866495

input archive log thread=1 sequence=3443 recid=2765 stamp=1004870098

input archive log thread=1 sequence=3444 recid=2766 stamp=1004875255

input archive log thread=1 sequence=3445 recid=2767 stamp=1004878858

input archive log thread=1 sequence=3446 recid=2768 stamp=1004884496

input archive log thread=1 sequence=3447 recid=2769 stamp=1004888099

input archive log thread=1 sequence=3448 recid=2770 stamp=1004893257

input archive log thread=1 sequence=3449 recid=2771 stamp=1004896859

input archive log thread=1 sequence=3450 recid=2772 stamp=1004902507

input archive log thread=1 sequence=3451 recid=2773 stamp=1004906109

input archive log thread=1 sequence=3452 recid=2774 stamp=1004909701

input archive log thread=1 sequence=3453 recid=2775 stamp=1004914859

input archive log thread=1 sequence=3454 recid=2776 stamp=1004918460

input archive log thread=1 sequence=3455 recid=2777 stamp=1004918468

input archive log thread=1 sequence=3456 recid=2778 stamp=1004918474

input archive log thread=1 sequence=3457 recid=2779 stamp=1004918482

input archive log thread=1 sequence=3458 recid=2780 stamp=1004918492

input archive log thread=1 sequence=3459 recid=2781 stamp=1004918499

input archive log thread=1 sequence=3460 recid=2782 stamp=1004918507

input archive log thread=1 sequence=3461 recid=2783 stamp=1004918516

input archive log thread=1 sequence=3462 recid=2784 stamp=1004918524

input archive log thread=1 sequence=3463 recid=2785 stamp=1004918531

channel ch2: starting piece 1 at 08-APR-19

channel ch3: starting compressed archive log backupset

channel ch3: specifying archive log(s) in backup set

input archive log thread=1 sequence=3493 recid=2815 stamp=1004992513

input archive log thread=1 sequence=3494 recid=2816 stamp=1004997609

input archive log thread=1 sequence=3495 recid=2817 stamp=1005001211

input archive log thread=1 sequence=3496 recid=2818 stamp=1005004812

input archive log thread=1 sequence=3497 recid=2819 stamp=1005004820

input archive log thread=1 sequence=3498 recid=2820 stamp=1005004829

input archive log thread=1 sequence=3499 recid=2821 stamp=1005004838

input archive log thread=1 sequence=3500 recid=2822 stamp=1005004849

input archive log thread=1 sequence=3501 recid=2823 stamp=1005004858

input archive log thread=1 sequence=3502 recid=2824 stamp=1005004868

input archive log thread=1 sequence=3503 recid=2825 stamp=1005004877

input archive log thread=1 sequence=3504 recid=2826 stamp=1005004886

input archive log thread=1 sequence=3505 recid=2827 stamp=1005004898

input archive log thread=1 sequence=3506 recid=2828 stamp=1005004909

input archive log thread=1 sequence=3507 recid=2829 stamp=1005004918

input archive log thread=1 sequence=3508 recid=2830 stamp=1005004928

input archive log thread=1 sequence=3509 recid=2831 stamp=1005004938

input archive log thread=1 sequence=3510 recid=2832 stamp=1005004948

input archive log thread=1 sequence=3511 recid=2833 stamp=1005004958

input archive log thread=1 sequence=3512 recid=2834 stamp=1005004968

input archive log thread=1 sequence=3513 recid=2835 stamp=1005004978

input archive log thread=1 sequence=3514 recid=2836 stamp=1005004987

input archive log thread=1 sequence=3515 recid=2837 stamp=1005004997

input archive log thread=1 sequence=3516 recid=2838 stamp=1005005007

input archive log thread=1 sequence=3517 recid=2839 stamp=1005005016

input archive log thread=1 sequence=3518 recid=2840 stamp=1005008410

input archive log thread=1 sequence=3519 recid=2841 stamp=1005010628

channel ch3: starting piece 1 at 08-APR-19

channel ch3: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/archivelog_PRC_105_20190408.bkp tag=ARCHIVELOG comment=NONE

channel ch3: backup set complete, elapsed time: 00:03:56

channel ch2: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/archivelog_PRC_104_20190408.bkp tag=ARCHIVELOG comment=NONE

channel ch2: backup set complete, elapsed time: 00:04:03

channel ch1: finished piece 1 at 08-APR-19

piece handle=/back_sqldata/full_backup/archivelog_PRC_103_20190408.bkp tag=ARCHIVELOG comment=NONE

channel ch1: backup set complete, elapsed time: 00:04:18

Finished backup at 08-APR-19


crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_78_20190406.bkp recid=56 stamp=1004835665

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_77_20190406.bkp recid=57 stamp=1004835665

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_76_20190406.bkp recid=58 stamp=1004835665

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_79_20190406.bkp recid=61 stamp=1004836852

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_80_20190406.bkp recid=62 stamp=1004837117

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/control_PRC_83_20190406.bkp recid=63 stamp=1004837798

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_87_20190407.bkp recid=65 stamp=1004922065

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_86_20190407.bkp recid=66 stamp=1004922064

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_85_20190407.bkp recid=67 stamp=1004922064

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_90_20190407.bkp recid=68 stamp=1004924034

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_88_20190407.bkp recid=70 stamp=1004923232

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_89_20190407.bkp recid=71 stamp=1004923586

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/control_PRC_92_20190407.bkp recid=72 stamp=1004924232

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/spfile_PRC_93_20190407.bkp recid=73 stamp=1004924234

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_96_20190408.bkp recid=74 stamp=1005008465

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_95_20190408.bkp recid=75 stamp=1005008465

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_94_20190408.bkp recid=76 stamp=1005008464

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_99_20190408.bkp recid=77 stamp=1005010416

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_100_20190408.bkp recid=78 stamp=1005010421

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_97_20190408.bkp recid=79 stamp=1005009652

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/full_PRC_98_20190408.bkp recid=80 stamp=1005009988

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/control_PRC_101_20190408.bkp recid=81 stamp=1005010624

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/spfile_PRC_102_20190408.bkp recid=82 stamp=1005010626

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/archivelog_PRC_105_20190408.bkp recid=83 stamp=1005010630

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/archivelog_PRC_104_20190408.bkp recid=84 stamp=1005010630

crosschecked backup piece: found to be 'AVAILABLE'

backup piece handle=/back_sqldata/full_backup/archivelog_PRC_103_20190408.bkp recid=85 stamp=1005010630

Crosschecked 26 objects



validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3435_997804422.dbf recid=2757 stamp=1004837802

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3436_997804422.dbf recid=2758 stamp=1004842851

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3437_997804422.dbf recid=2759 stamp=1004846476

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3438_997804422.dbf recid=2760 stamp=1004850059

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3439_997804422.dbf recid=2761 stamp=1004853656

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3440_997804422.dbf recid=2762 stamp=1004857266

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3441_997804422.dbf recid=2763 stamp=1004862893

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3442_997804422.dbf recid=2764 stamp=1004866495

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3443_997804422.dbf recid=2765 stamp=1004870098

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3444_997804422.dbf recid=2766 stamp=1004875255

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3445_997804422.dbf recid=2767 stamp=1004878858

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3446_997804422.dbf recid=2768 stamp=1004884496

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3447_997804422.dbf recid=2769 stamp=1004888099

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3448_997804422.dbf recid=2770 stamp=1004893257

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3449_997804422.dbf recid=2771 stamp=1004896859

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3450_997804422.dbf recid=2772 stamp=1004902507

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3451_997804422.dbf recid=2773 stamp=1004906109

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3452_997804422.dbf recid=2774 stamp=1004909701

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3453_997804422.dbf recid=2775 stamp=1004914859

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3454_997804422.dbf recid=2776 stamp=1004918460

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3455_997804422.dbf recid=2777 stamp=1004918468

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3456_997804422.dbf recid=2778 stamp=1004918474

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3457_997804422.dbf recid=2779 stamp=1004918482

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3458_997804422.dbf recid=2780 stamp=1004918492

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3459_997804422.dbf recid=2781 stamp=1004918499

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3460_997804422.dbf recid=2782 stamp=1004918507

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3461_997804422.dbf recid=2783 stamp=1004918516

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3462_997804422.dbf recid=2784 stamp=1004918524

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3463_997804422.dbf recid=2785 stamp=1004918531

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3464_997804422.dbf recid=2786 stamp=1004918541

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3465_997804422.dbf recid=2787 stamp=1004918550

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3466_997804422.dbf recid=2788 stamp=1004918559

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3467_997804422.dbf recid=2789 stamp=1004918569

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3468_997804422.dbf recid=2790 stamp=1004918579

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3469_997804422.dbf recid=2791 stamp=1004918589

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3470_997804422.dbf recid=2792 stamp=1004918598

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3471_997804422.dbf recid=2793 stamp=1004918605

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3472_997804422.dbf recid=2794 stamp=1004918615

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3473_997804422.dbf recid=2795 stamp=1004918624

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3474_997804422.dbf recid=2796 stamp=1004918634

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3475_997804422.dbf recid=2797 stamp=1004918644

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3476_997804422.dbf recid=2798 stamp=1004922060

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3477_997804422.dbf recid=2799 stamp=1004924237

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3478_997804422.dbf recid=2800 stamp=1004929261

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3479_997804422.dbf recid=2801 stamp=1004932883

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3480_997804422.dbf recid=2802 stamp=1004936469

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3481_997804422.dbf recid=2803 stamp=1004940065

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3482_997804422.dbf recid=2804 stamp=1004943680

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3483_997804422.dbf recid=2805 stamp=1004949300

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3484_997804422.dbf recid=2806 stamp=1004952902

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3485_997804422.dbf recid=2807 stamp=1004958064

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3486_997804422.dbf recid=2808 stamp=1004961667

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3487_997804422.dbf recid=2809 stamp=1004967300

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3488_997804422.dbf recid=2810 stamp=1004970902

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3489_997804422.dbf recid=2811 stamp=1004976006

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3490_997804422.dbf recid=2812 stamp=1004979608

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3491_997804422.dbf recid=2813 stamp=1004985301

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3492_997804422.dbf recid=2814 stamp=1004988915

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3493_997804422.dbf recid=2815 stamp=1004992513

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3494_997804422.dbf recid=2816 stamp=1004997609

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3495_997804422.dbf recid=2817 stamp=1005001211

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3496_997804422.dbf recid=2818 stamp=1005004812

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3497_997804422.dbf recid=2819 stamp=1005004820

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3498_997804422.dbf recid=2820 stamp=1005004829

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3499_997804422.dbf recid=2821 stamp=1005004838

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3500_997804422.dbf recid=2822 stamp=1005004849

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3501_997804422.dbf recid=2823 stamp=1005004858

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3502_997804422.dbf recid=2824 stamp=1005004868

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3503_997804422.dbf recid=2825 stamp=1005004877

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3504_997804422.dbf recid=2826 stamp=1005004886

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3505_997804422.dbf recid=2827 stamp=1005004898

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3506_997804422.dbf recid=2828 stamp=1005004909

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3507_997804422.dbf recid=2829 stamp=1005004918

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3508_997804422.dbf recid=2830 stamp=1005004928

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3509_997804422.dbf recid=2831 stamp=1005004938

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3510_997804422.dbf recid=2832 stamp=1005004948

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3511_997804422.dbf recid=2833 stamp=1005004958

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3512_997804422.dbf recid=2834 stamp=1005004968

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3513_997804422.dbf recid=2835 stamp=1005004978

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3514_997804422.dbf recid=2836 stamp=1005004987

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3515_997804422.dbf recid=2837 stamp=1005004997

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3516_997804422.dbf recid=2838 stamp=1005005007

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3517_997804422.dbf recid=2839 stamp=1005005016

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3518_997804422.dbf recid=2840 stamp=1005008410

validation succeeded for archived log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3519_997804422.dbf recid=2841 stamp=1005010628

Crosschecked 85 objects



RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 1 days

Deleting the following obsolete backups and copies:

Type                 Key    Completion Time    Filename/Handle

-------------------- ------ ------------------ --------------------

Backup Set           58     06-APR-19         

  Backup Piece       58     06-APR-19          /back_sqldata/full_backup/full_PRC_76_20190406.bkp

Backup Set           57     06-APR-19         

  Backup Piece       57     06-APR-19          /back_sqldata/full_backup/full_PRC_77_20190406.bkp

Backup Set           56     06-APR-19         

  Backup Piece       56     06-APR-19          /back_sqldata/full_backup/full_PRC_78_20190406.bkp

Backup Set           61     06-APR-19         

  Backup Piece       61     06-APR-19          /back_sqldata/full_backup/full_PRC_79_20190406.bkp

Backup Set           62     06-APR-19         

  Backup Piece       62     06-APR-19          /back_sqldata/full_backup/full_PRC_80_20190406.bkp

Backup Set           63     06-APR-19         

  Backup Piece       63     06-APR-19          /back_sqldata/full_backup/control_PRC_83_20190406.bkp

Archive Log          2757   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3435_997804422.dbf

Archive Log          2758   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3436_997804422.dbf

Archive Log          2759   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3437_997804422.dbf

Archive Log          2760   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3438_997804422.dbf

Archive Log          2761   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3439_997804422.dbf

Archive Log          2762   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3440_997804422.dbf

Archive Log          2763   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3441_997804422.dbf

Archive Log          2764   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3442_997804422.dbf

Archive Log          2765   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3443_997804422.dbf

Archive Log          2766   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3444_997804422.dbf

Archive Log          2767   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3445_997804422.dbf

Archive Log          2768   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3446_997804422.dbf

Archive Log          2769   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3447_997804422.dbf

Archive Log          2770   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3448_997804422.dbf

Archive Log          2771   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3449_997804422.dbf

Archive Log          2772   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3450_997804422.dbf

Archive Log          2773   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3451_997804422.dbf

Archive Log          2774   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3452_997804422.dbf

Archive Log          2775   06-APR-19          /oracle/PRC/oraarch/PRCarch1_3453_997804422.dbf

Archive Log          2776   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3454_997804422.dbf

Archive Log          2777   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3455_997804422.dbf

Archive Log          2778   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3456_997804422.dbf

Archive Log          2779   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3457_997804422.dbf

Archive Log          2780   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3458_997804422.dbf

Archive Log          2781   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3459_997804422.dbf

Archive Log          2782   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3460_997804422.dbf

Archive Log          2783   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3461_997804422.dbf

Archive Log          2784   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3462_997804422.dbf

Archive Log          2785   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3463_997804422.dbf

Archive Log          2786   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3464_997804422.dbf

Archive Log          2787   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3465_997804422.dbf

Archive Log          2788   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3466_997804422.dbf

Archive Log          2789   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3467_997804422.dbf

Archive Log          2790   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3468_997804422.dbf

Archive Log          2791   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3469_997804422.dbf

Archive Log          2792   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3470_997804422.dbf

Archive Log          2793   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3471_997804422.dbf

Archive Log          2794   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3472_997804422.dbf

Archive Log          2795   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3473_997804422.dbf

Archive Log          2796   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3474_997804422.dbf

Archive Log          2797   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3475_997804422.dbf

Archive Log          2798   07-APR-19          /oracle/PRC/oraarch/PRCarch1_3476_997804422.dbf

Backup Set           68     07-APR-19         

  Backup Piece       68     07-APR-19          /back_sqldata/full_backup/full_PRC_90_20190407.bkp

Backup Set           73     07-APR-19         

  Backup Piece       73     07-APR-19          /back_sqldata/full_backup/spfile_PRC_93_20190407.bkp

Backup Set           78     08-APR-19         

  Backup Piece       78     08-APR-19          /back_sqldata/full_backup/full_PRC_100_20190408.bkp

Backup Set           84     08-APR-19         

  Backup Piece       84     08-APR-19          /back_sqldata/full_backup/archivelog_PRC_104_20190408.bkp

deleted backup piece

backup piece handle=/back_sqldata/full_backup/full_PRC_76_20190406.bkp recid=58 stamp=1004835665

deleted backup piece

backup piece handle=/back_sqldata/full_backup/full_PRC_77_20190406.bkp recid=57 stamp=1004835665

deleted backup piece

backup piece handle=/back_sqldata/full_backup/full_PRC_78_20190406.bkp recid=56 stamp=1004835665

deleted backup piece

backup piece handle=/back_sqldata/full_backup/full_PRC_79_20190406.bkp recid=61 stamp=1004836852

deleted backup piece

backup piece handle=/back_sqldata/full_backup/full_PRC_80_20190406.bkp recid=62 stamp=1004837117

deleted backup piece

backup piece handle=/back_sqldata/full_backup/control_PRC_83_20190406.bkp recid=63 stamp=1004837798

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3435_997804422.dbf recid=2757 stamp=1004837802

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3436_997804422.dbf recid=2758 stamp=1004842851

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3437_997804422.dbf recid=2759 stamp=1004846476

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3438_997804422.dbf recid=2760 stamp=1004850059

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3439_997804422.dbf recid=2761 stamp=1004853656

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3440_997804422.dbf recid=2762 stamp=1004857266

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3441_997804422.dbf recid=2763 stamp=1004862893

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3442_997804422.dbf recid=2764 stamp=1004866495

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3443_997804422.dbf recid=2765 stamp=1004870098

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3444_997804422.dbf recid=2766 stamp=1004875255

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3445_997804422.dbf recid=2767 stamp=1004878858

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3446_997804422.dbf recid=2768 stamp=1004884496

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3447_997804422.dbf recid=2769 stamp=1004888099

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3448_997804422.dbf recid=2770 stamp=1004893257

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3449_997804422.dbf recid=2771 stamp=1004896859

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3450_997804422.dbf recid=2772 stamp=1004902507

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3451_997804422.dbf recid=2773 stamp=1004906109

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3452_997804422.dbf recid=2774 stamp=1004909701

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3453_997804422.dbf recid=2775 stamp=1004914859

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3454_997804422.dbf recid=2776 stamp=1004918460

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3455_997804422.dbf recid=2777 stamp=1004918468

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3456_997804422.dbf recid=2778 stamp=1004918474

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3457_997804422.dbf recid=2779 stamp=1004918482

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3458_997804422.dbf recid=2780 stamp=1004918492

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3459_997804422.dbf recid=2781 stamp=1004918499

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3460_997804422.dbf recid=2782 stamp=1004918507

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3461_997804422.dbf recid=2783 stamp=1004918516

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3462_997804422.dbf recid=2784 stamp=1004918524

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3463_997804422.dbf recid=2785 stamp=1004918531

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3464_997804422.dbf recid=2786 stamp=1004918541

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3465_997804422.dbf recid=2787 stamp=1004918550

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3466_997804422.dbf recid=2788 stamp=1004918559

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3467_997804422.dbf recid=2789 stamp=1004918569

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3468_997804422.dbf recid=2790 stamp=1004918579

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3469_997804422.dbf recid=2791 stamp=1004918589

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3470_997804422.dbf recid=2792 stamp=1004918598

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3471_997804422.dbf recid=2793 stamp=1004918605

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3472_997804422.dbf recid=2794 stamp=1004918615

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3473_997804422.dbf recid=2795 stamp=1004918624

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3474_997804422.dbf recid=2796 stamp=1004918634

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3475_997804422.dbf recid=2797 stamp=1004918644

deleted archive log

archive log filename=/oracle/PRC/oraarch/PRCarch1_3476_997804422.dbf recid=2798 stamp=1004922060

deleted backup piece

backup piece handle=/back_sqldata/full_backup/full_PRC_90_20190407.bkp recid=68 stamp=1004924034

deleted backup piece

backup piece handle=/back_sqldata/full_backup/spfile_PRC_93_20190407.bkp recid=73 stamp=1004924234

deleted backup piece

backup piece handle=/back_sqldata/full_backup/full_PRC_100_20190408.bkp recid=78 stamp=1005010421

deleted backup piece

backup piece handle=/back_sqldata/full_backup/archivelog_PRC_104_20190408.bkp recid=84 stamp=1005010630

Deleted 52 objects



RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 1 days

no obsolete backups found


RMAN retention policy will be applied to the command

RMAN retention policy is set to recovery window of 1 days

no obsolete backups found


released channel: ch1


released channel: ch2


released channel: ch3


RMAN> 


Recovery Manager complete.

transmission OK!






收藏
分享
12条回答
默认
最新
听说有人把我猫粮输光了

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 1 DAYS;


你这写了保存1天。。。请把1改成你想要的天数

暂无图片 评论
暂无图片 有用 0
听说有人把我猫粮输光了

obsolete:与retention policy相关，当备份或者副本根据保存策略而被丢弃的时候，就会被标记为该状态。

你上面写备份策略1天，下面下删除保存策略以外的。

要么你修改备份策略天数

要么你不用obsolete，用delete....until

暂无图片 评论
暂无图片 有用 0
许朝阳

你好 这个地方我做过测试，如果设置为1 的话  第二天的内容不会被删除，第三天的时候 会删除最早第一天的。

麻烦再帮忙看看其他地方有什么需要改进的嘛？


以下为测试内容：


#该参数设置3天实际会保留4天

#CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 3 DAYS;


[root@chaoyang-test rman]# lltotal 1110728
-rw-r-----. 1 oracle oinstall   1948160 Apr  1 10:02 archivelog_ORCL_278_20190401.bkp
-rw-r-----. 1 oracle oinstall     32768 Apr  1 10:02 archivelog_ORCL_279_20190401.bkp
-rw-r-----. 1 oracle oinstall   1948160 Apr  2 10:00 archivelog_ORCL_286_20190402.bkp
-rw-r-----. 1 oracle oinstall     32768 Apr  2 10:00 archivelog_ORCL_287_20190402.bkp
-rw-r-----. 1 oracle oinstall      2560 Apr  2 10:00 archivelog_ORCL_288_20190402.bkp
-rw-r-----. 1 oracle oinstall   1948160 Apr  3 10:00 archivelog_ORCL_295_20190403.bkp
-rw-r-----. 1 oracle oinstall     32768 Apr  3 10:00 archivelog_ORCL_296_20190403.bkp
-rw-r-----. 1 oracle oinstall      3072 Apr  3 10:00 archivelog_ORCL_297_20190403.bkp
-rw-r-----. 1 oracle oinstall   1948160 Apr  4 10:00 archivelog_ORCL_304_20190404.bkp
-rw-r-----. 1 oracle oinstall     33280 Apr  4 10:00 archivelog_ORCL_305_20190404.bkp
-rw-r-----. 1 oracle oinstall      3584 Apr  4 10:00 archivelog_ORCL_306_20190404.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  1 10:02 control_ORCL_280_20190401.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  2 10:00 control_ORCL_289_20190402.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  3 10:00 control_ORCL_298_20190403.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  4 10:00 control_ORCL_307_20190404.bkp
-rw-r-----. 1 oracle oinstall 190103552 Apr  1 10:02 full_ORCL_274_20190401.bkp
-rw-r-----. 1 oracle oinstall  89907200 Apr  1 10:02 full_ORCL_275_20190401.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  1 10:02 full_ORCL_276_20190401.bkp
-rw-r-----. 1 oracle oinstall 190103552 Apr  2 10:00 full_ORCL_282_20190402.bkp
-rw-r-----. 1 oracle oinstall  89931776 Apr  2 10:00 full_ORCL_283_20190402.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  2 10:00 full_ORCL_284_20190402.bkp
-rw-r-----. 1 oracle oinstall 190103552 Apr  3 10:00 full_ORCL_291_20190403.bkp
-rw-r-----. 1 oracle oinstall  89931776 Apr  3 10:00 full_ORCL_292_20190403.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  3 10:00 full_ORCL_293_20190403.bkp
-rw-r-----. 1 oracle oinstall 190111744 Apr  4 10:00 full_ORCL_300_20190404.bkp
-rw-r-----. 1 oracle oinstall  89939968 Apr  4 10:00 full_ORCL_301_20190404.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  4 10:00 full_ORCL_302_20190404.bkp
[root@chaoyang-test rman]# date -s "2019-04-05 10:00:00"Fri Apr  5 10:00:00 UTC 2019
[root@chaoyang-test rman]# lltotal 1103280
-rw-r-----. 1 oracle oinstall      2560 Apr  2 10:00 archivelog_ORCL_288_20190402.bkp
-rw-r-----. 1 oracle oinstall      3072 Apr  3 10:00 archivelog_ORCL_297_20190403.bkp
-rw-r-----. 1 oracle oinstall     33280 Apr  4 10:00 archivelog_ORCL_305_20190404.bkp
-rw-r-----. 1 oracle oinstall      3584 Apr  4 10:00 archivelog_ORCL_306_20190404.bkp
-rw-r-----. 1 oracle oinstall     33280 Apr  5 10:00 archivelog_ORCL_314_20190405.bkp
-rw-r-----. 1 oracle oinstall   1149952 Apr  5 10:00 archivelog_ORCL_315_20190405.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  2 10:00 control_ORCL_289_20190402.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  3 10:00 control_ORCL_298_20190403.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  4 10:00 control_ORCL_307_20190404.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  5 10:00 control_ORCL_316_20190405.bkp
-rw-r-----. 1 oracle oinstall 190103552 Apr  2 10:00 full_ORCL_282_20190402.bkp
-rw-r-----. 1 oracle oinstall  89931776 Apr  2 10:00 full_ORCL_283_20190402.bkp
-rw-r-----. 1 oracle oinstall 190103552 Apr  3 10:00 full_ORCL_291_20190403.bkp
-rw-r-----. 1 oracle oinstall  89931776 Apr  3 10:00 full_ORCL_292_20190403.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  3 10:00 full_ORCL_293_20190403.bkp
-rw-r-----. 1 oracle oinstall 190111744 Apr  4 10:00 full_ORCL_300_20190404.bkp
-rw-r-----. 1 oracle oinstall  89939968 Apr  4 10:00 full_ORCL_301_20190404.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  4 10:00 full_ORCL_302_20190404.bkp
-rw-r-----. 1 oracle oinstall 190111744 Apr  5 10:00 full_ORCL_309_20190405.bkp
-rw-r-----. 1 oracle oinstall  90144768 Apr  5 10:00 full_ORCL_310_20190405.bkp
-rw-r-----. 1 oracle oinstall   1163264 Apr  5 10:00 full_ORCL_311_20190405.bkp
[root@chaoyang-test rman]# date -s "2019-04-06 10:00:00"Sat Apr  6 10:00:00 UTC 2019

暂无图片 评论
暂无图片 有用 0
许朝阳

请问 delete....until 参数如何使用呢？ 我经验不多 。

我想删除 我的控制文件 归档文件 和备份文件 保留2天 请问如何写？


暂无图片 评论
暂无图片 有用 0
许朝阳

或者我这个脚本想要实现保留2天的内容 应该如何修改这个脚本呢，请教一下，帮忙修改一下我的参数或者脚本，指导一下。


暂无图片 评论
暂无图片 有用 0
听说有人把我猫粮输光了

第一种方法：


DELETE BACKUP COMPLETED before "SYSDATE-2";  这里bakup可以换成任意备份对象

第二种方法：

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;

delete noprompt obsolete;


注意:

show parameter control_file_record_keep_time;  控制文件里面的备份保存时间一定要比rman policy长。


暂无图片 评论
暂无图片 有用 0
许朝阳

你好！

我才用了第二种方法 

第二种方法：

CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS;

delete noprompt obsolete;


结果保留了3天的 

而且 最早的7号的 归档文件和spfile都没有保留住。

8号的spfile文件也被删除了。

只有当天的是最完整的。

麻烦能分析一下是什么问题吗？



image.png



image.png


image.png


暂无图片 评论
暂无图片 有用 0
李真旭

windows 这个时间是不包含当天的。这没什么问题呀

暂无图片 评论
暂无图片 有用 0
许朝阳

7号和8号的部分文件为什么删除了呢，按说应该保留3天的 完整备份才对呀。

现在问题是 我想实现保留2份完整的内容文件 该如何调整呢。

暂无图片 评论
暂无图片 有用 0
盖国强

你如何判断的 spfile 被删除了？

从备份集中 list 一下看看，report 一下 spfile 的备份情况看看。

暂无图片 评论
暂无图片 有用 0
许朝阳

你好！

         我现在改成CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 2 DAYS; 了 。

现在是保留3天的备份,但是前两天的spfile和部分归档都不全,没有了,只有最后一天的是完整的，盖总我也不知道是怎么回事,该如何修改呀。


image.png

image.png


image.png

image.png


暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经过期
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签，敬请期待~~
暂无图片墨值悬赏