rman 进度条--待续 定时计划

RMAN> list copy;


List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
1       1    1       A 31-AUG-14 /u01/oracle/11G/dbs/arch1_1_857057445.dbf
2       1    2       A 02-SEP-14 /u01/oracle/11G/dbs/arch1_2_857057445.dbf
3       1    3       A 06-SEP-14 /u01/oracle/11G/dbs/arch1_3_857057445.dbf
4       1    4       A 18-NOV-14 /u01/oracle/11G/dbs/arch1_4_857057445.dbf

RMAN> delete copy;

released channel: ORA_DISK_1
allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK

List of Archived Log Copies
Key     Thrd Seq     S Low Time  Name
------- ---- ------- - --------- ----
1       1    1       A 31-AUG-14 /u01/oracle/11G/dbs/arch1_1_857057445.dbf
2       1    2       A 02-SEP-14 /u01/oracle/11G/dbs/arch1_2_857057445.dbf
3       1    3       A 06-SEP-14 /u01/oracle/11G/dbs/arch1_3_857057445.dbf
4       1    4       A 18-NOV-14 /u01/oracle/11G/dbs/arch1_4_857057445.dbf

Do you really want to delete the above objects (enter YES or NO)? yes
deleted archive log
archive log filename=/u01/oracle/11G/dbs/arch1_1_857057445.dbf recid=1 stamp=857217649
deleted archive log
archive log filename=/u01/oracle/11G/dbs/arch1_2_857057445.dbf recid=2 stamp=857520610
deleted archive log
archive log filename=/u01/oracle/11G/dbs/arch1_3_857057445.dbf recid=3 stamp=863992930
deleted archive log
archive log filename=/u01/oracle/11G/dbs/arch1_4_857057445.dbf recid=4 stamp=866222072
Deleted 4 objects


RMAN> list copy;

specification does not match any archive log in the recovery catalog

RMAN> 

RMAN> run{
2> allocate channel c5 device type disk;
3> allocate channel c6 device type disk;
4> backup tablespace DTFILETS;
5> }

released channel: ORA_DISK_1
allocated channel: c5
channel c5: sid=140 devtype=DISK

allocated channel: c6
channel c6: sid=132 devtype=DISK

Starting backup at 02-FEB-15
channel c5: starting full datafile backupset
channel c5: specifying datafile(s) in backupset
input datafile fno=00005 name=/u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf
channel c5: starting piece 1 at 02-FEB-15
channel c5: finished piece 1 at 02-FEB-15
piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 tag=TAG20150202T213118 comment=NONE
channel c5: backup set complete, elapsed time: 00:00:02
Finished backup at 02-FEB-15
released channel: c5
released channel: c6

RMAN> list copy;

specification does not match any archive log in the recovery catalog

RMAN>  list backup; 


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    1.16M      DISK        00:00:01     02-FEB-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150202T213118
        Piece Name: /u01/oracle/11G/dbs/01pu9u56_1_1
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 1347509    02-FEB-15 /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf

RMAN>  list backup; 


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    1.16M      DISK        00:00:01     02-FEB-15      
        BP Key: 1   Status: AVAILABLE  Compressed: NO  Tag: TAG20150202T213118
        Piece Name: /u01/oracle/11G/dbs/01pu9u56_1_1
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 1347509    02-FEB-15 /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf

RMAN> delete backup;

allocated channel: ORA_DISK_1
channel ORA_DISK_1: sid=140 devtype=DISK

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1       1       1   1   AVAILABLE   DISK        /u01/oracle/11G/dbs/01pu9u56_1_1

Do you really want to delete the above objects (enter YES or NO)? yes

RMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) due
RMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix status
RMAN-06210: List of Mismatched objects
RMAN-06211: ==========================
RMAN-06212:   Object Type   Filename/Handle
RMAN-06213: --------------- ---------------------------------------------------
RMAN-06214: Backup Piece    /u01/oracle/11G/dbs/01pu9u56_1_1


RMAN> crosscheck backuppiece '/u01/oracle/11G/dbs/01pu9u56_1_1';

using channel ORA_DISK_1
crosschecked backup piece: found to be 'EXPIRED'
backup piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 recid=1 stamp=870643879
Crosschecked 1 objects


RMAN>  list backup; 


List of Backup Sets
===================

BS Key  Type LV Size       Device Type Elapsed Time Completion Time
------- ---- -- ---------- ----------- ------------ ---------------
1       Full    1.16M      DISK        00:00:01     02-FEB-15      
        BP Key: 1   Status: EXPIRED  Compressed: NO  Tag: TAG20150202T213118
        Piece Name: /u01/oracle/11G/dbs/01pu9u56_1_1
  List of Datafiles in backup set 1
  File LV Type Ckp SCN    Ckp Time  Name
  ---- -- ---- ---------- --------- ----
  5       Full 1347509    02-FEB-15 /u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbf

RMAN> delete backup;

using channel ORA_DISK_1

List of Backup Pieces
BP Key  BS Key  Pc# Cp# Status      Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
1       1       1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/01pu9u56_1_1

Do you really want to delete the above objects (enter YES or NO)? yes
deleted backup piece
backup piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 recid=1 stamp=870643879
Deleted 1 objects


RMAN>