C H A P T E R  5

images

Managing Control Files and Online Redo Logs

An Oracle database consists of three types of mandatory files: datafiles, control files, and online redo logs. Chapter 4 focused on tablespaces and datafiles. This chapter focuses on managing control files and online redo logs. The first part of this chapter discusses typical control-file maintenance tasks such adding, moving, and removing control files. The latter part of the chapter focuses on how to manage online redo log files. You learn how to rename, resize, and relocate these critical files.

Managing Control Files

A control file is a small binary file that stores the following ...

Get Pro Oracle Database 11g Administration 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.