Re: Rollback segment file corrupted

From: Steve Butler <sbut-is_at_seatimes.com>
Date: 1995/06/22
Message-ID: <Pine.SUN.3.91.950622153303.15666G-100000_at_seatimes>#1/1

On 21 Jun 1995, Jean-Pierre Lamarche wrote:
> We rebooted UNIX (NCR SVR 4.0) after a crash.
> ORA-01110 file rbs.dbf needs recovery.
>
> The RDBMS refuses to open the database

Mount your archived log files (you do archive don't you) and recover the database. The database is only MOUNTED during the recovery.

If you don't have archived log files, then you will need to restore from your last good backup. You do take backups?

+----------------------------------------------------+
| Steve Butler          Voice:  206-464-2998         |
| The Seattle Times       Fax:  206-382-8898         |
| PO Box 70          Internet:  sbut-is_at_seatimes.com |
| Seattle, WA 98111    Packet:  KG7JE_at_N6EQZ.WA       |
+----------------------------------------------------+

All standard and non-standard disclaimers apply. All other sources are annonymous. Received on Thu Jun 22 1995 - 00:00:00 CEST