Re: Instance won't startup up, one datafile in backup mode

From: Douglas Hawthorne <douglashawthorne_at_yahoo.com.au>
Date: Mon, 03 May 2004 13:48:53 GMT
Message-ID: <95slc.9746$TT.4421@news-server.bigpond.net.au>

"Douglas Hawthorne" <douglashawthorne_at_yahoo.com.au> wrote in message news:5Hrlc.9703$TT.8973_at_news-server.bigpond.net.au...
> "Stan Brown" <stanb_at_panix.com> wrote in message
> news:c75fq1$jj2$1_at_reader2.panix.com...
> > I've got an Oracle V7 (7.3.4.5.0 ) instance on HP-UX 10.20 that had the
> > power droped to it, and now it won't start up.
> >
> > Here's what I get when I try to start it from svrmgrl:
> >
> > SVRMGR> connect internal
> > Connected.
> > SVRMGR> shutdown abort
> > ORACLE instance shut down.
> > SVRMGR> startup
> > ORACLE instance started.
> > Total System Global Area 769118400 bytes
> > Fixed Size 38984 bytes
> > Variable Size 31635576 bytes
> > Database Buffers 737280000 bytes
> > Redo Buffers 163840 bytes
> > Database mounted.
> > ORA-01113: file 6 needs media recovery
> > ORA-01110: data file 6: '/db_local3/oradata/pwhse/tables/trend.dbf'
> >
> > So, it appears that one datafile was in backup mode, right?
> >
> > So,
> >
> > SVRMGR> select * from v$backup ;
> > FILE# STATUS CHANGE# TIME
> > ---------- ------------------ ---------- --------------------
> > 1 NOT ACTIVE 131699818 04/27/04 05:28:15
> > 2 NOT ACTIVE 131697427 04/27/04 05:21:47
> > 3 NOT ACTIVE 131699938 04/27/04 05:28:35
> > 4 NOT ACTIVE 131700997 04/27/04 05:31:38
> > 5 NOT ACTIVE 130164708 04/24/04 07:19:07
> > 6 ACTIVE 131701051 04/27/04 05:31:48
> > 7 NOT ACTIVE 131656545 04/27/04 03:29:13
> > 8 NOT ACTIVE 131656684 04/27/04 03:29:34
> > 9 NOT ACTIVE 131656575 04/27/04 03:29:17
> > 10 NOT ACTIVE 131676065 04/27/04 04:23:15
> > 10 rows selected.
> >
> > The last time something like this happened, I made the situation far
worse
> > by not understanding the correct action to take.
> >
> > So, I'm asking for some advice here.
> >
> > Can I just do something like this?
> >
> > alter datafile 6 end backup
> >
> > Or do I need to do somehting else?
> >
> >
> > --
> > "They that would give up essential liberty for temporary safety deserve
> > neither liberty nor safety."
> > -- Benjamin Franklin

>

> Stan,

>

> The datafile needs media recovery. It was not in backup mode.

>

> You will need to do the following:
> (1) ALTER DATABASE DATAFILE '/db_local3/oradata/pwhse/tables/trend.dbf'
> OFFLINE;
> (2) ALTER DATABASE OPEN;
> (3) ALTER TABLESPACE trend OFFLINE IMMEDIATE;
> (4) Restore the data file from your backups
> (5) RECOVER TABLESPACE trend
> (8) ALTER TABLESPACE trend ONLINE;
> (9) Query the V$DATAFILE view to check the status of the files

>

> Steps (1) and (2) allow you to get the database open while you work on
> recovery. However, the tablespace will be unavailable until you complete
> the recovery.

>

> Douglas Hawthorne

>
>
Stan,

My apologies.

Ignore this advice. See Richard Foote's answer in CDOS.

Douglas Hawthorne Received on Mon May 03 2004 - 08:48:53 CDT