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

From: Abramson, Stuart (SAbramson@Wabtec.com)
Date: Tue Dec 02 2003 - 12:12:01 EST


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)


This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 11:02:37 EDT