db19-rman详细教程二

标记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’;