Re: AIX and Oracle Cold Backup

From: Naylor, Jim (Jnaylor_at_SCHNUCKS.COM)
Date: 07/31/03

  • Next message: Gene Sais: "Re: AIX and Oracle Cold Backup" 
    Date:         Thu, 31 Jul 2003 15:52:03 -0500
To: aix-l@Princeton.EDU

    I assume you are not doing archiving on this database since you are doing
    cold backups. If you split the mirror would you not have files open and
    possibly not have a clean copy?

    Thanks,
    Jim Naylor
    Unix Systems Administrator
    Schnuck Markets, Inc.
    * Direct: (314) 994-4784
    *)) Cell: (314) 691-0186
    * Fax : (314) 994-4684
    * jnaylor@schnucks.com

    -----Original Message-----
    From: Dearman, Richard [mailto:rdearm1@UIC.EDU]
    Sent: Thursday, July 31, 2003 3:13 PM
    To: aix-l@princeton.edu
    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: Gene Sais: "Re: AIX and Oracle Cold Backup"

    Relevant Pages

    • Re: AIX and Oracle Cold Backup
      ... AIX Administrator, Komatsu America ... shut the database down to do cold backups every month because of the ... Then mirror them again on the production server once the back up is ... If you are not the intended recipient or the individual ...
      (AIX-L)
    • Re: hOt or cold back up?
      ... Hot and cold backups refer to backing up a database. ... hot backup is a backup of the database while the database ... A new method of database backups is to mirror the database, ...
      (Security-Basics)
    • 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)