RMAN> report obsolete;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
controlfile is not current - obsolete file list may be incomplete
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6 06-SEP-04
Backup Piece 6 06-SEP-04 /oraclebackup/08fva8dt_1_1_8.bak
Backup Set 8 06-SEP-04
Backup Piece 8 06-SEP-04 /oraclebackup/0afva9d7_1_1_10.bak
Backup Set 10 06-SEP-04
Backup Piece 10 06-SEP-04 /oraclebackup/0dfvah8q_1_1_13.bak
Controlfile Copy 2 26-AUG-04 /opt/control01.ctl
Controlfile Copy 3 06-SEP-04 /oraclebackup/control01.ctl
RMAN> allocate channel for maintenance type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=14 devtype=DISK
RMAN> crosscheck backup;
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/oraclebackup/08fva8dt_1_1_8.bak recid=6 stamp=536158655
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/oraclebackup/0afva9d7_1_1_10.bak recid=8 stamp=536159656
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/oraclebackup/0dfvah8q_1_1_13.bak recid=10 stamp=536167707
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oraclebackup/0gfvapbi_1_1_16.bak recid=12 stamp=536175987
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oraclebackup/0ifvaq8g_1_1_18.bak recid=14 stamp=536176913
Crosschecked 5 objects
RMAN> delete expired backup;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
6 6 1 1 EXPIRED DISK /oraclebackup/08fva8dt_1_1_8.bak
8 8 1 1 EXPIRED DISK /oraclebackup/0afva9d7_1_1_10.bak
10 10 1 1 EXPIRED DISK /oraclebackup/0dfvah8q_1_1_13.bak
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/oraclebackup/08fva8dt_1_1_8.bak recid=6 stamp=536158655
deleted backup piece
backup piece handle=/oraclebackup/0afva9d7_1_1_10.bak recid=8 stamp=536159656
deleted backup piece
backup piece handle=/oraclebackup/0dfvah8q_1_1_13.bak recid=10 stamp=536167707
Deleted 3 EXPIRED objects
RMAN> RELEASE CHANNEL;
released channel: ORA_MAINT_DISK_1
RMAN> allocate channel for maintenance type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=14 devtype=DISK
RMAN> change archivelog all crosscheck;
specification does not match any archive log in the recovery catalog
RMAN> release channel;
released channel: ORA_MAINT_DISK_1
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
controlfile is not current - obsolete file list may be incomplete
Report of obsolete backups and copies
Type Key Completion Time Filename/Handle
-------------------- ------ ------------------ --------------------
Backup Set 6 06-SEP-04
Backup Piece 6 06-SEP-04 /oraclebackup/08fva8dt_1_1_8.bak
Backup Set 8 06-SEP-04
Backup Piece 8 06-SEP-04 /oraclebackup/0afva9d7_1_1_10.bak
Backup Set 10 06-SEP-04
Backup Piece 10 06-SEP-04 /oraclebackup/0dfvah8q_1_1_13.bak
Controlfile Copy 2 26-AUG-04 /opt/control01.ctl
Controlfile Copy 3 06-SEP-04 /oraclebackup/control01.ctl
RMAN> allocate channel for maintenance type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=14 devtype=DISK
RMAN> crosscheck backup;
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/oraclebackup/08fva8dt_1_1_8.bak recid=6 stamp=536158655
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/oraclebackup/0afva9d7_1_1_10.bak recid=8 stamp=536159656
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/oraclebackup/0dfvah8q_1_1_13.bak recid=10 stamp=536167707
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oraclebackup/0gfvapbi_1_1_16.bak recid=12 stamp=536175987
crosschecked backup piece: found to be 'AVAILABLE'
backup piece handle=/oraclebackup/0ifvaq8g_1_1_18.bak recid=14 stamp=536176913
Crosschecked 5 objects
RMAN> delete expired backup;
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
6 6 1 1 EXPIRED DISK /oraclebackup/08fva8dt_1_1_8.bak
8 8 1 1 EXPIRED DISK /oraclebackup/0afva9d7_1_1_10.bak
10 10 1 1 EXPIRED DISK /oraclebackup/0dfvah8q_1_1_13.bak
Do you really want to delete the above objects (enter YES or NO)? YES
deleted backup piece
backup piece handle=/oraclebackup/08fva8dt_1_1_8.bak recid=6 stamp=536158655
deleted backup piece
backup piece handle=/oraclebackup/0afva9d7_1_1_10.bak recid=8 stamp=536159656
deleted backup piece
backup piece handle=/oraclebackup/0dfvah8q_1_1_13.bak recid=10 stamp=536167707
Deleted 3 EXPIRED objects
RMAN> RELEASE CHANNEL;
released channel: ORA_MAINT_DISK_1
RMAN> allocate channel for maintenance type disk;
allocated channel: ORA_MAINT_DISK_1
channel ORA_MAINT_DISK_1: sid=14 devtype=DISK
RMAN> change archivelog all crosscheck;
specification does not match any archive log in the recovery catalog
RMAN> release channel;
released channel: ORA_MAINT_DISK_1
List of Backup Sets
===================
BS Key Type LV Size Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
12 Full 5G DISK 00:13:12 06-SEP-04
BP Key: 12 Status: AVAILABLE Tag: TAG20040906T174626
Piece Name: /oraclebackup/0gfvapbi_1_1_16.bak
SPFILE Included: Modification time: 26-AUG-04
List of Datafiles in backup set 12
File LV Type Ckp SCN Ckp Time Name
---- -- ---- ---------- --------- ----
1 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/system01.dbf
2 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/undotbs01.dbf
3 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/cwmlite01.dbf
4 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/drsys01.dbf
5 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/example01.dbf
6 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/indx01.dbf
7 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/odm01.dbf
8 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/tools01.dbf
9 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/users01.dbf
10 Full 2567161 06-SEP-04 /opt/oracle/oradata/szdb/xdb01.dbf
BS Key Size Device Type Elapsed Time Completion Time
------- ---------- ----------- ------------ ---------------
14 893K DISK 00:00:01 06-SEP-04
BP Key: 14 Status: AVAILABLE Tag: TAG20040906T180147
Piece Name: /oraclebackup/0ifvaq8g_1_1_18.bak
List of Archived Logs in backup set 14
Thrd Seq Low SCN Low Time Next SCN Next Time
---- ------- ---------- --------- ---------- ---------
1 101 2567090 06-SEP-04 2569104 06-SEP-04
1 102 2569104 06-SEP-04 2569416 06-SEP-04
RMAN> restore database;
Starting restore at 07-SEP-04
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=14 devtype=DISK
channel ORA_DISK_1: starting datafile backupset restore
channel ORA_DISK_1: specifying datafile(s) to restore from backup set
restoring datafile 00001 to /opt/oracle/oradata/szdb/system01.dbf
restoring datafile 00002 to /opt/oracle/oradata/szdb/undotbs01.dbf
restoring datafile 00003 to /opt/oracle/oradata/szdb/cwmlite01.dbf
restoring datafile 00004 to /opt/oracle/oradata/szdb/drsys01.dbf
restoring datafile 00005 to /opt/oracle/oradata/szdb/example01.dbf
restoring datafile 00006 to /opt/oracle/oradata/szdb/indx01.dbf
restoring datafile 00007 to /opt/oracle/oradata/szdb/odm01.dbf
restoring datafile 00008 to /opt/oracle/oradata/szdb/tools01.dbf
restoring datafile 00009 to /opt/oracle/oradata/szdb/users01.dbf
restoring datafile 00010 to /opt/oracle/oradata/szdb/xdb01.dbf
channel ORA_DISK_1: restored backup piece 1
piece handle=/oraclebackup/0gfvapbi_1_1_16.bak tag=TAG20040906T174626 params=NULL
channel ORA_DISK_1: restore complete
Finished restore at 07-SEP-04
RMAN> restore archivelog all;
Starting restore at 07-SEP-04
using channel ORA_DISK_1
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-03002: failure of restore command at 09/07/2004 09:59:53
RMAN-06026: some targets not found - aborting restore
RMAN-06025: no backup of log thread 1 seq 100 scn 2546040 found to restore
RMAN-06025: no backup of log thread 1 seq 99 scn 2545959 found to restore
RMAN-06025: no backup of log thread 1 seq 98 scn 2545882 found to restore
RMAN-06025: no backup of log thread 1 seq 97 scn 2545819 found to restore
RMAN-06025: no backup of log thread 1 seq 96 scn 2545743 found to restore
RMAN-06025: no backup of log thread 1 seq 95 scn 2545622 found to restore
RMAN-06025: no backup of log thread 1 seq 94 scn 2515555 found to restore
RMAN-06025: no backup of log thread 1 seq 93 scn 2515475 found to restore
RMAN-06025: no backup of log thread 1 seq 92 scn 2513221 found to restore
RMAN-06025: no backup of log thread 1 seq 91 scn 2513145 found to restore
RMAN-06025: no backup of log thread 1 seq 90 scn 2504863 found to restore
RMAN-06025: no backup of log thread 1 seq 89 scn 2471725 found to restore
RMAN-06025: no backup of log thread 1 seq 88 scn 2194493 found to restore
RMAN-06025: no backup of log thread 1 seq 87 scn 1917742 found to restore
RMAN-06025: no backup of log thread 1 seq 86 scn 1639997 found to restore
RMAN-06025: no backup of log thread 1 seq 85 scn 1638727 found to restore
RMAN-06025: no backup of log thread 1 seq 84 scn 1638645 found to restore
RMAN-06025: no backup of log thread 1 seq 83 scn 1631895 found to restore
RMAN-06025: no backup of log thread 1 seq 82 scn 1609355 found to restore
RMAN-06025: no backup of log thread 1 seq 81 scn 1585298 found to restore
RMAN-06025: no backup of log thread 1 seq 80 scn 1384513 found to restore
RMAN-06025: no backup of log thread 1 seq 58 scn 253682 found to restore
RMAN-06025: no backup of log thread 1 seq 57 scn 251359 found to restore
RMAN-06025: no backup of log thread 1 seq 56 scn 251270 found to restore
RMAN-06025: no backup of log thread 1 seq 55 scn 251265 found to restore
RMAN-06025: no backup of log thread 1 seq 54 scn 241794 found to restore[oracle@test3 oraclebackup]$ ls
0gfvapbi_1_1_16.bak 0ifvaq8g_1_1_18.bak initszdb.ora请问这个restore archivelog all; 的问题该怎么解决,谢谢