RMAN Configuration

Showing the Default RMAN Configuration

11.2.0.4

RMAN> SHOW ALL;
using target database control file instead of recovery catalog
RMAN configuration parameters for database with db_unique_name ORCL are:
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP OFF; # default
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION FOR DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/u01/app/oracle/product/11.2.0/db_1/dbs/snapcf_orcl.f'; # default

Showing the backup information

-- 列出所有备份集
RMAN> LIST BACKUP;

-- 列出所有备份集的摘要信息
RMAN> LIST BACKUP SUMMARY;

-- 列出所有备份和副本（按文件分组）
RMAN> LIST BACKUP BY FILE;

-- 列出备份副本（image copies）
RMAN> LIST COPY;
RMAN> LIST COPY OF DATABASE;
RMAN> LIST COPY OF ARCHIVELOG ALL;

-- 列出数据库备份
RMAN> LIST BACKUP OF DATABASE;

-- 列出归档日志备份
RMAN> LIST BACKUP OF ARCHIVELOG ALL;

-- 列出控制文件备份
RMAN> LIST BACKUP OF CONTROLFILE;

-- 列出SPFILE备份
RMAN> LIST BACKUP OF SPFILE;

-- 列出特定表空间的备份
RMAN> LIST BACKUP OF TABLESPACE USERS;

-- 列出数据文件备份
RMAN> LIST BACKUP OF DATAFILE 1;

-- 按时间范围列出备份
RMAN> LIST BACKUP COMPLETED AFTER 'sysdate-7';

-- 列出过期的备份
RMAN> LIST EXPIRED BACKUP;

-- 查看备份标签
RMAN> LIST BACKUP TAG 'WEEKLY_BACKUP';

-- 列出需要备份的文件
RMAN> REPORT NEED BACKUP;

验证备份

-- 验证数据库文件（验证所有数据文件和控制文件）
RMAN> VALIDATE DATABASE;

-- 验证指定备份集（需要先通过LIST BACKUP查看备份集编号）
RMAN> LIST BACKUP SUMMARY;
RMAN> VALIDATE BACKUPSET 123;

-- 验证归档日志
RMAN> VALIDATE ARCHIVELOG ALL;

-- 验证表空间
RMAN> VALIDATE TABLESPACE USERS;

-- 验证数据文件
RMAN> VALIDATE DATAFILE 1;

-- 验证备份（检查逻辑损坏，不实际备份）
RMAN> BACKUP VALIDATE CHECK LOGICAL DATABASE;
RMAN> BACKUP VALIDATE CHECK LOGICAL ARCHIVELOG ALL;

-- 验证恢复操作（不实际恢复，只检查是否可恢复）
RMAN> RESTORE DATABASE VALIDATE;
RMAN> RESTORE TABLESPACE USERS VALIDATE;
RMAN> RESTORE ARCHIVELOG ALL VALIDATE;

-- 交叉检查备份（检查备份文件是否存在于磁盘/磁带）
RMAN> CROSSCHECK BACKUP;
RMAN> CROSSCHECK ARCHIVELOG ALL;

-- 删除过期备份（CROSSCHECK后标记为EXPIRED的备份）
RMAN> DELETE EXPIRED BACKUP;

-- 删除废弃备份（根据保留策略）
RMAN> DELETE OBSOLETE;