list命令:
list backupset summary 列出概要信息 list backupset by file
list archivelog all 列出所有归档日志 list backupset tag ' 00'列出标签信息
list backupset 8 列出8号备份集 list backup ofdatabase
list backup of tablespace users list backup
report命令:
report schema 查看构成数据库组成的文件 report unrecoverable (alter database force logging)
report need backup 报告需要备份的文件 report need backup days 3;列出三天未备份的文件
report need backup redundancy 3 列出没有3个备份的所有文件
report need backup tablespace system列出表空间需要备份
report obsolete 列出违反保留策略的备份集
show all 查看默认的保留策略
rman备份:
数据库启动到mount状态,backup database backup datafile 4 归档非归档均可
备份集 list backup 逻辑概念
备份片一个一个的文件
configure channel device type disk maxpiecesize 200m
crosscheck交叉检查
crosscheck backup
list expired backupset 查看过期 delete backupset delete expired backupset
delete expired 不删除文件,只更新存储库 delete obsolete 删除并更新rman储存库
backup noprompt backupset
手工注册备份集和归档日志
1.注册单个备份片
catalog backuppiece 路径
2.注册整个目录
catalog start with 目录
注册归档文件
单个:alter database register physical logfile路径
多个catalog start with 目录