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_at_[198.138.198.252]>
'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 [Quoted] I change the above file to
'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?
Date: Wed, 18 Apr 2001 19:39:01 GMT
Message-ID: <l.987622742.1631286621_at_[198.138.198.252]>
[Quoted] 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 1MDATAFILE
'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 [Quoted] 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' reuseDATAFILE
'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/newReceived on Wed Apr 18 2001 - 21:39:01 CEST