Re: AIX and Oracle Cold Backup

From: Bill Verzal (BVerzal_at_KOMATSUNA.COM)
Date: 07/31/03

  • Next message: Naylor, Jim: "Re: AIX and Oracle Cold Backup" 
    Date:         Thu, 31 Jul 2003 15:42:29 -0500
To: aix-l@Princeton.EDU

    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: Naylor, Jim: "Re: AIX and Oracle Cold Backup"

    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: replication
      ... mode, when a session begins, the mirror server synchronizes the mirror ... database with the principal database as quickly as possible. ... substantial if the principal server is under a heavy work load or the ...
      (comp.databases.ms-sqlserver)
    • RE: Database Mirroring or Log Shipping?
      ... Log Shipping nothing but moving tlog from Primary to Secondary once restored ... "Because the mirror database is in a recovering state, ... snapshots are not an option for us b/c we have SQL 2005 STD. ...
      (microsoft.public.sqlserver.replication)
    • RE: Database Mirroring or Log Shipping?
      ... "Because the mirror database is in a recovering state, ... snapshots are not an option for us b/c we have SQL 2005 STD. ... Maybe Log Shipping is an alternative, but thought that I read that Log ...
      (microsoft.public.sqlserver.replication)