-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
When one offline a datafile before you online the datafile one has to recover the datafile 1) Offline a datafile… READ MORE
We had seen case when the DDL timestamp of a procedure was changed in the middle of the night and… READ MORE
Scenario when the controlfile is lost and there was a datafile added to an existing table space after backup of… READ MORE
Scenario when all control files for some reason have been lost. The following scenario shows how to restore controlfile and… READ MORE
Restore spfile through RMAN, here are some scenerios/examples. There are some pre-requites, the database would need to be in nomount… READ MORE
When AUTOBACKUP is turned on Oracle will create backup of controlfile and spfile. When one runs backup of the database… READ MORE
Using the debug option one can turn on trace information, this can be used to troubleshoot an issue. Example: $ORACLE_HOME/bin/rman… READ MORE
Steps if you need to restore all datafiles in a tablespace is corrupted so you would need to restore the… READ MORE
The following example shows how to setup and cascade works when deleting record from parent table. 1) Shows how DELETE… READ MORE
To start the Oracle Enterprise Manager/Grid Control components in version 11g (11.1.0.1) $ cd /bin; ./emctl start oms $ cd… READ MORE
For SQLServer: — Clears all the procedure cache (works on SQLServer 2005 and SQLServer 2008) DBCC FREEPROCCACHE http://msdn.microsoft.com/en-us/library/ms174283%28v=SQL.90%29.aspx — On… READ MORE
The following document lists step how to install EM GridControl 11GR1 http://www.whopatooli.com/disquisitivedba/library/Joe_Johnson_Installing_EM_Grid_11gR1_11.1.0.1.pdf READ MORE
|
— Display SQL statement (SQLServer 2005 and SQLServer 2008), it displays creation time, last exeuction time, max time it ran… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 