Help: Recreate database script

From: <u518615722_at_spawnkill.ip-mobilphone.net>
Date: Wed, 18 Apr 2001 19:39:01 GMT
Message-ID: <l.987622742.1631286621@[198.138.198.252]>

I was learning to recreate the database to solve the system tablespace fragments. I backup the controlfile to trace and got the file as follow:

CREATE CONTROLFILE REUSE DATABASE test

    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 16
    MAXLOGHISTORY 1815
LOGFILE

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

DATAFILE
'C:\ORACLE\ORADATA\SHAO816\SYSTEM01.DBF',
'C:\ORACLE\ORADATA\SHAO816\RBS01.DBF',
'C:\ORACLE\ORADATA\SHAO816\USERS01.DBF',
'C:\ORACLE\ORADATA\SHAO816\TEMP01.DBF',
'C:\ORACLE\ORADATA\SHAO816\TOOLS01.DBF',
'C:\ORACLE\ORADATA\SHAO816\INDX01.DBF',
'C:\ORACLE\ORADATA\SHAO816\DR01.DBF',
'C:\ORACLE\ORADATA\SHAO816\DBA1.ORA'

CHARACTER SET WE8ISO8859P1 I change the above file to

CREATE DATABASE test

    MAXLOGFILES 32
    MAXLOGMEMBERS 2
    MAXDATAFILES 32
    MAXINSTANCES 16
    MAXLOGHISTORY 1815
LOGFILE

  GROUP 1 'C:\ORACLE\ORADATA\SHAO816\REDO03.LOG'  reuse,
  GROUP 2 'C:\ORACLE\ORADATA\SHAO816\REDO02.LOG'  reuse,
  GROUP 3 'C:\ORACLE\ORADATA\SHAO816\REDO01.LOG'  reuse

DATAFILE
'C:\ORACLE\ORADATA\SHAO816\SYSTEM01.DBF' reuse,
'C:\ORACLE\ORADATA\SHAO816\RBS01.DBF' reuse,
'C:\ORACLE\ORADATA\SHAO816\USERS01.DBF' reuse,
'C:\ORACLE\ORADATA\SHAO816\TEMP01.DBF' reuse,
'C:\ORACLE\ORADATA\SHAO816\TOOLS01.DBF' reuse,
'C:\ORACLE\ORADATA\SHAO816\INDX01.DBF' reuse,
'C:\ORACLE\ORADATA\SHAO816\DR01.DBF' reuse,
'C:\ORACLE\ORADATA\SHAO816\DBA1.ORA' reuse
CHARACTER SET WE8ISO8859P1 To my surprise, all my database was destroyed. All the datafile were put into system
tablespace. Thanks GOD it is only test
database. Could some body tell me what is the right script to re-create the database?

Thanks a lot.  

-- 
Sent  by dbadba62 from hotmail part of com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new

Received on Wed Apr 18 2001 - 14:39:01 CDT