Configure and clear rman configuration settings
You can configure RMAN settings to control how backups are performed and managed. These settings are persistent and stored in the database. Here are some common RMAN configuration commands:
1. View Current Configuration
RMAN> SHOW ALL;
2. Set Default Backup Destination
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO DISK;
3. Set Backup Retention Policy
By Recovery Window (e.g., 7 days):
RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
By Redundancy (e.g., 2 copies):
RMAN> CONFIGURE RETENTION POLICY TO REDUNDANCY 2;
4. Configure Control File Autobackup
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;
5. Set Backup Location
RMAN> CONFIGURE CHANNEL DEVICE TYPE DISK FORMAT '/backup/rman/%U.bkp';
6. Configure Compression
RMAN> CONFIGURE COMPRESSION ALGORITHM 'BASIC';
RMAN> CONFIGURE DEVICE TYPE DISK PARALLELISM 2 BACKUP TYPE TO COMPRESSED BACKUPSET;
7. Clear a Configuration Setting
RMAN> CONFIGURE RETENTION POLICY CLEAR;
No comments:
Post a Comment