Book Image

Oracle 10g/11g Data and Database Management Utilities

Book Image

Oracle 10g/11g Data and Database Management Utilities

Overview of this book

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.
Table of Contents (18 chapters)
Oracle 10g/11g Data and Database Management Utilities
Credits
About the Author
About the Reviewer
Preface

Recovering a lost Inventory


What should you do in case a central inventory gets lost? There are a couple of scenarios here; you could have a valid Oracle Home either intact or restored from a backup, but the central inventory is lost, if this is the case Oracle will work, but you will notice the missing inventory when you try to do an upgrade or apply a patch. In Oracle 10gR1 and earlier releases there is no other option but to restore the inventory from a backup, so you should include in your backup policies a periodic ORACLE_BASE backup which includes the different Oracle Homes and the central inventory. In Oracle 10gR2 and 11gR1, you can register it using the following procedure:

Change to the oui/bin directory inside the target Oracle Home:

cd $ORACLE_HOME/oui/bin

From this point, run the runInstaller (or setup.exe command in Windows) and use the attachHome and invPtrLoc modifiers:

./runInstaller -silent -attachHome -invPtrLoc ./oraInst.loc ORACLE_HOME="<Oracle_Home_Location>" ORACLE_HOME_NAME...