Re: AIX and Oracle Cold Backup

From: Gene Sais (Gsais@CO.PALM-BEACH.FL.US)
Date: Thu Jul 31 2003 - 16:52:48 EDT


lol, you need to do a little more than just sync and split mirrors.
Cold backups require all files to be closed, hence db shutdown.
Typically you put the db in hot backup mode, sync mirror, split mirror,
then end hot backup mode. There are plenty of white papers on how to do
this. I suspect your VMS backups are not valid. Have you tested
restores?
hth,
Gene

>>> BVerzal@KOMATSUNA.COM 07/31/03 04:42PM >>>
You could use "splitlvcopy" I would think.

BV
--------------------------------------------------------

Bill Verzal
AIX Administrator, Komatsu America
(847) 970-3726 - direct
(847) 970-4184 - fax

|---------+---------------------------->
| | "Dearman, |
| | Richard" |
| | <rdearm1@UIC.EDU>|
| | Sent by: IBM AIX |
| | Discussion List |
| | <aix-l@Princeton.|
| | EDU> |
| | |
| | |
| | 07/31/2003 03:13 |
| | PM |
| | Please respond to|
| | IBM AIX |
| | Discussion List |
| | |
|---------+---------------------------->

>-------------------------------------------------------------------------------------------------------------------------------|
  |
                                                          |
  | To: aix-l@Princeton.EDU
                                                          |
  | cc:
                                                          |
  | Subject: AIX and Oracle Cold Backup
                                                          |

>-------------------------------------------------------------------------------------------------------------------------------|

We rs6000 running aix 4.3.3 with and oracle database. We don't want
to
shut the database down to do cold backups every month because of the
downtime. We currently use volume group mirroring to keep 2 copies of
the
database. Is it possible in aix to unmirror the volume group then
mount
the unactive mirror set on another aix box then do a cold back of
those
disks. Then mirror them again on the production server once the back
up is
completed on the other server. We have SAN so the disk are accessible
to
both nodes. We currently do this on our vms system which has a large
oracle database but we want to do the same thing on our ais systems.

If this is possible please explain, how.

Thanks

***************************EMAIL DISCLAIMER***************************
This
email and any files transmitted with it may be confidential and are
intended solely for the use of th individual or entity to whom they
are
addressed. If you are not the intended recipient or the individual
responsible for delivering the e-mail to the intended recipient, any
disclosure, copying, distribution or any action taken or omitted to be
taken in reliance on it, is strictly prohibited. If you have received
this
e-mail in error, please delete it and notify the sender or contact
Health
Information Management 312.413.4947.



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 22:17:06 EDT