[HPADM] Summary: Splitting Oracle DataBases "Live" with EMC TimeFinder/B CV "symioctl" commands

From: Abramson, Stuart (SAbramson_at_Wabtec.com)
Date: 12/02/03

  • Next message: Patel Pankaj: "[HPADM] RE: tar cvf , tar xvf" 
    To: "Hpux-Admin (hpux-admin@dutchworks.nl)" <hpux-admin@dutchworks.nl>, "EMC List (E-mail) (emc_list@yahoogroups.com)" <emc_list@yahoogroups.com>
Date: Tue, 2 Dec 2003 12:12:01 -0500

    Thanks to:

            George Bodnar
            Bryan Quinn
            Joe Reeves
            Rita Workman
            Gary Paveza
            Dan Copeland

    Here are the steps involved:

    A.. Install
            1. Software: SRM and Shared 64-bit libraries
            2. License: Timefinder or Mapping
            3. Daemons: storapid / storora64d
                    

    B. USE:

            We want to:
            
            a. Set up:
                    1. Set variables
                    2. Check environment
            b. Split DataBase
                    3. Force archive log switch.
                    4. Put database tablespaces in backup mode.
                    5. "freeze" database.
                    6. flush veritas cached metadata and influx pages to
    disk
                    7. Split DB device groups; check status; wait complete
                    8. thaw database.
                    9. End backup mode.
                    10. Force current redo log to be archived.
            c. Split Archive Logs:
                    11. Split Archive Logs..

    1. Set environment variables:

                    #export SYMCLI_RDB_CONNECT="username/password@service"
                    export SYMCLI_RDB_CONNECT="system/stuart@HOTB"
                    export SYMCLI_RDB_TYPE=Oracle
                    export ORACLE_HOME=/u1001/app/oracle/product/9.2.0
                    export ORACLE_SID=HOTB
                    export PATH=$PATH:/$ORACLE_HOME/bin
                    
    2. Verify environmnet:

            o SID running
            o BCVs synched
            o Not in backup mode

    3-11. Commands:

            symioctl archive log -noprompt
            symioctl -type oracle begin backup -noprompt
            symioctl -type oracle freeze -noprompt
            symmir -f ${BCVFILE_DB} -sid ${SID} -instant split -noprompt
            symioctl -type oracle thaw -noprompt
            symioctl -type oracle end backup -noprompt
            symioctl archive log -noprompt
            symmir -f ${BCVFILE_AL} -sid ${SID} -instant split -noprompt

    ***** CONFIDENTIALITY NOTE *****
    The content contained in this e-mail transmission is legally privileged and confidential information intended only for the use of the individual or entity named herein. If the reader of this transmission is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this transmission is strictly prohibited. 

    --
             ---> Please post QUESTIONS and SUMMARIES only!! <---
        To subscribe/unsubscribe to this list, contact majordomo@dutchworks.nl
       Name: hpux-admin@dutchworks.nl     Owner: owner-hpux-admin@dutchworks.nl
 
 Archives:  ftp.dutchworks.nl:/pub/digests/hpux-admin       (FTP, browse only)
            http://www.dutchworks.nl/htbin/hpsysadmin   (Web, browse & search)
  • Next message: Patel Pankaj: "[HPADM] RE: tar cvf , tar xvf"