DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: timing activities

  1. 10-26-2007, 05:16 PM #1
    knitty
    knitty is offline Junior Member
    Join Date
    Oct 2007
    Posts
    16

    timing activities

    hi everybody,
    i would like to know time estimation for daily dba activities as wellas
    1)migration of database(75gb) from 9i to 10g
    2)whole database backup
    3)starting of database
    4)modifying any parameters
    and everything..

    thanks in advance,
    knitty.
    Reply With Quote Reply With Quote
  2. 10-26-2007, 05:23 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    and everything?

    why dont you try all those things and find out instead of being super lazy
    Reply With Quote Reply With Quote
  3. 10-29-2007, 05:36 AM #3
    Bore
    Bore is offline Advisor
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Well, depends on millions of factors.
    Last time we patched ASM+CRS+RAC from 10.2.0.1 to 10.2.0.3 for around 8 hours, including backups of the software, databases and some reorganizations
    That's what happened with us, what will happen with you... god knows :-)
    Reply With Quote Reply With Quote
  4. 10-29-2007, 07:45 AM #4
    PAVB's Avatar
    PAVB
    PAVB is offline Senior Advisor
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Quote Originally Posted by Bore
    ... depends on millions of factors.
    You have also to take into consideration the skills/set skills/level of the DBA doing the job.
    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.
    Reply With Quote Reply With Quote
  5. 10-29-2007, 11:27 AM #5
    knitty
    knitty is offline Junior Member
    Join Date
    Oct 2007
    Posts
    16

    thanks

    thank u guys....
    Reply With Quote Reply With Quote
  6. 10-30-2007, 03:45 AM #6
    hrishy
    hrishy is offline Senior Advisor
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    i am a weak hearted DBA and when it comes to patching etc i first play on a identical test bed no matter how simple the patching is and then get a sign off from the application owner and i document all the steps and only then i (after popping up my heart pills) i touch the production Database but thats me and if you are young and want to drive down the fast lane you could save some time by being heroic and directly trying to patch the production box and hoping that the oracle readme actually works the way it is documented...

    regards
    Hrishy
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width