db19-rman detailed tutorial two

Tag RMAN
BACKUP TABLESPACE USERS TAG'LIHAO';

Insert picture description here


LIST BACKUPSET TAG "LIHAO";

Insert picture description here


DELETE BACKUPSET TAG'LIHAO';

Insert picture description here


in the configuration retention policy
SHOW RETENTION POLICY;

Insert picture description here


redundancy-based retention policy
CONFIGURE RETENTION POLICY TO REDUNDANCY 2;

Insert picture description here


Insert picture description here


BACKUP TABLESPACE USERS TAG ' TEST';

Insert picture description here


Insert picture description here


Insert picture description here


Insert picture description here


view expired backup
REPORT OBSOLETE;

Insert picture description here


delete expired backup
DELETE OBSOLETE;

Insert picture description here


LIST BACKUP OF TABLESPACE USERS;

Insert picture description here


retention policy based on the recovery window
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;

Insert picture description here


SHOW RETENTION POLICY;

Insert picture description here


CONFIGURE RETENTION POLICY CLEAR;

Insert picture description here


configuration default Backup format
SHOW CHANNEL FOR DEVICE TYPE DISK;

Insert picture description here


Configure non-default backup location
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT'/u01/app/oracle/ BACKUP/% U.bkp';

Insert picture description here


Insert picture description here


Insert picture description here


BACKUP TABLESPACE USERS TAG'TEST';

Insert picture description here


BACKUP AS COPY TABLESPACE USERS TAG'TEST';

Insert picture description here


Insert picture description here


CONFIGURE CHANNEL DEVICE TYPE DISK CLEAR;

Insert picture description here


SHOW CHANNEL FOR DEVICE TYPE DISK;

Insert picture description here


define the backup destination
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 '; } View the configuration of parallelism in the default channel SHOW DEVICE TYPE; CONFIGURE DEVICE TYPE DISK PARALLELISM 2; BACKUP TABLESPACE USERS TAG'USERS_BS' LIST BACKUP; Manually configure each channel CONFIGURE CHANNEL 1 DEVICE TYPE DISK FORMAT'/ u01/app/oracle/ BACKUP/ BSS1/%U.bkp ';




Insert picture description here



Insert picture description here




Insert picture description here



Insert picture description here


Insert picture description here



Insert picture description here



Insert picture description here




Insert picture description here


CONFIGURE CHANNEL 2 DEVICE TYPE DISK FORMAT'/u01/app/oracle/

Insert picture description here


Insert picture description here


BACKUP /BSS2/% U.bkp'; backup complete

Insert picture description here


Insert picture description here


CONFIGURE DEVICE TYPE disk CLEAR;

Insert picture description here


Insert picture description here


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 multi-segment backup 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;




Insert picture description here


Insert picture description here




Insert picture description here



Insert picture description here



Insert picture description here



Insert picture description here



Insert picture description here



Insert picture description here



Insert picture description here





ALLOCATE CHANNEL c3 DEVICE TYPE DISK;
BACKUP TABLESPACE SYSTEM SECTION SIZE 400M;
}

Insert picture description here


LIST BACKUP OF TABLESPACE SYSTEM;

Insert picture description here


RUN { ALLOCATE CHANNEL c1 DEVICE TYPE DISK; ALLOCATE CHANNEL c2 DEVICE TYPE DISK; ALLOCATE CHANNEL INCAL LEVICE BACK TYPE DISK; SIZE 1 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 TABLE SYSTEM; } LIST COPY OF TABLESPACE SYSTEM; Use the LIST command to get information about RMAN backup





Insert picture description here


Insert picture description here


Insert picture description here








Insert picture description here



Insert picture description here



The CONFIGURE The RETENTION POLICY the TO the REDUNDANCY 2;

Insert picture description here


the BACKUP the AS BACKUPSET DATABASE the TAG 'DB_FULL_BS';

Insert picture description here


the BACKUP TABLESPACE the USERS the TAG 'USERS_BS';

Insert picture description here


the BACKUP TABLESPACE the USERS the TAG 'USERS_BS';

Insert picture description here


the BACKUP the AS COPY DATABASE the TAG 'DB_FULL_CP';

Insert picture description here


the BACKUP ARCHIVELOG ALL the TAG 'ARC_BS';

Insert picture description here


the BACKUP AS COPY ARCHIVELOG ALL;

Insert picture description here


view backup
LIST BACKUP;

Insert picture description here


LIST BACKUP SUMMARY;

Insert picture description here


LIST BACKUP OF DATABASE;

Insert picture description here


LIST COPY;

Insert picture description here


LIST BACKUP OF TABLESPACE USERS;

Insert picture description here


LIST COPY OF TABLESPACE USERS;

Insert picture description here


LIST BACKUPSET TAG'ARC_BS'

Insert picture description here


LIST ARCHIVELOG ALL;

Insert picture description here


LIST ARCHIVELOG SEQ and BETWELOG ALL 16;

Insert picture description here


LIST BACKUP OF ARCHIVELOG ALL;

Insert picture description here


LIST BACKUP OF ARCHIVELOG TIME BETWEEN'SYSDATE-1' AND'SYSDATE';

Insert picture description here


LIST ARCHIVELOG TIME BETWEEN'SYSDATE-1' AND'SYSDATE';

Insert picture description here