DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 15

Thread: database open time

  1. #1
    Join Date
    Jun 2007
    Posts
    60

    database open time

    Hi

    Is there any way to find out a database open time.
    (startup_time from v$instance shows the time when db was mounted.)

    Thank you!

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    yes... check alertlog.
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Jun 2007
    Posts
    60
    I am Sorry,

    I should have mentioned that I need to find it in the database table or view.
    So correct question is :

    Is there any way to find out a database open time apart from alert log file.

    Thanks

  4. #4
    Join Date
    Mar 2006
    Location
    Charlotte, NC
    Posts
    865
    no other way.

    Thanks,
    Vijay Tummala

    Try hard to get what you like OR you will be forced to like what you get.

  5. #5
    Join Date
    Jun 2007
    Posts
    60
    Ok then. I anticipated this ... Thanks anyway!

  6. #6
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    why *must* it be a database table - what is wrong with reading the alert log?

    why dont you load the alert log into a table and query that?

  7. #7
    Join Date
    Jun 2007
    Posts
    60
    I wrote a pl/sql package using dblinks quiering ~20 dbs every 5min or so and produces outage report. It all worked perfect until I hit this bag (my mistake), The hole concept was that I used startup time taken from v$instance to identify the outage. But didn't realise that when RMAN does hot backup it puts db in mount mode and startup time is popoulated however db is still unavailable etc.. anyway I re- thinking logic now ....

  8. #8
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by zam View Post
    ...But didn't realise that when RMAN does hot backup it puts db in mount mode and startup time is popoulated however db is still unavailable etc..
    do you mean... during restore, isn't it?
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  9. #9
    Join Date
    Jun 2007
    Posts
    60
    Why ? I didnt say restore ... No - During the backup!

  10. #10
    Join Date
    Jun 2007
    Posts
    60
    Oops.. yes ..it's not HOT it;s COLD backup when Rman put db in mount mode and then does the copy...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width