mirror UX and mix and oracle backup

[peter demus]

Hello !

i learned that mirror/UX can also do mirrors to more than 1 target volume. RAID 1

is it no problem to mix SCSI and FC devices ? so i can mirror the system and local data disk to a DS2100 rack in next room ?

what's the best way to backup oracle database (size 100GB) with only 5 min or no down time ? lvreduce of the second mirror or online backup possible with OmniBack ??

thanks and bye, peter

[Tom Geudens]

Hi,
Did you take a look at the snapshot capabilities of OnlineJFS ? Stop the database, mount a snapshotfilesystem, start the database ... and you can then backup the snapshotfilesystem ...

Hope this helps,
Tom

[Stefan Farrelly · Accepted solution]

Yes, you can create > 1 mirror copy of disks to any other disks you have attached.

Yes, you can use Omniback to backup Oracle online so no downtime ! But this may take a while if you have a 100GB database and certainly restoring the whole db (god forbid it should become necessary) will take quite a long time.

Much better to do as you said - create a 2nd mirror copy, shutdown the DB, split the 2nd mirror copy off, restart the DB (should only take a couple of minutes) and backup the split mirror copy at your leisure.

[Santosh Nair_1]

Just a quick note...the command to split the mirrors is lvsplit, not lvreduce. lvreduce will decrease the number of mirrors, while lvsplit will split the mirror onto an new LV. And to resynch the mirrors the command is lvmerge.

-Santosh

[Carlos Fernandez Riera]

To backup a oracle database w/o downtime you can use ' alter tablespace xxx begin backup for all tablespaces, this is a online backup.

When fisnish backup alter database end backup...


The database needs to be in archive mode.

Search ( boolean) :

oracle +online +backup

to find more trheads with this subject.