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

Thread: backup strategy

  1. 03-03-2003, 11:37 AM #1
    marciamg@hotmai
    marciamg@hotmai is offline Junior Member
    Join Date
    Mar 2003
    Location
    Miami, FL
    Posts
    10

    backup strategy

    Hi! Our database has multiple tablespaces dedicated to different data grouping. Also, we have all indexes stored in their own tablespaces. My question is, do I need to include the tablespaces that contain the indexes when doing an incremental backup only of the most used tablespaces? Thanks
    Reply With Quote Reply With Quote
  2. 03-03-2003, 11:39 AM #2
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Yes.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  3. 03-03-2003, 11:53 AM #3
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Yes, but only if you want a successful recovery.
    Jeff Hunter
    Reply With Quote Reply With Quote
  4. 03-03-2003, 11:56 AM #4
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Are you the Jeff Hunter who wrote "1001 ways to skrew a database"? GREAT BOOK!
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
  5. 03-03-2003, 12:07 PM #5
    adewri's Avatar
    adewri
    adewri is offline Oracle Monk
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Are you the man behind http://www.idevelopment.info/
    ??
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!
    Reply With Quote Reply With Quote
  6. 03-03-2003, 01:28 PM #6
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    Originally posted by adewri
    Are you the man behind http://www.idevelopment.info/
    ??
    Definitely not.
    Jeff Hunter
    Reply With Quote Reply With Quote
  7. 03-03-2003, 01:43 PM #7
    marciamg@hotmai
    marciamg@hotmai is offline Junior Member
    Join Date
    Mar 2003
    Location
    Miami, FL
    Posts
    10

    Smile

    Thanks to both answers
    Another question: What it is your recomendation on whether or not use a (RMAN) catalog? If I am doing level 0 weekly with level 2 daily, what should be my retention period for control files
    We are talking about a 50G-500G db (if size has anything to do)
    Thanks again
    Reply With Quote Reply With Quote
  8. 03-03-2003, 01:51 PM #8
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    My personal preferance is to use a catalog.
    Jeff Hunter
    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