*********************************
* Description: RMAN commands
* Compatiablity: RDBMS 11g, 12c
* Date: 05:24 PM EST, 04/18/2017
*********************************


<1> List all archivelog:
     |
     |__ RMAN> list archivelog all;
         RMAN> list copy of archivelog until time 'SYSDATE-10';
         RMAN> list copy of archivelog from time 'SYSDATE-10'
         RMAN> list copy of archivelog from time 'SYSDATE-10' until time 'SYSDATE-2';
         RMAN> list copy of archivelog from sequence 1000;
         RMAN> list copy of archivelog until sequence 1500;
         RMAN> list copy of archivelog from sequence 1000 until sequence 1500;

		 
<2> Delete achivelog:		 
     |
     |__ RMAN> delete archivelog all;
         RMAN> delete archivelog until time 'SYSDATE-10';
         RMAN> delete archivelog from time 'SYSDATE-10'
         RMAN> delete archivelog from time 'SYSDATE-10' until time 'SYSDATE-2';
         RMAN> delete archivelog from sequence 1000;
         RMAN> delete archivelog until sequence 1500;
         RMAN> delete archivelog from sequence 1000 until sequence 1500;
         RMAN> delete archivelog until time = 'sysdate-1' BACKED UP 1 TIMES TO DEVICE TYPE DISK;
         RMAN> delete noprompt archivelog all completed before 'sysdate - 3/24';
		 
		 
<3> Delete backup:
     |
     |__ RMAN> delete noprompt force backup completed before 'sysdate - 10';
	 

<4> Delete back up of control file:
     |
     |__ RMAN> delete noprompt force backup of controlfile completed before 'sysdate - 10';
        

<5> Delete backup of archivelog:
     |
     |__ RMAN> delete backup of archivelog until time='sysdate-1';
	 

<6> List all backup:
     |
     |__ RMAN> list backup;
	 
	 
<7> RMAN command line execution method:
     |
     |__ CMD> rman target / @/u01/emeralit/scripts/backup.rman log=/u01/emeralit/logs/backup.rman