Re: not able to start Oracle Database

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Thu, 4 Dec 2003 14:31:11 GMT
Message-ID: <3FCF452F.E6167DB6@remove_spam.peasland.com>

Comments inline...

> I have a database running on Wint - NT. till yesterday it was working
> fine but today user was not able to login. It was giving the error
> ORA-01109 database is initializing or shut down.

The ORA-1109 error just indicates that the database is not open for business. You'll have to open it up before you can proceed.

> Thru svrmgrl when I tried to shut it down by giving the command
>
> shutdown immediate
>
> it gives the message "No database is Open";
> Unmounting the database

Typically, a SHUTDOWN command would close the database first, but in this case it was not open. So the message was information. After the database is closed, it is unmounted. So the above worked as it should have.

> & then when I had given the command startup
> it display on the screen
> Total System Global Area 152016924
> Fixed size 75804
> Variable Size 58261504
> Database Buffer 93601792
> Redo Buffer 77824
> Database Mounted
> ORA-01578 : Oracle Datablock Corrupted (File # 2, Block # 2050)
> ORA - 01110 : Datafile 2: 'D:\ORACLE\ORADATA\ORCL\RBS01.DBF'

This is your problem. You have data block corruption in File#2, which belongs to your rollback tablespace. The easiest thing to do is to restore from a backup.

> I m new to company & there is no backup & Docummentation of this
> package.

Oops.....no backup. That's not good. Since this file is for your rollback segments, recovery without a backup is not impossible. Follow steps similar to these:

1. In your INIT.ORA, comment out the ROLLBACK_SEGMENTS parameter. With this parameter, Oracle needs to bring online the rollback segments in your RBS tablespace. You don't want that to happen.
2. STARTUP MOUNT the database. You cannot open it yet.
3. ALTER DATABASE DATAFILE 'D:\ORACLE\ORADATA\ORCL\RBS01.DBF' OFFLINE DROP; This removes the datafile from the database.
4. ALTER DATABASE OPEN; You should now be able to open the database.
5. DROP TABLESPACE rbs INCLUDING CONTENTS; The tablespace is now removed as well.
6. Physically remove the datafile from your disk system.
7. CREATE TABLESPACE rbs DATAFILE 'D:\ORACLE\ORADATA\ORCL\RBS01.DBF'....... Create the tablespace anew.
8. CREATE ROLLBACK SEGMENT r01..... Create the rollback segments in this tablespace again. Make sure that they are online.
9. Undo step #1 so that these rollback segments come online when you start the instance.
10. SHUTDOWN IMMEDIATE
11. Perform a cold backup immediately!
12. STARTUP

That's pretty much the basics. I would highly suggest that you visit your company's backup & recovery policies pertaining to your Oracle databases. You should have a valid backup. And backups don't help unless you know how to recover from them. So learn solid recovery techniques as well. This is one of your most important jobs as a DBA.

HTH,Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"

Received on Thu Dec 04 2003 - 08:31:11 CST