RMAN Implementation & Important Commands

[admin]

RMAN connection to target database
rman target /

Check database structure using RMAN
REPORT SCHEMA

Display current RMAN configuration
SHOW ALL

Enable automatic control file backup
CONFIGURE CONTROLFILE AUTOBACKUP ON

Set disk backup location format
CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/u01/backup/%U.bkp'

Take full database backup
BACKUP DATABASE

Backup database including archived redo logs
BACKUP DATABASE PLUS ARCHIVELOG

Backup only archived redo logs
BACKUP ARCHIVELOG ALL

Backup archived logs and delete them after successful backup
BACKUP ARCHIVELOG ALL DELETE INPUT

Perform incremental level 0 backup
BACKUP INCREMENTAL LEVEL 0 DATABASE

Perform incremental level 1 backup
BACKUP INCREMENTAL LEVEL 1 DATABASE

List all backups available to RMAN
LIST BACKUP

List all archived logs
LIST ARCHIVELOG ALL

Validate backup without actually creating it
BACKUP VALIDATE DATABASE

Restore database files from backup
RESTORE DATABASE

Recover database using archived logs
RECOVER DATABASE

Delete backups no longer needed as per retention policy
DELETE OBSOLETE

Delete expired backup records
DELETE EXPIRED BACKUP

Set retention policy to keep 7 days of recovery data
CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS