Oracle RMAN for Absolute Beginners
Oracle RMAN for Absolute Beginners is a gentle introduction to the use of Oracle's Recovery Manager software to make backups of an Oracle database, and to restore all or part of a database in the event that data loss occurs. It is often said that a database administrator's #1 job responsib...
| Autor principal: | |
|---|---|
| Autor Corporativo: | |
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2014.
|
| Edición: | 1st ed. 2014. |
| Colección: | Expert's voice in Oracle.
|
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009629182106719 |
Tabla de Contenidos:
- Contents at a Glance; Introduction; Chapter 1: Getting Started; Connecting to Your Database; Establishing OS Variables; Manually Setting Variables; Using Oracle's Script; Understanding oratab; Using oraenv; Using OS Authentication; Using a Password File; Starting the Database; Stopping the Database; Summary; Chapter 2: Files in Support of Backup and Recovery Operations; Managing Control Files; Viewing Control File Names and Locations; Adding a Control File; Spfile Scenario; Init.ora Scenario; Moving a Control File; Removing a Control File; Managing Online Redo Logs
- Displaying Online Redo Log InformationDetermining the Optimal Size of Online Redo Log Groups; Determining the Optimal Number of Redo Log Groups; Adding Online Redo Log Groups; Resizing and Dropping Online Redo Log Groups; Adding Online Redo Log Files to a Group; Removing Online Redo Log Files from a Group; Moving or Renaming Redo Log Files; Implementing Archivelog Mode; Making Architectural Decisions; Setting the Archive Redo File Location; Setting the Archive Location to a User-Defined Disk Location (non-FRA); Using the FRA for Archive Log Files; Enabling Archivelog Mode
- Disabling Archivelog ModeReacting to a Lack of Disk Space in Your Archive Log Destination; Backing Up Archive Redo Log Files; Managing Tablespaces and Data files; Understanding the First Five; Understanding the Need for More; Creating Tablespaces; Renaming a Tablespace; Controlling the Generation of Redo; Changing a Tablespace's Write Mode; Dropping a Tablespace; Using Oracle Managed Files; Creating a Bigfile Tablespace; Enabling Default Table Compression within a Tablespace; Displaying Tablespace Size; Altering Tablespace Size; Toggling Data Files Offline and Online
- Renaming or Relocating a Data FilePerforming Online Data File Operations; Performing Offline Data File Operations; Using SQL and OS Commands; Re-Creating the Control File and OS Commands; Summary; Chapter 3: User-Managed Backup and Recovery; Implementing a Cold-Backup Strategy for a Noarchivelog Mode Database; Making a Cold Backup of a Noarchivelog Mode Database; Step 1. Determine Where to Copy the Backup Files and How Much Space Is Required; Step 2. Identify the Locations and Names of the Database Files to Copy; Step 3. Shut Down the Database; Step 4. Create Backup Copies of the Files
- Step 5. Restart Your DatabaseRestoring a Cold Backup in Noarchivelog Mode with Online Redo Logs; Step 1. Shut Down the Instance; Step 2. Copy the Files Back from the Backup; Step 3. Start Up the Database; Restoring a Cold Backup in Noarchivelog Mode Without Online Redo Logs; Step 1. Shut Down the Instance; Step 2. Copy the Files Back from the Backup; Step 3. Start Up the Database in Mount Mode; Step 4. Open the Database with the OPEN RESETLOGS Clause; Scripting a Cold Backup and Restore; Making a Cold Backup of an Archivelog Mode Database; Implementing a Hot Backup Strategy
- Making a Hot Backup
