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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: missing datafile on STANDBY DATABASE.

Re: missing datafile on STANDBY DATABASE.

From: Zhu,Chao <zhuchao_at_gmail.com>
Date: Tue, 8 Aug 2006 22:56:29 +0800
Message-ID: <962cf44b0608080756p4e8dc584r1945bc9e195ae508@mail.gmail.com>


either alter database create datafile 'xxx' (or 'xxx' as 'yyy') if path is different, and go on recovery.
Or re-copy teh datafile from primary.
he is talking about archifvelog so it is physical standby.

On 8/8/06, Carel-Jan Engel <cjpengel.dbalert_at_xs4all.nl> wrote:
>
> Syed,
>
> First of all:
>
> OS, Oracle Version?
>
> I need to verify this later this evening at home at my testlab to be sure.
> What I'd suggest is this:
>
> Shutdown the standby.
> Create a new standby controlfile from the primary. Copy that to the
> standby, overwrite the existing standby controlfile(s).
> Put the tablespace in backup mode (on the primary) and recopy the missing
> datafile to the standby. Don't forget the 'end backup'
> Start the standby in managed recovery mode.
> It should catch up where needed.
>
> If you want me to check this tonight (4 hours from now, 8PM CET I have
> some time to perform the checks) let me know.
>
> Regards, Carel-Jan
>
> ===
> If you think education is expensive, try ignorance. (Derek Bok)
> ===
>
>
>
> > Hello list,
> >
> > We are maintaining the standby database to our one of important
> database.
> > On 5th August, a datafile has been added to primary database,
> > unfortunately, there was no sufficient space on standby server.
> > MRP background process has died and no archive logs were applied until
> > now.
> > I try to rename the datafile, create datafile, but, couldn't succeeded.
> > Opened a TAR with oracle and they said that rebuild standby.
> > I couldn't find the 'UNNAMED00266' file at OS leve. But, the entry is
> > there in v$datafile.
> > I have even cheked all my backups from 5th August, finding a luck to
> > have the file in backup, if someone deleted the file. But, not luck.
> > Is there any way that we can resolve this issue?
> > I have all the archived log since that point.
> >
> > Thanks,
> >
> > --
> > Best Regards,
> > Syed Jaffar Hussain
> > 8i,9i & 10g OCP DBA
> > Banque Saudi Fransi,
> > Saudi Arabia
> >
> > I blog at :http://jaffardba.blogspot.com/
> > http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain
> >
> ----------------------------------------------------------------------------------
> > "Winners don't do different things. They do things differently."
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Regards
Zhu Chao
www.cnoug.org

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Aug 08 2006 - 09:56:29 CDT

Original text of this message

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