Monday, March 2, 2015

Useful RMAN Commands(Deleting Archivelogs)


List archivelogs

RMAN> list archivelog all;
RMAN>list copy of archivelog  until time 'sysdate-7';
RMAN>list copy of archivelog  until sequence 1000;

Archivelog Deletion method

RMAN> delete archivelog all;
RMAN> delete archivelog  until time 'sysdate-7';
RMAN> delete archivelog until sequence 1000;
RMAN>delete archivelog from time 'sysdate-10';
RMAN> delete noprompt archivelog until time 'sysdate-10'; // this will not ask to confirm the   deletion.

Delete Obsolete Back ups

RMAN>delete obsolete;

RMAN>delete noprompt obsolete;//will not ask for conformation

No comments:

Post a Comment