LEADER 06539nam 22006375 450 001 9910300466203321 005 20200705113214.0 010 $a1-4842-0763-7 024 7 $a10.1007/978-1-4842-0763-5 035 $a(CKB)3710000000277342 035 $a(EBL)1964918 035 $a(SSID)ssj0001386659 035 $a(PQKBManifestationID)11766807 035 $a(PQKBTitleCode)TC0001386659 035 $a(PQKBWorkID)11374540 035 $a(PQKB)11137736 035 $a(MiAaPQ)EBC1964918 035 $a(DE-He213)978-1-4842-0763-5 035 $a(CaSebORM)9781484207635 035 $a(PPN)183090276 035 $a(EXLCZ)993710000000277342 100 $a20141105d2014 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aOracle RMAN for Absolute Beginners$b[electronic resource] /$fby Darl Kuhn 205 $a1st ed. 2014. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2014. 215 $a1 online resource (272 p.) 225 1 $aThe expert's voice in Oracle 300 $aIncludes index. 311 $a1-4842-0764-5 327 $aContents 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 327 $aDisplaying 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 327 $aDisabling 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 327 $aRenaming 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 327 $aStep 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 327 $aMaking a Hot Backup 330 $aOracle 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 responsibility is to be able to recover from data loss. If you're new to the Oracle platform, or you're new to database administration in general, you can hardly go wrong by making it your first priority to learn to backup and recover the database that has been entrusted into your hands. This book is short and sweet at just 200 pages. Focus lies on the mainstream use cases. Recovery Manager, or RMAN as it is called, is a powerful and complex tool that can be intimidating at first. Author Darl Kuhn understands the need to focus on the core use cases, building your confidence in the tool, and in your ability to recover from lost database files, and even to recover your entire database should that become necessary. Oracle RMAN for Absolute Beginners shows how to backup your database. That's the first job. You'll learn to backup the entire database, and to create incremental backups that in turn can speed restore and recovery operations. Then you'll learn to recover from lost data files, lost redo log files, lost control files, and even to restore the entire database from scratch. You'll even learn how to clone a database for development and test purposes by backing the database up on one system and restoring it onto another. Author Darl Kuhn has a decade and a half of experience in writing about, and teaching Oracle Database backup and recovery. If you are newly responsible for an Oracle Database, you can hardly do better than to pick up a copy of Oracle RMAN for Absolute Beginners. 410 0$aExpert's voice in Oracle. 606 $aDatabase management 606 $aDatabase Management$3https://scigraph.springernature.com/ontologies/product-market-codes/I18024 615 0$aDatabase management. 615 14$aDatabase Management. 676 $a004 676 $a005.74 700 $aKuhn$b Darl$4aut$4http://id.loc.gov/vocabulary/relators/aut$0895311 712 02$aInternational Oracle Users Group. 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910300466203321 996 $aOracle RMAN for Absolute Beginners$92000204 997 $aUNINA