Wednesday, May 21, 2025

How to configure rman configuration settings ?

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