================================================
Note: mush allocate channel first
allocate channel for maintenance type disk;
delete expired backup;
release channel;
RMAN> delete expired backup;
RMAN-03022: compiling command: delete expired
RMAN-03023: executing command: delete expired
RMAN-03022: compiling command: delete expired
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: delete expired
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242:
specification does not match any archivelog in the recovery catalog
2. delete expired backup of datafile xx is ok
==============================================
delete expired backup of datafile 1;
delete expired backup of datafile 2;
delete expired backup of datafile 3;
delete expired backup of datafile 4;
delete expired backup of datafile 5;
delete expired backup of datafile 6;
delete expired backup of datafile 7;
delete expired backup of datafile 8;
delete expired backup of datafile 9;
delete expired backup of datafile 10;
delete expired backup of datafile 11;
delete expired backup of datafile 12;
delete expired backup of datafile 13;
delete expired backup of datafile 14;
delete expired backup of datafile 15;
delete expired backup of datafile 16;
delete expired backup of datafile 17;
delete expired backup of datafile 18;
delete expired backup of datafile 19;
delete expired backup of datafile 20;
delete expired backup of datafile 21;
delete expired backup of datafile 22;
delete expired backup of datafile 23;
delete expired backup of datafile 24;
delete expired backup of datafile 25;
delete expired backup of datafile 26;
delete expired backup of datafile 27;
delete expired backup of datafile 28;
delete expired backup of datafile 29;
delete expired backup of datafile 30;
delete expired backup of datafile 31;
delete expired backup of datafile 32;
delete expired backup of datafile 33;
delete expired backup of datafile 34;
delete expired backup of datafile 35;
delete expired backup of datafile 36;
delete expired backup of datafile 37;
delete expired backup of datafile 38;
===
3. tablespace level --this one is ok too
=======================
delete expired backup of tablespace gen_data;
delete expired backup of tablespace system;
delete expired backup of tablespace audit_data;
delete expired backup of tablespace gen_indx;
delete expired backup of tablespace indx;
delete expired backup of tablespace rbs;
delete expired backup of tablespace tools
delete expired backup of tablespace users;
delete expired backup of tablespace gen_rep_data;
delete expired backup of tablespace fog_light;
File K-bytes Tablespace RB segs Name
---- ---------- -------------------- ------- -------------------
1 583680 SYSTEM YES
/ora02/oradata/GEN3S/gen_system01.dbf
2 29696 AUDIT_DATA NO
/ora02/oradata/GEN3S/gen_audit_rdbs01.dbf
3 2097152 GEN_DATA NO
/ora01/oradata/GEN3S/gen_data_01.dbf
4 2097152 GEN_DATA NO
/ora02/oradata/GEN3S/gen_data_02.dbf
5 2097152 GEN_DATA NO
/ora01/oradata/GEN3S/gen_data_03.dbf
6 2097152 GEN_DATA NO
/ora02/oradata/GEN3S/gen_data_04.dbf
7 2097152 GEN_DATA NO
/ora01/oradata/GEN3S/gen_data_05.dbf
8 2097152 GEN_DATA NO
/ora02/oradata/GEN3S/gen_data_06.dbf
9 2096136 GEN_DATA NO
/ora01/oradata/GEN3S/gen_data_07.dbf
10 2097152 GEN_DATA NO
/ora02/oradata/GEN3S/gen_data_08.dbf
11 2074728 GEN_DATA NO
/ora01/oradata/GEN3S/gen_data_09.dbf
12 3211264 GEN_DATA NO
/ora02/oradata/GEN3S/gen_data_10.dbf
13 3211264 GEN_DATA NO
/ora01/oradata/GEN3S/gen_data_11.dbf
14 3211264 GEN_DATA NO
/ora01/oradata/GEN3S/gen_data_12.dbf
15 1835008 GEN_INDX NO
/ora01/oradata/GEN3S/gen_indx_01.dbf
16 1835008 GEN_INDX NO
/ora02/oradata/GEN3S/gen_indx_02.dbf
17 1703936 GEN_INDX NO
/ora01/oradata/GEN3S/gen_indx_03.dbf
18 1835008 GEN_INDX NO
/ora02/oradata/GEN3S/gen_indx_04.dbf
19 1048576 GEN_INDX NO
/ora01/oradata/GEN3S/gen_indx_05.dbf
20 655360 GEN_INDX NO
/ora02/oradata/GEN3S/gen_indx_06.dbf
21 2228224 GEN_INDX NO
/ora01/oradata/GEN3S/gen_indx_07.dbf
22 2232320 GEN_INDX NO
/ora02/oradata/GEN3S/gen_indx_08.dbf
23 65536 INDX NO
/ora01/oradata/GEN3S/gen_indx01.dbf
24 2097152 RBS YES
/ora02/oradata/GEN3S/gen_rbs01.dbf
25 2097152 RBS YES
/ora01/oradata/GEN3S/gen_rbs02.dbf
28 872448 TOOLS NO
/ora01/oradata/GEN3S/gen_tools01.dbf
29 131072 USERS NO
/ora02/oradata/GEN3S/gen_users01.dbf
30 469504 GEN_REP_DATA NO
/ora01/oradata/GEN3S/gen_rep_data_01.dbf
31 468736 GEN_REP_DATA NO
/ora02/oradata/GEN3S/gen_rep_data_02.dbf
32 465152 GEN_REP_DATA NO
/ora01/oradata/GEN3S/gen_rep_data_03.dbf
33 466944 GEN_REP_DATA NO
/ora02/oradata/GEN3S/gen_rep_data_04.dbf
34 32768 FOGLIGHT NO
/ora02/oradata/GEN3S/foglight_01.dbf
4. crosscheck backup has problem too
========================================
RMAN> crosscheck backup;
RMAN-03022: compiling command: XCHECK
RMAN-03026: error recovery releasing channel resources
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure during compilation of command
RMAN-03013: command type: XCHECK
RMAN-06004: ORACLE error from recovery catalog database: RMAN-20242:
specification does not match any archivelog in the recovery catalog
5. crosscheck backup of tablespace system;
RMAN> crosscheck backup of tablespace system;
RMAN-03022: compiling command: XCHECK
RMAN-03023: executing command: XCHECK
RMAN-08074: crosschecked backup piece: found to be 'EXPIRED'
RMAN-08517: backup piece
handle=/oracle/admin/GEN3S/backup/May11bkup_cold_GEN3S_1_14.dbf recid=12
stamp=622309903
RMAN-08074: crosschecked backup piece: found to be 'EXPIRED'
RMAN-08517: backup piece
handle=/oracle/admin/GEN3S/backup/May15bkup_cold_GEN3S_1_25.dbf recid=23
stamp=622644884
RMAN-08074: crosschecked backup piece: found to be 'EXPIRED'
RMAN-08517: backup piece
handle=/oracle/admin/GEN3S/backup/May17bkup_cold_GEN3S_1_27.dbf recid=23
stamp=622832261
RMAN-08074: crosschecked backup piece: found to be 'AVAILABLE'
RMAN-08517: backup piece
handle=/oracle/admin/GEN3S/backup/May21Task38_cold_GEN3S_1_38.dbf
recid=34 stamp=623150216
RMAN-03023: executing command: partial resync
RMAN-08003: starting partial resync of recovery catalog
RMAN-08005: partial resync complete
crosscheck backup of tablespace SYSTEM ;
crosscheck backup of tablespace AUDIT_DATA ;
crosscheck backup of tablespace GEN_DATA ;
crosscheck backup of tablespace GEN_INDX ;
crosscheck backup of tablespace INDX ;
crosscheck backup of tablespace RBS ;
crosscheck backup of tablespace TOOLS ;
crosscheck backup of tablespace USERS ;
crosscheck backup of tablespace GEN_REP_DATA ;
crosscheck backup of tablespace FOGLIGHT ;
delete expired backup of tablespace SYSTEM ;
delete expired backup of tablespace AUDIT_DATA ;
delete expired backup of tablespace GEN_DATA ;
delete expired backup of tablespace GEN_INDX ;
delete expired backup of tablespace INDX ;
delete expired backup of tablespace RBS ;
delete expired backup of tablespace TOOLS ;
delete expired backup of tablespace USERS ;
delete expired backup of tablespace GEN_REP_DATA ;
delete expired backup of tablespace FOGLIGHT ;
No comments:
Post a Comment