Monthly Archives: November 2009

Change Rmans default date format.

When rman reports on backups, the date format contains no time portion. I like to see the times that the backups started and finished. Here’s how.

Posted in Oracle | Tagged , , | Comments Off

Why do my killed sessions remain ?

Often, when a client requests that we kill a session, we find that the session remains on the database in the status ‘KILLED’.During this time you cannot drop the user because the session remains in the database. How can we … Continue reading

Posted in Oracle | Tagged , , , | Comments Off

Delete windows listener service.

Had additional listener running on windows. How to delete it ?

Posted in Oracle | Tagged , , , | Comments Off

avoid ORA-19527 set dummy log_file_name_convert

You created new standby database using hotbackup script and did not create online REDO logs.  You are now trying to enable “Managed Standby Recovery” using the following command: alter database recover managed standby database using current logfile disconnect;

Posted in Configuration., Errors, Oracle, Parameters | Tagged , , | Comments Off

Refreshing a Physical Standby.

The client opened the standby database without stopping the primary. This destroys the dataguard setup. Here’s where I perform a refresh.

Posted in DataGuard, Oracle, Physical Standby, Standby | Tagged , , , | Comments Off