Create Database issues

From: <argosy22_at_my-deja.com>
Date: Tue, 28 Mar 2000 02:34:21 GMT
Message-ID: <8bp5nc$hon$1@nnrp1.deja.com>

Hi,

On the same Oracle instance, I could create a second database, without destroying the first one. Good. :)

However, I can't open it now.
It gives me a problem on the Rollback space.

To create, I used the statement:

create database	ltfd1
DATAFILE		'/data/ltfd1/sys1.dbf'		SIZE
50M
MAXLOGFILES		5
MAXLOGHISTORY	100
MAXINSTANCES	1
MAXDATAFILES	10

ARCHIVELOG
EXCLUSIVE
CHARACTER SET AL24UTFFSS
LOGFILE

GROUP	1  (	'/work/oralogs/ltfd1/redo01.log')	SIZE  4M,
GROUP 2  ( '/work/oralogs/ltfd1/redo02.log') 	SIZE	4M,
GROUP 3  ( '/work/oralogs/ltfd1/redo03.log') 	SIZE	4M

When I try to open, this is what I get:

SVRMGR> startup open
ORACLE instance started.

Total System Global Area       6092056 bytes
Fixed Size                       39816 bytes
Variable Size                  5527952 bytes
Database Buffers                491520 bytes
Redo Buffers                     32768 bytes

Database mounted.
ORA-01534: rollback segment 'ROLL1_RBS' doesn't exist

alter database ltfd1
mount exclusive
open

ORA-00933: SQL command not properly ended

alter database ltfd1 open

ORA-00704: bootstrap process failure
ORA-00604: error occurred at recursive SQL level 1
ORA-00955: name is already used by an existing object

Create public rollback segment ROLL1_RBS

ORA-01109: database not open

The database won't open because it doesn't have a rollback segment. But I can't create the rollback statement without opening the database.

Does anyone have any suggestions?

Thanks,

Argosy

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Mar 27 2000 - 20:34:21 CST