Managing Control Files, Online Redo Logs, and Archivelogs

An Oracle database consists of three types of mandatory files: data files, control files, and online redo logs. In Chapter 4 , the focus was on tablespaces and data files. This chapter looks at managing control files and online redo logs and implementing archivelogs. The first part of the chapter discusses typical control file maintenance tasks, such as adding, moving, and removing control files. Next, let’s examine the DBA activities related to online redo log files, such as renaming, adding, dropping, and relocating these critical files. Finally, the architecture aspects of enabling and implementing archiving are covered.