RMAN Commands

list and report commands

list backup;

list backup summary;

list expired backup;

report obsolete;

report obsolete recovery window of 7 days

list archivelog all;

list expired backup;

Delete commands:

delete archivelog until time 'SYSDATE-10';

delete expired archivelog all;

delete archivelog all;

delete noprompt force archivelog all;

delete noprompt archivelog until sequence=<seqnum>;

If archives not deleting due to any configuration like standby apply you can use FORCE

Ex: delete force noprompt archivelog until sequence=<sqnum>;

delete expired backup;

delete obsolete;

delete obsolete recovery window of 30 days;

Restore Archivelog:

restore archivelog from logseq 3165 until logseq 3180;

catalog:

catalog archivelog '/u10/fra/orcl/archivelog/2016_01_11';

catalog start with '/data1/fra/orcl/backupset' noprompt;

Incarnation:

list incarnation of database;

reset database to incarnation <Inc Key>;

Archivelog deletion policy:

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED TO ALL STANDBY;

CONFIGURE ARCHIVELOG DELETION POLICY TO SHIPPED TO ALL STANDBY;

CONFIGURE ARCHIVELOG DELETION POLICY TO APPLIED TO ALL STANDBY BACKED UP 1 TIMES TO DISK;