[HPADM] SQL statements to restart hot split Oracle BCV instance

• Previous message: Wright, Richard: "[HPADM] SUMMARY latest gzip for HP-UX 10.20"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

To: "'emc_list@yahoogroups.com'" <emc_list@yahoogroups.com>, "Hpux-Admin (hpux-admin@dutchworks.nl)" <hpux-admin@dutchworks.nl>
Date: Mon, 15 Dec 2003 18:10:59 -0500

Emc_list:
Hpux-admin:

We are able to do a hot split of our STD Oracle Database (version 8.1.7.4),
using the techniques that you helped me with in November:

        symioctl archive log
        symioctl -type oracle begin backup -noprompt
        symmir -f $DB_FILE split -noprompt -instant
        symioctl -type oracle end backup -noprompt
        symioctl archive log
        symmir -f $ARCH_FILE split -noprompt -instant
        #
        SQL > alter database backup controlfile to trace;

We are having some problems restarting the database on the BCV side. We get
a number of (undecipherable to me) oracle error messages.

The DBA with whom I am working on this, is able to start the database
manually using the ascii sql statements below, with the "verbs" on the last
two lines below.

Is this how people do it?"

        RECOVER DATABASE using backup controlfile until cancel
        ALTER DATABASE OPEN resetlogs;

??
                Stuart

=====================================================================

STARTUP NOMOUNT
CREATE CONTROLFILE REUSE set DATABASE "HOT6" RESETLOGS NOARCHIVELOG
    MAXLOGFILES 16
    MAXLOGMEMBERS 2
    MAXDATAFILES 30
    MAXINSTANCES 1
    MAXLOGHISTORY 907
LOGFILE
  GROUP 1 '/u2102/oradata/HOT6/redo03.log' SIZE 500K,
  GROUP 2 '/u2102/oradata/HOT6/redo02.log' SIZE 500K,
  GROUP 3 '/u2102/oradata/HOT6/redo01.log' SIZE 500K
DATAFILE
  '/u2101/oradata/HOT6/system01.dbf',
  '/u2101/oradata/HOT6/tools01.dbf',
  '/u2101/oradata/HOT6/rbs01.dbf',
  '/u2101/oradata/HOT6/temp01.dbf',
  '/u2101/oradata/HOT6/users01.dbf',
  '/u2101/oradata/HOT6/indx01.dbf',
  '/u2101/oradata/HOT6/drsys01.dbf'
CHARACTER SET US7ASCII
;
RECOVER DATABASE using backup controlfile until cancel
ALTER DATABASE OPEN resetlogs;

***** 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)

• Previous message: Wright, Richard: "[HPADM] SUMMARY latest gzip for HP-UX 10.20"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]