Re: Create Database issues

argosy22_at_my-deja.com wrote:
>
> 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.

        Your init.ora file controls which rollbacks Oracle expects to find available when
it opens. Do the following:

1. Comment out the "offending lines" in init.ora
2. Start up the database
3. Create the rollback segments named in your init.ora
4. Uncomment the lines you commented out in step 1
5. Shut down and restart the database

--
Jerry Gitomer
Once I learned how to spell DBA, I became one Received on Mon Mar 27 2000 - 23:36:59 CST