rman delete
来源:互联网 发布:aso如何优化 编辑:程序博客网 时间:2024/06/05 14:26
8.4.3 删除备份--DELETE命令
用于删除RMAN备份记录及相应的物理文件。当使用RMAN执行备份操作时,会在RMAN资料库(RMAN Repository)中生成RMAN备份记录,默认情况下RMAN备份记录会被存放在目标数据库的控制文件中,如果配置了恢复目录(Recovery Catalog),那么该备份记录也会被存放到恢复目录中。
RMAN中的DELETE命令就是用来删除记录(某些情况下并非删除记录,而是打上删除标记),以及这些记录关联的物理备份片段。
删除过期备份。当使用RMAN命令执行备份操作时,RMAN会根据备份冗余策略确定备份是否过期。
RMAN> DELETE OBSOLETE;
删除无效备份。首先执行CROSSCHECK命令核对备份集,如果发现备份无效(比如备份对应的数据文件损坏或丢失),RMAN会将该备份集标记为EXPIRED状态。要删除相应的备份记录,可以执行DELETE EXPIRED BACKUP命令:
RMAN> DELETE EXPIRED BACKUP;
删除EXPIRED副本,如下所示:
RMAN> DELETE EXPIRED COPY;
删除特定备份集,如下所示:
RMAN> DELETE BACKUPSET 19;
删除特定备份片,如下所示:
RMAN> DELETE BACKUPPIECE 'd:\backup\DEMO_19.bak';
删除所有备份集,如下所示:
RMAN> DELETE BACKUP;
删除特定映像副本,如下所示:
RMAN> DELETE DATAFILE COPY 'd:\backup\DEMO_19.bak';
删除所有映像副本,如下所示:
RMAN> DELETE COPY;
在备份后删除输入对象,如下所示:
RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;
RMAN> DELETE BACKUPSET 22 FORMAT = "d:\backup\%u.bak" DELETE INPUT;
sqlplus / as sysdba
select * from V$FLASH_RECOVERY_AREA_USAGE; 查询archlog大小
alter system set db_recovery_file_dest_size=5G scope=spfile; 更改archlog 大小
rman 删除archlog
crosscheck archivelog all; #检测archlog
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1'; #删除一天前的archlog
pog用rman 全背数据库
rman target /
backup database format '/oracle.bak/%u.bak'; #数据库全背
delete backuppiece '/oracle.bak/%u.bak'; #删除备份%u 根据实际文件名字
用于删除RMAN备份记录及相应的物理文件。当使用RMAN执行备份操作时,会在RMAN资料库(RMAN Repository)中生成RMAN备份记录,默认情况下RMAN备份记录会被存放在目标数据库的控制文件中,如果配置了恢复目录(Recovery Catalog),那么该备份记录也会被存放到恢复目录中。
RMAN中的DELETE命令就是用来删除记录(某些情况下并非删除记录,而是打上删除标记),以及这些记录关联的物理备份片段。
删除过期备份。当使用RMAN命令执行备份操作时,RMAN会根据备份冗余策略确定备份是否过期。
RMAN> DELETE OBSOLETE;
删除无效备份。首先执行CROSSCHECK命令核对备份集,如果发现备份无效(比如备份对应的数据文件损坏或丢失),RMAN会将该备份集标记为EXPIRED状态。要删除相应的备份记录,可以执行DELETE EXPIRED BACKUP命令:
RMAN> DELETE EXPIRED BACKUP;
删除EXPIRED副本,如下所示:
RMAN> DELETE EXPIRED COPY;
删除特定备份集,如下所示:
RMAN> DELETE BACKUPSET 19;
删除特定备份片,如下所示:
RMAN> DELETE BACKUPPIECE 'd:\backup\DEMO_19.bak';
删除所有备份集,如下所示:
RMAN> DELETE BACKUP;
删除特定映像副本,如下所示:
RMAN> DELETE DATAFILE COPY 'd:\backup\DEMO_19.bak';
删除所有映像副本,如下所示:
RMAN> DELETE COPY;
在备份后删除输入对象,如下所示:
RMAN> BACKUP ARCHIVELOG ALL DELETE INPUT;
RMAN> DELETE BACKUPSET 22 FORMAT = "d:\backup\%u.bak" DELETE INPUT;
sqlplus / as sysdba
select * from V$FLASH_RECOVERY_AREA_USAGE; 查询archlog大小
alter system set db_recovery_file_dest_size=5G scope=spfile; 更改archlog 大小
rman 删除archlog
crosscheck archivelog all; #检测archlog
DELETE ARCHIVELOG ALL COMPLETED BEFORE 'SYSDATE-1'; #删除一天前的archlog
pog用rman 全背数据库
rman target /
backup database format '/oracle.bak/%u.bak'; #数据库全背
delete backuppiece '/oracle.bak/%u.bak'; #删除备份%u 根据实际文件名字
阅读全文
0 0
- rman delete
- RMAN delete expired & delete obsolete
- rman: delete [all] input
- RMAN Crosscheck/Delete
- RMAN Crosscheck/Delete
- rman report list crosscheck delete -rman常用命令。
- RMAN命令delete noprompt obsolete,delete什么?
- Rman delete expried backup files
- RMAN 删除备份--DELETE命令
- rman删除备份--DELETE命令
- rman 的report list crosscheck delete show
- Oracle RMAN的show,list,crosscheck,delete
- rman 删除 delete noprompt obsolete 时出错
- rman 之crosscheck 与delete expired 2
- RMAN DELETE INPUT和DELETE ALL INPUT的区别
- Oracle RMAN 的 show,list,crosscheck,delete命令整理
- Oracle RMAN 的 show,list,crosscheck,delete命令整理
- 通过rman的delete命令删除归档日志文件
- maven_setting.xml备份
- 内联汇编
- MySQL的数据类型
- VB操作Excel
- 用SQL命令查看Mysql数据库大小
- rman delete
- Windows 窗体启动和关闭的事件顺序
- MySQL 安全配置
- 遍历磁盘目录代码实例
- 第十章 提纲挈领
- 线程安全与非线程安全
- notepad++查看bmp图片显示是乱码
- map集合重新遍历KEY得到不一样的VALUE
- maven-assembly-plugin 入门指南