Re: AIX and Oracle Cold Backup

From: Gene Sais (Gsais_at_CO.PALM-BEACH.FL.US)
Date: 07/31/03

  • Next message: James Jackson: "Errors on fiber channel adapter." 
    Date:         Thu, 31 Jul 2003 16:52:48 -0400
To: aix-l@Princeton.EDU

    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.

  • Next message: James Jackson: "Errors on fiber channel adapter."

    Relevant Pages

    • Re: AIX and Oracle Cold Backup
      ... I assume you are not doing archiving on this database since you are doing ... the database down to do cold backups every month because of the downtime. ... mirror set on another aix box then do a cold back of those disks. ... delivering the e-mail to the intended recipient, any disclosure, copying, ...
      (AIX-L)
    • Re: FILE-SAVE versus AIX mksysb tape
      ... Here's a potential novel way you could maybe consider to do this by using AIX software mirroring and using 3 mirror copies on all your D3/AIX logical volumes: ... No file system can be safely backed up while update activity is occurring. ... you need to be able to mark exactly where the backup ...
      (comp.databases.pick)
    • Re: read-from-all-disks support for RAID1?
      ... There are situations where data integrity is far more important than speed. ... On AIX I usually use the Mirror Write Consistency and Write Verify ... To unsubscribe from this list: send the line "unsubscribe linux-kernel" in the body of a message to majordomo@vger.kernel.org More majordomo info at http://vger.kernel.org/majordomo-info.html Please read the FAQ at http://www.tux.org/lkml/ ...
      (Linux-Kernel)
    • AIX SAN boot - ipl_varyon thinks yes, bootinfo thinks no
      ... Have folks booted AIX to EMC DMX-3000 arrays? ... I have some AIX 5.1 boxes that currently boot to an ... array and the new array, ... side of the the mirror it started out on? ...
      (comp.unix.admin)
    • Re: Question about moving data
      ... New to AIX? ... > Could you mirror that lv to a third hdisk then migrate that ... > hdisk to a new VG? ... > This message has been checked for all known viruses ...
      (AIX-L)