DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: backup of materialized views

  1. #1
    Join Date
    Dec 2001
    Posts
    320
    hi all,
    i need information on backing up materialized views, what are (if any) the things that i have to take into consideration when backing up materialized views?, i would be grateful if any of you provided me with a document that deals with this issue.

    best regards.

  2. #2
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Normal online/offline backup will back these up.
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  3. #3
    Join Date
    Dec 2001
    Posts
    320
    hi sureshy,
    Does that mean that i only have to follow my normal bakup plan in backing up these materialized views? wont this affect my replication process in any way?

    Thank you for replying.

  4. #4
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    I am not aware of a special backup practice for materialized views. Their definition is still stored in the dictionary, the only difference is that they occupy a segment aswell, all of this data is in the tablespaces you backup.

    If you're really worried about this, test a backup/recovery.

    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  5. #5
    Join Date
    Dec 2001
    Posts
    320
    well what if a snapshot site crashes? after simply recovering it data will be incosistent, am i right?

  6. #6
    Join Date
    Dec 2001
    Posts
    320
    hey guys i really need to know an answer, if anyone could just tell me about a document that i can read.

    Thank you guys.

  7. #7
    Join Date
    Dec 2001
    Posts
    320
    no answer?

    help Julian

  8. #8
    Join Date
    Apr 2001
    Location
    London
    Posts
    725
    Once you have eliminated all of the impossible,
    whatever remains however improbable,
    must be true.

  9. #9
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by hany
    no answer?

    help Julian
    Normal backups of MVs is just fine. If they are not too big you may neglect the backups and just reconstruct them if something happens to the DBs. I usually have an ASCII file with the create statements of all MVs and use it in case of disaster.
    Oracle Certified Master
    Oracle Certified Professional 6i,8i,9i,10g,11g,12c
    email: ocp_9i@yahoo.com

  10. #10
    Join Date
    Dec 2001
    Posts
    320
    hmmm, thanks Julian, but why ASCII File? why not a normal Text File?

Posting Permissions

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


Click Here to Expand Forum to Full Width