Re: cloning a db

From: <SUSOTT_at_amnutrition.com>
Date: Wed, 6 Mar 2002 16:32:33 -0700
Message-ID: <u8d9ohaa6c91eb@corp.supernews.com>

ISP would not allow binaries to be attached, here is the trace file copied, the init.ora is the default file produced in creating the database, If you desire to see it, I will post or email it.

CREATE CONTROLFILE reuse set DATABASE "PLAY" RESETLOGS NOARCHIVELOG

    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 16
    MAXLOGHISTORY 1815
LOGFILE

  GROUP 1 'C:\ORACLE\ORADATA\PLAY\REDO03.LOG'  SIZE 1M,
  GROUP 2 'C:\ORACLE\ORADATA\PLAY\REDO02.LOG'  SIZE 1M,
  GROUP 3 'C:\ORACLE\ORADATA\PLAY\REDO01.LOG'  SIZE 1M

DATAFILE
'C:\ORACLE\ORADATA\PLAY\SYSTEM01.DBF',
'C:\ORACLE\ORADATA\PLAY\RBS01.DBF',
'C:\ORACLE\ORADATA\PLAY\USERS01.DBF',
'C:\ORACLE\ORADATA\PLAY\TEMP01.DBF',
'C:\ORACLE\ORADATA\PLAY\TOOLS01.DBF',
'C:\ORACLE\ORADATA\PLAY\INDX01.DBF',
'C:\ORACLE\ORADATA\PLAY\DR01.DBF',
'C:\ORACLE\ORADATA\PLAY\OEM_REPOSITORY.ORA',
'E:\ORACLE\ORADATA\PLAY\CONSTANT_GROW_INDEXES01.ORA',
'E:\ORACLE\ORADATA\PLAY\CONSTANT_GROW_TABLES01.ORA',
'E:\ORACLE\ORADATA\PLAY\DEPENDENCY_INDEXES01.ORA',
'E:\ORACLE\ORADATA\PLAY\DEPENDENCY_TABLES01.ORA',
'E:\ORACLE\ORADATA\PLAY\DIAGRAM_INDEXES01.ORA',
'E:\ORACLE\ORADATA\PLAY\DIAGRAM_TABLES01.ORA',
'E:\ORACLE\ORADATA\PLAY\LOB_DATA1.ORA',
'E:\ORACLE\ORADATA\PLAY\RAPID_GROW_INDEXES01.ORA',
'E:\ORACLE\ORADATA\PLAY\RAPID_GROW_TABLES01.ORA',
'E:\ORACLE\ORADATA\PLAY\SYSTEM_META_INDEXES01.ORA',
'E:\ORACLE\ORADATA\PLAY\SYSTEM_META_TABLES01.ORA',
'E:\ORACLE\ORADATA\PLAY\TEMPORARY_INDEXES01.ORA',
'E:\ORACLE\ORADATA\PLAY\TEMPORARY_TABLES01.ORA',
'E:\ORACLE\ORADATA\PLAY\VERSION_INDEXES01.ORA',
'E:\ORACLE\ORADATA\PLAY\VERSION_TABLES01.ORA'
CHARACTER SET WE8ISO8859P1
;

# Recovery is required if any of the datafiles are restored backups,
# or if the last shutdown was not normal or immediate.
#RECOVER DATABASE
# Database can now be opened normally.
# ALTER DATABASE OPEN;
# No tempfile entries found to add.
#

Received on Wed Mar 06 2002 - 17:32:33 CST