Xref: alice comp.databases.oracle.server:69935 Path: alice!news-feed.fnsi.net!newsfeed.icl.net!newsfeed.nacamar.de!isdnet!wanadoo.fr!not-for-mail From: "herve.MAYNE" Newsgroups: comp.databases.oracle.server Subject: Re: help, please Date: Fri, 15 Oct 1999 06:01:34 +0200 Organization: Wanadoo, l'internet avec France Telecom Lines: 40 Message-ID: <7u69m6$e6$1@wanadoo.fr> References: <3804F93B.51E333DE@alloymail.com> <3806E6EE.11AC5BCB@abbnm.com> X-Trace: wanadoo.fr 939960838 454 164.138.227.3 (15 Oct 1999 04:13:58 GMT) X-Complaints-To: abuse@wanadoo.fr NNTP-Posting-Date: 15 Oct 1999 04:13:58 GMT X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.00.2014.211 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 hello you wrote you have created 2 rollback rbs01 & rbs02 have you controlled your init.ora (rollback_segments = rbs01,rbs02 ) good luck Tapan Trivedi a écrit dans le message : 3806E6EE.11AC5BCB@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