Recovery Manager: Release 19.0.0.0.0 - Production on Fri Mar 31 20:12:59 2023
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle and/or its affiliates. All rights reserved.
connected to target database: PROD (DBID=544466794)
RMAN> show all;
using target database control file instead of recovery catalog
RMAN configuration parameters for a database with db_unique_name PROD is:
CONFIGURE RETENTION POLICY TO REDUNDANCY
1; # default
-CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS;
- [HOW MANY BACKUPS DO YOU WANT TO KEEP. IF
YOU SET VALUE 2 IT WILL KEEP TWO DAYS BACKUP]
- OLD BACKUP WILL COUNT AS OBSOLETE MEANS NO LONGER REQUIRED FOR RECOVERY
- ONCE AN OBSOLETE BACKUP IS DELETED IT WILL COUNT AS AN EXPIRED BACKUP
CONFIGURE RETENTION POLICY TO
RECOVERY WINDOW OF 7 DAYS
- HOW LONG ABLE TO RECOVER DATABASE JUST LIKE POIT IN TIME RECOVERY
CONFIGURE BACKUP OPTIMIZATION
OFF; # default
- [ON - IF NO CHANGES MADE WITH LAST BACKUP, THEN IT WILL SKIP TO TAKE BACKUP]
CONFIGURE DEFAULT DEVICE TYPE
TO DISK; # default
CONFIGURE CONTROLFILE
AUTOBACKUP ON; # default
CONFIGURE CONTROLFILE
AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK
PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
- [ONE SERVER PROCESS WILL BE ACTIVATED]
- TWO TYPES OF BACKUPS
>BACKUP TYPE TO BACKUPSET - STORE IN THE
RMAN PROPITERIS FORMAT
>1 BACKUPSET FOR DATA FILES - 1 BACKUP PIECE
>ONE BACKUPSET HAVE 10 DATA FILES
>1 BACKUPSET FOR CONTROL FILES - 1 BACKUP PIECE
>1 ARCHIVELOG FILES - 1 BACKUP PIECE
>BACKUP TYPE TO COPY - IT'S LIKE A HOT
BACKUP MEANS IF YOUR DATAFILE SIZE 10GB ONLY 4GB IS FILED UP 6GB IS FREE EVEN
THOUGH YOU NEED 10GB SPACE.
CONFIGURE DATAFILE BACKUP
COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP
COPIES FOR DEVICE TYPE DISK TO 1; # default
- [HOW MANY COPYIES DO YOU WANT]
CONFIGURE MAXSETSIZE TO
UNLIMITED; # default
CONFIGURE ENCRYPTION FOR
DATABASE OFF; # default
CONFIGURE ENCRYPTION ALGORITHM
'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM
'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE; # default
- [BACKUP SIZE WOULD BE REDUCE. IF YOU USE HIGH COMPRESSION THEN IT WILL
CONSUME MUCH MORE CPU]
CONFIGURE RMAN OUTPUT TO KEEP
FOR 7 DAYS; # default
- [BACKUP WOULD BE STORE ONLY 7 DAYS]
CONFIGURE ARCHIVELOG DELETION
POLICY TO NONE; # default
- [SPECIFIES THE ARCHIVE LOG DELETION POLICY]
- CONFIGURE ARCHIVELOG DELETION POLICY TO
BACKED UP 1 TIMES TO DISK; [ONCE THE ARCHIVE LOGFILE BACKUP THEN IT CAN BE
DELETED AUTOMATICALLY]