Results 1 to 7 of 7
  1. #1
    Join Date
    Jan 2008
    Posts
    6

    Unanswered: READING REDO LOG And database information

    Hello friends,

    I want to know procedure to read redo log files information either through oracle or linux?

    also i want to know a script which can give me database information..which i can run every day to get to get database info......

    looking for help from you all...

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    LOGMINER "reads" redo log files.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jan 2008
    Posts
    6
    yeah i knw abt logminer....
    but can we read it using linux 'dd' command?

    alo can u help me with script...

  4. #4
    Join Date
    Jun 2004
    Posts
    796
    Provided Answers: 1
    With regards to the script, what database information do you want? Do you want to know the database name, or datafile sizes, or users logged in, or what?
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

  5. #5
    Join Date
    May 2004
    Location
    Dominican Republic
    Posts
    721
    I always thought redo log information is written in an Oracle propietary format, much like datafiles data is written. I just tried 'strings' on them but there's nothing usefull coming from them.

  6. #6
    Join Date
    Jan 2008
    Posts
    6
    yeah i have also tried using STRINGS command ...but not satisfactory results......

    Regarding the script......

    I will like to have a script which can be used to run each day or first time when one goes to manage a db......???

    BTW what all information will be required .....means soem exp dba can tell...what to look out for when one goes 1st time to manage a db?????

  7. #7
    Join Date
    Jan 2008
    Posts
    6
    can anyone tell me step by step process of

    CREATE USER abc
    identified EXTERNALLY

    i cant get it to work on linux......

Posting Permissions

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