Monthly Archives: September 2007

Rman does not support the movement of databases from one OS to another. So how to you do it?  

Oracle 10g offers compressed backups. Where the client has little storage space available, this offers the solution to saving space on backups.

10G database not responding. We had a 10g database not responding. Here's the key things to check on the database. Anyone with more information to add, please let me know.  

When checking whether you dealing with Physical or logical standby you have to remember that you remember the following: You can only utilise certain views for the two different standby Db's; Physical Standby:    V$ARCHIVE_DEST
V$ARCHIVE_DEST_STATUS
V$ARCHIVE_GAP
V$ARCHIVED_LOG
V$DATABASE
V$DATAFILE
V$DATAGUARD_STATUS
… Continue reading →

Restoring a database to a set point in time. This is performed on Oracle 9i, on a database which does not have flashback enabled. With flashback enabled on the database, the easier option would have been to flashback the entire … Continue reading →

Import Failures. Your import failed part way through, and you need to start it again. You don't want to drop the user and re-create it again, so there are a number of ways around this. Please, when using this, give … Continue reading →

Extracting a non-current perfstat report. I had a request to perform statspack checks on a database restored to another system. This meant that the DBID and system name were not the same as the one on which the report had … Continue reading →

The crontab is used for executing jobs according to a date pattern. The following in the solaris man page entries. Examples will be added later.