Re: How can I get my DB back if I lost one of my rollback segment (rb

From: A. Bardeen <abardeen1_at_yahoo.com>
Date: Tue, 14 Aug 2001 06:26:33 -0700
Message-ID: <F001.00369961.20010814060021@fatcity.com>

Hermanto,

You don't mention whether the db is in archivelog mode or not or whether the rbs02.dbf was included in a prior backup, so I'm assuming the answer to both questions is "no".

If the backup was a good cold backup (i.e. taken when the db was shutdown normal or immediate) then you can open the db, but you'll have to recreate the tablespace to which rbs02.dbf belongs.

1. Comment out the ROLLBACK_SEGMENTS entry in the init.ora, if there is one.
2. startup mount restrict
3. Offline drop the rbs02.dbf alter database datafile '<filename>' offline drop;
4. alter database open;

  If you don't have the online redo logs included in the backup, then you'll have to "fake" recovery in order to open with resetlogs:
  recover database until cancel;

     you should get a "media recovery complete" message if this was a good cold backup
  alter database open resetlogs;

5. Drop and recreate the tablespace to which rbs02.dbf belongs.

6. Take a full db backup

If the backup is a hot backup and/or you have archived logs you want to apply then it gets a bit trickier and odds are you'll have rows locked by uncommitted transactions that SMON is unable to rollback if any extents for active RBS's were allocated in the rbs02.dbf datafile.

HTH,

• Anita
  • Hermanto P <hermanto_p_at_aprilasia.com> wrote:
    > Hi gurus,
    > Recently, I have forgotten to backup one of rollback
    > segment file
    > (rbs02.dbf).
    > When I want to restore..the db can not startup
    > normally.
    > Anyone can give me advise..
    > Thanks in advance.
    >
    > Warm regards,
    > Hermanto
    > --
    > Please see the official ORACLE-L FAQ:
    > http://www.orafaq.com
    > --
    > Author: Hermanto P
    > INET: hermanto_p_at_aprilasia.com
    >
    

    ---

Do You Yahoo!?
Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: A. Bardeen
  INET: abardeen1_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Tue Aug 14 2001 - 08:26:33 CDT