Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Instance won't startup up, one datafile in backup mode

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:21:05 GMT
Message-ID: <5Hrlc.9703$TT.8973@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 Received on Mon May 03 2004 - 08:21:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US