'If you spend your free time studing things like what happens when you do incomplete media recovery using the UNTIL CANCEL option, you are probably ready to take the OCP Oracle9i database fundamentals II exam now. For the rest of us, Oracle and other companies offer classroom- and computer-based training options to learn Oracle. Now, users have another option—this book. By selecting this book, you demonstrate two excellent characteristics—that you are comitted to a superior career using Oracle products, and that you care about preparing for the exam corrctly and trorughly. By the way, the UNTIL CANCEL command enables you to apply redo till the end of each archive log, and it is on the OCP Oracle9i database fundamentals II exam. That fact, along with thousands of others, is covered extensively in this book to help you prepare for and pass the OCP Oracle9i database fundamental II exam.
'\r\n
ACKNOWLEDGMENTS\r\nINRODUCTION\r\n\r\nPART I Oracle Networking\r\n\r\n1 Networking Overview\r\n\r\nNetWorking Challenges in the Business Environment\r\nNetwork Configurations\r\nOracle's Solution to NetWorking lssues\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n2 Basic Oracle Net Architecture\r\n\r\nOpen System Interconnection Architecture\r\nOracle Net Layered Architecture\r\nOracle Net Services\r\nWeb Client Connections\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n3 Basic Net Server-Side Configuration\r\n\r\nHow the Listener Responds to Incoming Connections\r\nComponents of the Listener\r\nConfiguring the Listener Using the Oracle Net Manager\r\nControlling the Listener Using the Listener Control Utility (Isnrctl)\r\nDynamic Service Registration\r\nConfiguring the Listener for IIOP\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n4 Basic Oracle Net Services Client-Side Configuration\r\n\r\nNaming Methods\r\nConfiguring the Host Naming Method\r\nConfiguring the Local Naming Method\r\nConfiguring Net Service Names\r\nPerforming Simple Connection Troubleshooting\r\nChapter Questions\r\nChapter Answers\r\n\r\n5 Usage and Configuration of the Oracle Shared Server\r\n\r\nIdentifying the Components of the Oracle Shared Server\r\nOracle Shared Server Architecture\r\nConfiguring the Orac1e Shared Server\r\nShared Server Related Dictionary Views\r\nChapter Questions\r\nChapter Answers\r\n\r\nPART II Backup and Recovery\r\n\r\n6 Backup and Recovery Overview\r\n\r\nClassification of Failures\r\nBasics of Database Backup, Restoration, and Recovery\r\nBackup and Recovery Strategies\r\nDisaster Recovery Plan\r\nOracle'S High-Availability Features\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n7 Instance and Media Recovery Structures\r\n\r\nOracle Memory Structures\r\nOracle Background Processes\r\nOracle Database Files\r\nImportance of Checkpoints During Instance Recovery\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n8 Configuring the Database Archive Mode\r\n\r\nDifferences Between ARCHIVELOG and NOARCHIVELOG Mode\r\nConfiguring a Database for ARCHIVELOG Mode\r\nConfiguring Multiple Archive Processes\r\nConfiguring Multiple Destinations, Including Remote Destinations\r\nUseful V$VIEWS\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n9 Oracle Recovery Manager Overview and Connguration\r\n\r\nFeatures of RMAN\r\nComponents of RMAN\r\nRMAN Repository\r\nRMAN Channel Allocation\r\nMedia Management Library Interface\r\nConnecting to RMAN Without the Recovery Catalog\r\nConfiguring the RMAN Environment\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\nl0 User-Managed Backups\r\n\r\nUser-Managed Backup and Recovery\r\nClosed Database Backups\r\nOpen Database Backups\r\nBackups of Read-Only Tablespaces\r\nBackup of the Control File\r\nBackups of Archived Redo Logs\r\nCleanup Operations after Failed Online Backups\r\nLOGGING and NOLOGGING Options\r\ndbverify Utility\r\nChapter Questions\r\nAnswers to Chapter Questions\r\n\r\n11 RMAN Backups\r\n\r\nRMAN Backup Concepts\r\nRMAN Image Copies\r\nRMAN Backup Sets\r\nTags for Backup Sets and Image Copies\r\nBacking Up the ControI File\r\nBacking Up the Archive Redo Log files\r\nImportant V$VIEWS\r\nChapter Questions\r\nChapter Answers\r\n\r\n12 User-Managed Complete Recovery\r\n\r\nMedia Recovery\r\nPerforming User-Managed Complete Recovery\r\nPerforming Recovery in NOARCHIVELOG Mode\r\nPerforming Complete Recovery in ARCHlVELOG Mode\r\nRestoring Data Files to Different Locations\r\nRelocating and Recovering a Tablespace Using Archived\r\nLoss of an Online Inactive Redo Log Group and Recovery\r\nRecovery of Read-Only Tablespaces\r\nChapter Questions\r\nChapter Answers\r\n\r\n13 RMAN Complete Recovery\r\n\r\nServer Managed Media Recovery Using RMAN\r\nPerforming Recovery in NOARCHIVELOG Mode\r\nPerforming Complete Recovery in ARCHIVELOG Mode\r\nRestore Data Files to Different Locations Using RMAN\r\nRelocate and Recover a Tablespace Using the Archived Redo Log Files\r\nBlock Media Recovery (BMR)\r\nChapter Questions\r\nChapter Answers\r\n\r\n14 User Managed Incomplete Recovery\r\n\r\nIncomplete Recovery\r\nIdentifying Loss of a Current Online Redo Log File\r\nMedia Recovery in Parallel\r\nImportantV$VIEWS\r\nChapter Questions\r\nChapter Answers\r\n\r\n15 RMAN Incomplete Recovery\r\n\r\nIncomplete Recovery Using RMAN\r\nPerform an Incomplete Database Recovery Using UNTIL TIME\r\nPerform Incomplete Database Recovery Using UNTIL SEQUENCE\r\nRestore Optimization\r\nChapter Questions\r\nChapter Answers\r\n\r\n16 RMAN Maintenance\r\n\r\nRMAN Crosscheck\r\nPerforming a Crosscheck of Backup Sets and Image Copies\r\nUpdating the Repository When Backups Have Been Deleted\r\nChanging the Availability Status of Backup Sets and Image Copies\r\nMaking a Backup Set or an Image Copy Exempt from the\r\nCataloging Backups Made with the Operating System Commands\r\nChapter Questions\r\nChapter Answers\r\n\r\n17 Recovery Catalog Creation and Maintenance\r\n\r\nContents of the Recovery Catalog\r\nRecovery Catalog Creation\r\nUse RMAN to Register, Resynchronize, and Reset a Database\r\nMaintain the Recovery Catalog by Using RMAN Commands\r\nQuery the Recovery Catalog to Generate Reports and Lists\r\nCreate, Store, and Run Scripts\r\nMethods Of Backing Up and Recovering the Recovery Catalog\r\nImportant Recovery Catalog Views\r\nChapter Questions\r\nChapter Answers\r\n\r\n18 Transporting Data Between Databases\r\n\r\nOracle Logical Backups\r\nExport Concepts and Structures\r\nImport Concepts and Structures\r\nA List of Export and Import ferameters\r\nMethods to Invoke Export and Import\r\nPerform Export and Import Operations\r\nList Guidelines for Using Export and Import\r\nChapter Questions\r\nChapter Answers\r\n\r\n19 Loading Data into a Database\r\n\r\nDirect-Path Insert Operations\r\nSQL*Loader Usage\r\nLoading Methods in SQL*Loader\r\nSQL*Loader Files\r\nPerforming Basic SQL*Loader Operations\r\nGuidelines for Using SQL*Loader and Direct-Load Insert\r\nChapter Questions\r\nChapter Answers\r\n\r\nPART III TestYourseIf: Oracle9i DBA Practice Exams\r\n\r\n20 Practice Exams for OCP DBA II Fundamentals\r\n\r\nFull--Length Examination I\r\nFull-Length Examination II\r\nAnswers to Full-Length Examination I\r\nAnswers to Full-Length Examination II\r\n\r\nIndex