FAQ
Guys,

I know you can reconstruct data in a table (given your undo segments in =
your undo tablespace is not overwritten)
with flashback query. However, you should be able to do the same using =
log_minor.

So flashback is easier to work but probably couldn't restore as much as =
you could using log_minor. =20

Why would you use one versus the other?

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.

Search Discussions

  • Mladen Gogala at Jul 23, 2004 at 4:23 pm

    On 07/23/2004 05:24:34 PM, Paula_Stankus_at_doh.state.fl.us wrote:
    Guys,

    I know you can reconstruct data in a table (given your undo segments in =
    your undo tablespace is not overwritten)
    with flashback query. However, you should be able to do the same using =
    log_minor.
    Of course, if the table is dropped, then restoring from recycle bin may be an option.

    --
    Mladen Gogala
    Oracle DBA
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Paula_Stankus_at_doh.state.fl.us at Jul 23, 2004 at 4:28 pm
    Thanks for the input Mladen to my stupid question.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Mladen Gogala
    Sent: Friday, July 23, 2004 5:27 PM
    To: oracle-l_at_freelists.org
    Subject: Re: flashback query vs. log miner
    On 07/23/2004 05:24:34 PM, Paula_Stankus_at_doh.state.fl.us wrote:
    Guys,
    =20
    I know you can reconstruct data in a table (given your undo segments = in =3D
    your undo tablespace is not overwritten)
    with flashback query. However, you should be able to do the same = using =3D
    log_minor.
    Of course, if the table is dropped, then restoring from recycle bin may =
    be an option.

    --=20
    Mladen Gogala
    Oracle DBA

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    BEGIN-ANTISPAM-VOTING-LINKS
    ------------------------------------------------------
    Teach CanIt if this mail (ID 5376441) is spam:
    Spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D5376441&m=3Dd529a=
    3c4f77d
    Not spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D5376441&m=3Dd529a=
    3c4f77d
    Forget vote: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D5376441&m=3Dd529a=
    3c4f77d
    ------------------------------------------------------
    END-ANTISPAM-VOTING-LINKS

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mladen Gogala at Jul 23, 2004 at 4:45 pm

    On 07/23/2004 05:32:20 PM, Paula_Stankus_at_doh.state.fl.us wrote:
    Thanks for the input Mladen to my stupid question.
    It wasn't a stupid question, I just wanted to point out the new 10g
    "recycle bin" feature.

    --
    Mladen Gogala
    Oracle DBA
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mark W. Farnham at Jul 23, 2004 at 4:56 pm
    Mladen politely answered like have a dozen questions in a row.

    Maybe that's symptomatic of Friday afternoon. Here is my wife's recipe:

    6 oz. pineapple juice
    4 oz. grapefruit juice
    8 oz. good rum

    ice cubes

    Makes 2 nice 12 oz. drinks.

    Alternative recipe for Mogens: freeze the rum bottle. swig as needed.

    mwf

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Mladen Gogala
    Sent: Friday, July 23, 2004 5:43 PM
    To: oracle-l_at_freelists.org
    Subject: Re: flashback query vs. log miner
    On 07/23/2004 05:32:20 PM, Paula_Stankus_at_doh.state.fl.us wrote:
    Thanks for the input Mladen to my stupid question.
    It wasn't a stupid question, I just wanted to point out the new 10g
    "recycle bin" feature.

    --
    Mladen Gogala
    Oracle DBA
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mogens Nørgaard at Jul 23, 2004 at 5:36 pm
    Thank you! I have Mount Gay rum (what a name!), I have ice cubes, and I
    have grapefruit juice. No pineapple juice, though. Can it be substituted
    with something else?

    Mogens

    Mark W. Farnham wrote:
    Mladen politely answered like have a dozen questions in a row.

    Maybe that's symptomatic of Friday afternoon. Here is my wife's recipe:

    6 oz. pineapple juice
    4 oz. grapefruit juice
    8 oz. good rum
    ice cubes

    Makes 2 nice 12 oz. drinks.

    Alternative recipe for Mogens: freeze the rum bottle. swig as needed.

    mwf
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Connor McDonald at Jul 23, 2004 at 11:43 pm
    Alternative recipe for you Mogens is listed below...(patent pending)

    6 oz. pineapple juice => replace with pineapple juice bottle (empty), then filled with single
    malt
    4 oz. grapefruit juice => replace with grapefruit juice bottle (empty), then filled with single
    malt
    8 oz. good rum => retain
    ice cubes => retain

    Easy...

    Cheers
    Connor

    Mogens_Nørgaard wrote: > Thank you! I have Mount Gay rum (what a name!), I
    have ice cubes, and I
    have grapefruit juice. No pineapple juice, though. Can it be substituted
    with something else?

    Mogens

    Mark W. Farnham wrote:
    Mladen politely answered like have a dozen questions in a row.

    Maybe that's symptomatic of Friday afternoon. Here is my wife's recipe:

    6 oz. pineapple juice
    4 oz. grapefruit juice
    8 oz. good rum
    ice cubes

    Makes 2 nice 12 oz. drinks.

    Alternative recipe for Mogens: freeze the rum bottle. swig as needed.

    mwf

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Connor McDonald
    Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
    ISBN: 1590592174

    web: http://www.oracledba.co.uk
    web: http://www.oaktable.net
    email: connor_mcdonald_at_yahoo.com

    Coming Soon! "Oracle Insight - Tales of the OakTable"

    "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day"





    ___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://www.allnewmessenger.com
    ----------------------------------------------------------------

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mark W. Farnham at Jul 24, 2004 at 1:42 am
    Okay. Now we have two viable alternative recipes. I thought just freezing
    the bottle of rum would work for Pete and Mogens (see bottom of original
    message. Swig is American for drinking from the bottle.

    I can't think of a good substitute for the pineapple juice for constructing
    my wife's original recipe.

    mwf

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Connor McDonald
    Sent: Saturday, July 24, 2004 12:47 AM
    To: oracle-l_at_freelists.org
    Subject: Re: flashback query vs. log miner (OT: Mladen's being too nice,
    here's my wife's Friday PM recipe)

    Alternative recipe for you Mogens is listed below...(patent pending)

    6 oz. pineapple juice => replace with pineapple juice bottle (empty), then
    filled with single
    malt
    4 oz. grapefruit juice => replace with grapefruit juice bottle (empty), then
    filled with single
    malt
    8 oz. good rum => retain
    ice cubes => retain

    Easy...

    Cheers
    Connor

    Mogens_Nørgaard wrote: > Thank you! I have Mount Gay
    rum (what a name!), I
    have ice cubes, and I
    have grapefruit juice. No pineapple juice, though. Can it be substituted
    with something else?

    Mogens

    Mark W. Farnham wrote:
    Mladen politely answered like have a dozen questions in a row.

    Maybe that's symptomatic of Friday afternoon. Here is my wife's recipe:

    6 oz. pineapple juice
    4 oz. grapefruit juice
    8 oz. good rum
    ice cubes

    Makes 2 nice 12 oz. drinks.

    Alternative recipe for Mogens: freeze the rum bottle. swig as needed.

    mwf

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Connor McDonald
    Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
    ISBN: 1590592174

    web: http://www.oracledba.co.uk
    web: http://www.oaktable.net
    email: connor_mcdonald_at_yahoo.com

    Coming Soon! "Oracle Insight - Tales of the OakTable"

    "GIVE a man a fish and he will eat for a day. But TEACH him how to fish,
    and...he will sit in a boat and drink beer all day"

    ___________________________________________________________ALL-NEW Yahoo!

    Messenger - all new features - even more fun!
    http://www.allnewmessenger.com

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mladen Gogala at Jul 24, 2004 at 1:58 am

    On 07/24/2004 02:44:45 AM, Mark W. Farnham wrote:
    Okay. Now we have two viable alternative recipes. I thought just freezing
    the bottle of rum would work for Pete and Mogens (see bottom of original
    message. Swig is American for drinking from the bottle.
    From my days of experimenting with cocktails, I remember that something
    fruity and sweet is almost always needed to dilute and mellow the
    strong liquor like rum, vodka, tequila or gin. Pineapple juice and
    orange juice look like perfect flavoring ingredients, but what is missing
    is something to add a little "twist", and give an unusual taste. If you
    are a traditionalist, you can add a few drops of club soda, or even
    champagne, but I would even try with things like cinnamon. That
    would give you good drink that a gentleman can enjoy on a beach. Of
    course, if you want something to get drunk fast, the best recipe I
    know is a drink nicknamed "polar bear". It should be served cold,
    very cold, and it consists of 50% vodka, 50% champagne and just a
    few drops of apricot liquor. Served in pint-sized glasses. It is
    approximately as devastating as Long Island ice tea. Both drinks are
    good after long and successful recovery which took the better part of
    a night.

    --
    Mladen Gogala
    Oracle DBA
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Rachel Carmichael at Jul 24, 2004 at 5:44 am
    okay I know Jared is going to send everyone over to my list soon with
    this but before he does ...

    Connor -- please tell me that you don't mean for Mogens to drink the
    single malt WITH the rum! .....

    Yes Jared, I'm off to the OT list now

    Connor McDonald wrote:
    Alternative recipe for you Mogens is listed below...(patent pending)

    6 oz. pineapple juice => replace with pineapple juice bottle
    (empty), then filled with single
    malt
    4 oz. grapefruit juice => replace with grapefruit juice bottle
    (empty), then filled with single
    malt
    8 oz. good rum => retain
    ice cubes => retain

    Easy...

    Cheers
    Connor
    =====
    Connor McDonald
    Co-author: "Mastering Oracle PL/SQL - Practical Solutions"
    ISBN: 1590592174
    web: http://www.oracledba.co.uk
    web: http://www.oaktable.net
    email: connor_mcdonald_at_yahoo.com

    Coming Soon! "Oracle Insight - Tales of the OakTable"

    "GIVE a man a fish and he will eat for a day. But TEACH him how to
    fish, and...he will sit in a boat and drink beer all day"

    ------------------------------------------------------------

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Rob zijlstra at Jul 24, 2004 at 1:28 pm
    I think Jared with his long expierience will agree with me, that in the
    weekend receipes to unwind from a hectic Oracle week are not OT!!

    One from me:
    One bottle of Heiniken with a (rather large) glass of Jonge Jenever. ( this
    is pure Dutch, known as a 'Kopstoot', lousely translated as a 'Headbanger')

    Nice Weekend,

    Rob Zijlstra
    okay I know Jared is going to send everyone over to my list soon with
    this but before he does ...
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Sam Reddy at Aug 19, 2004 at 5:52 pm
    Hi All,

    Could you please share your experience if you have implemented RMAN backup on a 5TB (Tera Byte) system ? I am concerned about backup time with full/cumulative/ incremental backups when RMAN is used in conjunction with Legato networker. Would you please send me if you have any white papers ? Hardware setup at your shop and any other technical considerations ?

    I appreciate your help.

    Have a wonderful day!

    Regards,

    Sam.







    Do you Yahoo!?
    New and Improved Yahoo! Mail - Send 10MB messages!

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Tim Gorman at Aug 20, 2004 at 2:07 am
    I recently visited a shop where they use RMAN on a 35Tb DW. 22Tb are READ
    ONLY tablespaces, so their weekly level-0 is about 13Tb. Their daily
    level-1 and level-2 average about 2-4Tb each, couple hundred Gb of
    archivelogs per day. They run big-iron Solaris and Veritas Netbackup to Sun
    DLT tape drives (16 drives, I think).

    They're happy with RMAN, although that weekly level-0 is exceeding the 24hr
    backup window they've imposed. I suggested that the level-0's be
    distributed across each day of the 7-day week, to even out their spikes;
    don't know if they implemented it or not.

    Also suggested that they look into table compression, but that will be a
    longer term thing. At the moment, I think they opted to order 6-8 more tape
    drives...

    RMAN isn't a problem; it's a big part of the solution...
    on 8/19/04 4:56 PM, Sam Reddy at iamanoracledba_at_yahoo.com wrote:

    Hi All,

    Could you please share your experience if you have implemented RMAN backup on
    a 5TB (Tera Byte) system ? I am concerned about backup time with
    full/cumulative/ incremental backups when RMAN is used in conjunction with
    Legato networker. Would you please send me if you have any white papers ?
    Hardware setup at your shop and any other technical considerations ?

    I appreciate your help.

    Have a wonderful day!

    Regards,

    Sam.







    ---------------------------------
    Do you Yahoo!?
    New and Improved Yahoo! Mail - Send 10MB messages!

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Paula_Stankus_at_doh.state.fl.us at Jul 23, 2004 at 5:00 pm
    Mladen,

    I am really sorry. Not having gotten through my 9i cert. yet and =
    getting familiar with the 9i features (as I have been busy with SQL =
    Server as well and GIS - never mind.....), I thought you were just being =
    silly. Man I totally misunderstood you.

    However,

    I think I need to get familiar with recycle bin, flashback query and =
    logminer. This just proved it.

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Mladen Gogala
    Sent: Friday, July 23, 2004 5:43 PM
    To: oracle-l_at_freelists.org
    Subject: Re: flashback query vs. log miner
    On 07/23/2004 05:32:20 PM, Paula_Stankus_at_doh.state.fl.us wrote:
    Thanks for the input Mladen to my stupid question.
    It wasn't a stupid question, I just wanted to point out the new 10g
    "recycle bin" feature.
    --=20
    Mladen Gogala
    Oracle DBA

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    BEGIN-ANTISPAM-VOTING-LINKS
    ------------------------------------------------------
    Teach CanIt if this mail (ID 5377433) is spam:
    Spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D5377433&m=3D4362b=
    837f7b2
    Not spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D5377433&m=3D4362b=
    837f7b2
    Forget vote: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D5377433&m=3D4362b=
    837f7b2
    ------------------------------------------------------
    END-ANTISPAM-VOTING-LINKS

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Paula_Stankus_at_doh.state.fl.us at Jul 23, 2004 at 5:02 pm
    That could be a good article:

    -various ways of recovery, what they are, when you might use them...

    -recycle bin
    -log minor
    -the old rman restore/recovery

    I imagine it is a matter of volume - like one table - recycle/bin or =
    flashback
    Whole database rman
    Log minor - ???

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Mladen Gogala
    Sent: Friday, July 23, 2004 5:43 PM
    To: oracle-l_at_freelists.org
    Subject: Re: flashback query vs. log miner
    On 07/23/2004 05:32:20 PM, Paula_Stankus_at_doh.state.fl.us wrote:
    Thanks for the input Mladen to my stupid question.
    It wasn't a stupid question, I just wanted to point out the new 10g
    "recycle bin" feature.
    --=20
    Mladen Gogala
    Oracle DBA

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    BEGIN-ANTISPAM-VOTING-LINKS
    ------------------------------------------------------
    Teach CanIt if this mail (ID 5377433) is spam:
    Spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D5377433&m=3D4362b=
    837f7b2
    Not spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D5377433&m=3D4362b=
    837f7b2
    Forget vote: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D5377433&m=3D4362b=
    837f7b2
    ------------------------------------------------------
    END-ANTISPAM-VOTING-LINKS

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Niall Litchfield at Jul 24, 2004 at 7:37 am
    comments embedded
    On Fri, 23 Jul 2004 18:06:11 -0400, paula_stankus_at_doh.state.fl.us
    wrote:
    That could be a good article:

    -various ways of recovery, what they are, when you might use them...

    -recycle bin
    -log minor
    -the old rman restore/recovery

    I imagine it is a matter of volume - like one table - recycle/bin or =
    flashback
    the recycle bin is 10g only. but yes recycle for small number of dropped objects

    flashback, when you want to go back in time -
    Whole database rman
    pretty much yes
    Log minor - ???
    For recovery scenarios I'd say when you have corrupted a subset of the
    rows in a table and you want to undo the bad sql.

    --
    Niall Litchfield
    Oracle DBA
    http://www.niall.litchfield.dial.pipex.com
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Pete Sharman at Jul 23, 2004 at 6:47 pm
    Air can be substituted for both the grapefruit juice and the pineapple juic=
    e. And the ice for that matter. :)

    =

    Pete
    =

    "Controlling developers is like herding cats."
    Kevin Loney, Oracle DBA Handbook
    =

    "Oh no, it's not. It's much harder than that!"
    Bruce Pihlamae, long-term Oracle DBA

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org =
    On Behalf Of Mogens N=F8rgaard
    Sent: Saturday, 24 July 2004 8:40 AM
    To: oracle-l_at_freelists.org
    Subject: Re: flashback query vs. log miner (OT: Mladen's being too nice, he=
    re's my wife's Friday PM recipe)

    Thank you! I have Mount Gay rum (what a name!), I have ice cubes, and I =

    have grapefruit juice. No pineapple juice, though. Can it be substituted =

    with something else?

    Mogens

    Mark W. Farnham wrote:
    Mladen politely answered like have a dozen questions in a row.
    =
    Maybe that's symptomatic of Friday afternoon. Here is my wife's recipe:
    =
    6 oz. pineapple juice
    4 oz. grapefruit juice
    8 oz. good rum
    ice cubes
    =
    Makes 2 nice 12 oz. drinks.
    =
    Alternative recipe for Mogens: freeze the rum bottle. swig as needed.
    =
    mwf
    =
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mladen Gogala at Jul 23, 2004 at 6:53 pm

    On 07/23/2004 07:51:10 PM, Pete Sharman wrote:
    Air can be substituted for both the grapefruit juice and the pineapple juic=
    e. And the ice for that matter. :)
    Dry ice is not particularly good for human consumption. Is my favorite
    Oracle support representative trying to poison the whole list?

    --
    Mladen Gogala
    Oracle DBA
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Pete Sharman at Jul 24, 2004 at 2:08 am
    Good Lord. And the reason you think I'm in Support is ...?

    I thought the information I sent across this list was useful, which would o=
    f course immediately ensure I was not in Support. Well, at least Microsoft=
    's Support org, that is.;)

    =

    Pete
    =

    "Controlling developers is like herding cats."
    Kevin Loney, Oracle DBA Handbook
    =

    "Oh no, it's not. It's much harder than that!"
    Bruce Pihlamae, long-term Oracle DBA

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org =
    On Behalf Of Mladen Gogala
    Sent: Saturday, 24 July 2004 9:56 AM
    To: oracle-l_at_freelists.org
    Subject: Re: flashback query vs. log miner (OT: Mladen's being too nice, he=
    re's my wife's Friday PM recipe)
    On 07/23/2004 07:51:10 PM, Pete Sharman wrote:
    Air can be substituted for both the grapefruit juice and the pineapple ju= ic=3D
    e. And the ice for that matter. :)
    Dry ice is not particularly good for human consumption. Is my favorite =

    Oracle support representative trying to poison the whole list?
    -- =

    Mladen Gogala
    Oracle DBA

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Mogens Nørgaard at Jul 24, 2004 at 3:09 am
    Nobody really knows where Pete is, but I think he's still in Consulting
    somewhere. His occasional brush with reality is probably what makes his
    advise and observations more valuable than . Now, after
    moving back to Canberra I'm not sure what he has actually seen (most
    databases require computers and computers require electricity), but he
    can still answer a few questions here and there.

    He wrote a book once. While visiting him in California, I bought the
    book in the bookstore in order to a) get the book and b) let a small
    amount of royalty go his way. When I came home to Pete with the book I
    was informed in Pete's usual diplomatic way that the publisher had gone
    bankrupt and so no royalties were coming his way - and by the way he had
    several copies of the book that I could have.

    Oh, and he's an old VMS man, of course.

    The DECUS (Digital Equipment Corp. User Society or whatever) has been
    killed by two mergers, but VMS lives on.

    On September 17 we have a party here in Maaloev for all the old DECUS
    members. We will tell stories from the old days (about clusters that
    just worked, and disks that could be filled 100% without going down) and
    we will have people from DEComHPaq telling us about the glorious future
    of VMS on Itanium.

    During those presentations we'll have one beer each, and then we'll
    start drinking, I think. And I think we shall have drinks named "Mark
    Farnham", "Mladen Gogetemall", "Connor McDonald" and "Pete the Sharman"

    So here is a suggestion for all of you out there: Create your own, local
    DECUS reunion. And serve the official Oracle-L drinks.

    Mogens

    Pete Sharman wrote:
    Good Lord. And the reason you think I'm in Support is ...?

    I thought the information I sent across this list was useful, which would o=
    f course immediately ensure I was not in Support. Well, at least Microsoft=
    's Support org, that is.;)

    =

    Pete
    =

    "Controlling developers is like herding cats."
    Kevin Loney, Oracle DBA Handbook
    =

    "Oh no, it's not. It's much harder than that!"
    Bruce Pihlamae, long-term Oracle DBA

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org =
    On Behalf Of Mladen Gogala
    Sent: Saturday, 24 July 2004 9:56 AM
    To: oracle-l_at_freelists.org
    Subject: Re: flashback query vs. log miner (OT: Mladen's being too nice, he=
    re's my wife's Friday PM recipe)


    On 07/23/2004 07:51:10 PM, Pete Sharman wrote:
    Air can be substituted for both the grapefruit juice and the pineapple ju= ic=3D
    e. And the ice for that matter. :)


    Dry ice is not particularly good for human consumption. Is my favorite =

    Oracle support representative trying to poison the whole list?
    -- =

    Mladen Gogala
    Oracle DBA
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------


    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Kirtikumar Deshpande at Jul 24, 2004 at 9:46 am
    Paula,
    One must use LogMiner if one needs to access data that is more than 5 days old (instance
    uptime wise). FBQ does not help you. Of course, this changes with Oracle 10g ( and what
    doesn't?;).

    Also, with 9i rel 2 SQL enhancement (the AS OF clause) it is very easy to use FBQ to
    access past data (if it is still available in the undo segments). Accessing the same
    information via LogMiner is a bit more involved process. With proper privileges, you can
    let your developers use FBQ, but I doubt if DBAs will allow Developers to play with
    LogMiner.

    So, I would not use one versus the other all the time, but may be required to use both,
    depending on the requirement.

    Regards,
    - Kirti


    Paula_Stankus_at_doh.state.fl.us wrote:
    Guys,

    I know you can reconstruct data in a table (given your undo segments in =
    your undo tablespace is not overwritten)
    with flashback query. However, you should be able to do the same using =
    log_minor.


    So flashback is easier to work but probably couldn't restore as much as =
    you could using log_minor. =20

    Why would you use one versus the other?
    Do you Yahoo!?
    Yahoo! Mail Address AutoComplete - You start. We finish.
    http://promotions.yahoo.com/new_mail

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Paula_Stankus_at_doh.state.fl.us at Jul 26, 2004 at 10:38 am
    Thanks Kirti,

    That was a very concise description and along the lines of what I was =
    telling a junior dba I am training. =20

    However, is it a hard limit for FBQ - 5 days - or is it solely based on =
    undo tablespace size and undo tablespace retention parameter? =20

    Also, is there any downside with allocating a great deal of space to the =
    undo tablespace in a database other than static allocation?

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Kirtikumar Deshpande
    Sent: Saturday, July 24, 2004 10:50 AM
    To: oracle-l_at_freelists.org
    Subject: RE: flashback query vs. log miner

    Paula,
    One must use LogMiner if one needs to access data that is more than 5 =
    days old (instance
    uptime wise). FBQ does not help you. Of course, this changes with Oracle =
    10g ( and what
    doesn't?;).=20

    Also, with 9i rel 2 SQL enhancement (the AS OF clause) it is very easy =
    to use FBQ to
    access past data (if it is still available in the undo segments). =
    Accessing the same
    information via LogMiner is a bit more involved process. With proper =
    privileges, you can
    let your developers use FBQ, but I doubt if DBAs will allow Developers =
    to play with
    LogMiner. =20

    So, I would not use one versus the other all the time, but may be =
    required to use both,
    depending on the requirement.=20

    Regards,
    - Kirti
    =20
    --- Paula_Stankus_at_doh.state.fl.us wrote:
    Guys,
    =20
    I know you can reconstruct data in a table (given your undo segments = in =3D
    your undo tablespace is not overwritten)
    with flashback query. However, you should be able to do the same = using =3D
    log_minor.
    =20
    =20
    So flashback is easier to work but probably couldn't restore as much = as =3D
    you could using log_minor. =3D20
    =20
    Why would you use one versus the other?
    =09

    Do you Yahoo!?
    Yahoo! Mail Address AutoComplete - You start. We finish.
    http://promotions.yahoo.com/new_mail=20

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    BEGIN-ANTISPAM-VOTING-LINKS
    ------------------------------------------------------
    Teach CanIt if this mail (ID 5416553) is spam:
    Spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Ds&i=3D5416553&m=3D3e3a8=
    d0f45c8
    Not spam: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Dn&i=3D5416553&m=3D3e3a8=
    d0f45c8
    Forget vote: =
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3Df&i=3D5416553&m=3D3e3a8=
    d0f45c8
    ------------------------------------------------------
    END-ANTISPAM-VOTING-LINKS

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Kirtikumar Deshpande at Jul 26, 2004 at 11:03 am
    Paula,
    For FBQ, in Oracle 9i, there is a hard limit of 5 days of instance uptime. Period! No
    amount of undo space and undo retention time can cross this limit. And, there are ways to
    size the undo tablespace to suit your requirements.

    I presented a paper on 9i AUM and FBQ in the recent IOUG conf. You may refer to my
    paper. It discusses all these issues, and shows why there is a 5-day instance uptime
    limit for FBQ in Oracle 9i.



    Regards,

    Kirti

    Paula_Stankus_at_doh.state.fl.us wrote:
    Thanks Kirti,

    That was a very concise description and along the lines of what I was =
    telling a junior dba I am training. =20

    However, is it a hard limit for FBQ - 5 days - or is it solely based on =
    undo tablespace size and undo tablespace retention parameter? =20

    Also, is there any downside with allocating a great deal of space to the =
    undo tablespace in a database other than static allocation?



    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Kirtikumar Deshpande
    Sent: Saturday, July 24, 2004 10:50 AM
    To: oracle-l_at_freelists.org
    Subject: RE: flashback query vs. log miner


    Paula,
    One must use LogMiner if one needs to access data that is more than 5 =
    days old (instance
    uptime wise). FBQ does not help you. Of course, this changes with Oracle =
    10g ( and what
    doesn't?;).=20

    Also, with 9i rel 2 SQL enhancement (the AS OF clause) it is very easy =
    to use FBQ to
    access past data (if it is still available in the undo segments). =
    Accessing the same
    information via LogMiner is a bit more involved process. With proper =
    privileges, you can
    let your developers use FBQ, but I doubt if DBAs will allow Developers =
    to play with
    LogMiner. =20

    So, I would not use one versus the other all the time, but may be =
    required to use both,
    depending on the requirement.=20

    Regards,
    - Kirti
    =20
    Do you Yahoo!?
    New and Improved Yahoo! Mail - Send 10MB messages!
    http://promotions.yahoo.com/new_mail

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Bobak, Mark at Jul 26, 2004 at 10:44 am
    I'm pretty sure that 5 days is a hard limit, unless you're into hacking
    the database.....;-)

    As I recall a certain dinner in Dallas, Kirti described how he
    successfully did so, extending the 5 day limit to, um, 10 days,
    perhaps....?;-)

    But, I don't think that would be a recommended approach for a production
    database....;-)

    Mark J. Bobak
    Oracle DBA
    ProQuest Company
    Ann Arbor, MI
    "Post Hoc Ergo Propter Hoc"

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of
    Paula_Stankus_at_doh.state.fl.us
    Sent: Monday, July 26, 2004 11:42 AM
    To: oracle-l_at_freelists.org
    Subject: RE: flashback query vs. log miner

    Thanks Kirti,

    That was a very concise description and along the lines of what I was =
    =3D
    telling a junior dba I am training. =3D20

    However, is it a hard limit for FBQ - 5 days - or is it solely based on
    =3D
    undo tablespace size and undo tablespace retention parameter? =3D20

    Also, is there any downside with allocating a great deal of space to the
    =3D
    undo tablespace in a database other than static allocation?

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Kirtikumar Deshpande
    Sent: Saturday, July 24, 2004 10:50 AM
    To: oracle-l_at_freelists.org
    Subject: RE: flashback query vs. log miner

    Paula,
    One must use LogMiner if one needs to access data that is more than 5 =
    =3D
    days old (instance
    uptime wise). FBQ does not help you. Of course, this changes with Oracle
    =3D
    10g ( and what
    doesn't?;).=3D20

    Also, with 9i rel 2 SQL enhancement (the AS OF clause) it is very easy
    =3D
    to use FBQ to
    access past data (if it is still available in the undo segments). =3D
    Accessing the same
    information via LogMiner is a bit more involved process. With proper =3D
    privileges, you can
    let your developers use FBQ, but I doubt if DBAs will allow Developers =
    =3D
    to play with
    LogMiner. =3D20

    So, I would not use one versus the other all the time, but may be =3D
    required to use both,
    depending on the requirement.=3D20

    Regards,
    - Kirti
    =3D20
    --- Paula_Stankus_at_doh.state.fl.us wrote:
    Guys,
    =3D20
    I know you can reconstruct data in a table (given your undo segments =
    =3D
    in =3D3D
    your undo tablespace is not overwritten)
    with flashback query. However, you should be able to do the same =3D
    using =3D3D
    log_minor.
    =3D20
    =3D20
    So flashback is easier to work but probably couldn't restore as much =
    =3D
    as =3D3D
    you could using log_minor. =3D3D20
    =3D20
    Why would you use one versus the other?
    =3D09

    Do you Yahoo!?
    Yahoo! Mail Address AutoComplete - You start. We finish.
    http://promotions.yahoo.com/new_mail=3D20

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    BEGIN-ANTISPAM-VOTING-LINKS
    ------------------------------------------------------
    Teach CanIt if this mail (ID 5416553) is spam:
    Spam: =3D
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Ds&i=3D3D5416553&m=3D3=
    D3e3a
    8=3D
    d0f45c8
    Not spam: =3D
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Dn&i=3D3D5416553&m=3D3=
    D3e3a
    8=3D
    d0f45c8
    Forget vote: =3D
    https://dohsmsi01.doh.state.fl.us/canit/b.php?c=3D3Df&i=3D3D5416553&m=3D3=
    D3e3a
    8=3D
    d0f45c8
    ------------------------------------------------------
    END-ANTISPAM-VOTING-LINKS

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Raj Jamadagni at Jul 26, 2004 at 11:11 am
    Mark,

    I remember that ... 8:)

    Raj
    --- "Bobak, Mark" wrote:
    I'm pretty sure that 5 days is a hard limit, unless you're into hacking
    the database.....;-)

    As I recall a certain dinner in Dallas, Kirti described how he
    successfully did so, extending the 5 day limit to, um, 10 days,
    perhaps....?;-)

    But, I don't think that would be a recommended approach for a production
    database....;-)

    Mark J. Bobak
    Oracle DBA
    ProQuest Company
    Ann Arbor, MI
    "Post Hoc Ergo Propter Hoc"
    Best Regards
    Raj

    select mandatory_disclaimer from company_requirements;



    Do you Yahoo!?
    Yahoo! Mail is new and improved - Check it out!
    http://promotions.yahoo.com/new_mail

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Kirtikumar Deshpande at Jul 26, 2004 at 11:12 am
    Mark,
    You have a strong memory :-)


    In one my test databases FBQ does work for upto 10 days of instance uptime :)


    Yes, hacking of SYS owned object is required to extend the 5-day limit.

    And unless it is a throw-away database, I would advise against it !!


    Cheers!

    Kirti

    "Bobak, Mark" wrote:
    I'm pretty sure that 5 days is a hard limit, unless you're into hacking
    the database.....;-)

    As I recall a certain dinner in Dallas, Kirti described how he
    successfully did so, extending the 5 day limit to, um, 10 days,
    perhaps....?;-)

    But, I don't think that would be a recommended approach for a production
    database....;-)

    Mark J. Bobak
    Oracle DBA
    ProQuest Company
    Ann Arbor, MI
    "Post Hoc Ergo Propter Hoc"


    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of
    Paula_Stankus_at_doh.state.fl.us
    Sent: Monday, July 26, 2004 11:42 AM
    To: oracle-l_at_freelists.org
    Subject: RE: flashback query vs. log miner


    Thanks Kirti,

    That was a very concise description and along the lines of what I was =
    =3D
    telling a junior dba I am training. =3D20

    However, is it a hard limit for FBQ - 5 days - or is it solely based on
    =3D
    undo tablespace size and undo tablespace retention parameter? =3D20

    Also, is there any downside with allocating a great deal of space to the
    =3D
    undo tablespace in a database other than static allocation?

    Do you Yahoo!?
    New and Improved Yahoo! Mail - 100MB free storage!
    http://promotions.yahoo.com/new_mail

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Stephen.Lee_at_DTAG.Com at Aug 20, 2004 at 9:56 am


    I don't have anything as big as your situation, but I do have a box on which
    the rman backup sets for full backup total between 500 - 600 Gb. The
    limitation on speed here is the rate at which data can be tape written to
    the tape drives; and this depends on the number of drives and the number of
    I/O interfaces to the drives. If you are writing directly to tape, then you
    can experiment with the number of rman channels to open to get the writes to
    distribute over the drives and keep all of the drives busy writing. There
    is also an rman parameter that sets how big the chunks of data are that it
    sends to Networker. I forgot what it is.

    Because of concerns about restore time when restoring directly from tape, we
    now run rman to backup to a 1.8 Tb filesystem created for this purpose, then
    use a ksh (We don't need no stinkin' Perl) script to copy the files to tape
    via Networker and delete the previous day's backup. The archived log
    backups get copied first. Our backup times run 3 hours to backup to disk
    and 7 - 9 hours to copy to four tape drives on two SCSI interfaces. I have
    maxpiecesize set to 5 GB for the datafile backups so that the I/O gets
    distributed more or less evenly among the tape drives. Archived log backups
    don't have maxpiecesize set because those backup sets usually total around
    15 - 25 Gb.

    The script for sending to files to tape can be found here:
    http://integrid.info/tape_copy.ksh

    NOTE: One thing that should be fixed with the script -- one of these days
    when I get around to it (oh yeah, sure) -- is that while the script checks
    to see if it is already running with at least one of the command line args
    and exits if it is, it will run (I think) if there are no common command
    line args between the two commands. HOWEVER, both running copies will use
    the same log file. (I'm pretty sure the e-mail files will be unique.) I
    really should do something about that ... some time ... before the Vogons
    get here and bulldoze the planet away.
    -----Original Message-----
    I am concerned about
    backup time with full/cumulative/ incremental backups when
    RMAN is used in conjunction with Legato networker.
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Jared.Still_at_radisys.com at Aug 20, 2004 at 12:50 pm

    Because of concerns about restore time when restoring directly from tape, we
    now run rman to backup to a 1.8 Tb filesystem created for this purpose, then
    use a ksh (We don't need no stinkin' Perl) script to copy the files to
    tape
    Too bad, you don't know what you're missing.
    NOTE: One thing that should be fixed with the script -- one of these days
    when I get around to it (oh yeah, sure) -- is that while the script checks
    to see if it is already running with at least one of the command line args
    and exits if it is, it will run (I think) if there are no common command
    line args between the two commands. .
    This is actually quite trivial in Perl via flock(). Doesn't matter if
    the previous job was kill -9'd, flock() will let you check to see if
    the file is in use. ( Fctnl flock in my case);)

    Jared

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Sam Reddy at Aug 23, 2004 at 3:35 pm
    Hi Stephen,


    Thank you very much for the details! Much appreciated!


    When you recollect the rman parameter that sets how big the chunks of data are that it
    sends to Networker please let me know.


    Best regards,
    Sam
    Stephen.Lee_at_DTAG.Com wrote:

    I don't have anything as big as your situation, but I do have a box on which
    the rman backup sets for full backup total between 500 - 600 Gb. The
    limitation on speed here is the rate at which data can be tape written to
    the tape drives; and this depends on the number of drives and the number of
    I/O interfaces to the drives. If you are writing directly to tape, then you
    can experiment with the number of rman channels to open to get the writes to
    distribute over the drives and keep all of the drives busy writing. There
    is also an rman parameter that sets how big the chunks of data are that it
    sends to Networker. I forgot what it is.

    Because of concerns about restore time when restoring directly from tape, we
    now run rman to backup to a 1.8 Tb filesystem created for this purpose, then
    use a ksh (We don't need no stinkin' Perl) script to copy the files to tape
    via Networker and delete the previous day's backup. The archived log
    backups get copied first. Our backup times run 3 hours to backup to disk
    and 7 - 9 hours to copy to four tape drives on two SCSI interfaces. I have
    maxpiecesize set to 5 GB for the datafile backups so that the I/O gets
    distributed more or less evenly among the tape drives. Archived log backups
    don't have maxpiecesize set because those backup sets usually total around
    15 - 25 Gb.

    The script for sending to files to tape can be found here:
    http://integrid.info/tape_copy.ksh

    NOTE: One thing that should be fixed with the script -- one of these days
    when I get around to it (oh yeah, sure) -- is that while the script checks
    to see if it is already running with at least one of the command line args
    and exits if it is, it will run (I think) if there are no common command
    line args between the two commands. HOWEVER, both running copies will use
    the same log file. (I'm pretty sure the e-mail files will be unique.) I
    really should do something about that ... some time ... before the Vogons
    get here and bulldoze the planet away.
    -----Original Message-----
    I am concerned about
    backup time with full/cumulative/ incremental backups when
    RMAN is used in conjunction with Legato networker.
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ---------------------------------
    Do you Yahoo!?
    Win 1 of 4,000 free domain names from Yahoo! Enter now.

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • DENNIS WILLIAMS at Aug 20, 2004 at 10:56 am
    Tim - How long do they estimate the recovery time would be?

    Dennis Williams
    DBA

    Lifetouch, Inc.

    "We all want progress, but if you're on the wrong road, progress means
    doing an about-turn and walking back to the right road; in that case,
    the man who turns back soonest is the most progressive."
    -- C.S. Lewis

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Tim Gorman
    Sent: Thursday, August 19, 2004 11:06 PM
    To: oracle-l_at_freelists.org
    Subject: Re: ****** RMAN backup for multi TB databases ******

    I recently visited a shop where they use RMAN on a 35Tb DW. 22Tb are READ
    ONLY tablespaces, so their weekly level-0 is about 13Tb. Their daily
    level-1 and level-2 average about 2-4Tb each, couple hundred Gb of
    archivelogs per day. They run big-iron Solaris and Veritas Netbackup to Sun
    DLT tape drives (16 drives, I think).

    They're happy with RMAN, although that weekly level-0 is exceeding the 24hr
    backup window they've imposed. I suggested that the level-0's be
    distributed across each day of the 7-day week, to even out their spikes;
    don't know if they implemented it or not.

    Also suggested that they look into table compression, but that will be a
    longer term thing. At the moment, I think they opted to order 6-8 more tape
    drives...

    RMAN isn't a problem; it's a big part of the solution...
    on 8/19/04 4:56 PM, Sam Reddy at iamanoracledba_at_yahoo.com wrote:

    Hi All,

    Could you please share your experience if you have implemented RMAN backup on
    a 5TB (Tera Byte) system ? I am concerned about backup time with
    full/cumulative/ incremental backups when RMAN is used in conjunction with
    Legato networker. Would you please send me if you have any white papers ?
    Hardware setup at your shop and any other technical considerations ?

    I appreciate your help.

    Have a wonderful day!

    Regards,

    Sam.







    ---------------------------------
    Do you Yahoo!?
    New and Improved Yahoo! Mail - Send 10MB messages!

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Jose Luis Delgado at Aug 20, 2004 at 11:09 am
    Hi!...

    I'm trying to refresh a replication group with:

    begin
    dbms_refresh.refresh('"OWNER".'"REFRESH_GROUP"');
    end;
    /

    after the above command I get:

    ORA-02055: distributed update operation failed;
    rollback required.

    The group is part of a: master-slave replication.
    i.e: Snapshot refresh only (at the snapshot site).

    The rest of my groups are ok...

    Any ideas?...
    I'm looking at Metalink without luck...

    TIA.

    JL



    Do you Yahoo!?
    Yahoo! Mail - 50x more storage than other providers!
    http://promotions.yahoo.com/new_mail

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
  • Gogala, Mladen at Aug 20, 2004 at 11:11 am
    Recovery of a 35 TB daatabase? Forever and ever, until death takes us apart.

    --
    Mladen Gogala
    Oracle DBA
    email:mladeng_at_aetvn.com
    Ext: 9787
    -----Original Message-----
    From: DENNIS WILLIAMS
    Sent: Friday, August 20, 2004 11:56 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: ****** RMAN backup for multi TB databases ******


    Tim - How long do they estimate the recovery time would be?
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • DENNIS WILLIAMS at Aug 20, 2004 at 11:25 am
    Mladen

    And if you've used RAID5 for the really large database (probably a data
    warehouse), then recovery might take longer than you expect. I thought
    somebody on the list mentioned that they were using a mirrored drive system
    for backups. Something like a 3-mirror system so you have your production
    and backup, then a third system that is your last backup. To backup you
    split the mirror then copy the mirror copy to the third copy, then resilver
    the mirror. And then write everything to tape or something. Maybe somebody
    that does that can provide the correct description of this method.

    Dennis Williams
    DBA

    Lifetouch, Inc.

    "We all want progress, but if you're on the wrong road, progress means
    doing an about-turn and walking back to the right road; in that case,
    the man who turns back soonest is the most progressive."
    -- C.S. Lewis

    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Gogala, Mladen
    Sent: Friday, August 20, 2004 11:16 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: ****** RMAN backup for multi TB databases ******

    Recovery of a 35 TB daatabase? Forever and ever, until death takes us apart.

    --
    Mladen Gogala
    Oracle DBA
    email:mladeng_at_aetvn.com
    Ext: 9787
    -----Original Message-----
    From: DENNIS WILLIAMS
    Sent: Friday, August 20, 2004 11:56 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: ****** RMAN backup for multi TB databases ******


    Tim - How long do they estimate the recovery time would be?
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Gogala, Mladen at Aug 20, 2004 at 11:32 am
    Dennis, without kidding, the only place that I know that has such
    setup is 911 department of the state of NY. I know that mostly
    because I used to work with the top-of-the-line DBA who used to
    work there. It's a Canadian guy by the name Bernard Antonouk,
    and he is really good. During my tenure at OXHP, we were splitting
    EMC, but it was raid 1+0 and we didn't have 3 copies, but 2 copies,
    one production and one for performance testing. Bernie used to be
    one of the top guys at Ingres and he was consulting in NYC in the
    late 90's (97,98,99). I don't know where is he now, but he would be
    a guy that I'd look for if I needed a setup like that.

    --
    Mladen Gogala
    Oracle DBA
    email:mladeng_at_aetvn.com
    Ext: 9787
    -----Original Message-----
    From: DENNIS WILLIAMS
    Sent: Friday, August 20, 2004 12:25 PM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: ****** RMAN backup for multi TB databases ******


    Mladen
    And if you've used RAID5 for the really large database
    (probably a data warehouse), then recovery might take longer
    than you expect. I thought somebody on the list mentioned
    that they were using a mirrored drive system for backups.
    Something like a 3-mirror system so you have your production
    and backup, then a third system that is your last backup. To
    backup you split the mirror then copy the mirror copy to the
    third copy, then resilver the mirror. And then write
    everything to tape or something. Maybe somebody that does
    that can provide the correct description of this method.

    Dennis Williams
    DBA
    Lifetouch, Inc.

    "We all want progress, but if you're on the wrong road,
    progress means doing an about-turn and walking back to the
    right road; in that case, the man who turns back soonest is
    the most progressive."
    -- C.S. Lewis


    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Gogala, Mladen
    Sent: Friday, August 20, 2004 11:16 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: ****** RMAN backup for multi TB databases ******


    Recovery of a 35 TB daatabase? Forever and ever, until death
    takes us apart.

    --
    Mladen Gogala
    Oracle DBA
    email:mladeng_at_aetvn.com
    Ext: 9787

    -----Original Message-----
    From: DENNIS WILLIAMS
    Sent: Friday, August 20, 2004 11:56 AM
    To: 'oracle-l_at_freelists.org'
    Subject: RE: ****** RMAN backup for multi TB databases ******


    Tim - How long do they estimate the recovery time would be?
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Stephen.Lee_at_DTAG.Com at Aug 20, 2004 at 1:20 pm

    -----Original Message-----
    This is actually quite trivial in Perl via flock(). Doesn't matter if
    the previous job was kill -9'd, flock() will let you check to see if
    the file is in use. ( Fctnl flock in my case)
    Well, oh yeah. Well, ksh can call fuser. But I don't think it would work
    in this case since the script uses individual redirects within the script.

    What I should have done was either not let more than one copy of the script
    run at all. Or, as I sort of intended, let more than one copy run as long
    as the command args don't intersect. That was an idea I had later on, but I
    forgot to modify the handling of the log file(s). And never got around to
    fixing it so that the log file doesn't start looking like the Windows
    registry if you run multiple copies of the script. And probably won't until
    the extremely unlikely day comes that I need to do it.
    I've
    never written a line of Java code.
    I have.
    Which is why I prefer Perl.
    I stopped to take a look at Java. Then kept on walking.

    The strange thing is, if there ever arose a desperate cry for it (shortly
    after hell freezes over), I think I might not mind programming using the
    Motif libs. I think it's a case of something being so extreme that the
    challenge has its appeal.

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Tim Gorman at Aug 22, 2004 at 11:20 am
    Obviously, it depends on what needs to be restored - one datafile, a couple
    of them, or all of them. The level-0 backup of 13Tb is approaching 24
    hours, so that should provide perspective.

    However, just by sheer odds based on space consumption, it is the READ ONLY
    tablespaces (which only need to be restored, not recovered) that are most
    likely to get "hit" by some failure. The odds of having to restore and
    recover the entire 35Tb at once is pretty slim, and at that point, you have
    to compare the cost of possibly having to restore/recover 35Tb against the
    benefits of having the 35Tb at all. What would be the advantages and
    disadvantages of throwing some of it away on purpose? And, would it be
    necessary to have a complete service outage for the entire restore/recover
    operation, or can some of the database (i.e. tablespaces with "newer" data)
    be up and running while the rest of the database is restored and recovered?

    Nice thing about RMAN is that mistakes on restore are fewer and more
    accurate...
    on 8/20/04 9:56 AM, DENNIS WILLIAMS at DWILLIAMS_at_LIFETOUCH.COM wrote:

    Tim - How long do they estimate the recovery time would be?

    Dennis Williams
    DBA
    Lifetouch, Inc.

    "We all want progress, but if you're on the wrong road, progress means
    doing an about-turn and walking back to the right road; in that case,
    the man who turns back soonest is the most progressive."
    -- C.S. Lewis


    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Tim Gorman
    Sent: Thursday, August 19, 2004 11:06 PM
    To: oracle-l_at_freelists.org
    Subject: Re: ****** RMAN backup for multi TB databases ******


    I recently visited a shop where they use RMAN on a 35Tb DW. 22Tb are READ
    ONLY tablespaces, so their weekly level-0 is about 13Tb. Their daily
    level-1 and level-2 average about 2-4Tb each, couple hundred Gb of
    archivelogs per day. They run big-iron Solaris and Veritas Netbackup to Sun
    DLT tape drives (16 drives, I think).

    They're happy with RMAN, although that weekly level-0 is exceeding the 24hr
    backup window they've imposed. I suggested that the level-0's be
    distributed across each day of the 7-day week, to even out their spikes;
    don't know if they implemented it or not.

    Also suggested that they look into table compression, but that will be a
    longer term thing. At the moment, I think they opted to order 6-8 more tape
    drives...

    RMAN isn't a problem; it's a big part of the solution...


    on 8/19/04 4:56 PM, Sam Reddy at iamanoracledba_at_yahoo.com wrote:
    Hi All,

    Could you please share your experience if you have implemented RMAN backup on
    a 5TB (Tera Byte) system ? I am concerned about backup time with
    full/cumulative/ incremental backups when RMAN is used in conjunction with
    Legato networker. Would you please send me if you have any white papers ?
    Hardware setup at your shop and any other technical considerations ?

    I appreciate your help.

    Have a wonderful day!

    Regards,

    Sam.
    ----------------------------------------------------------------

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------
  • Sam Reddy at Aug 23, 2004 at 3:38 pm
    Hi Tim,


    Thank you very much for the details! Much appreciated!
    Best Regards,
    Sam

    Tim Gorman wrote:
    Obviously, it depends on what needs to be restored - one datafile, a couple
    of them, or all of them. The level-0 backup of 13Tb is approaching 24
    hours, so that should provide perspective.

    However, just by sheer odds based on space consumption, it is the READ ONLY
    tablespaces (which only need to be restored, not recovered) that are most
    likely to get "hit" by some failure. The odds of having to restore and
    recover the entire 35Tb at once is pretty slim, and at that point, you have
    to compare the cost of possibly having to restore/recover 35Tb against the
    benefits of having the 35Tb at all. What would be the advantages and
    disadvantages of throwing some of it away on purpose? And, would it be
    necessary to have a complete service outage for the entire restore/recover
    operation, or can some of the database (i.e. tablespaces with "newer" data)
    be up and running while the rest of the database is restored and recovered?

    Nice thing about RMAN is that mistakes on restore are fewer and more
    accurate...
    on 8/20/04 9:56 AM, DENNIS WILLIAMS at DWILLIAMS_at_LIFETOUCH.COM wrote:

    Tim - How long do they estimate the recovery time would be?

    Dennis Williams
    DBA
    Lifetouch, Inc.

    "We all want progress, but if you're on the wrong road, progress means
    doing an about-turn and walking back to the right road; in that case,
    the man who turns back soonest is the most progressive."
    -- C.S. Lewis


    -----Original Message-----
    From: oracle-l-bounce_at_freelists.org
    On Behalf Of Tim Gorman
    Sent: Thursday, August 19, 2004 11:06 PM
    To: oracle-l_at_freelists.org
    Subject: Re: ****** RMAN backup for multi TB databases ******


    I recently visited a shop where they use RMAN on a 35Tb DW. 22Tb are READ
    ONLY tablespaces, so their weekly level-0 is about 13Tb. Their daily
    level-1 and level-2 average about 2-4Tb each, couple hundred Gb of
    archivelogs per day. They run big-iron Solaris and Veritas Netbackup to Sun
    DLT tape drives (16 drives, I think).

    They're happy with RMAN, although that weekly level-0 is exceeding the 24hr
    backup window they've imposed. I suggested that the level-0's be
    distributed across each day of the 7-day week, to even out their spikes;
    don't know if they implemented it or not.

    Also suggested that they look into table compression, but that will be a
    longer term thing. At the moment, I think they opted to order 6-8 more tape
    drives...

    RMAN isn't a problem; it's a big part of the solution...


    on 8/19/04 4:56 PM, Sam Reddy at iamanoracledba_at_yahoo.com wrote:
    Hi All,

    Could you please share your experience if you have implemented RMAN backup on
    a 5TB (Tera Byte) system ? I am concerned about backup time with
    full/cumulative/ incremental backups when RMAN is used in conjunction with
    Legato networker. Would you please send me if you have any white papers ?
    Hardware setup at your shop and any other technical considerations ?

    I appreciate your help.

    Have a wonderful day!

    Regards,

    Sam.
    ----------------------------------------------------------------

    Please see the official ORACLE-L FAQ: http://www.orafaq.com

    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.

    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

    ---------------------------------
    Do you Yahoo!?
    Yahoo! Mail is new and improved - Check it out!

    ----------------------------------------------------------------
    Please see the official ORACLE-L FAQ: http://www.orafaq.com
    ----------------------------------------------------------------
    To unsubscribe send email to: oracle-l-request_at_freelists.org
    put 'unsubscribe' in the subject line.
    --
    Archives are at http://www.freelists.org/archives/oracle-l/
    FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
    -----------------------------------------------------------------

Related Discussions

People

Translate

site design / logo © 2022 Grokbase