Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: help, please
hello
you wrote you have created 2 rollback rbs01 & rbs02
have you controlled your init.ora (rollback_segments = rbs01,rbs02 )
good luck
Tapan Trivedi <tapan.trivedi_at_abbnm.com> a écrit dans le message :
3806E6EE.11AC5BCB_at_abbnm.com...
> Did you do a
> alter rollback segment R01 online;
> after you created the same.
>
> As far as your archivelog mode goes please describe exactly what you are
> doing and then maybe we can take it from there but here is a thought...
> Go to svrmgrl and then do a connect internal and then a startup open.
> Tell me what it says. If it says something like 'recovery required '
> then give a recover database command. If this does not take you to
> 'database opened' then your database needs recovery and you need more
> help. Keep us informed.
>
> Tapan
>
> GreyWolf_69 wrote:
> >
> > I've created a new database instance. Oracle 7.3.4.
> > I created a rbs tablespace
> > I created 2 rollback segments (rbs01 & rbs02) using the rbs tablespace.
> > when I try to open the db I get this error:
> >
> > "rollback segment 'R01' doesn't exist"
> >
> > what is this, does anybody know?
> >
> > also when I try to put the db in archivelog mode I get this message:
> >
> > "ORA-00265: Instance recovery required, cannot set ARCHIVELOG mode"
> >
> > help!! Please
> >
> > TIA
Received on Thu Oct 14 1999 - 23:01:34 CDT