DBAsupport.com Forums - Powered by vBulletin
Page 1 of 3 123 LastLast
Results 1 to 10 of 27

Thread: How to ask questions in a forum!! Newbees and exp. people pay attention!

Hybrid View

  1. #1
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    I agree that there are situations where you can't help but to follow the orders even if you don't agree with the solution.
    I remember a new project came up at our company the database and backup methodology was designed at partner company. The partner company wanted to implement the same thing at our site. They sent me documents and asked me to do exactly what was documented.

    I went through the documented and was amused with there backup methodology. It was a small db runnig on WinNT. They have two machines with exactly same confguration. On the main server they have batch jobs to shutdown th db and backup all the drives. Then they move whole backup to another machine (kinda c: to c:, d: to d: etc). They called the other machine "standby server". And they do it on weekly basis. On daily basis they copy the archive logs to another server.

    I contacted the people there and tried to explain them that this is not the correct way to do it BUT they wanted EXACTLY same as documents. I agreed on a condition that I will not be taking care of this db after installation and setup.

    You know they still call me whenever they run into trouble but not ready to change the way they backup.
    Sanjay G.
    Oracle Certified Professional 8i, 9i.

    "The degree of normality in a database is inversely proportional to that of its DBA"

  2. #2
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by patel_dil
    It depends on the kind of application and environment one works for. I would modify stecal's line to "DBA who thinks export...."
    I don't think that kinda clients/corporates exist in this internet era who can wait for couple of hours to bring their database back on line with import and no indexes and creating indexes again might take some time again.

    I'm assuming here decent size database if not, Well! One can take cold backup of all the files assoicated with database on Sunday in the middle of the night. May be Public sector is an exception as no one is gonna get fired even if the database crash. OR fix it while users spend their time in cafetaria.
    Reddy,Sam

  3. #3
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Originally posted by patel_dil
    Like I said before, many time you have to just do what you are told to by your manager.
    I'm missing something here how does it matter to application what kinda B&R methodology you use for database. If I'm managing the database, I'm responsible for data on database not my manager. I will take the best solution for B&R not what manager wants cuz, he is favorite of Exp/Imp. Unless they do not want to give me hard disk to save my backup files (In that case I will not be having disk for exp dumps either).

    This is not for the sake of argument but, for the sake of dba who needs take best measures for safe guarding the data on the database he is responsible for.
    Last edited by sreddy; 05-21-2003 at 02:33 PM.
    Reddy,Sam

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    Mr. Hanky,

    Yeah! I understand now. But if you think over from B&R perspective Is'nt its lot easier to have daily hot backup midnight which takes away costs on disk for archive logs. DBAs can recover within 15 to 30 minutes rather few hours to import and recreate indices and go from there.

    Thats whole another story of enabling archive mode and issues with performance which can be tuned for optimum performance. I don't see benifits having only exp/imp B&R methodology. I see only the practical benefit off of exp/imp methodology is object level recovery (Human mistakes of table drops etc.) Anyway, it has become more likedebate now
    Reddy,Sam

  5. #5
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843
    I was talking from the perspective of making dba day-to-day life easier considering mean time to recover with minimal available resources. If corporate mgmt do not understand and don't give a damn, obviously dba will not give a damn for how long it take to bring database back online.

    I don't think effort of recovery from exp/imp is equivalent to the effort from hot backup. Corporate Mgmt doesn't know how to use resources effectively or they will stick to what they beleive and never explore options for better infrastructure. Nobody help 'em anyway.
    Reddy,Sam

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by shibha
    That sticky is very unfriendly. There are ways to convey your message. Although there are no rules as to how moderators should address the mass public, it's just curtesy to say things nicely. Although each of the points are very valid.
    I think I mentioned a few times, people deserve the corresponding responses from anyone, not just the moderators, the way they ask or the effort they have done before ask. A forum is not a school, a learning center, a support center, a free consultancy or free consultants. Unfortunately it seems that many think this is one of those places. WRONG!

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    the problem withj export import is not that you can lose 24 hour or 48 hours data whateever

    the problem is you need to recreate a new database, import is slow as hell, can your company afford 5 ~6 hours downtime (for a small database)? our development database ranges from 10gb to 100gb, if I had to restore the 50gb+ ones how long it would take? probably one whole day, with backup takes one hour or less or more but not a whole day that's for sure

    if you can afford that downtime so then go ahead and do your export/import
    Last edited by pando; 05-21-2003 at 02:56 PM.

  8. #8
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by Mr.Hanky
    Most of the time you are recovering one table.
    And how on earth you recover a table in a production OLTP database with import? Considering the table is not a lookup/parent/dimension table?

  9. #9
    Join Date
    Nov 2000
    Location
    Baltimore, MD USA
    Posts
    1,339
    I just wanted to re-emphasize the point about providing feedback. My last 'sabbatical' I took from this forum was after I had worked out an incredibly complicated (in my opinion, at least) problem for someone. This took a lot of time and effort on my part and I was quite proud of what I came up with. The person showed their appreciation by....

    ...well, by doing nothing, actually. That left a very bad taste in my mouth and I decided to take a break from the board - for several months.

    I don't expect anyone to send me roses or anything, just a simple 'that worked' would be fantastic.

    That's the give-and-take dynamic of a board like this.

    If you post a question, you do it because you need help. If we provide this free help, it is generally not out of the goodness of our hearts. We want something back. That something can be simple relief of boredom, or the fear and respect of all our peers (a guy can dream, right?) But mostly, it's to exercise our brains and learn. That learning process is kinda difficult without any feedback.

    The process should be:

    - You ask
    - Someone answers
    - You tell them if it worked or not.
    - And a 'thank you' wouldn't kill you, either.

    - Chris
    Christopher R. Long
    ChrisRLong@HotMail.Com
    But that's just my opinion. I could be wrong

  10. #10
    Join Date
    Jan 2001
    Posts
    3,134
    Ok, I certainly agree with all of what is said here, and getting a little thank you on occasion is not asking a whole lot. BUT…this is no excuse for some of the downright nasty comments I have seen from some “moderators”. Some actually seem to post more venom than help the community. I can’t understand that, why would you want to chase away new people from this website. Let’s face it, if no one visits dbasupport.com there will be no dbasupport.com, no?

    MH
    I remember when this place was cool.

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