Re: ORACLE datafiles on mirrored disks

Michael Kiesel (ea7_at_informatik-zentrum-bayern.de) wrote:

: Hi there!
 

: I would like to know if there is anybody out there running ORACLE V7.x
: on mirrored disks. The management people here are concerned about high
: availability and decided to put all data on mirrored disks. As we are
: using a lot of app's that work in a classical fileserver architecture
: (LanManager/X) this is understandable. Backup is done by 'unmounting'
: the mirrored disk, copying to tape and 'mounting' it again.
 

: The questions are:
: - How does this procedure comply with ORACLE data files?

ORACLE does not care what mechanism is used for the o/s copy of the datafiles provided that:

for cold backups, the db is shutdown for whole duration of backup of all datafiles

for hot backups, the db tablespace being backed up is in hot backup mode for whole duration of backup of datafiles and archiving is enabled.

: - What should be done before/after backup? Same SQL*DBA-commands like
: with 'normal' online-backup ('alter tablespace begin backup' ...)?

see above.

: - Is it safe to put the (online- and offline-) redologs on the same
: volume as the data files?

to ensure better risk distribution and i/o throughput, i would recommend against putting online redo's or archive logs on the same volumns as datafiles. you should also try to segregate the redo's and archive logs into separate volumns.

: Any comments/suggestions are welcome!
 

: Thanks in advance
 

: --
: |\/|. Michael G. Kiesel | e-mail: mkie_at_izb.de
: IZB GmbH & Co. KG | voice: +49-89-2868-1579
: Karolinenplatz 5 | fax: +49-89-2868-1715
: D-80333 Muenchen, Germany | >>> STANDARD DISCLAIMER APPLIES! <<<
Received on Tue May 23 1995 - 00:00:00 CEST