Home » RDBMS Server » Server Administration » Rollback segment issue!
Rollback segment issue! [message #158336] Fri, 10 February 2006 00:59 Go to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member
Hi,

I'm trying to brng up database from the cold back and while creating the control file i realised I don't have rollbacksegment file (rbs01) with me but I have rest of all files rbs02,rbs03,rbs04,rbs05,rbs06 with me...

and in inti<sid>.ora I have following entries..
rollback_segments = (rbs01,rbs02)


Please advice me

Puneet

Report message to a moderator

Re: Rollback segment issue! [message #158342 is a reply to message #158336] Fri, 10 February 2006 01:31 Go to previous messageGo to next message
puneetsachar
Messages: 97
Registered: March 2005
Location: New Delhi, India
Member
Hi...

I tried to copy rbs02 and rename as rbs01 and then tried to bring up DB.

Follwoing error message i got.
ERROR at line 1:
ORA-01503: CREATE CONTROLFILE failed
ORA-01167: two files are the same file/group number or the same file
ORA-01110: data file 344: '/ora2/oradata/H003/data03/rbs02.dbf'
ORA-01110: data file 344: '/ora2/oradata/H003/data03/rbs01.dbf'


Puneet

Report message to a moderator

Re: Rollback segment issue! [message #158483 is a reply to message #158342] Sat, 11 February 2006 18:48 Go to previous message
SQLAREA
Messages: 21
Registered: January 2006
Location: Belgium
Junior Member
Hi,

You are proceeding in a unconvential way my friend.

Why didn' t you take a backup of the controlfile ?
Why don' t you have a backup of your rbs01 file ?

A cold backup involves a shutdown immediate or normal of the database, backup of all the datafiles and at least 1 controlfile backup.

The way you try to recreate your missing rbs01 file by copying and renaming rbs02-copy is wrong.

What you can try is
1. in your init.ora file do not reference anymore rollback segment rbs01
2. startup nomount
3. recreate your controlfile
4. alter database datafile <path>/rbs01.dbf offline drop
5. alter database open;

If you are receiving errors while opening the db you may want to take a look here http://www.fors.com/velpuri2/Backup%20and%20Recovery/LOSTROLLBACK

Take care and good luck

Regards
Guy Lambregts

Report message to a moderator

Previous Topic: ORA-00604: error occurred at recursive SQL level 3...Please help
Next Topic: No of Sessions in Oracle DB is exceeded
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 19 03:04:32 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.