Re: Copy Database

From: Chuck Isaacson <ccisaac_at_mtu.edu>
Date: 1996/06/21
Message-ID: <4qecol$aej_at_instasrv.admin>

From: Nimesh V Soni <leo_at_INTERNET.KRONOS.COM> Subject: Re: Steps for creating additional database with additional i

     May be this will help you. Let me know if u need any more help.

     Creating a database - Steps involved:
     -----------------------------------------------------
     Let's assume we are creating another instance named CADRE.
     1. Change ORACLE_SID to CADRE
        $ ORACLE_SID=CADRE; export ORACLE_SID
     2. Create initCADRE.ora and configCADRE.ora
         Check the following parameters especially.
        DB_NAME                 DB_DOMAIN
        CONTROL_FILES           DB_BLOCK_SIZE
        DB_BLOCK_BUFFERS        PROCESSES
        ROLLBACK_SEGMENTS
        INIT_SQL_FILES

        Create required directories (look in config.ora file)

     3. Log in to sqldba lmode=y
     4. connect internal
     5. startup the instance .i.e.
        sqldba> startup nomount
     6. Create the database using CREATE DATABASE command
     7. Create data dictionary .i.e. execute following scripts from sqldba
     prompt.
        /oracle/rdbms/admin/sql.bsq
        /oracle/rdbms/admin/catalog.sql
        /oracle/rdbms/admin/catproc.sql
     8. Create the rollback segment tablespace; and then create rollback
     segments.
     9. Your database is created. Now you can exit sqldba.


______________________________ Reply Separator _________________________________

Subject: Steps for creating additional database with additional insta Author: "ORACLE database mailing list." <ORACLE-L_at_kbs.net> at INTERNET Date: 5/9/96 18:04

hi,
 currently, we have the development database db_dev associated with instance and SID 'DEV'. people are using the database for development. i would like to know some important steps if i have to create a test database db_test with another instance and SID 'TEST' on the same HP-UX server (memory is 256 MB and no constraint on diskspace). my questions are

1. should i close and unmount db_dev database before issuing create database commnad
2. In the create databsae commnad, if the maxinstances is set to 1 then can both the instances can access the databases mutually ? or should it be set to 2.
3. i am worried about the existing control file will be overwriiten. If i set control file ipath in a new initdb_test.ora file , does it create a new control file. is it OK.
4. should the control file REUSE option necessary. REUSE - is it for reusing the existing control file or for the control file to be reused by the server.
5. the .profile for oracle has DB_NAME=DB_DEV and SID=DEV should i change these to the new test database name and sid after starting the instance and before issuing CREATE DATABASE script.
6. should the catalog.sql should be again run after the test database.
7. what will be the system and sys passwords for the new test database created
8. can the database link be created after creating the databse , should it be done at both the databases dev and test .
9. what is the setup required to access the tables from both the databases ?

 Thanks in advance for expected solution

  GK

---

 G. Gopalakrishna
 Email : gkrish_at_ctp.com

---

---

   To subscribe, unsubscribe or change subscription options to ORACLE-L,    send a message to LISTSERV_at_dbinfo.com.

       ORACLE-L is a service of Kapur Business Systems, Inc.

---

---

   To subscribe, unsubscribe or change subscription options to ORACLE-L,    send a message to LISTSERV_at_dbinfo.com.

       ORACLE-L is a service of Kapur Business Systems, Inc.

---

Shaochun Lin (lovedog_at_gwis2.circ.gwu.edu) wrote:
: Please help! I want to find best way to dupliate a database, the basic
: idea in my mind is, create a new database and create exact size of
: tablespaces and doing full export and full import. Does someone can give
: me a advise and are there any hole in this procedure. Thanks, SC
Received on Fri Jun 21 1996 - 00:00:00 CEST