RMAN [RECOVERY MANAGER]
IT IS UTILITY TO TAKE BACKUP, RESTORE AND RECOVERY
RMAN UTILITIES COMPONENT
RAMAN CLIENT
EXECUTABLE
TARGET DATABASE
TO WHICH DATABASE YOU WANT TO TAKE THE BACKUP
CONTROLFILE, RECOVERY CATALOG DATABASE
CONTROLFILE CONTAIN/STORE RMAN REPOSITORY MEANS META DATA OF RMAN
CONTROLFILE STORE ONLY ONE WEEK RMAN META INFORMATION
RECOVERY CATALOG DATABASE ALSO STORE RMAN REPOSITORY [DEDICATED MACHINE | OPTIONAL]
RECOVERY CATALOG DATABASE STORE MORE THAN ONE WEEK RMAN META INFORMATION
FLASH RECOVERY AREA OR MEDIA MANAGEMENT SOFTWARE
WHERE WE WANT TO STORE THE BACKUP [FRA DIRECTORY]
MEDIA MANAGEMENT SOFTWARE MEANS YOU WANT TO TAKE THE BACKUP TO TAPE DRIVE
RMAN EXECUTABLE
TARGET DATABASE
o BACKUP TAPE DRIVE
o BACKUP LOCAL DISK
FAST RECOVERY AREA
o CONTROL FILE
>DUPLICATE OR STANDBY DATABASE
>AUXILIARY INSTANCE
>RECOVERY CATALOG
>RECOVERY CATALOG SCHEMA
>RAMAN CHANNELS
>ONE STREAM OF DATA TO A DEVICE TYPE AND CORRESPONDS TO ONE SERVER SESSION. ALLOCATION OF ONE OR MORE RMAN CHANNELS IS NECCESSARY.
#Verify the Current Retention Policy
SHOW RETENTION POLICY; ---current policy settings (REDUNDANCY, RECOVERY WINDOW, or NONE)
#Set the Retention Policy to REDUNDANCY 1
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; ---sets the policy to keep only the most recent backup and mark any older ones as obsolete.
#Crosscheck Backups (Optional but Recommended)
CROSSCHECK BACKUP; ---Run a crosscheck to synchronize the RMAN repository with physical backups on disk or tape
#Display All Backups (Optional but Recommended)
LIST BACKUP;
#Check Obsolete Backups
REPORT OBSOLETE;
#Delete Obsolete Backups
DELETE OBSOLETE;
#Crosscheck and Delete Missing Backups (Optional)
LIST EXPIRED BACKUP; ---checks the status of all backups against their actual storage location. If a backup is missing, it will be marked as EXPIRED.
DELETE EXPIRED BACKUP; ---If some backup files are missing (deleted from disk), synchronize the RMAN repository and remove those entries:
#Delete All Backups
DELETE BACKUP;
RMAN> CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters:
CONFIGURE BACKUP OPTIMIZATION ON;
new RMAN configuration parameters are successfully stored
RMAN> show BACKUP OPTIMIZATION;
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE BACKUP OPTIMIZATION ON;
RMAN> CONFIGURE DEFAULT DEVICE TYPE TO sbt;
new RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
new RMAN configuration parameters are successfully stored
RMAN> show DEFAULT DEVICE TYPE;
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
RMAN> CONFIGURE DEFAULT DEVICE TYPE clear;
old RMAN configuration parameters:
CONFIGURE DEFAULT DEVICE TYPE TO 'SBT_TAPE';
RMAN configuration parameters are successfully reset to default value
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/ctl_%F';
new RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/ctl_%F';
new RMAN configuration parameters are successfully stored
RMAN> show CONTROLFILE AUTOBACKUP FORMAT;
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/ctl_%F';
RMAN> CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK clear;
old RMAN configuration parameters:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '/u01/ctl_%F';
RMAN configuration parameters are successfully reset to default value
RMAN> show CONTROLFILE AUTOBACKUP FORMAT;
RMAN configuration parameters for database with db_unique_name PROD are:
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
#USING RMAN
-POSSIBLE BACKUP
>DATAFILES
>CONTROLFILES
>ARCHIVE LOG FILES
>SPFILE
-NOT POSSIBLE BACKUP
>PFILE
>REDOLOG FILES
SQL> archive log list
Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 11
Next log sequence to archive 13
Current log sequence 13
SQL> show parameter db_recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 12732M
SQL> show parameter reco
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
control_file_record_keep_time integer 7
db_recovery_file_dest string /u01/app/oracle/fast_recovery_area
db_recovery_file_dest_size big integer 12732M
db_unrecoverable_scn_tracking boolean TRUE
recovery_parallelism integer 0
remote_recovery_file_dest string