Part II Oracle Database Structure and Storage
You can create and manage database structures and storage components.
- Managing Control Files
You can create, back up, and drop control files. - Managing the Redo Log
You manage the redo log by completing tasks such as creating redo log groups and members, relocating and renaming redo log members, dropping redo log groups and members, and forcing log switches. - Managing Archived Redo Log Files
You manage the archived redo log files by completing tasks such as choosing betweenNOARCHIVELOG
orARCHIVELOG
mode and specifying archive destinations. - Managing Tablespaces
A tablespace is a database storage unit that groups related logical structures together. The database data files are stored in tablespaces. - Managing Data Files and Temp Files
You can manage data files and temp files by performing tasks such as creating them, altering them, and dropping them. - Transporting Data
Transporting data moves the data from one database to another. - Managing Undo
For a default installation, Oracle Database automatically manages undo. There is typically no need for DBA intervention. However, if your installation uses Oracle Flashback operations, you may need to perform some undo management tasks to ensure the success of these operations. - Using Oracle Managed Files
Oracle Database can manage the files that comprise the database.