Oracle Tips by Burleson

Oracle 10g Avoiding Disruption

In this chapter, we will highlight the new features and enhancements related to Oracle Database high availability and scalability. The facilities and features that help to achieve higher availability and scalability of the database, avoiding disruptions will especially be emphasized.

Traditionally, the Oracle Database has been very involved in providing a variety of high availability features. The same pattern is visible in enhancing and adding the new features in Oracle Database 10g. The main areas of high availability enhancements are:

Online Redefinition – Without disrupting the usual database operations, table structure or definition can be modified. New procedures are added to the dbms_redefinition package. Support for tables with additional data types has been extended.

Log Miner Enhancements – LogMiner provides a mechanism to extract all SQL statements from the redo and archived log files. Enhancements include automatic determination of the redo log files needed for a logminer session, and support for additional data types and objects.

Synonyms – Automatic Validation of dependent PL/SQL program units is introduced.

Real Application Clusters – Many improvements are added in this release. The main additions and changes include the concept of Service for better work load management, cluster ready services (portable clusterware), improved tools such as DBCA, SRVCTL, DBUA, and OEM, improved streams support, and limited rolling upgrade possibility.

Data Guard – The main improvements include real time apply, the simplified zero data loss for data guard SQL apply method, named data guard configurations, secured redo transmission, using the standby redo log files and support for additional data types and objects.

Supplemental Logging – Fine Grained supplemental logging.

Database Flashback – Restore to a previous point in time instead of point-in-time recovery if errors are polluting the database system. Table Flashback quickly re-establishes a table from the past, using the new recyclebin structures. A detailed account of database flashback is presented in Chapter 12.

Get the complete Oracle10g story:

The above text is an excerpt from "Oracle Database 10g New Features: Oracle10g Reference for Advanced Tuning and Administration", by Rampant TechPress.  Written by top Oracle experts, this book has a complete online code deport with ready to use scripts. 

To get the code instantly, click here:

http://rampant-books.com/book_2003_2_oracle10g.htm

Need an Oracle Mentor?

BEI is now offering personal mentors for Oracle DBAs where you can have an Oracle expert right at your fingertips, anytime day or night. We work with hundreds of Oracle databases every year, so we know exactly how to quickly assist you with any Oracle question.

Why risk an unplanned outage? You can now get telephone access to Don Burleson or any of his Oracle Certified DBAs with more than 20 years of full-time IT experience. Click here for details:

http://www.dba-oracle.com/service_oracle_backup.htm