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:

 

  • /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

 

 

One Response to 12 Days of #Cloud: Exploring #DBaaS File System

  1. Pingback: 12th Day of #Cloud: Thoughts » Biju's Oracle Notes

Leave a Reply

%d bloggers like this: