Liste des commandes utiles RMAN
RMAN> show all;
Configure the disk channel to the format /backup/ora_df%t_s%s_s%p’
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘/backup/ora_df%t_s%s_s%p’;
Configure the disk channel to the format +FLASHDG
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT ‘+FLASHDG’;
Backup the database using the standard RMAN parameters
RMAN> backup database;
List all of the current backups for the database
RMAN> list backup;
List Backup summary
RMAN> list summary;
Crosscheck backups to see if they still exist
RMAN> crosscheck backup;
Crosscheck archive logs to see if they still exist
RMAN> crosscheck archivelog all;
Remove any expired backup
RMAN> delete expired backup;
Remove any expired archivelos
RMAN> delete expired archivelog;
Backup the database and archivelogs using the standard RMAN parameters and delete the archivelogs after the backup
RMAN> backup archivelog all delete input;
And
RMAN> run
2> {
3> backup database;
4> backup archivelog all delete input;
5> }
Report of files that need backup due to unrecoverable operations
RMAN> report unrecoverable;
Report the obsolete backups and archivelogs
RMAN> report obsolete;
Delete the obsolete backups and archivelogs
RMAN> delete obsolete;
List all of the archivelogs
RMAN> list archivelog all;
Delete a specifed backupset
RMAN> delete backupset 1344
Sample backup command
RMAN> run
2> {
3> backup database;
4> sql “alter system switch logfile”;
5> backup archivelog all delete input;
6> sql “alter database backup controlfile to trace”;
7> }
Backup archive logs from scn 680
RMAN> run
2> {
3> ALLOCATE CHANNEL d1 DEVICE TYPE disk
4> FORMAT = ‘/app/oracle/admin/TEST/backup/df_%d_%s_%p.bak’;
5> backup as compressed backupset archivelog from sequence 680;
6> }
Backup archive logs and delete them up to scn 679
RMAN> run
2> {
3> ALLOCATE CHANNEL d1 DEVICE TYPE disk
4> FORMAT = ‘/app/oracle/admin/TEST/backup/df_%d_%s_%p.bak’;
5> backup as compressed backupset archivelog high sequence 679 delete input;
6> }
Point in time recovery
RMAN> run{
2> set until time “to_date(’05/07/11 09:00:00′ , ‘dd/mm/yy hh24:mi:ss’)”;
3> restore database;
4> recover database;
5> alter database open resetlogs;}
Delete archive logs up to scn 650
RMAN> delete archivelog high sequence 650;
list archivelogs from yesterday.
RMAN> list archivelog time between “sysdate -1” and “sysdate”
Delete archivelogs backed up 1 time to disk
RMAN> delete archive log all backed up 1 times to disk;
Delete backups older than 7 days
RMAN> delete backup completed before ‘sysdate -7’;
Restore archivelog between to scn numbers
RMAN> restore archivelog scn between 547484587 and 547662805;
Check For Logical And Physical Block Corruption
RMAN> backup check logical validate database;
source : https://oracledbazone.com/2012/04/18/useful-rman-commands/