• About Me

    Maxwell Miranda
    Oracle DBA Consultant.
  • Category

  • Archives

  • My Blog Calendar

    February 2018
    M T W T F S S
    « Sep    
  • RSS Oracle Feeds

    • Can't access database after power outage
      I could access the database before the power outage. From what I've read, it is a problem with the environment variables, but they are correct. Not sure what else to add. C:\Documents and Settings\konoca>sqlplus / as sysdba SQL*Plus: Release - Production on Wed Feb 21 09:17:08 2018 Copyright (c) 1982, 2005, Oracle. All rights reserved. ERR […]
    • Problems with RESET DATABASE
      Recently I wanted to do RESET DATABASE. Oracle documentation suggests the following commands connect target / startup force nomount reset database to incarnation 2 run { set until time "date time" restore controlfile from autobackup alter database mount restore database recover database } alter database open resetlogs In this view my db has given e […]
  • Advertisements

My Profile

Born in Vasai (Suburb near Bombay/Mumbai), India…an Aquarian….. After getting a degree at Pune University India in Computer Science, worked as a programmer for few years before becoming a DBA.
Likes Soft Music and Photography.


5 Responses

  1. send ur no.i want to contact

  2. Hi Maxwell. Thanks for such good supporting docs.
    Where r u rite now.

  3. hi maxwell,

    Thankyou for posting scripts.

    i have one question .in a database how do you get tablespace and segment is growing per day by day.can you know particular tablespace are growing.


  4. :) landed on your page for autosys.. Orville

    • let me know if you need anything on autosys…btw where are you nowadays

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: