Comments
- Phil Dunn (@Phil_Oracle) on Oracle’s New T5 TPC-C: Where’s the SPARC?, Part II
- ODBC on Installing the Netezza ODBC Driver.
- ashish on View deleted data in Netezza with view_deleted_records.
- Gary on Installing the Netezza ODBC Driver.
- venkat on Installing the Netezza ODBC Driver.
- Gary on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- arnab on EMCA Fails With Error “Failed to allocate port(s) in the specified range(s) for the following proces
- Hank Classe on ANS1017E (RC-50) Session rejected: TCP/IP connection failure
- Sean Robinson on Registering with Multiple listeners.
- Gary on Sending nzevent emails for system state changes.
Meta
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.
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
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 log_file_name_convert, ORA-19527, set~log_file_name_convert
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 10g, physical standby, refresh, standby
Comments Off