...
Description of hardware
Server in virtualization system proxmox
...
Memory: 48 GB
...
Processors: 8
...
cores
Data Storages
Object storage
...
There are more levels of data archiving to ensure data safety and quick database recovery. Data are archived on database level and operation system level
- Database level backups
- RMAN utility is integral part of the Oracle database. It creates binary copy of whole database and stores it to filesystem. The RMAN utility is run every week. The files are stored internally on database server and are copied to two independent backup sites.
- EXPDP/IMPDP is data pump exporting data into text base backups. The EXPDP utility is run every 4 hours. The backup target is the same as with RMAN. It is stored to two independent backup sites.
- Redo Logs are archived every day to filesystem.
- Operation system backups
...
- Application server is backuped up on operational system level regularly in virtualization sytem Proxmox.
RMAN configuration file
CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
CONFIGURE BACKUP OPTIMIZATION OFF; # default
CONFIGURE DEFAULT DEVICE TYPE TO DISK; # default
CONFIGURE CONTROLFILE AUTOBACKUP ON;
CONFIGURE CONTROLFILE AUTOBACKUP FORMAT FOR DEVICE TYPE DISK TO '%F'; # default
CONFIGURE DEVICE TYPE DISK PARALLELISM 1 BACKUP TYPE TO BACKUPSET; # default
CONFIGURE DATAFILE BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE ARCHIVELOG BACKUP COPIES FOR DEVICE TYPE DISK TO 1; # default
CONFIGURE MAXSETSIZE TO UNLIMITED; # default
CONFIGURE ENCRYPTION ALGORITHM 'AES128'; # default
CONFIGURE COMPRESSION ALGORITHM 'BASIC' AS OF RELEASE 'DEFAULT' OPTIMIZE FOR LOAD TRUE ; # default
CONFIGURE RMAN OUTPUT TO KEEP FOR 7 DAYS; # default
CONFIGURE ARCHIVELOG DELETION POLICY TO NONE; # default
CONFIGURE SNAPSHOT CONTROLFILE NAME TO '/../../oracle/12c/dbs/snapcf_imtm.f'; # default
...