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

来源:互联网 发布:xtrafinder for mac 编辑:程序博客网 时间:2024/05/08 15:10
RMAN> list copy;List of Archived Log CopiesKey     Thrd Seq     S Low Time  Name------- ---- ------- - --------- ----1       1    1       A 31-AUG-14 /u01/oracle/11G/dbs/arch1_1_857057445.dbf2       1    2       A 02-SEP-14 /u01/oracle/11G/dbs/arch1_2_857057445.dbf3       1    3       A 06-SEP-14 /u01/oracle/11G/dbs/arch1_3_857057445.dbf4       1    4       A 18-NOV-14 /u01/oracle/11G/dbs/arch1_4_857057445.dbfRMAN> delete copy;released channel: ORA_DISK_1allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=140 devtype=DISKList of Archived Log CopiesKey     Thrd Seq     S Low Time  Name------- ---- ------- - --------- ----1       1    1       A 31-AUG-14 /u01/oracle/11G/dbs/arch1_1_857057445.dbf2       1    2       A 02-SEP-14 /u01/oracle/11G/dbs/arch1_2_857057445.dbf3       1    3       A 06-SEP-14 /u01/oracle/11G/dbs/arch1_3_857057445.dbf4       1    4       A 18-NOV-14 /u01/oracle/11G/dbs/arch1_4_857057445.dbfDo you really want to delete the above objects (enter YES or NO)? yesdeleted archive logarchive log filename=/u01/oracle/11G/dbs/arch1_1_857057445.dbf recid=1 stamp=857217649deleted archive logarchive log filename=/u01/oracle/11G/dbs/arch1_2_857057445.dbf recid=2 stamp=857520610deleted archive logarchive log filename=/u01/oracle/11G/dbs/arch1_3_857057445.dbf recid=3 stamp=863992930deleted archive logarchive log filename=/u01/oracle/11G/dbs/arch1_4_857057445.dbf recid=4 stamp=866222072Deleted 4 objectsRMAN> list copy;specification does not match any archive log in the recovery catalogRMAN> 


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_1allocated channel: c5channel c5: sid=140 devtype=DISKallocated channel: c6channel c6: sid=132 devtype=DISKStarting backup at 02-FEB-15channel c5: starting full datafile backupsetchannel c5: specifying datafile(s) in backupsetinput datafile fno=00005 name=/u01/oracle/oradata/db01/ts_move/ts_DTFILETS01.dbfchannel c5: starting piece 1 at 02-FEB-15channel c5: finished piece 1 at 02-FEB-15piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 tag=TAG20150202T213118 comment=NONEchannel c5: backup set complete, elapsed time: 00:00:02Finished backup at 02-FEB-15released channel: c5released channel: c6RMAN> list copy;specification does not match any archive log in the recovery catalogRMAN>  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.dbfRMAN>  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.dbfRMAN> delete backup;allocated channel: ORA_DISK_1channel ORA_DISK_1: sid=140 devtype=DISKList of Backup PiecesBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name------- ------- --- --- ----------- ----------- ----------1       1       1   1   AVAILABLE   DISK        /u01/oracle/11G/dbs/01pu9u56_1_1Do you really want to delete the above objects (enter YES or NO)? yesRMAN-06207: WARNING: 1 objects could not be deleted for DISK channel(s) dueRMAN-06208:          to mismatched status.  Use CROSSCHECK command to fix statusRMAN-06210: List of Mismatched objectsRMAN-06211: ==========================RMAN-06212:   Object Type   Filename/HandleRMAN-06213: --------------- ---------------------------------------------------RMAN-06214: Backup Piece    /u01/oracle/11G/dbs/01pu9u56_1_1RMAN> crosscheck backuppiece '/u01/oracle/11G/dbs/01pu9u56_1_1';using channel ORA_DISK_1crosschecked backup piece: found to be 'EXPIRED'backup piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 recid=1 stamp=870643879Crosschecked 1 objectsRMAN>  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.dbfRMAN> delete backup;using channel ORA_DISK_1List of Backup PiecesBP Key  BS Key  Pc# Cp# Status      Device Type Piece Name------- ------- --- --- ----------- ----------- ----------1       1       1   1   EXPIRED     DISK        /u01/oracle/11G/dbs/01pu9u56_1_1Do you really want to delete the above objects (enter YES or NO)? yesdeleted backup piecebackup piece handle=/u01/oracle/11G/dbs/01pu9u56_1_1 recid=1 stamp=870643879Deleted 1 objectsRMAN> 




0 0
原创粉丝点击