CHAPTER 5

image

Managing Control Files, Online Redo Logs, and Archiving

An Oracle database consists of three types of mandatory files: data files, control files, and online redo logs. Chapter 4 focused on tablespaces and data files. This chapter looks at managing control files and online redo logs and implementing archiving (of the online redo logs). The first part of the chapter discusses typical control file maintenance tasks, such adding, moving, and removing control files. The middle part of the chapter examines DBA activities related to online redo log files, such as renaming, adding, dropping, and relocating these critical files. Finally, the ...

Get Pro Oracle Database 12c Administration, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.