标记RMAN
BACKUP TABLESPACE USERS TAG ‘LIHAO’;
LIST BACKUPSET TAG “LIHAO”;
DELETE BACKUPSET TAG ‘LIHAO’;
中配置保留策略
SHOW RETENTION POLICY;
基于冗余的保留策略
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
BACKUP TABLESPACE USERS TAG ‘TEST’;
查看过期的备份
REPORT OBSOLETE;
删除过期的备份
DELETE OBSOLETE;
LIST BACKUP OF TABLESPACE USERS;
基于恢复窗口的保留策略
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
SHOW RETENTION POLICY;
CONFIGURE RETENTION POLICY CLEAR;
配置默认备份格式
SHOW CHANNEL FOR DEVICE TYPE DISK;
配置非默认备份位置
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/u01/app/oracle/BACKUP/%U.bkp’;
BACKUP TABLESPACE USERS TAG ‘TEST’;
BACKUP AS COPY TABLESPACE USERS TAG ‘TEST’;
CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;
SHOW CHANNEL FOR DEVICE TYPE DISK;
定义备份目的地
RUN
{
ALLOCATE CHANNEL c1 DEVICE TYPE disk FORMAT ‘/u01/app/oracle/BACKUP/RMANDB_%t_s%s_p%p’;
BACKUP TABLESPACE users TAG ‘TEST’;
BACKUP ARCHIVELOG ALL DELETE INPUT TAG ‘ARC’;
}
查看
在默认通道中配置并行性
SHOW DEVICE TYPE;
CONFIGURE DEVICE TYPE DISK PARALLELISM 2;
BACKUP TABLESPACE USERS TAG ‘USERS_BS’
LIST BACKUP;
手动配置每个通道
CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT ‘/u01/app/oracle/BACKUP/BSS1/%U.bkp’;
CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT ‘/u01/app/oracle/BACKUP/BSS2/%U.bkp’;
备份完成
CONFIGURE DEVICE TYPE disk CLEAR;
RUN
{
ALLOCATE CHANNEL ch1 DEVICE TYPE DISK FORMAT ‘/u01/app/oracle/BACKUP/BSS1/%U.bkp’;
ALLOCATE CHANNEL ch2 DEVICE TYPE DISK FORMAT ‘/u01/app/oracle/BACKUP/BSS2/%U.bkp’;
BACKUP DATABASE;
}
RMAN 多段备份
REPORT SCHEMA;
BACKUP TABLESPACE SYSTEM;
LIST BACKUP OF TABLESPACE SYSTEM;
DELETE BACKUPSET;
BACKUP TABLESPACE SYSTEM SECTION SIZE 400M;
LIST BACKUP OF TABLESPACE SYSTEM;
DELETE BACKUPSET;
RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
BACKUP TABLESPACE SYSTEM SECTION SIZE 400M;
}
LIST BACKUP OF TABLESPACE SYSTEM;
RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
BACKUP INCREMENTAL LEVEL 1 SECTION SIZE 400M DATAFILE ‘/u01/app/oracle/oradata/ORADB/system01.dbf’;
}
RUN {
ALLOCATE CHANNEL c1 DEVICE TYPE DISK;
ALLOCATE CHANNEL c2 DEVICE TYPE DISK;
ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
BACKUP AS COPY SECTION SIZE 400M TABLESPACE SYSTEM;
}
LIST COPY OF TABLESPACE SYSTEM;
使用 LIST 命令获取有关 RMAN 备份的信息
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
BACKUP AS BACKUPSET DATABASE TAG ‘DB_FULL_BS’;
BACKUP TABLESPACE USERS TAG ‘USERS_BS’;
BACKUP TABLESPACE USERS TAG ‘USERS_BS’;
BACKUP AS COPY DATABASE TAG ‘DB_FULL_CP’;
BACKUP ARCHIVELOG ALL TAG ‘ARC_BS’;
BACKUP AS COPY ARCHIVELOG ALL;
查看备份
LIST BACKUP;
LIST BACKUP SUMMARY;
LIST BACKUP OF DATABASE;
LIST COPY;
LIST BACKUP OF TABLESPACE USERS;
LIST COPY OF TABLESPACE USERS;
LIST BACKUPSET TAG ‘ARC_BS’
LIST ARCHIVELOG ALL;
LIST ARCHIVELOG SEQUENCE BETWEEN 15 and 16;
LIST BACKUP OF ARCHIVELOG ALL;
LIST BACKUP OF ARCHIVELOG TIME BETWEEN ‘SYSDATE-1’ AND ‘SYSDATE’;
LIST ARCHIVELOG TIME BETWEEN ‘SYSDATE-1’ AND ‘SYSDATE’;
db19-rman详细教程二
最新推荐文章于 2024-01-03 14:35:07 发布
本文详细介绍了Oracle Recovery Manager (RMAN) 的各种命令,包括备份、恢复策略、保留策略配置、备份空间管理以及多段备份等操作。通过具体的RMAN命令示例,展示了如何进行数据库、表空间的备份、查询备份信息、删除过期备份以及设置备份通道和并行性等,为数据库管理员提供了实用的操作指南。
摘要由CSDN通过智能技术生成