Results 1 to 9 of 9
  1. #1
    Join Date
    Mar 2006
    Posts
    3

    Unanswered: Can database restore be done with tablespace backups only?

    Suppose I lost all full database backups. The only backup images I could find are various tablespace backups taken at various time. Each tablespace has its corresponding tablespace backup but with different timestamp.

    Is it possible for me to restore the full database using these individual tablespace backups?

    Thanks in advance!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is it possible for me to restore the full database using these individual tablespace backups?
    It depends, but most likely NO.
    P.S.
    The person in charge of "backups" should be summarily terminated for incompetence if they can not restore complete data integrity.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Mar 2006
    Posts
    3
    Well... how about in a multi-terabyte data warehouse in which it is too long to run a full database backup?

  4. #4
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >how about in a multi-terabyte data warehouse in which it is too long to run a full database backup?
    Penny-wise, pound foolish.
    If damagement decides that the loss of data is more acceptable than paying for sufficient backup media, then they must accept the fact that data may go missing & become irretrievable.
    How exactly are you doing "tablespace backups"?
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  5. #5
    Join Date
    Jul 2003
    Posts
    2,296
    what dw is not multi-terabyte??

    regardless, perhaps you should at least implement some type of BCV split
    copy which would at least allow you a cold-backup copy of your dw.
    Then schedule that at a time-interval that is acceptible.

    what is the database error?
    - The_Duck
    you can lead someone to something but they will never learn anything ...

  6. #6
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi Anacedent,

    I usually find your manner intolerant, but your knowledge insightful... I am not a DBA by any means, I'm just a developer who has for his sins, found himself concerned about backups.

    Is it fair to say, that given a copy of the control file (backup controlfile to trace) and all the table spaces at a single moment in time that the database could be restored? (ie database closed, cold copies of tablespaces and control file).

    Its an honest question, everything I read about Oracle backups suggests there is some voodoo in there somewhere :-(

    Cheers
    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  7. #7
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >(ie database closed, cold copies of tablespaces and control file).
    IMO, is that is all you have in addition to the output from
    ALTER DATABASE BACKUP CONTROLFILE TO TRACE;
    then my answer would be "NO".
    I believe that you also would require copies of the REDO log files.
    Do not take my word for anything.
    Run DBCA & create a sample test database of a few hundred MB.
    Move the files to a different box & get the database open.
    If/when Oracle has opened, the restore is a success.
    Anything less is a failure.
    I will stipulate that that after a clean SHUTDOWN IMMEDIATE, you can copy ALL necessary files to another box (into the EXACT same locations) and then simply issue the "STARTUP" command.
    Oracle will not know or care that is has been moved.
    If you ever issue a RESETLOG command, your 1st order of business should be a BACKUP of one flavor or another.

    HAND!
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  8. #8
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Hi,

    Quote Originally Posted by anacedent
    >I believe that you also would require copies of the REDO log files.
    Ah yes, makes sense.

    Quote Originally Posted by anacedent
    Run DBCA & create a sample test database of a few hundred MB.
    Move the files to a different box & get the database open.
    If/when Oracle has opened, the restore is a success.
    Anything less is a failure.
    I'll give that a go, thanks. I think it might be the straightforward backup/restore method which a non-Oracle but tech literate (ie average Sysadmin) could perform.

    Quote Originally Posted by anacedent
    HAND!
    Thankyou!

    Bill
    Please don't email me directly with questions. I've probably just got home from the pub and cannot guarantee the sanity of my answers. In fact, I can't believe I actually made it home.

  9. #9
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool


    If you have backups at different time's you would at least need the following:
    1) Latest controlfile as of latest backupset you have.
    2) All archive logs from oldest backup time upto that controlfile (or beyond).
    3) No need of redo-logs if you are to do a point in time recovery.

    Good Luck!
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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