Who issued ALTER DATABASE RECOVER - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 3 FirstFirst 123 LastLast
Results 11 to 20 of 24

Thread: Who issued ALTER DATABASE RECOVER

  1. #11
    Join Date
    Aug 2001
    Posts
    147
    Originally posted by marist89
    Originally posted by Mr.Hanky

    Hire honest employees, I would have told you ASAP.
    If it IS one of my DBA's, I might have an opening soon ...

    Maybe it's a honest mistake, maybe someone accidently run a b&r shellscript which would trigger that command.

  2. #12
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by np70
    Jeff,

    listener.log will tell you which machine and time request came from (if it was different machine).
    All the entries in listener.log have been accounted for. They all had a purpose and can be explained.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #13
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by NDT

    Maybe it's a honest mistake, maybe someone accidently run a b&r shellscript which would trigger that command.
    I agree it's a mistake. I want to find out WHO so I can make them an honest person.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #14
    Join Date
    Jan 2000
    Location
    Silver Spring MD USA
    Posts
    105
    If this was issued from OS, then do

    last | more

    at OS prompt

    You can see what was logged on from what IP address at what time.

    That might help to narrow it down some.


  5. #15
    Join Date
    Jan 2001
    Posts
    3,131
    Ted Night, Caddyshack.

    "WELL, WE'RE WAITING"

    What's the deal, did you find the cause of this error.

    MH
    I remember when this place was cool.

  6. #16
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by maachan
    If this was issued from OS, then do

    last | more

    at OS prompt

    You can see what was logged on from what IP address at what time.

    That might help to narrow it down some.

    last only shows who was logged on and not what commands they ran. There was nobody logged in to the box at the time. I would need lastcomm to show me which commands were executed, but that relies on OS accounting to be turned on.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  7. #17
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by Mr.Hanky

    What's the deal, did you find the cause of this error.
    Still investigating. I have my suspects, but no evidence yet.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  8. #18
    Join Date
    Feb 2001
    Location
    Bangalore, India
    Posts
    109
    can you use the PARSING_USER_ID column in the V$SQLAREA and get some result?

  9. #19
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Originally posted by sln81
    can you use the PARSING_USER_ID column in the V$SQLAREA and get some result?
    The parsing of that statement obviously failed (insufficient privileges ORA error), so that particular statement was realy never put in the library cache. So looking for it in V$SQLAREA is useless, IMHO.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  10. #20
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    It was actually in v$sqlarea with the correct timestamp, but since the parsing failed, I don't think the PARSING_USER_ID or PARSING_SCHEMA_ID are reliable (they both indicate SYS did the parsing but SYS would have privs...)
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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