12 Days of #Cloud: Exploring #DBaaS File System

12 Days of #Cloud: Day 5

When you create a new Cloud DBaaS instance, Oracle Cloud Service provision a VM and required file systems. These are the file systems:

 

[oracle@CLDB4ACED ~]$ df -h
Filesystem            Size  Used Avail Use% Mounted on
/dev/xvdb3             25G   14G   11G  57% /
tmpfs                 7.3G     0  7.3G   0% /dev/shm
/dev/xvdb1            477M  148M  300M  34% /boot
/dev/xvde1             59G  9.0G   47G  17% /u01
/dev/mapper/dataVolGroup-lvol0
                       50G   16G   32G  33% /u02
/dev/mapper/fraVolGroup-lvol0
                      6.8G  3.1G  3.4G  49% /u03
/dev/mapper/redoVolGroup-lvol0
                       25G  3.4G   20G  15% /u04

• /u01 – Local file system – Oracle software binaries, DIAGNOSTIC_DEST
• /u02 – Cloud Storage – Database Files, Change tracking file
• /u03 – Cloud Storage – Fast Recovery Area, backup files, control file copy
• /u04 – Cloud Storage – Redo log files, Temporary files
• On RAC systems, /u02, /u03, /u04 are ACFS.

To increase or decrease the size of /u02, /u03 or /u04 file systems, use the “Scale Up or Down Service” menu.

SPFile is in the standard location with the usual name:

• /u01/app/oracle/product/12.2.0/dbhome_1/dbs/spfileCDDB01.ora

Two Control files:

• /u02/app/oracle/oradata/CDDB01/control01.ctl
• /u03/app/oracle/fast_recovery_area/CDDB01/control02.ctl

Fast Recovery Area where backups are written:

• /u03/app/oracle/fast_recovery_area

Diagnostic Destination:

• /u01/app/oracle

Automatic Diagnostic Repository home:

• /u01/app/oracle/diag/rdbms/cddb01/CDDB01

Alert log and trace files location:

• /u01/app/oracle/diag/rdbms/cddb01/CDDB01/trace/

Software and files used to build the Cloud Instance VM

• /scratch/db

Backup configuration files:

• /var/opt/oracle/ocde/assistants/bkup/
• /home/oracle/bkup/CDDB01

Backup log files:

• /var/opt/oracle/log/bkup/

On Demand backup:

• /var/opt/oracle/bkup_api/bkup_api

Weekly cronjob – Cleanup log files

• /var/opt/oracle/cleandb/cleandblogs.pl

Retention of alert log, listener log, trace files configuration (used by cleandblogs.pl). See documentation for details.

• /var/opt/oracle/cleandb/cleandblogs.cfg