Monthly Archives: February 2008

When running a standby database, there are a number of options available for shipping the redo information to the standby databases, each with it’s advantages and disadvantages. Here’s an example of the ARCH log transport option, showing the process in … Continue reading →

Rebuilding a Physical Standby.   Why would you need to rebuild the physical standby? There's a number of reasons, usually the loss of an archive log in transit and it not being available on the primary database. In this case, … Continue reading →

ORA-01555   Why an I getting ORA-01555 errors with undo retention set?   The undo is managed through the size of the undo tablespace, and the retention set with undo_retention. If you are still experiencing ORA-01555 errors, then there are … Continue reading →

Solaris 10 and projects. Solaris 10 can still run with the /etc/system oracle changes in there, but it is recommended to use projects. The Project Database Projects are defined in the project database. The project database can be a local … Continue reading →

Sizing the UNDO TABLESPACE for Automatic Undo management   Three pieces of information are required for this: (UR) UNDO_RETENTION in seconds  (UPS) Number of undo data blocks generated per second  (DBS) Overhead varies based on extent and file size (db_block_size) … Continue reading →

Questions about SQL*Net. How to configure, use and debug it.

The following details how to switchover from a primary database to a physical database on oracle 9i.   This has been tested on a solaris 5.10 system.

ALL_ALL_TABLES

Oracle 9i introduced the insert all sql statement, allowing multiple table inserts using a single statement with conditional clauses. There are basically three insert types: Unconditional. All tables have the rows inserted. Conditional. Each table has a condition to decide … Continue reading →