IN ORACLE MILIEU …

Beyond Knowledge

Monthly Archives: December 2007

Understanding Oracle Trace Utility – Oracle Database 10g

Overview: Some times the situation demands more information about an event. Example if we take a case of some error coming in our database because of some application. In this case its the job of developer to drill down into the application and get the exact queries those are failing. I have seen many situations [...]

Oracle Database 10g – Recovery Scenario

Recovery Scenarios Recovering a Database in NOARCHIVELOG Mode: When the database is running in noarchivelog mode, then its very difficult to perform the complete recovery. Because while the database is running, the online redo log file will get overwritten as the transactions proceeds. Following scenerio explains the complete and incomplete recovery. Scenario 1: Incomplete Recovery [...]

Follow

Get every new post delivered to your Inbox.

Join 156 other followers