Snapshots and Oracle

From: Aaron Sherman (ajs@ajs.com)
Date: Wed Aug 09 2000 - 16:50:08 EDT

  • Next message: kevin graham: "Re: Snapshots and Oracle"

    I have a few snapshot questions for anyone else who's running Oracle:

            1. Does a hot backup (as described on
               http://www.netapp.com/tech_library/3049.html) present any
               restoration problems? Has anyone done a restore from a hot
               backup?
            2. Hot backups are as close to "live" as you're supposed to
               come, but it seems to me that a nice extra bit of paranoia
               would be to take snapshots 2-3 times per day of the live
               database. The image would be consistent, and Oracle would
               come up off of it as it would from a crash (unlike, say a
               tar of the data-files which would be junk). The only problem
               would be that you would loose any half-completed
               actions which were not correctly tansactionalized. Can
               anyone comment on this?
            3. Has anyone seen roughly how much storage an Oracle snapshot
               takes? It seems to me that it would be larger than a
               filesystem snapshot because more blocks are changing. Of
               course, it depends on your read/write ratio, but is there a
               general consensus?
               
    I've so far been very impressed with my filer. Oracle over NFS sounded
    outright dumb to me at first, but damn if it isn't faster than local
    disk.

    Thanks. 

    -- 
Aaron Sherman
Systems Architect
HighWired.com -- The global high school community
http://www.highwired.com

    300 North Beacon Street
Watertown, MA 02472
(617) 926-1850 x238
(617) 926-1861 fax
asherman@highwired-inc.com / ICQ#43677395 / Y!ajstrader

    "We had some good machines, but they don't work no more."
	-"Faded Flowers" / Shriekback

    This archive was generated by hypermail 2b29 : Wed Aug 09 2000 - 16:56:20 EDT