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
- rman 进度条--待续 定时计划
- RMAN常用命令(未完待续)
- rman 定时备份
- 计划任务执行rman备份
- 中心库rman备份计划
- RMAN备份计划及脚本
- oracle rman 定时备份脚本
- rman 定时增量全备
- Oracle rman定时备份数据库
- 关于进度条的使用理解(待续)
- 计划任务定时执行
- window 定时执行计划
- spring 定时计划
- 计划任务定时关机
- 定时执行计划.php
- 计划任务 定时执行
- 线程中定时计划
- linux定时任务计划
- Difference between Static listener and Dynamic listener registrations
- 运行一个Hadoop Job所需要指定的属性
- XMPP 常见错误:(<failure xmlns="urn:ietf:params:xml:ns:xmpp-sasl"><not-authorized/></failure>)
- LeetCode:Pascal's Triangle
- 美团推荐算法实践
- rman 进度条--待续 定时计划
- ubuntu安装scikit-learn的步骤和virtualbox中安装ubuntu后如何共享本地文件
- leetcode|26|Remove Duplicates from Sorted Array
- Python+Scrapy(完整包全安装过程)
- IOS开发之UITextField开发详细介绍
- POJ3056:The Bavarian Beer Party(区间DP)
- Motivated Word(4)
- ACM--steps--2.2.5--模拟
- jQuery选择器(一)——基本选择器